Debian Codegraph @

mysql-test/suite/ndb/r/ndb_multi_row.result

raw
1 drop table if exists t1, t2, t3, t4;
2 flush status;
3 drop table if exists t1, t2, t3, t4;
4 flush status;
5 create table t1 (a int) engine=ndbcluster;
6 create table t2 (a int) engine=ndbcluster;
7 insert into t1 value (2);
8 insert into t2 value (3);
9 select * from t1;
10 a
11 2
12 select * from t2;
13 a
14 3
15 show status like 'handler_discover%';
16 Variable_name Value
17 Handler_discover 0
18 select * from t1;
19 a
20 2
21 drop table t1;
22 create table t1 (a int) engine=ndbcluster;
23 insert into t1 value (2);
24 select * from t1;
25 a
26 2
27 show status like 'handler_discover%';
28 Variable_name Value
29 Handler_discover 0
30 drop table t1;
31 create table t1 (a int) engine=ndbcluster;
32 insert into t1 value (2);
33 select * from t1;
34 a
35 2
36 flush status;
37 select * from t1;
38 a
39 2
40 update t1 set a=3 where a=2;
41 show status like 'handler_discover%';
42 Variable_name Value
43 Handler_discover 0
44 create table t3 (a int not null primary key, b varchar(22),
45 c int, last_col text) engine=ndb;
46 insert into t3 values(1, 'Hi!', 89, 'Longtext column');
47 create table t4 (pk int primary key, b int) engine=ndb;
48 select * from t1;
49 a
50 3
51 select * from t3;
52 a b c last_col
53 1 Hi! 89 Longtext column
54 show tables like 't4';
55 Tables_in_test (t4)
56 t4
57 show tables;
58 Tables_in_test
59 t1
60 t2
61 t3
62 t4
63 drop table t1, t2, t3, t4;
64 drop table if exists t1, t3, t4;
65 Warnings:
66 Note 1051 Unknown table 'test.t1'
67 Note 1051 Unknown table 'test.t3'
68 Note 1051 Unknown table 'test.t4'