Debian Codegraph @

mysql-test/suite/ndbcrunch/check.test

raw
1 --source include/not_parallel.inc
2 --source include/have_ndb.inc
3
4 #
5 # Basic test of the crunch cluster setup
6 #
7
8 --echo # ##################################################
9 --echo # Show configured data nodes
10 SELECT node_id, status FROM ndbinfo.nodes ORDER BY node_id;
11
12 --echo # ##################################################
13 --echo # Run traditional basic.test snippet
14 CREATE TABLE t1 (
15 a int PRIMARY KEY,
16 b varchar(255)
17 ) ENGINE = NDB;
18 INSERT INTO t1 VALUES (1, "MySQL Server with NDB");
19 INSERT INTO t1 (a, b) VALUES (11, "Barrier effect");
20 INSERT INTO t1 (a, b) VALUES
21 (12, "The third row"),
22 (37, "And of course number 37");
23 SELECT * FROM t1 WHERE a = 1;
24 UPDATE t1 SET b = CONCAT(b, " test") WHERE a = 1;
25 SELECT * FROM t1 WHERE a = 1;
26 REPLACE t1 (a, b) VALUES (12, "Another layer");
27 SELECT * FROM t1 WHERE a = 12 ORDER BY a;
28 DELETE FROM t1 WHERE a = 11;
29 SELECT COUNT(*) FROM t1;
30 SELECT b FROM t1 WHERE b LIKE "MySQL%";
31 DELETE FROM t1 ORDER BY b DESC;
32 DROP TABLE t1;
33
34 #
35 # NOTE! Don't add any more tests here, this is the _basic_ test, not test all!
36 #