• unknown's avatar
    Fixed BUG#11365: Stored Procedure: Crash on Procedure operation · accdff51
    unknown authored
      Two separate problems. A key buffer was too small in sp.cc for multi-byte
      fields, and the creation and fixing of mysql.proc in the scripts hadn't been
      updated with the correct character sets and collations (like the other
      system tables had).
      Note: No special test case, as the use of utf8 for mysql.proc will make
      any existing crash (if the buffer overrrun wasn't fixed).
    
    
    mysql-test/r/sp-error.result:
      Updated test case for too long SP names (as the limit has increased with the use of utf8).
    mysql-test/t/sp-error.test:
      Updated test case for too long SP names (as the limit has increased with the use of utf8).
    scripts/mysql_create_system_tables.sh:
      Use utf8 for mysql.proc, just like for the other system tables.
    scripts/mysql_fix_privilege_tables.sql:
      Use utf8 for mysql.proc, just like for the other system tables.
      (Some tabs also replaced by space)
    sql/sp.cc:
      Use a larger key buffer for stored procedures to avoid stack overrun with multi-byte keys.
    accdff51
sp-error.test 19.3 KB