Debian Codegraph @

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

raw
1 SET @old_ndb_metadata_check_mysqld2 = @@global.ndb_metadata_check;
2 SET GLOBAL ndb_metadata_check = false;
3 SET @old_ndb_metadata_check_mysqld1 = @@global.ndb_metadata_check;
4 SET GLOBAL ndb_metadata_check = false;
5 SHOW CREATE TABLE t_num;
6 Table Create Table
7 t_num CREATE TABLE `t_num` (
8 `t_pk` int NOT NULL,
9 `t_bit` bit(64) DEFAULT NULL,
10 `t_tinyint` tinyint DEFAULT NULL,
11 `t_bool` tinyint(1) DEFAULT NULL,
12 `t_smallint` smallint DEFAULT NULL,
13 `t_mediumint` mediumint DEFAULT NULL,
14 `t_int` int DEFAULT NULL,
15 `t_bigint` bigint DEFAULT NULL,
16 `t_float` float DEFAULT NULL,
17 `t_double` double DEFAULT NULL,
18 `t_decimal` decimal(37,16) DEFAULT NULL,
19 PRIMARY KEY (`t_pk`)
20 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
21 SHOW CREATE TABLE t_datetime;
22 ERROR 42S02: Table 'test.t_datetime' doesn't exist
23 SHOW WARNINGS;
24 Level Code Message
25 Warning 10923 Table definition contains obsolete data types such as old temporal or decimal types
26 Warning 1296 Failed to discover table 't_datetime' from NDB, could not upgrade table with extra metadata version 1
27 Error 1146 Table 'test.t_datetime' doesn't exist
28 SHOW CREATE TABLE t_string_1;
29 Table Create Table
30 t_string_1 CREATE TABLE `t_string_1` (
31 `t_pk` int NOT NULL,
32 `t_char` char(255) DEFAULT NULL,
33 `t_varchar` varchar(655) DEFAULT NULL,
34 `t_binary` binary(255) DEFAULT NULL,
35 `t_varbinary` varbinary(6553) DEFAULT NULL,
36 PRIMARY KEY (`t_pk`)
37 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
38 SHOW CREATE TABLE t_string_2;
39 Table Create Table
40 t_string_2 CREATE TABLE `t_string_2` (
41 `t_pk` int NOT NULL,
42 `t_tinyblob` tinyblob,
43 `t_tinytext` tinytext,
44 `t_blob` blob,
45 `t_text` text,
46 `t_mediumblob` mediumblob,
47 `t_mediumtext` mediumtext,
48 `t_longblob` longblob,
49 `t_longtext` longtext,
50 `t_enum` enum('001001','001004','001010','001018','001019','001020','001021','001027','001028','001029','001030','001031','001100','002003','002004','002005','002007') NOT NULL DEFAULT '001001',
51 `t_set` set('a','B') DEFAULT NULL,
52 PRIMARY KEY (`t_pk`)
53 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
54 SHOW CREATE TABLE t_gis;
55 Table Create Table
56 t_gis CREATE TABLE `t_gis` (
57 `t_pk` int NOT NULL,
58 `t_point` point DEFAULT NULL,
59 `t_linestring` linestring DEFAULT NULL,
60 `t_polygon` polygon DEFAULT NULL,
61 `t_multipoint` multipoint DEFAULT NULL,
62 `t_multilinestring` multilinestring DEFAULT NULL,
63 `t_multipolygon` multipolygon DEFAULT NULL,
64 `t_geometrycollection` geomcollection DEFAULT NULL,
65 `t_geometry` geometry DEFAULT NULL,
66 PRIMARY KEY (`t_pk`)
67 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
68 SELECT * FROM t_datetime;
69 ERROR 42S02: Table 'test.t_datetime' doesn't exist
70 SHOW WARNINGS;
71 Level Code Message
72 Warning 10923 Table definition contains obsolete data types such as old temporal or decimal types
73 Warning 1296 Failed to discover table 't_datetime' from NDB, could not upgrade table with extra metadata version 1
74 Error 1146 Table 'test.t_datetime' doesn't exist
75 SELECT t_pk,hex(t_bit),t_tinyint,t_bool,t_smallint,t_mediumint,t_int,t_bigint,t_float,t_double,t_decimal FROM t_num;
76 t_pk hex(t_bit) t_tinyint t_bool t_smallint t_mediumint t_int t_bigint t_float t_double t_decimal
77 1 AAAAAAAAAAAAAAAA 125 1 32765 8388606 2147483647 9223372036854775807 1e20 1.0000000000000002e150 331.0000000000000000
78 SELECT t_pk,t_char,t_varchar,hex(t_binary),hex(t_varbinary) FROM t_string_1;
79 t_pk t_char t_varchar hex(t_binary) hex(t_varbinary)
80 1 abcdefghijklmn abcdefghijklmnabcdefghijklmnabcdefghijklmnabcdefghijklmn 612020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 4100
81 SELECT * FROM t_string_2;
82 t_pk t_tinyblob t_tinytext t_blob t_text t_mediumblob t_mediumtext t_longblob t_longtext t_enum t_set
83 1 abcdefghijklmnabcdefghijklmn abcdefghijklmnabcdefghijklmn a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 001001 a
84 SELECT ST_AsText(t_point), ST_AsText(t_linestring),ST_AsText(t_polygon) FROM t_gis ORDER by t_pk;
85 ST_AsText(t_point) ST_AsText(t_linestring) ST_AsText(t_polygon)
86 POINT(10 10) LINESTRING(10 10,20 10,20 20,10 20,10 10) POLYGON((0 0,50 0,50 50,0 50,0 0),(10 10,20 10,20 20,10 20,10 10))
87 POINT(10 20) LINESTRING(10 10,40 10) POLYGON((0 0,30 0,30 30,0 0))
88 SELECT ST_AsText(t_multipoint), ST_AsText(t_multilinestring),ST_AsText(t_multipolygon) FROM t_gis ORDER by t_pk;
89 ST_AsText(t_multipoint) ST_AsText(t_multilinestring) ST_AsText(t_multipolygon)
90 MULTIPOINT((1 1),(11 11),(11 21),(21 21)) MULTILINESTRING((10 48,10 21,10 0)) MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
91 MULTIPOINT((3 6),(4 10)) MULTILINESTRING((1 2,3 5),(2 5,5 8,21 7)) MULTIPOLYGON(((0 3,3 3,3 0,0 3)))
92 SELECT ST_AsText(t_geometrycollection), ST_AsText(t_geometry) FROM t_gis ORDER by t_pk;
93 ST_AsText(t_geometrycollection) ST_AsText(t_geometry)
94 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10)) MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
95 GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9)) GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9))
96 DROP TABLE t_num,t_string_1,t_string_2,t_gis;
97 SHOW CREATE TABLE t_num;
98 Table Create Table
99 t_num CREATE TABLE `t_num` (
100 `t_pk` int NOT NULL,
101 `t_bit` bit(64) DEFAULT NULL,
102 `t_tinyint` tinyint DEFAULT NULL,
103 `t_bool` tinyint(1) DEFAULT NULL,
104 `t_smallint` smallint DEFAULT NULL,
105 `t_mediumint` mediumint DEFAULT NULL,
106 `t_int` int DEFAULT NULL,
107 `t_bigint` bigint DEFAULT NULL,
108 `t_float` float DEFAULT NULL,
109 `t_double` double DEFAULT NULL,
110 `t_decimal` decimal(37,16) DEFAULT NULL,
111 PRIMARY KEY (`t_pk`)
112 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
113 SHOW CREATE TABLE t_datetime;
114 ERROR 42S02: Table 'test.t_datetime' doesn't exist
115 SHOW WARNINGS;
116 Level Code Message
117 Warning 10923 Table definition contains obsolete data types such as old temporal or decimal types
118 Warning 1296 Failed to discover table 't_datetime' from NDB, could not upgrade table with extra metadata version 1
119 Error 1146 Table 'test.t_datetime' doesn't exist
120 SHOW CREATE TABLE t_string_1;
121 Table Create Table
122 t_string_1 CREATE TABLE `t_string_1` (
123 `t_pk` int NOT NULL,
124 `t_char` char(255) DEFAULT NULL,
125 `t_varchar` varchar(655) DEFAULT NULL,
126 `t_binary` binary(255) DEFAULT NULL,
127 `t_varbinary` varbinary(6553) DEFAULT NULL,
128 PRIMARY KEY (`t_pk`)
129 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
130 SHOW CREATE TABLE t_string_2;
131 Table Create Table
132 t_string_2 CREATE TABLE `t_string_2` (
133 `t_pk` int NOT NULL,
134 `t_tinyblob` tinyblob,
135 `t_tinytext` tinytext,
136 `t_blob` blob,
137 `t_text` text,
138 `t_mediumblob` mediumblob,
139 `t_mediumtext` mediumtext,
140 `t_longblob` longblob,
141 `t_longtext` longtext,
142 `t_enum` enum('001001','001004','001010','001018','001019','001020','001021','001027','001028','001029','001030','001031','001100','002003','002004','002005','002007') NOT NULL DEFAULT '001001',
143 `t_set` set('a','B') DEFAULT NULL,
144 PRIMARY KEY (`t_pk`)
145 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
146 SHOW CREATE TABLE t_gis;
147 Table Create Table
148 t_gis CREATE TABLE `t_gis` (
149 `t_pk` int NOT NULL,
150 `t_point` point DEFAULT NULL,
151 `t_linestring` linestring DEFAULT NULL,
152 `t_polygon` polygon DEFAULT NULL,
153 `t_multipoint` multipoint DEFAULT NULL,
154 `t_multilinestring` multilinestring DEFAULT NULL,
155 `t_multipolygon` multipolygon DEFAULT NULL,
156 `t_geometrycollection` geomcollection DEFAULT NULL,
157 `t_geometry` geometry DEFAULT NULL,
158 PRIMARY KEY (`t_pk`)
159 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
160 SELECT * FROM t_datetime;
161 ERROR 42S02: Table 'test.t_datetime' doesn't exist
162 SHOW WARNINGS;
163 Level Code Message
164 Warning 10923 Table definition contains obsolete data types such as old temporal or decimal types
165 Warning 1296 Failed to discover table 't_datetime' from NDB, could not upgrade table with extra metadata version 1
166 Error 1146 Table 'test.t_datetime' doesn't exist
167 SELECT t_pk,hex(t_bit),t_tinyint,t_bool,t_smallint,t_mediumint,t_int,t_bigint,t_float,t_double,t_decimal FROM t_num;
168 t_pk hex(t_bit) t_tinyint t_bool t_smallint t_mediumint t_int t_bigint t_float t_double t_decimal
169 1 AAAAAAAAAAAAAAAA 125 1 32765 8388606 2147483647 9223372036854775807 1e20 1.0000000000000002e150 331.0000000000000000
170 SELECT t_pk,t_char,t_varchar,hex(t_binary),hex(t_varbinary) FROM t_string_1;
171 t_pk t_char t_varchar hex(t_binary) hex(t_varbinary)
172 1 abcdefghijklmn abcdefghijklmnabcdefghijklmnabcdefghijklmnabcdefghijklmn 612020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 4100
173 SELECT * FROM t_string_2;
174 t_pk t_tinyblob t_tinytext t_blob t_text t_mediumblob t_mediumtext t_longblob t_longtext t_enum t_set
175 1 abcdefghijklmnabcdefghijklmn abcdefghijklmnabcdefghijklmn a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 a123456789b123456789c123456789d123456789e123456789f123456789g123456789 001001 a
176 SELECT ST_AsText(t_point), ST_AsText(t_linestring),ST_AsText(t_polygon) FROM t_gis ORDER by t_pk;
177 ST_AsText(t_point) ST_AsText(t_linestring) ST_AsText(t_polygon)
178 POINT(10 10) LINESTRING(10 10,20 10,20 20,10 20,10 10) POLYGON((0 0,50 0,50 50,0 50,0 0),(10 10,20 10,20 20,10 20,10 10))
179 POINT(10 20) LINESTRING(10 10,40 10) POLYGON((0 0,30 0,30 30,0 0))
180 SELECT ST_AsText(t_multipoint), ST_AsText(t_multilinestring),ST_AsText(t_multipolygon) FROM t_gis ORDER by t_pk;
181 ST_AsText(t_multipoint) ST_AsText(t_multilinestring) ST_AsText(t_multipolygon)
182 MULTIPOINT((1 1),(11 11),(11 21),(21 21)) MULTILINESTRING((10 48,10 21,10 0)) MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
183 MULTIPOINT((3 6),(4 10)) MULTILINESTRING((1 2,3 5),(2 5,5 8,21 7)) MULTIPOLYGON(((0 3,3 3,3 0,0 3)))
184 SELECT ST_AsText(t_geometrycollection), ST_AsText(t_geometry) FROM t_gis ORDER by t_pk;
185 ST_AsText(t_geometrycollection) ST_AsText(t_geometry)
186 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10)) MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
187 GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9)) GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9))
188 DROP TABLE t_num,t_string_1,t_string_2,t_gis;
189 SET GLOBAL ndb_metadata_check = @old_ndb_metadata_check_mysqld2;
190 SET GLOBAL ndb_metadata_check = @old_ndb_metadata_check_mysqld1;