diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/prim_key_5.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/prim_key_5.result | 79 |
1 files changed, 79 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/prim_key_5.result b/storage/tokudb/mysql-test/tokudb/r/prim_key_5.result new file mode 100644 index 00000000000..2f930127833 --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb/r/prim_key_5.result @@ -0,0 +1,79 @@ +SET DEFAULT_STORAGE_ENGINE='tokudb'; +*** Bug #22169 *** +DROP TABLE IF EXISTS t1; +CREATE TABLE t1 (a int, b bigint, c char(10), d date, e int, primary key (a)); +INSERT into t1 values (1,54,"zardosht", '1986-08-30', 3287); +INSERT into t1 values (2,8709,"Alaadin", '1789-01-31', 8327); +INSERT into t1 values (3,234,"Gilbert", '1325-05-21', 871233); +INSERT into t1 values (4,563,"Lois", '1981-11-06', 654); +INSERT into t1 values (5,587,"Lexington", '1844-03-01', 75); +INSERT into t1 values (6,934764,"Goliath", '1161-11-01', 453); +INSERT into t1 values (7,109234,"Peter", '2005-11-01', 5); +INSERT into t1 values (8,9438,"Bart", '1472-11-01', 234); +INSERT into t1 values (9,111111111,"Superman", '1776-07-04', 65); +INSERT into t1 values (10,50000004,"Batman", '1981-11-01', 87423); +SELECT * from t1; +a b c d e +1 54 zardosht 1986-08-30 3287 +2 8709 Alaadin 1789-01-31 8327 +3 234 Gilbert 1325-05-21 871233 +4 563 Lois 1981-11-06 654 +5 587 Lexington 1844-03-01 75 +6 934764 Goliath 1161-11-01 453 +7 109234 Peter 2005-11-01 5 +8 9438 Bart 1472-11-01 234 +9 111111111 Superman 1776-07-04 65 +10 50000004 Batman 1981-11-01 87423 +alter table t1 drop primary key; +SELECT * from t1; +a b c d e +1 54 zardosht 1986-08-30 3287 +2 8709 Alaadin 1789-01-31 8327 +3 234 Gilbert 1325-05-21 871233 +4 563 Lois 1981-11-06 654 +5 587 Lexington 1844-03-01 75 +6 934764 Goliath 1161-11-01 453 +7 109234 Peter 2005-11-01 5 +8 9438 Bart 1472-11-01 234 +9 111111111 Superman 1776-07-04 65 +10 50000004 Batman 1981-11-01 87423 +alter table t1 add primary key (a,d,c(3),e,b); +SELECT * from t1; +a b c d e +1 54 zardosht 1986-08-30 3287 +2 8709 Alaadin 1789-01-31 8327 +3 234 Gilbert 1325-05-21 871233 +4 563 Lois 1981-11-06 654 +5 587 Lexington 1844-03-01 75 +6 934764 Goliath 1161-11-01 453 +7 109234 Peter 2005-11-01 5 +8 9438 Bart 1472-11-01 234 +9 111111111 Superman 1776-07-04 65 +10 50000004 Batman 1981-11-01 87423 +alter table t1 drop primary key; +SELECT * from t1; +a b c d e +1 54 zardosht 1986-08-30 3287 +2 8709 Alaadin 1789-01-31 8327 +3 234 Gilbert 1325-05-21 871233 +4 563 Lois 1981-11-06 654 +5 587 Lexington 1844-03-01 75 +6 934764 Goliath 1161-11-01 453 +7 109234 Peter 2005-11-01 5 +8 9438 Bart 1472-11-01 234 +9 111111111 Superman 1776-07-04 65 +10 50000004 Batman 1981-11-01 87423 +alter table t1 add primary key (e,d,c(3),b,a); +SELECT * from t1; +a b c d e +7 109234 Peter 2005-11-01 5 +9 111111111 Superman 1776-07-04 65 +5 587 Lexington 1844-03-01 75 +8 9438 Bart 1472-11-01 234 +6 934764 Goliath 1161-11-01 453 +4 563 Lois 1981-11-06 654 +1 54 zardosht 1986-08-30 3287 +2 8709 Alaadin 1789-01-31 8327 +10 50000004 Batman 1981-11-01 87423 +3 234 Gilbert 1325-05-21 871233 +DROP TABLE t1; |