blob: c9ea9737e5f7241c266157ebc210bb57f25419a9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
DROP TABLE IF EXISTS t;
SET SESSION TOKUDB_DISABLE_SLOW_ALTER=ON;
CREATE TABLE t (a VARCHAR(100) NOT NULL DEFAULT '', b VARCHAR(256) NOT NULL DEFAULT '') ENGINE=TokuDB;
SHOW CREATE TABLE t;
Table Create Table
t CREATE TABLE `t` (
`a` varchar(100) NOT NULL DEFAULT '',
`b` varchar(256) NOT NULL DEFAULT ''
) ENGINE=TokuDB DEFAULT CHARSET=latin1
ALTER TABLE t CHANGE COLUMN a a VARCHAR(255) NOT NULL DEFAULT 'a';
SHOW CREATE TABLE t;
Table Create Table
t CREATE TABLE `t` (
`a` varchar(255) NOT NULL DEFAULT 'a',
`b` varchar(256) NOT NULL DEFAULT ''
) ENGINE=TokuDB DEFAULT CHARSET=latin1
ALTER TABLE t CHANGE COLUMN a a VARCHAR(256) NOT NULL DEFAULT 'b';
SHOW CREATE TABLE t;
Table Create Table
t CREATE TABLE `t` (
`a` varchar(256) NOT NULL DEFAULT 'b',
`b` varchar(256) NOT NULL DEFAULT ''
) ENGINE=TokuDB DEFAULT CHARSET=latin1
ALTER TABLE t CHANGE COLUMN b b VARCHAR(255) NOT NULL DEFAULT 'c';
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
ALTER TABLE t CHANGE COLUMN b b VARCHAR(1024) NOT NULL DEFAULT 'd';
SHOW CREATE TABLE t;
Table Create Table
t CREATE TABLE `t` (
`a` varchar(256) NOT NULL DEFAULT 'b',
`b` varchar(1024) NOT NULL DEFAULT 'd'
) ENGINE=TokuDB DEFAULT CHARSET=latin1
ALTER TABLE t CHANGE COLUMN b b VARCHAR(256) NOT NULL DEFAULT 'e';
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
DROP TABLE t;
|