diff options
Diffstat (limited to 'mysql-test/r/mix2_myisam.result')
| -rw-r--r-- | mysql-test/r/mix2_myisam.result | 24 |
1 files changed, 20 insertions, 4 deletions
diff --git a/mysql-test/r/mix2_myisam.result b/mysql-test/r/mix2_myisam.result index 1ffebcd50be..b04e8c88f6f 100644 --- a/mysql-test/r/mix2_myisam.result +++ b/mysql-test/r/mix2_myisam.result @@ -839,6 +839,7 @@ desc t1; Field Type Null Key Default Extra t int(11) NO MUL 1 drop table t1; +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; CREATE TABLE t1 ( number bigint(20) NOT NULL default '0', cname char(15) NOT NULL default '', @@ -852,12 +853,18 @@ version smallint(6) NOT NULL default '0', assigned_scps int(11) default '0', status tinyint(4) default '0' ) ENGINE=MyISAM; -INSERT INTO t1 VALUES (4077711111,'SeanWheeler',90,2,20020111112846,500,00000000000000,-1,2,3,1); +SET sql_mode = DEFAULT; +INSERT IGNORE INTO t1 VALUES (4077711111,'SeanWheeler',90,2,20020111112846,500,00000000000000,-1,2,3,1); +Warnings: +Warning 1265 Data truncated for column 'last_app_date' at row 1 INSERT INTO t1 VALUES (9197722223,'berry',90,3,20020111112809,500,20020102114532,501,4,10,0); -INSERT INTO t1 VALUES (650,'San Francisco',0,0,20011227111336,342,00000000000000,-1,1,24,1); +INSERT IGNORE INTO t1 VALUES (650,'San Francisco',0,0,20011227111336,342,00000000000000,-1,1,24,1); +Warnings: +Warning 1265 Data truncated for column 'last_app_date' at row 1 INSERT INTO t1 VALUES (302467,'Sue\'s Subshop',90,3,20020109113241,500,20020102115111,501,7,24,0); INSERT INTO t1 VALUES (6014911113,'SudzCarwash',520,1,20020102115234,500,20020102115259,501,33,32768,0); INSERT INTO t1 VALUES (333,'tubs',99,2,20020109113440,501,20020109113440,500,3,10,0); +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; CREATE TABLE t2 ( number bigint(20) NOT NULL default '0', cname char(15) NOT NULL default '', @@ -871,9 +878,14 @@ version smallint(6) NOT NULL default '0', assigned_scps int(11) default '0', status tinyint(4) default '0' ) ENGINE=MyISAM; -INSERT INTO t2 VALUES (4077711111,'SeanWheeler',0,2,20020111112853,500,00000000000000,-1,2,3,1); +SET sql_mode = DEFAULT; +INSERT IGNORE INTO t2 VALUES (4077711111,'SeanWheeler',0,2,20020111112853,500,00000000000000,-1,2,3,1); +Warnings: +Warning 1265 Data truncated for column 'last_app_date' at row 1 INSERT INTO t2 VALUES (9197722223,'berry',90,3,20020111112818,500,20020102114532,501,4,10,0); -INSERT INTO t2 VALUES (650,'San Francisco',90,0,20020109113158,342,00000000000000,-1,1,24,1); +INSERT IGNORE INTO t2 VALUES (650,'San Francisco',90,0,20020109113158,342,00000000000000,-1,1,24,1); +Warnings: +Warning 1265 Data truncated for column 'last_app_date' at row 1 INSERT INTO t2 VALUES (333,'tubs',99,2,20020109113453,501,20020109113453,500,3,10,0); select * from t1; number cname carrier_id privacy last_mod_date last_mod_id last_app_date last_app_id version assigned_scps status @@ -1988,18 +2000,22 @@ create table t1 (v varchar(65530), key(v)); Warnings: Warning 1071 Specified key was too long; max key length is 1000 bytes drop table t1; +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; create table t1 (v varchar(65536)); Warnings: Note 1246 Converting column 'v' from VARCHAR to TEXT +SET sql_mode = DEFAULT; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `v` mediumtext DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table t1; +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; create table t1 (v varchar(65530) character set utf8); Warnings: Note 1246 Converting column 'v' from VARCHAR to TEXT +SET sql_mode = DEFAULT; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( |