|
1
by brian
clean slate |
1 |
drop table if exists t1;
|
2 |
CREATE TABLE t1 (a int, unique (a), b int not null, unique(b), c int not null, index(c));
|
|
3 |
replace into t1 values (1,1,1),(2,2,2),(3,1,3);
|
|
4 |
select * from t1;
|
|
5 |
a b c
|
|
|
496.1.4
by Paul McCullagh
Changes to .result files to run both PBXT and InnoDB |
6 |
2 2 2
|
|
1
by brian
clean slate |
7 |
3 1 3
|
8 |
check table t1;
|
|
9 |
Table Op Msg_type Msg_text
|
|
10 |
test.t1 check status OK
|
|
11 |
drop table t1;
|