|
1193.2.1
by Joe Daly
add new tests for create table with select, update with a subquery, and a call to rand() |
1 |
#
|
2 |
# Test that create with select works |
|
3 |
#
|
|
4 |
||
5 |
--disable_warnings |
|
6 |
DROP TABLE IF EXISTS t1; |
|
7 |
DROP TABLE IF EXISTS t2; |
|
8 |
--enable_warnings |
|
9 |
||
10 |
CREATE TABLE t1 ( |
|
|
1143.2.37
by Jay Pipes
Merge Joe's new test cases for transaction log |
11 |
id INT NOT NULL PRIMARY KEY |
|
1193.2.1
by Joe Daly
add new tests for create table with select, update with a subquery, and a call to rand() |
12 |
, padding VARCHAR(200) NOT NULL |
13 |
);
|
|
14 |
||
15 |
INSERT INTO t1 VALUES (1, "I love testing."); |
|
16 |
INSERT INTO t1 VALUES (2, "I hate testing."); |
|
17 |
||
18 |
CREATE TABLE t2 ( |
|
|
1143.2.37
by Jay Pipes
Merge Joe's new test cases for transaction log |
19 |
id INT NOT NULL PRIMARY KEY |
|
1193.2.1
by Joe Daly
add new tests for create table with select, update with a subquery, and a call to rand() |
20 |
, padding VARCHAR(200) NOT NULL |
|
1143.2.37
by Jay Pipes
Merge Joe's new test cases for transaction log |
21 |
) SELECT * FROM t1; |
|
1193.2.6
by Joe Daly
remove sub_select test thsi is still failing on updating a primary key. Add drop table to rand, create_select tests |
22 |
|
23 |
DROP TABLE t1, t2; |