Debian Codegraph @

mysql-test/suite/ndbcrunch/check.result

raw
1 # ##################################################
2 # Show configured data nodes
3 SELECT node_id, status FROM ndbinfo.nodes ORDER BY node_id;
4 node_id status
5 1 STARTED
6 2 STARTED
7 # ##################################################
8 # Run traditional basic.test snippet
9 CREATE TABLE t1 (
10 a int PRIMARY KEY,
11 b varchar(255)
12 ) ENGINE = NDB;
13 INSERT INTO t1 VALUES (1, "MySQL Server with NDB");
14 INSERT INTO t1 (a, b) VALUES (11, "Barrier effect");
15 INSERT INTO t1 (a, b) VALUES
16 (12, "The third row"),
17 (37, "And of course number 37");
18 SELECT * FROM t1 WHERE a = 1;
19 a b
20 1 MySQL Server with NDB
21 UPDATE t1 SET b = CONCAT(b, " test") WHERE a = 1;
22 SELECT * FROM t1 WHERE a = 1;
23 a b
24 1 MySQL Server with NDB test
25 REPLACE t1 (a, b) VALUES (12, "Another layer");
26 SELECT * FROM t1 WHERE a = 12 ORDER BY a;
27 a b
28 12 Another layer
29 DELETE FROM t1 WHERE a = 11;
30 SELECT COUNT(*) FROM t1;
31 COUNT(*)
32 3
33 SELECT b FROM t1 WHERE b LIKE "MySQL%";
34 b
35 MySQL Server with NDB test
36 DELETE FROM t1 ORDER BY b DESC;
37 DROP TABLE t1;