• unknown's avatar
    More fixes for strict mode: · 6966e869
    unknown authored
    More tests.
    Better error messages.
    Fixed bug when checking if we updated all needed columns for INSERT.
    Give an error if we encounter a wrong float value during parsing.
    Don't print DEFAULT for columns without a default value in SHOW CREATE/SHOW FIELDS.
    Fixed UPDATE IGNORE when using STRICT mode.
    
    
    include/mysqld_error.h:
      More error messages for strict mode
    include/sql_state.h:
      Fixed wrong state
      New error message
    mysql-test/r/alter_table.result:
      Updated results for not automatic default fields
    mysql-test/r/auto_increment.result:
      Better error messages
    mysql-test/r/create.result:
      Updated results for not automatic default fields
      Better error messages
    mysql-test/r/ctype_collate.result:
      Updated results for not automatic default fields
    mysql-test/r/ctype_latin1_de.result:
      Updated results for not automatic default fields
    mysql-test/r/ctype_many.result:
      Updated results for not automatic default fields
    mysql-test/r/ctype_recoding.result:
      Updated results for not automatic default fields
    mysql-test/r/gis-rtree.result:
      Updated results for not automatic default fields
    mysql-test/r/gis.result:
      Updated results for not automatic default fields
    mysql-test/r/innodb.result:
      Updated results for not automatic default fields
    mysql-test/r/insert.result:
      Better error messages
    mysql-test/r/insert_select.result:
      Better error messages
    mysql-test/r/isam.result:
      Updated results for not automatic default fields
    mysql-test/r/key.result:
      Better error messages
    mysql-test/r/merge.result:
      Updated results for not automatic default fields
    mysql-test/r/null.result:
      Better error messages
    mysql-test/r/null_key.result:
      Better error messages
    mysql-test/r/ps_1general.result:
      Updated results for not automatic default fields
    mysql-test/r/select.result:
      Drop views that may interfere with later results
    mysql-test/r/show_check.result:
      Updated results for not automatic default fields
    mysql-test/r/sp.result:
      Updated results for not automatic default fields
    mysql-test/r/strict.result:
      More tests
    mysql-test/r/type_set.result:
      Updated results for not automatic default fields
    mysql-test/r/warnings.result:
      Better error messages
    mysql-test/t/insert.test:
      Using wrong float values now gives an error
    mysql-test/t/select.test:
      Drop views that may interfere with later results
    mysql-test/t/strict.test:
      More tests
    scripts/mysql_fix_privilege_tables.sql:
      Add missing DEFAULT's
    sql/field.cc:
      Fix some strict mode issues for float and double
    sql/field.h:
      Fix DEFAULT handling
    sql/item.cc:
      Give an error if we encounter a wrong float value during parsing.
      Give an error if we use DEFAULT() on a field that doesn't have a default value.
    sql/item.h:
      Give an error if we encounter a wrong float value during parsing.
    sql/mysqld.cc:
      More debug info
    sql/share/czech/errmsg.txt:
      Better error messages
    sql/share/danish/errmsg.txt:
      Better error messages
    sql/share/dutch/errmsg.txt:
      Better error messages
    sql/share/english/errmsg.txt:
      Better error messages
    sql/share/estonian/errmsg.txt:
      Better error messages
    sql/share/french/errmsg.txt:
      Better error messages
    sql/share/german/errmsg.txt:
      Better error messages
    sql/share/greek/errmsg.txt:
      Better error messages
    sql/share/hungarian/errmsg.txt:
      Better error messages
    sql/share/italian/errmsg.txt:
      Better error messages
    sql/share/japanese/errmsg.txt:
      Better error messages
    sql/share/korean/errmsg.txt:
      Better error messages
    sql/share/norwegian-ny/errmsg.txt:
      Better error messages
    sql/share/norwegian/errmsg.txt:
      Better error messages
    sql/share/polish/errmsg.txt:
      Better error messages
    sql/share/portuguese/errmsg.txt:
      Better error messages
    sql/share/romanian/errmsg.txt:
      Better error messages
    sql/share/russian/errmsg.txt:
      Better error messages
    sql/share/serbian/errmsg.txt:
      Better error messages
    sql/share/slovak/errmsg.txt:
      Better error messages
    sql/share/spanish/errmsg.txt:
      Better error messages
    sql/share/swedish/errmsg.txt:
      Better error messages
    sql/share/ukrainian/errmsg.txt:
      Better error messages
    sql/sql_insert.cc:
      Fixed bug in last push of checking of default values.
    sql/sql_parse.cc:
      Enum fields has always a default value
    sql/sql_show.cc:
      Don't print DEFAULT for columns without a default value in SHOW CREATE/SHOW FIELDS
    sql/sql_table.cc:
      Fixed storing/retrieving of NO_DEFAULT_VALUE_FLAG
    sql/sql_update.cc:
      Don't abort for wrong values for UPDATE IGNORE
    sql/sql_yacc.yy:
      Abort if we find a wrong float value
    sql/table.cc:
      Fixed storing/retrieving of NO_DEFAULT_VALUE_FLAG
    6966e869
sql_table.cc 101 KB