508 lines
12 KiB
Plaintext
508 lines
12 KiB
Plaintext
CREATE TABLE t1 (
|
|
a int,
|
|
b varchar(255),
|
|
c int,
|
|
d blob,
|
|
primary key(a,b),
|
|
key(b),
|
|
unique (c)) engine=ndb character set latin1 comment='NDB_TABLE=FULLY_REPLICATED=1,PARTITION_BALANCE=FOR_RA_BY_NODE' partition by key(a) ;
|
|
show warnings;
|
|
Level Code Message
|
|
CREATE TABLE t2 (
|
|
a int,
|
|
b varchar(255),
|
|
c int,
|
|
d blob,
|
|
primary key(a,b),
|
|
key(b),
|
|
unique (c)) engine=ndb comment='NDB_TABLE=JUNK' partition by key(a) ;
|
|
ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'Syntax error in COMMENT modifier'
|
|
CREATE TABLE t2 (
|
|
a int,
|
|
b varchar(255),
|
|
c int,
|
|
primary key(a,b),
|
|
key(b),
|
|
unique (c)) engine=ndb comment='NDB_TABLE=FULLY_REPLICATED=1,PARTITION_BALANCE=FOR_RA_BY_LDM' partition by key(a) ;
|
|
DROP TABLE t2;
|
|
CREATE TABLE t2 (
|
|
a int,
|
|
b varchar(255),
|
|
c int not null,
|
|
primary key (a,b),
|
|
unique key (b,a)
|
|
) engine=ndb
|
|
comment='NDB_TABLE=FULLY_REPLICATED=1'
|
|
partition by key(a);
|
|
alter table t2 algorithm=inplace, add unique index (c);
|
|
-- t1 --
|
|
Version: Any
|
|
Fragment type: HashMapPartition
|
|
K Value: 6
|
|
Min load factor: 78
|
|
Max load factor: 80
|
|
Temporary table: no
|
|
Number of attributes: 4
|
|
Number of primary keys: 2
|
|
Length of frm data: XXX
|
|
Max Rows: 0
|
|
Row Checksum: 1
|
|
Row GCI: 1
|
|
SingleUserMode: 0
|
|
ForceVarPart: 1
|
|
PartitionCount: 1
|
|
FragmentCount: 2
|
|
PartitionBalance: FOR_RA_BY_NODE
|
|
ExtraRowGciBits: 0
|
|
ExtraRowAuthorBits: 0
|
|
TableStatus: Retrieved
|
|
Table options: readbackup, fullyreplicated
|
|
HashMap: DEFAULT-HASHMAP-3840-1
|
|
-- Attributes --
|
|
a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
|
|
b Varchar(255;latin1_swedish_ci) PRIMARY KEY AT=SHORT_VAR ST=MEMORY
|
|
c Int NULL AT=FIXED ST=MEMORY
|
|
d Blob(256,2000,0) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=NDB$BLOB_XX_3
|
|
-- Indexes --
|
|
PRIMARY KEY(a, b) - UniqueHashIndex
|
|
PRIMARY(a, b) - OrderedIndex
|
|
c(c) - OrderedIndex
|
|
c$unique(c) - UniqueHashIndex
|
|
b(b) - OrderedIndex
|
|
-- t1/PRIMARY --
|
|
Version: Any
|
|
Base table: t1
|
|
Number of attributes: 2
|
|
Logging: 0
|
|
Index type: OrderedIndex
|
|
Index status: Retrieved
|
|
-- Attributes --
|
|
a Int NOT NULL AT=FIXED ST=MEMORY
|
|
b Varchar(255;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY
|
|
-- IndexTable XX/PRIMARY --
|
|
Version: Any
|
|
Fragment type: FragUndefined
|
|
K Value: 6
|
|
Min load factor: 78
|
|
Max load factor: 80
|
|
Temporary table: yes
|
|
Number of attributes: 3
|
|
Number of primary keys: 1
|
|
Length of frm data: XXX
|
|
Max Rows: 0
|
|
Row Checksum: 1
|
|
Row GCI: 1
|
|
SingleUserMode: 2
|
|
ForceVarPart: 0
|
|
PartitionCount: 2
|
|
FragmentCount: 2
|
|
PartitionBalance: FOR_RP_BY_LDM
|
|
ExtraRowGciBits: 0
|
|
ExtraRowAuthorBits: 0
|
|
TableStatus: Retrieved
|
|
Table options:
|
|
-- Attributes --
|
|
a Int NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
|
|
b Varchar(255;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY
|
|
NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
|
|
-- Indexes --
|
|
PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
|
|
|
|
-- t1/b --
|
|
Version: Any
|
|
Base table: t1
|
|
Number of attributes: 1
|
|
Logging: 0
|
|
Index type: OrderedIndex
|
|
Index status: Retrieved
|
|
-- Attributes --
|
|
b Varchar(255;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY
|
|
-- IndexTable XX/b --
|
|
Version: Any
|
|
Fragment type: FragUndefined
|
|
K Value: 6
|
|
Min load factor: 78
|
|
Max load factor: 80
|
|
Temporary table: yes
|
|
Number of attributes: 2
|
|
Number of primary keys: 1
|
|
Length of frm data: XXX
|
|
Max Rows: 0
|
|
Row Checksum: 1
|
|
Row GCI: 1
|
|
SingleUserMode: 2
|
|
ForceVarPart: 0
|
|
PartitionCount: 2
|
|
FragmentCount: 2
|
|
PartitionBalance: FOR_RP_BY_LDM
|
|
ExtraRowGciBits: 0
|
|
ExtraRowAuthorBits: 0
|
|
TableStatus: Retrieved
|
|
Table options:
|
|
-- Attributes --
|
|
b Varchar(255;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY
|
|
NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
|
|
-- Indexes --
|
|
PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
|
|
|
|
-- t1/c --
|
|
Version: Any
|
|
Base table: t1
|
|
Number of attributes: 1
|
|
Logging: 0
|
|
Index type: OrderedIndex
|
|
Index status: Retrieved
|
|
-- Attributes --
|
|
c Int NULL AT=FIXED ST=MEMORY
|
|
-- IndexTable XX/c --
|
|
Version: Any
|
|
Fragment type: FragUndefined
|
|
K Value: 6
|
|
Min load factor: 78
|
|
Max load factor: 80
|
|
Temporary table: yes
|
|
Number of attributes: 2
|
|
Number of primary keys: 1
|
|
Length of frm data: XXX
|
|
Max Rows: 0
|
|
Row Checksum: 1
|
|
Row GCI: 1
|
|
SingleUserMode: 2
|
|
ForceVarPart: 0
|
|
PartitionCount: 2
|
|
FragmentCount: 2
|
|
PartitionBalance: FOR_RP_BY_LDM
|
|
ExtraRowGciBits: 0
|
|
ExtraRowAuthorBits: 0
|
|
TableStatus: Retrieved
|
|
Table options:
|
|
-- Attributes --
|
|
c Int NULL AT=FIXED ST=MEMORY
|
|
NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
|
|
-- Indexes --
|
|
PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
|
|
|
|
-- t1/c$unique --
|
|
Version: Any
|
|
Base table: t1
|
|
Number of attributes: 1
|
|
Logging: 1
|
|
Index type: UniqueHashIndex
|
|
Index status: Retrieved
|
|
-- Attributes --
|
|
c Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
|
|
-- IndexTable XX/c$unique --
|
|
Version: Any
|
|
Fragment type: HashMapPartition
|
|
K Value: 6
|
|
Min load factor: 78
|
|
Max load factor: 80
|
|
Temporary table: no
|
|
Number of attributes: 2
|
|
Number of primary keys: 1
|
|
Length of frm data: XXX
|
|
Max Rows: 0
|
|
Row Checksum: 1
|
|
Row GCI: 1
|
|
SingleUserMode: 2
|
|
ForceVarPart: 0
|
|
PartitionCount: 1
|
|
FragmentCount: 2
|
|
PartitionBalance: FOR_RA_BY_NODE
|
|
ExtraRowGciBits: 0
|
|
ExtraRowAuthorBits: 0
|
|
TableStatus: Retrieved
|
|
Table options: readbackup, fullyreplicated
|
|
HashMap: DEFAULT-HASHMAP-3840-1
|
|
-- Attributes --
|
|
c Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
|
|
NDB$PK Unsigned [66] NOT NULL AT=3? ST=MEMORY
|
|
-- Indexes --
|
|
PRIMARY KEY(c) - UniqueHashIndex
|
|
|
|
-- NDB$BLOB_XX_3 --
|
|
Version: Any
|
|
Fragment type: HashMapPartition
|
|
K Value: 6
|
|
Min load factor: 78
|
|
Max load factor: 80
|
|
Temporary table: no
|
|
Number of attributes: 5
|
|
Number of primary keys: 3
|
|
Length of frm data: XXX
|
|
Max Rows: 0
|
|
Row Checksum: 1
|
|
Row GCI: 1
|
|
SingleUserMode: 0
|
|
ForceVarPart: 0
|
|
PartitionCount: 1
|
|
FragmentCount: 2
|
|
PartitionBalance: FOR_RA_BY_NODE
|
|
ExtraRowGciBits: 0
|
|
ExtraRowAuthorBits: 0
|
|
TableStatus: Retrieved
|
|
Table options: readbackup, fullyreplicated
|
|
HashMap: DEFAULT-HASHMAP-3840-1
|
|
-- Attributes --
|
|
a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
|
|
b Varchar(255;latin1_swedish_ci) PRIMARY KEY AT=SHORT_VAR ST=MEMORY
|
|
NDB$PART Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
|
|
NDB$PKID Unsigned NOT NULL AT=FIXED ST=MEMORY
|
|
NDB$DATA Longvarbinary(2000) NOT NULL AT=MEDIUM_VAR ST=MEMORY
|
|
-- Indexes --
|
|
PRIMARY KEY(a, b, NDB$PART) - UniqueHashIndex
|
|
|
|
|
|
NDBT_ProgramExit: 0 - OK
|
|
|
|
insert into t1 values
|
|
(0, "row 0", 0, REPEAT("qubit#0",500)),
|
|
(1, "row 1", 1, REPEAT("qubit#1",500)),
|
|
(2, "row 2", 2, REPEAT("qubit#2",500)),
|
|
(3, "row 3", 3, REPEAT("qubit#3",500)),
|
|
(4, "row 4", 4, REPEAT("qubit#4",500)),
|
|
(5, "row 5", 5, REPEAT("qubit#5",500)),
|
|
(6, "row 6", 6, REPEAT("qubit#6",500)),
|
|
(7, "row 7", 7, REPEAT("qubit#7",500)),
|
|
(8, "row 8", 8, REPEAT("qubit#8",500)),
|
|
(9, "row 9", 9, REPEAT("qubit#9",500));
|
|
select a,b,c,LENGTH(d) from t1 order by 1;
|
|
a b c LENGTH(d)
|
|
0 row 0 0 3500
|
|
1 row 1 1 3500
|
|
2 row 2 2 3500
|
|
3 row 3 3 3500
|
|
4 row 4 4 3500
|
|
5 row 5 5 3500
|
|
6 row 6 6 3500
|
|
7 row 7 7 3500
|
|
8 row 8 8 3500
|
|
9 row 9 9 3500
|
|
begin;
|
|
select a,b,c,LENGTH(d) from t1 where a = 7;
|
|
a b c LENGTH(d)
|
|
7 row 7 7 3500
|
|
select a,b,c,LENGTH(d) from t1 where c = 9;
|
|
a b c LENGTH(d)
|
|
9 row 9 9 3500
|
|
select a,b,c,LENGTH(d) from t1 order by 1;
|
|
a b c LENGTH(d)
|
|
0 row 0 0 3500
|
|
1 row 1 1 3500
|
|
2 row 2 2 3500
|
|
3 row 3 3 3500
|
|
4 row 4 4 3500
|
|
5 row 5 5 3500
|
|
6 row 6 6 3500
|
|
7 row 7 7 3500
|
|
8 row 8 8 3500
|
|
9 row 9 9 3500
|
|
select a,b,c,LENGTH(d) from t1 where a < 5 order by a;
|
|
a b c LENGTH(d)
|
|
0 row 0 0 3500
|
|
1 row 1 1 3500
|
|
2 row 2 2 3500
|
|
3 row 3 3 3500
|
|
4 row 4 4 3500
|
|
update t1 set b = 'pk update' where a = 3;
|
|
update t1 set c = c + 10;
|
|
update t1 set b = 'uk update' where c = 16;
|
|
delete from t1 where a = 7;
|
|
delete from t1 where c = 17;
|
|
delete from t1 where a < 5;
|
|
select a,b,c,LENGTH(d) from t1 order by 1;
|
|
a b c LENGTH(d)
|
|
5 row 5 15 3500
|
|
6 uk update 16 3500
|
|
8 row 8 18 3500
|
|
9 row 9 19 3500
|
|
insert into t1 values (0, "row 0", 0, REPEAT("qubit#0",500)),(1, "row 1", 1, REPEAT("qubit#1",500));
|
|
select a,b,c,LENGTH(d) from t1 order by 1;
|
|
a b c LENGTH(d)
|
|
0 row 0 0 3500
|
|
1 row 1 1 3500
|
|
5 row 5 15 3500
|
|
6 uk update 16 3500
|
|
8 row 8 18 3500
|
|
9 row 9 19 3500
|
|
rollback;
|
|
"Stop node 1"
|
|
begin;
|
|
select a,b,c,LENGTH(d) from t1 where a = 7;
|
|
a b c LENGTH(d)
|
|
7 row 7 7 3500
|
|
select a,b,c,LENGTH(d) from t1 where c = 9;
|
|
a b c LENGTH(d)
|
|
9 row 9 9 3500
|
|
select a,b,c,LENGTH(d) from t1 order by 1;
|
|
a b c LENGTH(d)
|
|
0 row 0 0 3500
|
|
1 row 1 1 3500
|
|
2 row 2 2 3500
|
|
3 row 3 3 3500
|
|
4 row 4 4 3500
|
|
5 row 5 5 3500
|
|
6 row 6 6 3500
|
|
7 row 7 7 3500
|
|
8 row 8 8 3500
|
|
9 row 9 9 3500
|
|
select a,b,c,LENGTH(d) from t1 where a < 5 order by a;
|
|
a b c LENGTH(d)
|
|
0 row 0 0 3500
|
|
1 row 1 1 3500
|
|
2 row 2 2 3500
|
|
3 row 3 3 3500
|
|
4 row 4 4 3500
|
|
update t1 set b = 'pk update' where a = 3;
|
|
update t1 set c = c + 10;
|
|
update t1 set b = 'uk update' where c = 16;
|
|
delete from t1 where a = 7;
|
|
delete from t1 where c = 17;
|
|
delete from t1 where a < 5;
|
|
select a,b,c,LENGTH(d) from t1 order by 1;
|
|
a b c LENGTH(d)
|
|
5 row 5 15 3500
|
|
6 uk update 16 3500
|
|
8 row 8 18 3500
|
|
9 row 9 19 3500
|
|
insert into t1 values (0, "row 0", 0, REPEAT("qubit#0",500)),(1, "row 1", 1, REPEAT("qubit#1",500));
|
|
select a,b,c,LENGTH(d) from t1 order by 1;
|
|
a b c LENGTH(d)
|
|
0 row 0 0 3500
|
|
1 row 1 1 3500
|
|
5 row 5 15 3500
|
|
6 uk update 16 3500
|
|
8 row 8 18 3500
|
|
9 row 9 19 3500
|
|
rollback;
|
|
"Start node 1"
|
|
begin;
|
|
select a,b,c,LENGTH(d) from t1 where a = 7;
|
|
a b c LENGTH(d)
|
|
7 row 7 7 3500
|
|
select a,b,c,LENGTH(d) from t1 where c = 9;
|
|
a b c LENGTH(d)
|
|
9 row 9 9 3500
|
|
select a,b,c,LENGTH(d) from t1 order by 1;
|
|
a b c LENGTH(d)
|
|
0 row 0 0 3500
|
|
1 row 1 1 3500
|
|
2 row 2 2 3500
|
|
3 row 3 3 3500
|
|
4 row 4 4 3500
|
|
5 row 5 5 3500
|
|
6 row 6 6 3500
|
|
7 row 7 7 3500
|
|
8 row 8 8 3500
|
|
9 row 9 9 3500
|
|
select a,b,c,LENGTH(d) from t1 where a < 5 order by a;
|
|
a b c LENGTH(d)
|
|
0 row 0 0 3500
|
|
1 row 1 1 3500
|
|
2 row 2 2 3500
|
|
3 row 3 3 3500
|
|
4 row 4 4 3500
|
|
update t1 set b = 'pk update' where a = 3;
|
|
update t1 set c = c + 10;
|
|
update t1 set b = 'uk update' where c = 16;
|
|
delete from t1 where a = 7;
|
|
delete from t1 where c = 17;
|
|
delete from t1 where a < 5;
|
|
select a,b,c,LENGTH(d) from t1 order by 1;
|
|
a b c LENGTH(d)
|
|
5 row 5 15 3500
|
|
6 uk update 16 3500
|
|
8 row 8 18 3500
|
|
9 row 9 19 3500
|
|
insert into t1 values (0, "row 0", 0, REPEAT("qubit#0",500)),(1, "row 1", 1, REPEAT("qubit#1",500));
|
|
select a,b,c,LENGTH(d) from t1 order by 1;
|
|
a b c LENGTH(d)
|
|
0 row 0 0 3500
|
|
1 row 1 1 3500
|
|
5 row 5 15 3500
|
|
6 uk update 16 3500
|
|
8 row 8 18 3500
|
|
9 row 9 19 3500
|
|
rollback;
|
|
drop table t1,t2;
|
|
CREATE TABLE t1 (
|
|
a int,
|
|
b varchar(255),
|
|
c int,
|
|
d blob,
|
|
primary key(a,b),
|
|
key(b),
|
|
unique (c)) engine=ndb comment='NDB_TABLE=FULLY_REPLICATED=1' partition by key(a) ;
|
|
CREATE TABLE t2 (
|
|
a int,
|
|
b varchar(255),
|
|
c int not null,
|
|
primary key (a,b),
|
|
unique key (b,a)
|
|
) engine=ndb
|
|
comment='NDB_TABLE=FULLY_REPLICATED=1'
|
|
partition by key(a);
|
|
alter table t2 algorithm=inplace, add unique index (c);
|
|
insert into t1 values
|
|
(0, "row 0", 0, REPEAT("qubit#0",500)),
|
|
(1, "row 1", 1, REPEAT("qubit#1",500)),
|
|
(2, "row 2", 2, REPEAT("qubit#2",500)),
|
|
(3, "row 3", 3, REPEAT("qubit#3",500)),
|
|
(4, "row 4", 4, REPEAT("qubit#4",500)),
|
|
(5, "row 5", 5, REPEAT("qubit#5",500)),
|
|
(6, "row 6", 6, REPEAT("qubit#6",500)),
|
|
(7, "row 7", 7, REPEAT("qubit#7",500)),
|
|
(8, "row 8", 8, REPEAT("qubit#8",500)),
|
|
(9, "row 9", 9, REPEAT("qubit#9",500));
|
|
"Restart cluster"
|
|
"Wait reconnect"
|
|
begin;
|
|
select a,b,c,LENGTH(d) from t1 where a = 7;
|
|
a b c LENGTH(d)
|
|
7 row 7 7 3500
|
|
select a,b,c,LENGTH(d) from t1 where c = 9;
|
|
a b c LENGTH(d)
|
|
9 row 9 9 3500
|
|
select a,b,c,LENGTH(d) from t1 order by 1;
|
|
a b c LENGTH(d)
|
|
0 row 0 0 3500
|
|
1 row 1 1 3500
|
|
2 row 2 2 3500
|
|
3 row 3 3 3500
|
|
4 row 4 4 3500
|
|
5 row 5 5 3500
|
|
6 row 6 6 3500
|
|
7 row 7 7 3500
|
|
8 row 8 8 3500
|
|
9 row 9 9 3500
|
|
select a,b,c,LENGTH(d) from t1 where a < 5 order by a;
|
|
a b c LENGTH(d)
|
|
0 row 0 0 3500
|
|
1 row 1 1 3500
|
|
2 row 2 2 3500
|
|
3 row 3 3 3500
|
|
4 row 4 4 3500
|
|
update t1 set b = 'pk update' where a = 3;
|
|
update t1 set c = c + 10;
|
|
update t1 set b = 'uk update' where c = 16;
|
|
delete from t1 where a = 7;
|
|
delete from t1 where c = 17;
|
|
delete from t1 where a < 5;
|
|
select a,b,c,LENGTH(d) from t1 order by 1;
|
|
a b c LENGTH(d)
|
|
5 row 5 15 3500
|
|
6 uk update 16 3500
|
|
8 row 8 18 3500
|
|
9 row 9 19 3500
|
|
insert into t1 values (0, "row 0", 0, REPEAT("qubit#0",500)),(1, "row 1", 1, REPEAT("qubit#1",500));
|
|
select a,b,c,LENGTH(d) from t1 order by 1;
|
|
a b c LENGTH(d)
|
|
0 row 0 0 3500
|
|
1 row 1 1 3500
|
|
5 row 5 15 3500
|
|
6 uk update 16 3500
|
|
8 row 8 18 3500
|
|
9 row 9 19 3500
|
|
rollback;
|
|
drop table t1,t2;
|