diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_bugs/r/1833.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb_bugs/r/1833.result | 84 |
1 files changed, 84 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_bugs/r/1833.result b/storage/tokudb/mysql-test/tokudb_bugs/r/1833.result new file mode 100644 index 00000000000..2dae2efe763 --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb_bugs/r/1833.result @@ -0,0 +1,84 @@ +SET DEFAULT_STORAGE_ENGINE = 'tokudb'; +DROP TABLE IF EXISTS foo; +create table foo (a int, b int, primary key (a))engine=tokudb; +insert into foo values (1,10),(2,2),(3,300),(4,40); +select * from foo; +a b +1 10 +2 2 +3 300 +4 40 +replace into foo values (5,50),(10,1000); +select * from foo; +a b +1 10 +2 2 +3 300 +4 40 +5 50 +10 1000 +replace into foo (a) values (1),(3); +select * from foo; +a b +1 NULL +2 2 +3 NULL +4 40 +5 50 +10 1000 +replace into foo values (1,1),(3,3),(6,60); +select * from foo; +a b +1 1 +2 2 +3 3 +4 40 +5 50 +6 60 +10 1000 +alter table foo add index (b); +select b from foo; +b +1 +2 +3 +40 +50 +60 +1000 +select * from foo; +a b +1 1 +2 2 +3 3 +4 40 +5 50 +6 60 +10 1000 +delete from foo where a > 4; +replace into foo values (1,10),(2,2),(3,300),(4,40); +select * from foo use index (primary); +a b +1 10 +2 2 +3 300 +4 40 +replace into foo values (5,50),(10,1000); +select * from foo use index (primary); +a b +1 10 +2 2 +3 300 +4 40 +5 50 +10 1000 +replace into foo (a) values (1),(2),(3),(4); +select * from foo use index (primary); +a b +1 NULL +2 NULL +3 NULL +4 NULL +5 50 +10 1000 +DROP TABLE foo; |