1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
*** Bug #23945 ***
SET DEFAULT_STORAGE_ENGINE = tokudb;
DROP TABLE IF EXISTS t1;
SET AUTOCOMMIT = 1;
CREATE TABLE t1 (PRIMARY KEY (a)) SELECT 1 AS a UNION ALL SELECT 1;
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
SELECT * FROM t1;
ERROR 42S02: Table 'test.t1' doesn't exist
DROP TABLE t1;
ERROR 42S02: Unknown table 'test.t1'
SET AUTOCOMMIT = 0;
CREATE TABLE t1 (PRIMARY KEY (a)) SELECT 1 AS a UNION ALL SELECT 1;
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
SELECT * FROM t1;
ERROR 42S02: Table 'test.t1' doesn't exist
DROP TABLE t1;
ERROR 42S02: Unknown table 'test.t1'
create table t1 (a int, b int) engine=MyISAM;
insert into t1 values (1,1),(1,2);
alter table t1 engine=TokuDB, add unique key (a);
ERROR 23000: Duplicate entry '1' for key 'a'
drop table t1;
|
