diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_add_index/r/add_index_5.result')
| -rw-r--r-- | storage/tokudb/mysql-test/tokudb_add_index/r/add_index_5.result | 161 |
1 files changed, 161 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_add_index/r/add_index_5.result b/storage/tokudb/mysql-test/tokudb_add_index/r/add_index_5.result new file mode 100644 index 00000000000..cb55c4630d1 --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb_add_index/r/add_index_5.result @@ -0,0 +1,161 @@ +SET DEFAULT_STORAGE_ENGINE='tokudb'; +*** Bug #22169 *** +DROP TABLE IF EXISTS t1; +CREATE TABLE t1 (a int, b int, c int, z int, y int, x int, r int, s int, t int, primary key (a,b), key (z), key(x), key(t)); +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL foo foo NULL NULL NULL; Using where; Using index +c r a b +0 20 10 0 +2 18 9 1 +4 16 8 2 +6 14 7 3 +8 12 6 4 +10 10 5 5 +12 8 4 6 +14 6 3 7 +16 4 2 8 +18 2 1 9 +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL NULL NULL NULL NULL NULL; +a b c z y x r s t +1 9 18 10 100 1000 2 3 4 +2 8 16 20 200 2000 4 6 8 +3 7 14 30 300 3000 6 9 12 +4 6 12 40 400 4000 8 12 16 +5 5 10 50 500 5000 10 15 20 +6 4 8 60 600 6000 12 18 24 +7 3 6 70 700 7000 14 21 28 +8 2 4 80 800 8000 16 24 32 +9 1 2 90 900 9000 18 27 36 +10 0 0 100 1000 10000 20 30 40 +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL NULL NULL NULL NULL NULL; Using where +c r a b +18 2 1 9 +16 4 2 8 +14 6 3 7 +12 8 4 6 +10 10 5 5 +8 12 6 4 +6 14 7 3 +4 16 8 2 +2 18 9 1 +0 20 10 0 +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL NULL NULL NULL NULL NULL; +a b c z y x r s t +1 9 18 10 100 1000 2 3 4 +2 8 16 20 200 2000 4 6 8 +3 7 14 30 300 3000 6 9 12 +4 6 12 40 400 4000 8 12 16 +5 5 10 50 500 5000 10 15 20 +6 4 8 60 600 6000 12 18 24 +7 3 6 70 700 7000 14 21 28 +8 2 4 80 800 8000 16 24 32 +9 1 2 90 900 9000 18 27 36 +10 0 0 100 1000 10000 20 30 40 +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL foo foo NULL NULL NULL; Using where; Using index +c r a b +0 20 10 0 +2 18 9 1 +4 16 8 2 +6 14 7 3 +8 12 6 4 +10 10 5 5 +12 8 4 6 +14 6 3 7 +16 4 2 8 +18 2 1 9 +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL NULL NULL NULL NULL NULL; +a b c z y x r s t +1 9 18 10 100 1000 2 3 4 +2 8 16 20 200 2000 4 6 8 +3 7 14 30 300 3000 6 9 12 +4 6 12 40 400 4000 8 12 16 +5 5 10 50 500 5000 10 15 20 +6 4 8 60 600 6000 12 18 24 +7 3 6 70 700 7000 14 21 28 +8 2 4 80 800 8000 16 24 32 +9 1 2 90 900 9000 18 27 36 +10 0 0 100 1000 10000 20 30 40 +ERROR 42000: Duplicate key name 'foo' +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL foo foo NULL NULL NULL; Using where; Using index +c r a b +0 20 10 0 +2 18 9 1 +4 16 8 2 +6 14 7 3 +8 12 6 4 +10 10 5 5 +12 8 4 6 +14 6 3 7 +16 4 2 8 +18 2 1 9 +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL NULL NULL NULL NULL NULL; +a b c z y x r s t +1 9 18 10 100 1000 2 3 4 +2 8 16 20 200 2000 4 6 8 +3 7 14 30 300 3000 6 9 12 +4 6 12 40 400 4000 8 12 16 +5 5 10 50 500 5000 10 15 20 +6 4 8 60 600 6000 12 18 24 +7 3 6 70 700 7000 14 21 28 +8 2 4 80 800 8000 16 24 32 +9 1 2 90 900 9000 18 27 36 +10 0 0 100 1000 10000 20 30 40 +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL z z NULL NULL NULL; Using where; Using index +z a b +10 1 9 +20 2 8 +30 3 7 +40 4 6 +50 5 5 +60 6 4 +70 7 3 +80 8 2 +90 9 1 +100 10 0 +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL NULL NULL NULL NULL NULL; +a b c z y x r s t +1 9 18 10 100 1000 2 3 4 +2 8 16 20 200 2000 4 6 8 +3 7 14 30 300 3000 6 9 12 +4 6 12 40 400 4000 8 12 16 +5 5 10 50 500 5000 10 15 20 +6 4 8 60 600 6000 12 18 24 +7 3 6 70 700 7000 14 21 28 +8 2 4 80 800 8000 16 24 32 +9 1 2 90 900 9000 18 27 36 +10 0 0 100 1000 10000 20 30 40 +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL foo foo NULL NULL NULL; Using where; Using index +c r a b +0 20 10 0 +2 18 9 1 +4 16 8 2 +6 14 7 3 +8 12 6 4 +10 10 5 5 +12 8 4 6 +14 6 3 7 +16 4 2 8 +18 2 1 9 +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL NULL NULL NULL NULL NULL; +a b c z y x r s t +1 9 18 10 100 1000 2 3 4 +2 8 16 20 200 2000 4 6 8 +3 7 14 30 300 3000 6 9 12 +4 6 12 40 400 4000 8 12 16 +5 5 10 50 500 5000 10 15 20 +6 4 8 60 600 6000 12 18 24 +7 3 6 70 700 7000 14 21 28 +8 2 4 80 800 8000 16 24 32 +9 1 2 90 900 9000 18 27 36 +10 0 0 100 1000 10000 20 30 40 |