130 lines
4.0 KiB
Plaintext
130 lines
4.0 KiB
Plaintext
select @@session.time_zone;
|
|
@@session.time_zone
|
|
SYSTEM
|
|
set time_zone = '+00:00';
|
|
select @@session.time_zone;
|
|
@@session.time_zone
|
|
+00:00
|
|
# create table prec 0
|
|
create table t1 (
|
|
a int not null,
|
|
b year not null default '2000',
|
|
c date not null default '2000-01-02',
|
|
d time not null default '10:11:12',
|
|
e datetime not null default '2000-01-02 10:11:12',
|
|
f timestamp not null default '2000-01-02 10:11:12',
|
|
primary key using hash (a),
|
|
index bx (b),
|
|
index cx (c),
|
|
index dx (d),
|
|
index ex (e),
|
|
index fx (f)
|
|
) engine=ndb;
|
|
show create table t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`a` int(11) NOT NULL,
|
|
`b` year(4) NOT NULL DEFAULT '2000',
|
|
`c` date NOT NULL DEFAULT '2000-01-02',
|
|
`d` time NOT NULL DEFAULT '10:11:12',
|
|
`e` datetime NOT NULL DEFAULT '2000-01-02 10:11:12',
|
|
`f` timestamp NOT NULL DEFAULT '2000-01-02 10:11:12',
|
|
PRIMARY KEY (`a`) USING HASH,
|
|
KEY `bx` (`b`),
|
|
KEY `cx` (`c`),
|
|
KEY `dx` (`d`),
|
|
KEY `ex` (`e`),
|
|
KEY `fx` (`f`)
|
|
) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
Attributes:
|
|
a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
|
|
b Year NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000
|
|
c Date NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02
|
|
d Time2(0) NOT NULL AT=FIXED ST=MEMORY DEFAULT 10:11:12
|
|
e Datetime2(0) NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02/10:11:12
|
|
f Timestamp2(0) NOT NULL AT=FIXED ST=MEMORY DEFAULT 946807872
|
|
Indexes:
|
|
bx(b) - OrderedIndex
|
|
cx(c) - OrderedIndex
|
|
dx(d) - OrderedIndex
|
|
ex(e) - OrderedIndex
|
|
fx(f) - OrderedIndex
|
|
# test defaults
|
|
insert into t1 (a) values (0);
|
|
select * from t1;
|
|
a b c d e f
|
|
0 2000 2000-01-02 10:11:12 2000-01-02 10:11:12 2000-01-02 10:11:12
|
|
delete from t1;
|
|
# restore data from wl946_pre with promote
|
|
# check contents
|
|
select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
|
|
count(*) sum(crc32(concat(a,b,c,d,e,f)))
|
|
500 1105949732775
|
|
# run backup
|
|
# drop table
|
|
drop table t1;
|
|
# restore meta from backup
|
|
show create table t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`a` int(11) NOT NULL,
|
|
`b` year(4) NOT NULL DEFAULT '2000',
|
|
`c` date NOT NULL DEFAULT '2000-01-02',
|
|
`d` time NOT NULL DEFAULT '10:11:12',
|
|
`e` datetime NOT NULL DEFAULT '2000-01-02 10:11:12',
|
|
`f` timestamp NOT NULL DEFAULT '2000-01-02 10:11:12',
|
|
PRIMARY KEY (`a`) USING HASH,
|
|
KEY `bx` (`b`),
|
|
KEY `cx` (`c`),
|
|
KEY `dx` (`d`),
|
|
KEY `ex` (`e`),
|
|
KEY `fx` (`f`)
|
|
) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
Attributes:
|
|
a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
|
|
b Year NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000
|
|
c Date NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02
|
|
d Time2(0) NOT NULL AT=FIXED ST=MEMORY DEFAULT 10:11:12
|
|
e Datetime2(0) NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02/10:11:12
|
|
f Timestamp2(0) NOT NULL AT=FIXED ST=MEMORY DEFAULT 946807872
|
|
Indexes:
|
|
bx(b) - OrderedIndex
|
|
cx(c) - OrderedIndex
|
|
dx(d) - OrderedIndex
|
|
ex(e) - OrderedIndex
|
|
fx(f) - OrderedIndex
|
|
# restore data from backup
|
|
# check contents
|
|
select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
|
|
count(*) sum(crc32(concat(a,b,c,d,e,f)))
|
|
500 1105949732775
|
|
# drop table
|
|
drop table t1;
|
|
# restore meta wl946_pre
|
|
Attributes:
|
|
a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
|
|
b Year NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000
|
|
c Date NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02
|
|
d Time NOT NULL AT=FIXED ST=MEMORY DEFAULT 10:11:12
|
|
e Datetime NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02/10:11:12
|
|
f Timestamp NOT NULL AT=FIXED ST=MEMORY DEFAULT 946807872
|
|
Indexes:
|
|
bx(b) - OrderedIndex
|
|
cx(c) - OrderedIndex
|
|
dx(d) - OrderedIndex
|
|
ex(e) - OrderedIndex
|
|
fx(f) - OrderedIndex
|
|
# restore data from backup with demote
|
|
# check contents
|
|
select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
|
|
ERROR 42S02: Table 'test.t1' doesn't exist
|
|
SHOW WARNINGS;
|
|
Level Code Message
|
|
Warning 1296 Table definition contains obsolete data types such as old temporal or decimal types
|
|
Warning 1296 Failed to discover table 't1' from NDB, could not upgrade table with extra metadata version 1
|
|
Error 1146 Table 'test.t1' doesn't exist
|
|
set time_zone = default;
|
|
select @@session.time_zone;
|
|
@@session.time_zone
|
|
SYSTEM
|