ndb_autodiscover.result 8.84 KB
Newer Older
joreland@mysql.com's avatar
joreland@mysql.com committed
1
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9,t10;
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
flush status;
create table t1(
id int not null primary key,
name char(20)
) engine=ndb;
insert into t1 values(1, "Autodiscover");
flush tables;
select * from t1;
id	name
1	Autodiscover
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	1
flush tables;
insert into t1 values (2, "Auto 2");
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	2
insert into t1 values (3, "Discover 3");
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	2
flush tables;
25
select * from t1 order by id;
26
id	name
27
1	Autodiscover
28 29 30 31 32 33 34 35 36 37
2	Auto 2
3	Discover 3
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	3
flush tables;
update t1 set name="Autodiscover" where id = 2;
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	4
joreland@mysql.com's avatar
joreland@mysql.com committed
38
select * from t1 order by id;
39 40
id	name
1	Autodiscover
joreland@mysql.com's avatar
joreland@mysql.com committed
41
2	Autodiscover
42 43 44 45 46 47
3	Discover 3
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	4
flush tables;
delete from  t1 where id = 3;
48
select * from t1 order by id;
49 50
id	name
1	Autodiscover
51
2	Autodiscover
52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	5
drop table t1;
flush status;
create table t2(
id int not null primary key,
name char(22)
) engine=ndb;
insert into t2 values (1, "Discoverer");
select * from t2;
id	name
1	Discoverer
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	0
flush tables;
select * from t2;
id	name
1	Discoverer
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	1
drop table t2;
flush status;
create table t3(
id int not null primary key,
name char(255)
) engine=ndb;
insert into t3 values (1, "Explorer");
select * from t3;
id	name
1	Explorer
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	0
flush tables;
create table t3(
id int not null primary key,
name char(20), a int, b float, c char(24)
) engine=ndb;
ERROR 42S01: Table 't3' already exists
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	1
create table IF NOT EXISTS t3(
id int not null primary key,
id2 int not null,
name char(20)
) engine=ndb;
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	2
SHOW CREATE TABLE t3;
Table	Create Table
t3	CREATE TABLE `t3` (
108
  `id` int(11) NOT NULL,
109 110 111 112 113 114 115 116 117 118 119
  `name` char(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
select * from t3;
id	name
1	Explorer
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	2
drop table t3;
flush status;
120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147
create table t7(
id int not null primary key,
name char(255)
) engine=ndb;
create table t6(
id int not null primary key,
name char(255)
) engine=MyISAM;
insert into t7 values (1, "Explorer");
insert into t6 values (2, "MyISAM table");
select * from t7;
id	name
1	Explorer
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	0
flush tables;
show tables from test;
Tables_in_test
t6
t7
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	1
flush tables;
show table status;
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
t6	MyISAM	9	Fixed	1	260	#	#	#	0	NULL	#	#	NULL	#	NULL		
148
t7	ndbcluster	9	Fixed	1	0	#	#	#	0	NULL	#	#	NULL	#	NULL		
149 150 151 152 153
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	2
drop table t6, t7;
flush status;
154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275
create table t4(
id int not null primary key,
name char(27)
) engine=ndb;
insert into t4 values (1, "Automatic");
select * from t4;
id	name
1	Automatic
select * from t4;
ERROR 42S02: Table 'test.t4' doesn't exist
select * from t4;
ERROR 42S02: Table 'test.t4' doesn't exist
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	0
drop table t4;
flush status;
create table t4(
id int not null primary key,
id2 int,
name char(27)
) engine=ndb;
insert into t4 values (1, 76, "Automatic2");
select * from t4;
id	id2	name
1	76	Automatic2
flush tables;
SHOW TABLES;
Tables_in_test
select * from t4;
ERROR 42S02: Table 'test.t4' doesn't exist
flush status;
create table t1(id int) engine=ndbcluster;
create table t2(id int, b char(255)) engine=myisam;
create table t3(id int, c char(255)) engine=ndbcluster;
create table t4(id int) engine=myisam;
create table t5(id int, d char(56)) engine=ndbcluster;
create table t6(id int) engine=ndbcluster;
create table t7(id int) engine=ndbcluster;
create table t8(id int, e char(34)) engine=myisam;
create table t9(id int) engine=myisam;
insert into t2 values (2, "myisam table 2");
insert into t3 values (3, "ndb table 3");
insert into t5 values (5, "ndb table 5");
insert into t6 values (6);
insert into t8 values (8, "myisam table 8");
insert into t9 values (9);
SHOW TABLES;
Tables_in_test
t1
t2
t4
t8
t9
t7
t6
select * from t6;
id
6
select * from t7;
id
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	2
drop table t1, t2, t4, t6, t7, t8, t9;
flush status;
create table t1(id int) engine=ndbcluster;
create table t2(id int, b char(255)) engine=myisam;
create table t3(id int, c char(255)) engine=ndbcluster;
create table t4(id int) engine=myisam;
create table t5(id int, d char(56)) engine=ndbcluster;
create table t6(id int) engine=ndbcluster;
create table t7(id int) engine=ndbcluster;
create table t8(id int, e char(34)) engine=myisam;
create table t9(id int) engine=myisam;
insert into t2 values (2, "myisam table 2");
insert into t3 values (3, "ndb table 3");
insert into t5 values (5, "ndb table 5");
insert into t6 values (6);
insert into t8 values (8, "myisam table 8");
insert into t9 values (9);
SHOW TABLES LIKE 't6';
Tables_in_test (t6)
t6
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	1
create table t3(a int);
ERROR 42S01: Table 't3' already exists
create table t5(a int);
ERROR 42S01: Table 't5' already exists
SHOW TABLES LIKE 't%';
Tables_in_test (t%)
t1
t2
t4
t6
t8
t9
t7
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	2
drop table t1, t2, t4, t6, t7, t8, t9;
flush status;
create table t1(id int) engine=ndbcluster;
create table t2(id int, b char(255)) engine=ndbcluster;
create table t3(id int, c char(255)) engine=ndbcluster;
create table t4(id int) engine=myisam;
insert into t1 values (1);
insert into t2 values (2, "table 2");
insert into t3 values (3, "ndb table 3");
insert into t4 values (4);
flush tables;
select * from t1, t2, t3, t4;
id	id	b	id	c	id
1	2	table 2	3	ndb table 3	4
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	3
drop table t1, t2, t3, t4;
flush status;
276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	0
create table t5(
id int not null primary key,
name char(200)
) engine=ndb;
insert into t5 values (1, "Magnus");
select * from t5;
id	name
1	Magnus
ALTER TABLE t5 ADD COLUMN adress char(255) FIRST;
select * from t5;
adress	id	name
NULL	1	Magnus
insert into t5 values 
("Adress for record 2", 2, "Carl-Gustav"), 
("Adress for record 3", 3, "Karl-Emil");
update t5 set name="Bertil" where id = 2;
select * from t5 order by id;
adress	id	name
NULL	1	Magnus
Adress for record 2	2	Bertil
Adress for record 3	3	Karl-Emil
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	0
drop table t5;
flush status;
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	0
create table t6(
id int not null primary key,
name char(20)
) engine=ndb;
insert into t6 values (1, "Magnus");
select * from t6;
id	name
1	Magnus
ALTER TABLE t6 ADD COLUMN adress char(255) FIRST;
select * from t6;
adress	id	name
NULL	1	Magnus
insert into t6 values 
("Adress for record 2", 2, "Carl-Gustav"), 
("Adress for record 3", 3, "Karl-Emil");
update t6 set name="Bertil" where id = 2;
select * from t6 order by id;
adress	id	name
NULL	1	Magnus
Adress for record 2	2	Bertil
Adress for record 3	3	Karl-Emil
show status like 'handler_discover%';
Variable_name	Value
Handler_discover	0
drop table t6;
333 334
show tables;
Tables_in_test
335
create table t1 (a int,b longblob) engine=ndb;
336 337 338 339 340 341 342 343 344
show tables;
Tables_in_test
t1
create database test2;
use test2;
show tables;
Tables_in_test2
select * from t1;
ERROR 42S02: Table 'test2.t1' doesn't exist
345
create table t2 (b int,c longblob) engine=ndb;
346 347
use test;
select * from t1;
348
a	b
349 350 351 352 353 354 355 356 357
show tables;
Tables_in_test
t1
drop table t1;
use test2;
drop table t2;
drop database test2;
show databases;
Database
358
information_schema
359 360 361
mysql
test
use test;
362 363 364 365 366 367 368 369 370 371
drop database if exists test_only_ndb_tables;
create database test_only_ndb_tables;
use test_only_ndb_tables;
create table t1 (a int primary key) engine=ndb;
select * from t1;
a
select * from t1;
ERROR HY000: Can't lock file (errno: 4009)
use test;
drop database test_only_ndb_tables;
372 373 374 375 376
CREATE TABLE t9 (
a int NOT NULL PRIMARY KEY,
b int
) engine=ndb;
insert t9 values(1, 2), (2,3), (3, 4), (4, 5);
joreland@mysql.com's avatar
joreland@mysql.com committed
377 378 379 380 381
create table t10 (
a int not null primary key,
b blob
) engine=ndb;
insert into t10 values (1, 'kalle');