Debian Codegraph @

mysql-test/suite/ndbcluster/select_count.result

raw
1 CREATE TABLE t_ndb(c1 INT NOT NULL PRIMARY KEY,
2 c2 INT NOT NULL,
3 c3 char(20),
4 KEY c3_idx(c3)) ENGINE=ndbcluster;
5 INSERT INTO t_ndb VALUES (1,1, '9412'), (2,2, '9413');
6 CREATE TABLE t_innodb(c1 INT NOT NULL PRIMARY KEY,
7 c2 INT NOT NULL,
8 c3 char(20),
9 KEY c3_idx(c3))ENGINE=INNODB;
10 INSERT INTO t_innodb VALUES (1, 1, 'a'), (2,2,'a'), (3,3,'a');
11 ANALYZE TABLE t_innodb;
12 Table Op Msg_type Msg_text
13 test.t_innodb analyze status OK
14 EXPLAIN SELECT COUNT(*) FROM t_ndb;
15 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
16 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # # Select tables optimized away
17 Warnings:
18 Note 1003 /* select#1 */ select count(0) AS `COUNT(*)` from `test`.`t_ndb`
19 EXPLAIN SELECT COUNT(*) FROM t_ndb, t_innodb;
20 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
21 1 SIMPLE t_ndb p0,p1,p2,p3,p4,p5,p6,p7 ALL NULL NULL NULL NULL # # NULL
22 1 SIMPLE t_innodb NULL index NULL c3_idx 81 NULL # # Using index
23 Warnings:
24 Note 1003 /* select#1 */ select count(0) AS `COUNT(*)` from `test`.`t_ndb` join `test`.`t_innodb`
25 SELECT COUNT(*) FROM t_ndb;
26 COUNT(*)
27 2
28 SELECT COUNT(*) FROM t_ndb, t_innodb;
29 COUNT(*)
30 6
31 DROP TABLE t_ndb, t_innodb;