Debian Codegraph @

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

raw
1 CREATE DATABASE BANK default charset=latin1 default collate=latin1_bin;
2 USE BANK;
3 ALTER TABLE ACCOUNT MODIFY`OWNER` int(11) unsigned NOT NULL COLUMN_FORMAT FIXED;
4 Now there should be two warnings of implicit COLUMN_FORMAT conversion
5 SHOW WARNINGS;
6 Level Code Message
7 ALTER TABLE BANK.ACCOUNT RENAME test.t1;
8 Attributes:
9 ACCOUNT_ID Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
10 OWNER Unsigned NOT NULL AT=FIXED ST=MEMORY
11 BALANCE Unsigned NOT NULL AT=FIXED ST=MEMORY
12 ACCOUNT_TYPE Unsigned NOT NULL AT=FIXED ST=MEMORY
13 DROP TABLE test.t1;
14 ALTER TABLE ACCOUNT_TYPE algorithm=inplace, MODIFY `DESCRIPTION` char(65);
15 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Altering field definition is not supported. Try ALGORITHM=COPY.
16 ALTER TABLE ACCOUNT_TYPE DROP `DESCRIPTION`;
17 Now there should be no warning
18 SHOW WARNINGS;
19 Level Code Message
20 ALTER TABLE SYSTEM_VALUES MODIFY `VALUE` bigint(21);
21 Now there should be one warning of implicit COLUMN_FORMAT conversion
22 SHOW WARNINGS;
23 Level Code Message
24 ALTER TABLE SYSTEM_VALUES MODIFY `VALUE` bigint(22);
25 Warnings:
26 Warning 1681 Integer display width is deprecated and will be removed in a future release.
27 Now there should be no warning
28 SHOW WARNINGS;
29 Level Code Message
30 Warning 1681 Integer display width is deprecated and will be removed in a future release.
31 ALTER TABLE SYSTEM_VALUES MODIFY `VALUE` bigint(23);
32 Warnings:
33 Warning 1681 Integer display width is deprecated and will be removed in a future release.
34 set @old_acat = @@session.ndb_allow_copying_alter_table;
35 set @@session.ndb_allow_copying_alter_table = off;
36 ALTER TABLE SYSTEM_VALUES MODIFY `VALUE` bigint(24);
37 Warnings:
38 Warning 1681 Integer display width is deprecated and will be removed in a future release.
39 Now there should be no warning
40 SHOW WARNINGS;
41 Level Code Message
42 Warning 1681 Integer display width is deprecated and will be removed in a future release.
43 set @@session.ndb_allow_copying_alter_table = @old_acat;
44 set @old_ndcf = @@global.ndb_default_column_format;
45 set @@global.ndb_default_column_format = FIXED;
46 ALTER TABLE TRANSACTION MODIFY `ACCOUNT_TYPE` int(11) unsigned NOT NULL;
47 Now there should be no warning
48 SHOW WARNINGS;
49 Level Code Message
50 ALTER TABLE BANK.TRANSACTION RENAME test.t1;
51 Attributes:
52 TRANSACTION_ID Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
53 ACCOUNT Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
54 ACCOUNT_TYPE Unsigned NOT NULL AT=FIXED ST=MEMORY
55 OTHER_ACCOUNT Unsigned NOT NULL AT=FIXED ST=MEMORY
56 TRANSACTION_TYPE Unsigned NOT NULL AT=FIXED ST=MEMORY
57 TIME Bigunsigned NOT NULL AT=FIXED ST=MEMORY
58 AMOUNT Unsigned NOT NULL AT=FIXED ST=MEMORY
59 DROP TABLE test.t1;
60 set @@global.ndb_default_column_format = @old_ndcf;
61 DROP DATABASE BANK;