Debian Codegraph @

mysql-test/suite/compat/oracle/t/column_compression.test

raw
1 --source include/have_innodb.inc
2 --source include/have_csv.inc
3 --source include/have_normal_zlib.inc
4 --source include/test_db_charset_latin1.inc
5
6 SET sql_mode=ORACLE;
7
8 SET column_compression_zlib_wrap=true;
9 CREATE TABLE t1 (a BLOB COMPRESSED);
10 INSERT INTO t1 VALUES (REPEAT('a',10000));
11 SELECT DATA_LENGTH<100 AS c FROM INFORMATION_SCHEMA.TABLES
12 WHERE TABLE_NAME='t1' AND TABLE_SCHEMA='test';
13 DROP TABLE t1;
14
15 --echo #
16 --echo # MDEV-17363 - Compressed columns cannot be restored from dump
17 --echo #
18
19 --error ER_PARSE_ERROR
20 CREATE TABLE t1(a INT NOT NULL COMPRESSED);
21 SHOW WARNINGS;
22
23 CREATE TABLE t1(
24 a JSON COMPRESSED,
25 b VARCHAR(1000) COMPRESSED BINARY,
26 c NVARCHAR(1000) COMPRESSED BINARY,
27 d TINYTEXT COMPRESSED BINARY
28 );
29 SHOW CREATE TABLE t1;
30 DROP TABLE t1;
31
32
33 --echo #
34 --echo # VARCHAR and TEXT variants
35 --echo #
36
37 --let type=VARCHAR(10)
38 --source include/column_compression_syntax_varchar.inc
39
40 --let type=VARCHAR2(10)
41 --source include/column_compression_syntax_varchar.inc
42
43 --let type=TINYTEXT
44 --source include/column_compression_syntax_varchar.inc
45
46 --let type=TEXT
47 --source include/column_compression_syntax_varchar.inc
48
49 --let type=MEDIUMTEXT
50 --source include/column_compression_syntax_varchar.inc
51
52 --let type=LONGTEXT
53 --source include/column_compression_syntax_varchar.inc
54
55
56 --echo #
57 --echo # VARBINARY and BLOB variables
58 --echo #
59
60 --let type=VARCHAR(10)
61 --source include/column_compression_syntax_varbinary.inc
62
63 --let type=TINYBLOB
64 --source include/column_compression_syntax_varbinary.inc
65
66 --let type=BLOB
67 --source include/column_compression_syntax_varbinary.inc
68
69 --let type=MEDIUMBLOB
70 --source include/column_compression_syntax_varbinary.inc
71
72 --let type=LONGBLOB
73 --source include/column_compression_syntax_varbinary.inc
74
75
76 --echo #
77 --echo # NVARCHAR
78 --echo #
79
80 CREATE TABLE t1 (a NVARCHAR(10) COMPRESSED);
81 SHOW CREATE TABLE t1;
82 DROP TABLE t1;
83 --error ER_PARSE_ERROR
84 CREATE TABLE t1 (a NVARCHAR(10) COMPRESSED BINARY COMPRESSED);
85 --error ER_PARSE_ERROR
86 CREATE TABLE t1 (a NVARCHAR(10) COMPRESSED DEFAULT '' COMPRESSED);
87
88 --source include/test_db_charset_restore.inc