• unknown's avatar
    Fixed BUG#336: Subselects with tables does not work as values for local SP variables · 3aaa8ab9
    unknown authored
     and BUG#1654: Stored Procedure Crash if contains subquery and set function
    
    Disallowed subselects in RETURN (for FUNCTIONs) and SET of local variables.
    The latter should work, but turned out to be difficult to fix, so we just
    disallow it for the time being.
    
    
    include/mysqld_error.h:
      New error message for unsupported subselect as SP set values (for the time being).
    include/sql_state.h:
      New error message for unsupported subselect as SP set values (for the time being).
    mysql-test/r/sp-error.result:
      Test cases for BUG#336 and BUG#1654. (Unsupported use of subselect)
    mysql-test/t/sp-error.test:
      Test cases for BUG#336 and BUG#1654. (Unsupported use of subselect)
    sql/item.cc:
      Made Item_splocal::type() work at compile time, for error checking.
    sql/item.h:
      Made Item_splocal::type() work at compile time, for error checking.
    sql/share/czech/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/danish/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/dutch/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/english/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/estonian/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/french/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/german/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/greek/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/hungarian/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/italian/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/japanese/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/korean/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/norwegian-ny/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/norwegian/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/polish/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/portuguese/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/romanian/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/russian/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/serbian/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/slovak/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/spanish/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/swedish/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/share/ukrainian/errmsg.txt:
      New error message for unsupported subselect as SP set values (for the time being).
    sql/sp_head.cc:
      Fixed (bogus) compile error on HP-UX alpha.
    sql/sql_yacc.yy:
      Disallowed subselects in RETURN (for FUNCTIONs) and SET of local variables.
      The latter should work, but turned out to be difficult to fix, so we just
      disallow it for the time being.
    3aaa8ab9
errmsg.txt 19 KB