Debian Codegraph @

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

raw
1 CREATE TABLE t1 (
2 c1 INT PRIMARY KEY AUTO_INCREMENT,
3 c2 INT UNSIGNED NOT NULL DEFAULT 0,
4 c3 FLOAT DEFAULT 1.5,
5 c4 VARCHAR(255) NOT NULL DEFAULT '',
6 c5 TIME,
7 c6 DATE,
8 c7 DATETIME,
9 c8 BLOB,
10 c9 CHAR(30) DEFAULT 'a',
11 c10 VARBINARY(255),
12 c11 DECIMAL(5,2),
13 c12 DATETIME(6),
14 c13 TIMESTAMP(2),
15 c14 TIMESTAMP,
16 c15 YEAR,
17 c16 INT NOT NULL,
18 UNIQUE KEY xc2(c2),
19 UNIQUE KEY uk(c16) USING HASH,
20 INDEX idx(c16)
21 ) ENGINE NDB;
22 ALTER TABLE t1 DROP INDEX uk;
23 INSERT INTO t1 VALUES(1,1,2.5,'a','23:59:59','2018-01-30','2018-01-30 13:46:00','b','c','d',78.3,'2020-06-01 16:36:04.297','2020-06-01 16:36:04.297','2020-06-01 16:36:04','1918',35);
24 CREATE TABLE t2 (
25 c1 INT PRIMARY KEY,
26 c2 INT GENERATED ALWAYS AS (c1*c1) VIRTUAL
27 ) ENGINE NDB;
28 INSERT INTO t2(c1) VALUES(2);
29 CREATE LOGFILE GROUP lg1
30 ADD UNDOFILE 'undofile.dat'
31 INITIAL_SIZE 1M
32 UNDO_BUFFER_SIZE = 1M
33 ENGINE=NDB;
34 CREATE TABLESPACE ts1
35 ADD DATAFILE 'datafile.dat'
36 USE LOGFILE GROUP lg1
37 INITIAL_SIZE 8M
38 EXTENT_SIZE 256k
39 ENGINE NDB;
40 CREATE TABLE t3 (
41 a INT STORAGE DISK,
42 b INT COLUMN_FORMAT DYNAMIC,
43 c BIT(8) NOT NULL
44 ) TABLESPACE ts1 ENGINE NDB;
45 INSERT INTO t3 VALUES (10000,325,b'1');
46 TRUNCATE TABLE t3;
47 CREATE TABLE t4 (
48 a INT PRIMARY KEY
49 ) STORAGE DISK TABLESPACE ts1 ENGINE NDB;
50 INSERT INTO t4 VALUES (10001);
51 CREATE TABLE t5 (
52 a INT PRIMARY KEY
53 ) ENGINE NDB;
54 ALTER TABLE t5 STORAGE DISK TABLESPACE ts1;
55 INSERT INTO t5 VALUES (15980);
56 CREATE TABLE t6 (
57 a INT,
58 b INT COLUMN_FORMAT FIXED,
59 PRIMARY KEY pk USING HASH(a)
60 ) ENGINE NDB;
61 CREATE TABLE t7 (
62 a INT PRIMARY KEY,
63 b BIT(3) DEFAULT b'111'
64 ) ENGINE NDB;
65 CREATE TABLE t8 (
66 a INT PRIMARY KEY
67 ) ENGINE NDB;
68 ALTER TABLE t8 ALGORITHM=INPLACE,
69 ADD COLUMN b INT COLUMN_FORMAT DYNAMIC;
70 DROP TABLE t1,t2,t3,t4,t5,t6,t7,t8;
71 ALTER TABLESPACE ts1
72 DROP DATAFILE 'datafile.dat';
73 DROP TABLESPACE ts1;
74 DROP LOGFILE GROUP lg1
75 ENGINE NDB;
76 CREATE TABLE parent (
77 col1 INT PRIMARY KEY,
78 col2 INT,
79 UNIQUE p_ukc2(col2)
80 ) ENGINE NDB;
81 CREATE TABLE child (
82 c1 INT,
83 c2 INT,
84 INDEX c_xc1 (c1),
85 INDEX c_xc2 (c2),
86 CONSTRAINT c_fk1
87 FOREIGN KEY (c1)
88 REFERENCES parent(col1),
89 CONSTRAINT c_fk2
90 FOREIGN KEY (c2)
91 REFERENCES parent(col2)
92 ) ENGINE NDB;
93 INSERT INTO parent VALUES (1,1);
94 DROP TABLE child,parent;
95 CREATE TABLE parent (
96 pk INT PRIMARY KEY,
97 id1 INT UNIQUE,
98 id2 INT UNIQUE,
99 id3 INT UNIQUE,
100 ref1 INT,
101 ref2 INT,
102 ref3 INT
103 ) ENGINE NDB;
104 CREATE TABLE child (
105 pk INT PRIMARY KEY,
106 ref1 INT,
107 ref2 INT
108 ) ENGINE NDB;
109 ALTER TABLE parent
110 ADD CONSTRAINT fk_p1 FOREIGN KEY ref1_idx(ref1) REFERENCES parent(id1),
111 ALGORITHM = COPY;
112 DROP TABLE child,parent;
113 CREATE TABLE t1 (
114 c1 INT PRIMARY KEY,
115 c2 INT
116 ) ENGINE NDB;
117 DROP TABLE t1;
118 SHOW CREATE TABLE t1;
119 Table Create Table
120 t1 CREATE TABLE `t1` (
121 `c1` int NOT NULL,
122 `c2` int DEFAULT NULL,
123 PRIMARY KEY (`c1`)
124 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
125 DROP TABLE t1;