summaryrefslogtreecommitdiff
path: root/storage/myisammrg/mysql-test/storage_engine/create_table.rdiff
blob: 5d3578ad3cd1dbbefcf3bd987d0fa9cf8c5f4f5f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
7c7
< ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
---
> ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`)
16c16
< ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
---
> ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`)
22c22
< ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
---
> ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`)
27,36c27,35
< SHOW CREATE TABLE t1;
< Table	Create Table
< t1	CREATE TABLE `t1` (
<   `1` bigint(20) NOT NULL DEFAULT '0'
< ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
< SELECT * FROM t1;
< 1
< 1
< 2
< DROP TABLE t1;
---
> ERROR HY000: 'test.t1' is not BASE TABLE
> # ERROR: Statement ended with errno 1347, errname ER_WRONG_OBJECT (expected to succeed)
> # ------------ UNEXPECTED RESULT ------------
> # The statement|command finished with ER_WRONG_OBJECT.
> # CREATE TABLE .. AS SELECT or the mix could be unsupported|malfunctioning, or the problem was caused by previous errors. 
> # You can change the engine code, or create an rdiff, or disable the test by adding it to disabled.def.
> # Further in this test, the message might sometimes be suppressed; a part of the test might be skipped.
> # Also, this problem may cause a chain effect (more errors of different kinds in the test).
> # -------------------------------------------
43c42
< ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
---
> ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`)