Debian Codegraph @

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

raw
1 create table t1 (ki int primary key,
2 dis int,
3 diu int unsigned,
4 dbs bigint,
5 dbu bigint unsigned,
6 dmi mediumint) engine = ndb;
7 insert into t1 values
8 (0,
9 2147483547, # Max - 100
10 4294967195, # Max - 100
11 9223372036854775707, # Max - 100
12 18446744073709551515, # Max - 100
13 0),
14 (1,
15 -2147483548, # Min + 100
16 100, # Min + 100
17 -9223372036854775708, # Min + 100
18 100, # Min + 100
19 0);
20 select ki, dis, diu, dbs, dbu, dmi from test.t1 order by ki;
21 ki dis diu dbs dbu dmi
22 0 2147483547 4294967195 9223372036854775707 18446744073709551515 0
23 1 -2147483548 100 -9223372036854775708 100 0
24 Run backup
25 truncate t1;
26 Malformed spec : db
27 Malformed spec : db.
28 Malformed spec : db.table
29 Malformed spec : db.table.column
30 Malformed spec : db.table.column
31 Malformed spec : db.table.column:function
32 Malformed spec : db.table.column:function:badargument
33 Non existent db+table not allowed
34 Non existent table not allowed
35 Non existent table not allowed
36 Bad function name
37 Out of range offsets
38 Unsupported type (mediumint)
39 Test limits of offset ranges (limited to +/- signed type range)
40 Too large offsets
41 Signed int
42 Unsigned int
43 Signed bigint
44 Unsigned bigint
45 Test data over/underflow errors
46 Signed int
47 truncate t1;
48 select count(1) from t1 where ki = 0;
49 count(1)
50 0
51 truncate t1;
52 select count(1) from t1 where ki = 1;
53 count(1)
54 0
55 Unsigned int
56 truncate t1;
57 select count(1) from t1 where ki = 0;
58 count(1)
59 0
60 truncate t1;
61 select count(1) from t1 where ki = 1;
62 count(1)
63 0
64 Signed bigint
65 truncate t1;
66 select count(1) from t1 where ki = 0;
67 count(1)
68 0
69 truncate t1;
70 select count(1) from t1 where ki = 1;
71 count(1)
72 0
73 Unsigned bigint
74 truncate t1;
75 select count(1) from t1 where ki = 0;
76 count(1)
77 0
78 truncate t1;
79 select count(1) from t1 where ki = 1;
80 count(1)
81 0
82 drop table t1;