diff options
| author | unknown <Li-Bing.Song@sun.com> | 2010-08-18 17:35:41 +0800 |
|---|---|---|
| committer | unknown <Li-Bing.Song@sun.com> | 2010-08-18 17:35:41 +0800 |
| commit | d0d8bbed5e901e59044be6bcaa6d4020238a1eb4 (patch) | |
| tree | c731d148d97af93063d14bda3e39d1ac5f45a74e /mysql-test/r/ps_ddl.result | |
| parent | e28d6ee66a8404dd0f8fe3aaabb9d72544e5d42e (diff) | |
| download | mariadb-git-d0d8bbed5e901e59044be6bcaa6d4020238a1eb4.tar.gz | |
WL#5370 Keep forward-compatibility when changing
'CREATE TABLE IF NOT EXISTS ... SELECT' behaviour
BUG#47132, BUG#47442, BUG49494, BUG#23992 and BUG#48814 will disappear
automatically after the this patch.
BUG#55617 is fixed by this patch too.
This is the 5.5 part.
It implements:
- 'CREATE TABLE IF NOT EXISTS ... SELECT' statement will not insert
anything and binlog anything if the table already exists.
It only generate a warning that table already exists.
- A couple of test cases for the behavior changing.
Diffstat (limited to 'mysql-test/r/ps_ddl.result')
| -rw-r--r-- | mysql-test/r/ps_ddl.result | 4 |
1 files changed, 0 insertions, 4 deletions
diff --git a/mysql-test/r/ps_ddl.result b/mysql-test/r/ps_ddl.result index 9752c5160a6..76d6c735f43 100644 --- a/mysql-test/r/ps_ddl.result +++ b/mysql-test/r/ps_ddl.result @@ -1833,7 +1833,6 @@ SUCCESS select * from t2; a 1 -1 execute stmt; Warnings: Note 1050 Table 't2' already exists @@ -1843,8 +1842,6 @@ SUCCESS select * from t2; a 1 -1 -1 drop table t2; create temporary table t2 (a varchar(10)); execute stmt; @@ -1852,7 +1849,6 @@ Warnings: Note 1050 Table 't2' already exists select * from t2; a -1 call p_verify_reprepare_count(1); SUCCESS |