|
1701.4.1
by Stewart Smith
some basic tests for PBXT |
1 |
CREATE TABLE t1 (a int primary key); |
2 |
SHOW CREATE TABLE t1; |
|
3 |
Table Create Table |
|
4 |
t1 CREATE TABLE `t1` ( |
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
5 |
`a` INT NOT NULL, |
|
1701.4.1
by Stewart Smith
some basic tests for PBXT |
6 |
PRIMARY KEY (`a`) |
|
1720.1.2
by Patrick Crews
Updated pbxt tests due to inclusion of COLLATE info in SHOW CREATE TABLE output now. Only re-recorded .result files |
7 |
) ENGINE=InnoDB COLLATE = utf8_general_ci |
|
1701.4.1
by Stewart Smith
some basic tests for PBXT |
8 |
CREATE TABLE t1 (a int primary key); |
9 |
ERROR 42S01: Table 'test.t1' already exists |
|
10 |
CREATE TABLE t2 (a int primary key, b varchar(20), c bigint); |
|
11 |
DROP TABLE t1, t2; |