# ml_err30.test (test case derived from NIST: schema8.smi ) use test ; --disable_warnings drop table if exists EXACT_DEF ; --enable_warnings # Force the usage of the default set session sql_mode = ''; # statement for comparison, value starts with '.' create table EXACT_DEF ( min_num dec(6,6) default .000001); drop table EXACT_DEF ; set session sql_mode = 'IGNORE_SPACE'; # statement for comparison, value starts with '0' create table EXACT_DEF ( min_num dec(6,6) default 0.000001); drop table EXACT_DEF ; # This statement fails, value starts with '.' create table EXACT_DEF ( min_num dec(6,6) default .000001);