Debian Codegraph @

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

raw
1 select @@session.time_zone;
2 @@session.time_zone
3 SYSTEM
4 set time_zone = '+00:00';
5 select @@session.time_zone;
6 @@session.time_zone
7 +00:00
8 # create table prec 0
9 create table t1 (
10 a int not null,
11 b year not null default '2000',
12 c date not null default '2000-01-02',
13 d time not null default '10:11:12',
14 e datetime not null default '2000-01-02 10:11:12',
15 f timestamp not null default '2000-01-02 10:11:12',
16 primary key using hash (a),
17 index bx (b),
18 index cx (c),
19 index dx (d),
20 index ex (e),
21 index fx (f)
22 ) engine=ndb;
23 show create table t1;
24 Table Create Table
25 t1 CREATE TABLE `t1` (
26 `a` int NOT NULL,
27 `b` year NOT NULL DEFAULT '2000',
28 `c` date NOT NULL DEFAULT '2000-01-02',
29 `d` time NOT NULL DEFAULT '10:11:12',
30 `e` datetime NOT NULL DEFAULT '2000-01-02 10:11:12',
31 `f` timestamp NOT NULL DEFAULT '2000-01-02 10:11:12',
32 PRIMARY KEY (`a`) USING HASH,
33 KEY `bx` (`b`),
34 KEY `cx` (`c`),
35 KEY `dx` (`d`),
36 KEY `ex` (`e`),
37 KEY `fx` (`f`)
38 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
39 Attributes:
40 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
41 b Year NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000
42 c Date NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02
43 d Time2(0) NOT NULL AT=FIXED ST=MEMORY DEFAULT 10:11:12
44 e Datetime2(0) NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02/10:11:12
45 f Timestamp2(0) NOT NULL AT=FIXED ST=MEMORY DEFAULT 946807872
46 Indexes:
47 bx(b) - OrderedIndex
48 cx(c) - OrderedIndex
49 dx(d) - OrderedIndex
50 ex(e) - OrderedIndex
51 fx(f) - OrderedIndex
52 # test defaults
53 insert into t1 (a) values (0);
54 select * from t1;
55 a b c d e f
56 0 2000 2000-01-02 10:11:12 2000-01-02 10:11:12 2000-01-02 10:11:12
57 delete from t1;
58 # restore data from wl946_pre with promote
59 # check contents
60 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
61 count(*) sum(crc32(concat(a,b,c,d,e,f)))
62 500 1105949732775
63 # run backup
64 # drop table
65 drop table t1;
66 # restore meta from backup
67 show create table t1;
68 Table Create Table
69 t1 CREATE TABLE `t1` (
70 `a` int NOT NULL,
71 `b` year NOT NULL DEFAULT '2000',
72 `c` date NOT NULL DEFAULT '2000-01-02',
73 `d` time NOT NULL DEFAULT '10:11:12',
74 `e` datetime NOT NULL DEFAULT '2000-01-02 10:11:12',
75 `f` timestamp NOT NULL DEFAULT '2000-01-02 10:11:12',
76 PRIMARY KEY (`a`) USING HASH,
77 KEY `bx` (`b`),
78 KEY `cx` (`c`),
79 KEY `dx` (`d`),
80 KEY `ex` (`e`),
81 KEY `fx` (`f`)
82 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
83 Attributes:
84 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
85 b Year NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000
86 c Date NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02
87 d Time2(0) NOT NULL AT=FIXED ST=MEMORY DEFAULT 10:11:12
88 e Datetime2(0) NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02/10:11:12
89 f Timestamp2(0) NOT NULL AT=FIXED ST=MEMORY DEFAULT 946807872
90 Indexes:
91 bx(b) - OrderedIndex
92 cx(c) - OrderedIndex
93 dx(d) - OrderedIndex
94 ex(e) - OrderedIndex
95 fx(f) - OrderedIndex
96 # restore data from backup
97 # check contents
98 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
99 count(*) sum(crc32(concat(a,b,c,d,e,f)))
100 500 1105949732775
101 # drop table
102 drop table t1;
103 # restore meta wl946_pre
104 Attributes:
105 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
106 b Year NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000
107 c Date NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02
108 d Time NOT NULL AT=FIXED ST=MEMORY DEFAULT 10:11:12
109 e Datetime NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02/10:11:12
110 f Timestamp NOT NULL AT=FIXED ST=MEMORY DEFAULT 946807872
111 Indexes:
112 bx(b) - OrderedIndex
113 cx(c) - OrderedIndex
114 dx(d) - OrderedIndex
115 ex(e) - OrderedIndex
116 fx(f) - OrderedIndex
117 # restore data from backup with demote
118 # check contents
119 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
120 ERROR 42S02: Table 'test.t1' doesn't exist
121 SHOW WARNINGS;
122 Level Code Message
123 Warning 10923 Table definition contains obsolete data types such as old temporal or decimal types
124 Warning 1296 Failed to discover table 't1' from NDB, could not upgrade table with extra metadata version 1
125 Error 1146 Table 'test.t1' doesn't exist
126 set time_zone = default;
127 select @@session.time_zone;
128 @@session.time_zone
129 SYSTEM