diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_alter_table/r/hcad_all_blob_add.result')
| -rw-r--r-- | storage/tokudb/mysql-test/tokudb_alter_table/r/hcad_all_blob_add.result | 1736 |
1 files changed, 0 insertions, 1736 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_alter_table/r/hcad_all_blob_add.result b/storage/tokudb/mysql-test/tokudb_alter_table/r/hcad_all_blob_add.result index af66b4edfba..fe8545a7873 100644 --- a/storage/tokudb/mysql-test/tokudb_alter_table/r/hcad_all_blob_add.result +++ b/storage/tokudb/mysql-test/tokudb_alter_table/r/hcad_all_blob_add.result @@ -10,17 +10,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL; alter table bar add column added_1 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -32,17 +24,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1; alter table bar add column added_2 bigint default -1; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -54,17 +38,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1; alter table bar add column added_3 bigint NOT NULL default -1; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -76,17 +52,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL; alter table bar add column added_4 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -98,17 +66,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty"; alter table bar add column added_5 varchar(10) default "qwerty"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -120,17 +80,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt"; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -142,17 +94,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL; alter table bar add column added_7 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -164,17 +108,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL; alter table bar add column added_8 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -186,17 +122,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL first; alter table bar add column added_1 bigint default NULL first; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -208,17 +136,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 first; alter table bar add column added_2 bigint default -1 first; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -230,17 +150,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 first; alter table bar add column added_3 bigint NOT NULL default -1 first; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -252,17 +164,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL first; alter table bar add column added_4 varchar(10) default NULL first; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -274,17 +178,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" first; alter table bar add column added_5 varchar(10) default "qwerty" first; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -296,17 +192,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -318,17 +206,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL first; alter table bar add column added_7 text default NULL first; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -340,17 +220,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL first; alter table bar add column added_8 mediumtext default NULL first; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -362,17 +234,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL after bb; alter table bar add column added_1 bigint default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -384,17 +248,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 after bb; alter table bar add column added_2 bigint default -1 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -406,17 +262,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 after bb; alter table bar add column added_3 bigint NOT NULL default -1 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -428,17 +276,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL after bb; alter table bar add column added_4 varchar(10) default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -450,17 +290,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" after bb; alter table bar add column added_5 varchar(10) default "qwerty" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -472,17 +304,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -494,17 +318,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL after bb; alter table bar add column added_7 text default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -516,17 +332,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL after bb; alter table bar add column added_8 mediumtext default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -538,17 +346,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL, add column added_11 bigint default NULL; alter table bar add column added_1 bigint default NULL, add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -560,17 +360,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL, add column added_21 bigint default 1234; alter table bar add column added_1 bigint default NULL, add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -582,17 +374,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL, add column added_31 bigint NOT NULL default 54; alter table bar add column added_1 bigint default NULL, add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -604,17 +388,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL, add column added_41 varchar(10) default NULL; alter table bar add column added_1 bigint default NULL, add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -626,17 +402,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL, add column added_51 varchar(10) default "abracadab"; alter table bar add column added_1 bigint default NULL, add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -648,17 +416,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_1 bigint default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -670,17 +430,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL, add column added_71 text default NULL; alter table bar add column added_1 bigint default NULL, add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -692,17 +444,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL, add column added_81 mediumtext default NULL; alter table bar add column added_1 bigint default NULL, add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -714,17 +458,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1, add column added_11 bigint default NULL; alter table bar add column added_2 bigint default -1, add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -736,17 +472,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1, add column added_21 bigint default 1234; alter table bar add column added_2 bigint default -1, add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -758,17 +486,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1, add column added_31 bigint NOT NULL default 54; alter table bar add column added_2 bigint default -1, add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -780,17 +500,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1, add column added_41 varchar(10) default NULL; alter table bar add column added_2 bigint default -1, add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -802,17 +514,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1, add column added_51 varchar(10) default "abracadab"; alter table bar add column added_2 bigint default -1, add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -824,17 +528,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1, add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_2 bigint default -1, add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -846,17 +542,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1, add column added_71 text default NULL; alter table bar add column added_2 bigint default -1, add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -868,17 +556,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1, add column added_81 mediumtext default NULL; alter table bar add column added_2 bigint default -1, add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -890,17 +570,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1, add column added_11 bigint default NULL; alter table bar add column added_3 bigint NOT NULL default -1, add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -912,17 +584,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1, add column added_21 bigint default 1234; alter table bar add column added_3 bigint NOT NULL default -1, add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -934,17 +598,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1, add column added_31 bigint NOT NULL default 54; alter table bar add column added_3 bigint NOT NULL default -1, add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -956,17 +612,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1, add column added_41 varchar(10) default NULL; alter table bar add column added_3 bigint NOT NULL default -1, add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -978,17 +626,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1, add column added_51 varchar(10) default "abracadab"; alter table bar add column added_3 bigint NOT NULL default -1, add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1000,17 +640,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1, add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_3 bigint NOT NULL default -1, add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1022,17 +654,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1, add column added_71 text default NULL; alter table bar add column added_3 bigint NOT NULL default -1, add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1044,17 +668,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1, add column added_81 mediumtext default NULL; alter table bar add column added_3 bigint NOT NULL default -1, add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1066,17 +682,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL, add column added_11 bigint default NULL; alter table bar add column added_4 varchar(10) default NULL, add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1088,17 +696,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL, add column added_21 bigint default 1234; alter table bar add column added_4 varchar(10) default NULL, add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1110,17 +710,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL, add column added_31 bigint NOT NULL default 54; alter table bar add column added_4 varchar(10) default NULL, add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1132,17 +724,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL, add column added_41 varchar(10) default NULL; alter table bar add column added_4 varchar(10) default NULL, add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1154,17 +738,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL, add column added_51 varchar(10) default "abracadab"; alter table bar add column added_4 varchar(10) default NULL, add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1176,17 +752,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_4 varchar(10) default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1198,17 +766,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL, add column added_71 text default NULL; alter table bar add column added_4 varchar(10) default NULL, add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1220,17 +780,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL, add column added_81 mediumtext default NULL; alter table bar add column added_4 varchar(10) default NULL, add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1242,17 +794,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty", add column added_11 bigint default NULL; alter table bar add column added_5 varchar(10) default "qwerty", add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1264,17 +808,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty", add column added_21 bigint default 1234; alter table bar add column added_5 varchar(10) default "qwerty", add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1286,17 +822,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty", add column added_31 bigint NOT NULL default 54; alter table bar add column added_5 varchar(10) default "qwerty", add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1308,17 +836,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty", add column added_41 varchar(10) default NULL; alter table bar add column added_5 varchar(10) default "qwerty", add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1330,17 +850,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty", add column added_51 varchar(10) default "abracadab"; alter table bar add column added_5 varchar(10) default "qwerty", add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1352,17 +864,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty", add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_5 varchar(10) default "qwerty", add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1374,17 +878,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty", add column added_71 text default NULL; alter table bar add column added_5 varchar(10) default "qwerty", add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1396,17 +892,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty", add column added_81 mediumtext default NULL; alter table bar add column added_5 varchar(10) default "qwerty", add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1418,17 +906,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_11 bigint default NULL; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1440,17 +920,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_21 bigint default 1234; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1462,17 +934,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_31 bigint NOT NULL default 54; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1484,17 +948,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_41 varchar(10) default NULL; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1506,17 +962,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_51 varchar(10) default "abracadab"; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1528,17 +976,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1550,17 +990,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_71 text default NULL; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1572,17 +1004,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_81 mediumtext default NULL; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1594,17 +1018,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL, add column added_11 bigint default NULL; alter table bar add column added_7 text default NULL, add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1616,17 +1032,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL, add column added_21 bigint default 1234; alter table bar add column added_7 text default NULL, add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1638,17 +1046,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL, add column added_31 bigint NOT NULL default 54; alter table bar add column added_7 text default NULL, add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1660,17 +1060,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL, add column added_41 varchar(10) default NULL; alter table bar add column added_7 text default NULL, add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1682,17 +1074,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL, add column added_51 varchar(10) default "abracadab"; alter table bar add column added_7 text default NULL, add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1704,17 +1088,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_7 text default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1726,17 +1102,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL, add column added_71 text default NULL; alter table bar add column added_7 text default NULL, add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1748,17 +1116,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL, add column added_81 mediumtext default NULL; alter table bar add column added_7 text default NULL, add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1770,17 +1130,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL, add column added_11 bigint default NULL; alter table bar add column added_8 mediumtext default NULL, add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1792,17 +1144,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL, add column added_21 bigint default 1234; alter table bar add column added_8 mediumtext default NULL, add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1814,17 +1158,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL, add column added_31 bigint NOT NULL default 54; alter table bar add column added_8 mediumtext default NULL, add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1836,17 +1172,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL, add column added_41 varchar(10) default NULL; alter table bar add column added_8 mediumtext default NULL, add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1858,17 +1186,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL, add column added_51 varchar(10) default "abracadab"; alter table bar add column added_8 mediumtext default NULL, add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1880,17 +1200,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_8 mediumtext default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1902,17 +1214,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL, add column added_71 text default NULL; alter table bar add column added_8 mediumtext default NULL, add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1924,17 +1228,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL, add column added_81 mediumtext default NULL; alter table bar add column added_8 mediumtext default NULL, add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1946,17 +1242,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL first, add column added_11 bigint default NULL; alter table bar add column added_1 bigint default NULL first, add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1968,17 +1256,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL first, add column added_21 bigint default 1234; alter table bar add column added_1 bigint default NULL first, add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -1990,17 +1270,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL first, add column added_31 bigint NOT NULL default 54; alter table bar add column added_1 bigint default NULL first, add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2012,17 +1284,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL first, add column added_41 varchar(10) default NULL; alter table bar add column added_1 bigint default NULL first, add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2034,17 +1298,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL first, add column added_51 varchar(10) default "abracadab"; alter table bar add column added_1 bigint default NULL first, add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2056,17 +1312,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_1 bigint default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2078,17 +1326,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL first, add column added_71 text default NULL; alter table bar add column added_1 bigint default NULL first, add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2100,17 +1340,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL first, add column added_81 mediumtext default NULL; alter table bar add column added_1 bigint default NULL first, add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2122,17 +1354,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 first, add column added_11 bigint default NULL; alter table bar add column added_2 bigint default -1 first, add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2144,17 +1368,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 first, add column added_21 bigint default 1234; alter table bar add column added_2 bigint default -1 first, add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2166,17 +1382,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 first, add column added_31 bigint NOT NULL default 54; alter table bar add column added_2 bigint default -1 first, add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2188,17 +1396,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 first, add column added_41 varchar(10) default NULL; alter table bar add column added_2 bigint default -1 first, add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2210,17 +1410,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 first, add column added_51 varchar(10) default "abracadab"; alter table bar add column added_2 bigint default -1 first, add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2232,17 +1424,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 first, add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_2 bigint default -1 first, add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2254,17 +1438,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 first, add column added_71 text default NULL; alter table bar add column added_2 bigint default -1 first, add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2276,17 +1452,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 first, add column added_81 mediumtext default NULL; alter table bar add column added_2 bigint default -1 first, add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2298,17 +1466,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_11 bigint default NULL; alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2320,17 +1480,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_21 bigint default 1234; alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2342,17 +1494,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_31 bigint NOT NULL default 54; alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2364,17 +1508,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_41 varchar(10) default NULL; alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2386,17 +1522,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_51 varchar(10) default "abracadab"; alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2408,17 +1536,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2430,17 +1550,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_71 text default NULL; alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2452,17 +1564,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_81 mediumtext default NULL; alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2474,17 +1578,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL first, add column added_11 bigint default NULL; alter table bar add column added_4 varchar(10) default NULL first, add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2496,17 +1592,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL first, add column added_21 bigint default 1234; alter table bar add column added_4 varchar(10) default NULL first, add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2518,17 +1606,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL first, add column added_31 bigint NOT NULL default 54; alter table bar add column added_4 varchar(10) default NULL first, add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2540,17 +1620,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL first, add column added_41 varchar(10) default NULL; alter table bar add column added_4 varchar(10) default NULL first, add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2562,17 +1634,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL first, add column added_51 varchar(10) default "abracadab"; alter table bar add column added_4 varchar(10) default NULL first, add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2584,17 +1648,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_4 varchar(10) default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2606,17 +1662,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL first, add column added_71 text default NULL; alter table bar add column added_4 varchar(10) default NULL first, add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2628,17 +1676,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL first, add column added_81 mediumtext default NULL; alter table bar add column added_4 varchar(10) default NULL first, add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2650,17 +1690,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_11 bigint default NULL; alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2672,17 +1704,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_21 bigint default 1234; alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2694,17 +1718,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_31 bigint NOT NULL default 54; alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2716,17 +1732,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_41 varchar(10) default NULL; alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2738,17 +1746,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_51 varchar(10) default "abracadab"; alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2760,17 +1760,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2782,17 +1774,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_71 text default NULL; alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2804,17 +1788,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_81 mediumtext default NULL; alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2826,17 +1802,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_11 bigint default NULL; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2848,17 +1816,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_21 bigint default 1234; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2870,17 +1830,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_31 bigint NOT NULL default 54; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2892,17 +1844,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_41 varchar(10) default NULL; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2914,17 +1858,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_51 varchar(10) default "abracadab"; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2936,17 +1872,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2958,17 +1886,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_71 text default NULL; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -2980,17 +1900,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_81 mediumtext default NULL; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3002,17 +1914,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL first, add column added_11 bigint default NULL; alter table bar add column added_7 text default NULL first, add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3024,17 +1928,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL first, add column added_21 bigint default 1234; alter table bar add column added_7 text default NULL first, add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3046,17 +1942,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL first, add column added_31 bigint NOT NULL default 54; alter table bar add column added_7 text default NULL first, add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3068,17 +1956,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL first, add column added_41 varchar(10) default NULL; alter table bar add column added_7 text default NULL first, add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3090,17 +1970,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL first, add column added_51 varchar(10) default "abracadab"; alter table bar add column added_7 text default NULL first, add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3112,17 +1984,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_7 text default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3134,17 +1998,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL first, add column added_71 text default NULL; alter table bar add column added_7 text default NULL first, add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3156,17 +2012,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL first, add column added_81 mediumtext default NULL; alter table bar add column added_7 text default NULL first, add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3178,17 +2026,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL first, add column added_11 bigint default NULL; alter table bar add column added_8 mediumtext default NULL first, add column added_11 bigint default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3200,17 +2040,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL first, add column added_21 bigint default 1234; alter table bar add column added_8 mediumtext default NULL first, add column added_21 bigint default 1234; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3222,17 +2054,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL first, add column added_31 bigint NOT NULL default 54; alter table bar add column added_8 mediumtext default NULL first, add column added_31 bigint NOT NULL default 54; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3244,17 +2068,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL first, add column added_41 varchar(10) default NULL; alter table bar add column added_8 mediumtext default NULL first, add column added_41 varchar(10) default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3266,17 +2082,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL first, add column added_51 varchar(10) default "abracadab"; alter table bar add column added_8 mediumtext default NULL first, add column added_51 varchar(10) default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3288,17 +2096,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; alter table bar add column added_8 mediumtext default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3310,17 +2110,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL first, add column added_71 text default NULL; alter table bar add column added_8 mediumtext default NULL first, add column added_71 text default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3332,17 +2124,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL first, add column added_81 mediumtext default NULL; alter table bar add column added_8 mediumtext default NULL first, add column added_81 mediumtext default NULL; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3354,17 +2138,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL after bb, add column added_11 bigint default NULL after bb; alter table bar add column added_1 bigint default NULL after bb, add column added_11 bigint default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3376,17 +2152,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL after bb, add column added_21 bigint default 1234 after bb; alter table bar add column added_1 bigint default NULL after bb, add column added_21 bigint default 1234 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3398,17 +2166,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; alter table bar add column added_1 bigint default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3420,17 +2180,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL after bb, add column added_41 varchar(10) default NULL after bb; alter table bar add column added_1 bigint default NULL after bb, add column added_41 varchar(10) default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3442,17 +2194,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; alter table bar add column added_1 bigint default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3464,17 +2208,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; alter table bar add column added_1 bigint default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3486,17 +2222,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL after bb, add column added_71 text default NULL after bb; alter table bar add column added_1 bigint default NULL after bb, add column added_71 text default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3508,17 +2236,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL after bb, add column added_81 mediumtext default NULL after bb; alter table bar add column added_1 bigint default NULL after bb, add column added_81 mediumtext default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3530,17 +2250,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 after bb, add column added_11 bigint default NULL after bb; alter table bar add column added_2 bigint default -1 after bb, add column added_11 bigint default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3552,17 +2264,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 after bb, add column added_21 bigint default 1234 after bb; alter table bar add column added_2 bigint default -1 after bb, add column added_21 bigint default 1234 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3574,17 +2278,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 after bb, add column added_31 bigint NOT NULL default 54 after bb; alter table bar add column added_2 bigint default -1 after bb, add column added_31 bigint NOT NULL default 54 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3596,17 +2292,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 after bb, add column added_41 varchar(10) default NULL after bb; alter table bar add column added_2 bigint default -1 after bb, add column added_41 varchar(10) default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3618,17 +2306,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 after bb, add column added_51 varchar(10) default "abracadab" after bb; alter table bar add column added_2 bigint default -1 after bb, add column added_51 varchar(10) default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3640,17 +2320,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; alter table bar add column added_2 bigint default -1 after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3662,17 +2334,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 after bb, add column added_71 text default NULL after bb; alter table bar add column added_2 bigint default -1 after bb, add column added_71 text default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3684,17 +2348,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_2 bigint default -1 after bb, add column added_81 mediumtext default NULL after bb; alter table bar add column added_2 bigint default -1 after bb, add column added_81 mediumtext default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3706,17 +2362,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_11 bigint default NULL after bb; alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_11 bigint default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3728,17 +2376,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_21 bigint default 1234 after bb; alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_21 bigint default 1234 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3750,17 +2390,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_31 bigint NOT NULL default 54 after bb; alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_31 bigint NOT NULL default 54 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3772,17 +2404,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_41 varchar(10) default NULL after bb; alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_41 varchar(10) default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3794,17 +2418,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_51 varchar(10) default "abracadab" after bb; alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_51 varchar(10) default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3816,17 +2432,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3838,17 +2446,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_71 text default NULL after bb; alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_71 text default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3860,17 +2460,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_81 mediumtext default NULL after bb; alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_81 mediumtext default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3882,17 +2474,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL after bb, add column added_11 bigint default NULL after bb; alter table bar add column added_4 varchar(10) default NULL after bb, add column added_11 bigint default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3904,17 +2488,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL after bb, add column added_21 bigint default 1234 after bb; alter table bar add column added_4 varchar(10) default NULL after bb, add column added_21 bigint default 1234 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3926,17 +2502,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; alter table bar add column added_4 varchar(10) default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3948,17 +2516,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL after bb, add column added_41 varchar(10) default NULL after bb; alter table bar add column added_4 varchar(10) default NULL after bb, add column added_41 varchar(10) default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3970,17 +2530,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; alter table bar add column added_4 varchar(10) default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -3992,17 +2544,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; alter table bar add column added_4 varchar(10) default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4014,17 +2558,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL after bb, add column added_71 text default NULL after bb; alter table bar add column added_4 varchar(10) default NULL after bb, add column added_71 text default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4036,17 +2572,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_4 varchar(10) default NULL after bb, add column added_81 mediumtext default NULL after bb; alter table bar add column added_4 varchar(10) default NULL after bb, add column added_81 mediumtext default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4058,17 +2586,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_11 bigint default NULL after bb; alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_11 bigint default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4080,17 +2600,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_21 bigint default 1234 after bb; alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_21 bigint default 1234 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4102,17 +2614,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_31 bigint NOT NULL default 54 after bb; alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_31 bigint NOT NULL default 54 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4124,17 +2628,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_41 varchar(10) default NULL after bb; alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_41 varchar(10) default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4146,17 +2642,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_51 varchar(10) default "abracadab" after bb; alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_51 varchar(10) default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4168,17 +2656,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4190,17 +2670,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_71 text default NULL after bb; alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_71 text default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4212,17 +2684,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_81 mediumtext default NULL after bb; alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_81 mediumtext default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4234,17 +2698,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_11 bigint default NULL after bb; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_11 bigint default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4256,17 +2712,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_21 bigint default 1234 after bb; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_21 bigint default 1234 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4278,17 +2726,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_31 bigint NOT NULL default 54 after bb; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_31 bigint NOT NULL default 54 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4300,17 +2740,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_41 varchar(10) default NULL after bb; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_41 varchar(10) default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4322,17 +2754,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_51 varchar(10) default "abracadab" after bb; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_51 varchar(10) default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4344,17 +2768,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4366,17 +2782,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_71 text default NULL after bb; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_71 text default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4388,17 +2796,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_81 mediumtext default NULL after bb; alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_81 mediumtext default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4410,17 +2810,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL after bb, add column added_11 bigint default NULL after bb; alter table bar add column added_7 text default NULL after bb, add column added_11 bigint default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4432,17 +2824,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL after bb, add column added_21 bigint default 1234 after bb; alter table bar add column added_7 text default NULL after bb, add column added_21 bigint default 1234 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4454,17 +2838,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; alter table bar add column added_7 text default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4476,17 +2852,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL after bb, add column added_41 varchar(10) default NULL after bb; alter table bar add column added_7 text default NULL after bb, add column added_41 varchar(10) default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4498,17 +2866,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; alter table bar add column added_7 text default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4520,17 +2880,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; alter table bar add column added_7 text default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4542,17 +2894,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL after bb, add column added_71 text default NULL after bb; alter table bar add column added_7 text default NULL after bb, add column added_71 text default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4564,17 +2908,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_7 text default NULL after bb, add column added_81 mediumtext default NULL after bb; alter table bar add column added_7 text default NULL after bb, add column added_81 mediumtext default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4586,17 +2922,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL after bb, add column added_11 bigint default NULL after bb; alter table bar add column added_8 mediumtext default NULL after bb, add column added_11 bigint default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4608,17 +2936,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL after bb, add column added_21 bigint default 1234 after bb; alter table bar add column added_8 mediumtext default NULL after bb, add column added_21 bigint default 1234 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4630,17 +2950,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; alter table bar add column added_8 mediumtext default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4652,17 +2964,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL after bb, add column added_41 varchar(10) default NULL after bb; alter table bar add column added_8 mediumtext default NULL after bb, add column added_41 varchar(10) default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4674,17 +2978,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; alter table bar add column added_8 mediumtext default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4696,17 +2992,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; alter table bar add column added_8 mediumtext default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4718,17 +3006,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL after bb, add column added_71 text default NULL after bb; alter table bar add column added_8 mediumtext default NULL after bb, add column added_71 text default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4740,17 +3020,9 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_8 mediumtext default NULL after bb, add column added_81 mediumtext default NULL after bb; alter table bar add column added_8 mediumtext default NULL after bb, add column added_81 mediumtext default NULL after bb; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; @@ -4762,16 +3034,8 @@ insert into foo values (NULL,"oifds",NULL,"fdsjfds"); insert into foo values ("rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table foo add column added_1 bigint default NULL, add column added_2 bigint default -1 after bb, add column added_3 bigint NOT NULL default -1; alter table bar add column added_1 bigint default NULL, add column added_2 bigint default -1 after bb, add column added_3 bigint NOT NULL default -1; include/diff_tables.inc [test.foo, test.bar] -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead -Warnings: -Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead drop table foo; drop table bar; |