Debian Codegraph @

mysql-test/suite/ndb_ddl/alter_max_rows.result

raw
1 ALTER TABLE t1
2 algorithm=inplace,
3 max_rows=1111111;
4 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: setting MAX_ROWS on table without MAX_ROWS. Try ALGORITHM=COPY.
5 ALTER TABLE t1
6 algorithm=copy,
7 max_rows=1111111;
8 ALTER TABLE t3
9 algorithm=inplace,
10 max_rows=4444444;
11 ALTER TABLE t3
12 algorithm=copy,
13 max_rows=5555555;
14 ALTER TABLE t3
15 algorithm=copy,
16 max_rows=33333 /* Small enough to get default number of frags */;
17 ALTER TABLE t3
18 algorithm=inplace,
19 max_rows=33332 /* Small enough to still be at default number of frags */;
20 Note! The value of MAX_ROWS in NDB is still 33333
21 -- t3 --
22 Version: Any
23 Fragment type: HashMapPartition
24 K Value: 6
25 Min load factor: 78
26 Max load factor: 80
27 Temporary table: no
28 Number of attributes: 3
29 Number of primary keys: 1
30 Length of frm data: XXX
31 Max Rows: 33333
32 Row Checksum: 1
33 Row GCI: 1
34 SingleUserMode: 0
35 ForceVarPart: 1
36 PartitionCount: 8
37 FragmentCount: 8
38 PartitionBalance: SPECIFIC
39 ExtraRowGciBits: 0
40 ExtraRowAuthorBits: 0
41 TableStatus: Retrieved
42 Table options: readbackup
43 HashMap: DEFAULT-HASHMAP-3840-8
44 -- Attributes --
45 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
46 b Longvarchar(1020;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=MEMORY
47 c Datetime2(0) NULL AT=FIXED ST=MEMORY
48 -- Indexes --
49 PRIMARY KEY(a) - UniqueHashIndex
50 PRIMARY(a) - OrderedIndex
51 b(b) - OrderedIndex
52 a(a, b, c) - OrderedIndex
53 ALTER TABLE t3
54 algorithm=inplace,
55 reorganize partition;
56 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: REORGANIZE of table with MAX_ROWS. Try ALGORITHM=COPY.
57 ALTER TABLE t3
58 algorithm=inplace,
59 max_rows=0;
60 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Setting MAX_ROWS to 0 is not supported online. Try ALGORITHM=COPY.
61 ALTER TABLE t3
62 algorithm=copy,
63 max_rows=0;
64 ALTER TABLE t3
65 algorithm=inplace,
66 reorganize partition;
67 INSERT INTO t3 VALUES(37, "MySQL Cluster", '2015-12-15');
68 SELECT b FROM t3 WHERE a > 10;
69 b
70 MySQL Cluster
71 DELETE FROM t3 WHERE a = 37;
72 ALTER TABLE t3
73 algorithm=copy,
74 max_rows=444444444 /* Large with many frags */;
75 ALTER TABLE t3
76 algorithm=inplace,
77 max_rows=0 /* Not allowed since number of frags reduced */;
78 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Online reduction in number of fragments not supported. Try ALGORITHM=COPY.
79 ALTER TABLE t3
80 algorithm=copy,
81 max_rows=0 /* Back to zero by using copying */;
82 ALTER TABLE t3
83 algorithm=inplace,
84 reorganize partition;
85 INSERT INTO t3 VALUES(37, "MySQL Cluster", '2015-12-15');
86 SELECT b FROM t3 WHERE a > 10;
87 b
88 MySQL Cluster
89 DELETE FROM t3 WHERE a = 37;
90 ALTER TABLE t2
91 algorithm=copy,
92 max_rows=33333;
93 ALTER TABLE t2
94 algorithm=inplace,
95 max_rows=0;
96 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Setting MAX_ROWS to 0 is not supported online. Try ALGORITHM=COPY.
97 ALTER TABLE t2
98 algorithm=copy,
99 max_rows=0;
100 == verify_mysql_dd.inc ==