Debian Codegraph @

mysql-test/suite/gcol/r/federated_gcol.result

raw
1 stop slave;
2 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
3 reset master;
4 reset slave;
5 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
6 start slave;
7 stop slave;
8 DROP DATABASE IF EXISTS federated;
9 CREATE DATABASE federated;
10 DROP DATABASE IF EXISTS federated;
11 CREATE DATABASE federated;
12 SET @OLD_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT;
13 SET @@GLOBAL.CONCURRENT_INSERT= 0;
14 DROP TABLE IF EXISTS federated.t1;
15 Warnings:
16 Note 1051 Unknown table 't1'
17 DROP TABLE IF EXISTS federated.t1;
18 Warnings:
19 Note 1051 Unknown table 't1'
20 CREATE TABLE federated.t1 (
21 `id` int(20) NOT NULL,
22 `group` int NOT NULL default 0,
23 `tmp` virtual int as (`id` + 1)
24 )
25 ENGINE="FEDERATED" DEFAULT CHARSET=latin1
26 CONNECTION='mysql://[email protected]:SLAVE_PORT/federated/t1';
27 ERROR HY000: 'Specified storage engine' is not yet supported for generated columns.
28 CREATE TABLE federated.t1 (
29 `id` int(20) NOT NULL,
30 `group` int NOT NULL default 0
31 )
32 ENGINE="FEDERATED" DEFAULT CHARSET=latin1
33 CONNECTION='mysql://[email protected]:SLAVE_PORT/federated/t1';
34 alter table federated.t1 add column `tmp` virtual int as (`id` + 1);
35 ERROR HY000: Table storage engine for 't1' doesn't have this option
36 DROP TABLE IF EXISTS federated.t1;
37 End of 5.1 tests
38 DROP TABLE IF EXISTS federated.t1;
39 DROP DATABASE IF EXISTS federated;
40 DROP TABLE IF EXISTS federated.t1;
41 DROP DATABASE IF EXISTS federated;
42 SET @@GLOBAL.CONCURRENT_INSERT= @OLD_CONCURRENT_INSERT;
43 DROP VIEW IF EXISTS v1,v2;
44 DROP TABLE IF EXISTS t1,t2,t3;
45 DROP PROCEDURE IF EXISTS p1;
46 DROP FUNCTION IF EXISTS f1;
47 DROP TRIGGER IF EXISTS trg1;
48 DROP TRIGGER IF EXISTS trg2;
49 set sql_warnings = 0;