diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_bugs/r')
5 files changed, 14 insertions, 1 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_bugs/r/6684.result b/storage/tokudb/mysql-test/tokudb_bugs/r/6684.result index b2d393d4469..9a72e882b3c 100644 --- a/storage/tokudb/mysql-test/tokudb_bugs/r/6684.result +++ b/storage/tokudb/mysql-test/tokudb_bugs/r/6684.result @@ -11,12 +11,14 @@ CREATE TABLE `site` ( PRIMARY KEY (`id`), KEY `owner_title` (`title`) ) ENGINE=TokuDB AUTO_INCREMENT=575 DEFAULT CHARSET=utf8; +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; CREATE TABLE `screenshot` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `site` int(11) unsigned NOT NULL, `timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=TokuDB AUTO_INCREMENT=82720 DEFAULT CHARSET=utf8; +SET sql_mode = DEFAULT; INSERT INTO `site` (`id`, `title`) VALUES (9, 'Facebook'), @@ -38,7 +40,9 @@ WHERE screenshot.id IS NULL; id title id site timestamp SELECT * FROM site where site.id not in (select screenshot.site from screenshot where timestamp > '2013-04-28 13:30:00'); id title +set sql_mode = ''; create index `site` on screenshot(`site`); +set sql_mode = default; SELECT * FROM site LEFT JOIN screenshot diff --git a/storage/tokudb/mysql-test/tokudb_bugs/r/alter_table_copy_table.result b/storage/tokudb/mysql-test/tokudb_bugs/r/alter_table_copy_table.result index e8765ec7ab9..03bcc13efc2 100644 --- a/storage/tokudb/mysql-test/tokudb_bugs/r/alter_table_copy_table.result +++ b/storage/tokudb/mysql-test/tokudb_bugs/r/alter_table_copy_table.result @@ -3,6 +3,8 @@ set tokudb_disable_hot_alter=ON; set default_storage_engine=tokudb; create table t (id int, x char(2), primary key (id), unique key (x)); insert into t values (1,'aa'),(2,'ab'); +set sql_mode = ''; alter table t modify x char(1); ERROR 23000: Duplicate entry 'a' for key 'x' +set sql_mode = default; drop table t; diff --git a/storage/tokudb/mysql-test/tokudb_bugs/r/db397_delete_trigger.result b/storage/tokudb/mysql-test/tokudb_bugs/r/db397_delete_trigger.result index c8565fb4b2b..600deeae7c6 100644 --- a/storage/tokudb/mysql-test/tokudb_bugs/r/db397_delete_trigger.result +++ b/storage/tokudb/mysql-test/tokudb_bugs/r/db397_delete_trigger.result @@ -12,9 +12,11 @@ ts timestamp not null default now()); insert into t1 (col1,col2) values (0,0); insert into t1_audit (col1,action) values (0,'DUMMY'); set local tokudb_prelock_empty=0; +set sql_mode = ''; create trigger t1_trigger before delete on t1 for each row insert into t1_audit (col1, action) values (old.col1, 'BEFORE DELETE'); +set sql_mode = default; insert into t1 (col1,col2) values (1,1); start transaction; delete from t1 where col1 = 1; @@ -32,9 +34,11 @@ locks_dname locks_key_left locks_key_right ./test/t1_audit-main 0200000000000000 0200000000000000 commit; drop trigger t1_trigger; +set sql_mode = ''; create trigger t1_trigger after delete on t1 for each row insert into t1_audit (col1, action) values (old.col1, 'AFTER DELETE'); +set sql_mode = default; insert into t1 (col1,col2) values (2,2); start transaction; delete from t1 where col1 = 2; diff --git a/storage/tokudb/mysql-test/tokudb_bugs/r/db945.result b/storage/tokudb/mysql-test/tokudb_bugs/r/db945.result index 6b3c239d602..edebae3b9e0 100644 --- a/storage/tokudb/mysql-test/tokudb_bugs/r/db945.result +++ b/storage/tokudb/mysql-test/tokudb_bugs/r/db945.result @@ -7,7 +7,7 @@ set session tokudb_analyze_throttle = 0; set session tokudb_analyze_time = 0; create table t1(a int, b text(1), c text(1), filler text(1), primary key(a, b(1)), unique key (a, c(1))); lock tables t1 write, t1 as a read, t1 as b read; -insert into t1(a) values(1); +insert ignore into t1(a) values(1); Warnings: Warning 1364 Field 'b' doesn't have a default value alter table t1 drop key a; diff --git a/storage/tokudb/mysql-test/tokudb_bugs/r/leak172.result b/storage/tokudb/mysql-test/tokudb_bugs/r/leak172.result index fa98811c803..e3991b42a06 100644 --- a/storage/tokudb/mysql-test/tokudb_bugs/r/leak172.result +++ b/storage/tokudb/mysql-test/tokudb_bugs/r/leak172.result @@ -1,5 +1,6 @@ set default_storage_engine=tokudb; drop table if exists t1,t2; +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; CREATE TABLE `t1` ( `c4` int(11) DEFAULT NULL, `c5` int(11) DEFAULT NULL, @@ -118,6 +119,7 @@ KEY `c31` (`c31`) ); LOAD DATA INFILE 'leak172_t1.data' INTO TABLE `t1` fields terminated by ','; connect conn1,localhost,root,,; +set sql_mode = ''; set session debug_dbug="+d,tokudb_end_bulk_insert_sleep"; LOAD DATA INFILE 'leak172_t2.data' INTO TABLE `t2` fields terminated by ','; connection default; @@ -127,3 +129,4 @@ connection conn1; connection default; disconnect conn1; drop table t1,t2; +set sql_mode = default; |