Debian Codegraph @

mysql-test/suite/compat/oracle/r/mysqldump_restore.result

raw
1 SET sql_mode=ORACLE;
2 #
3 # Start of 10.3 tests
4 #
5 #
6 # MDEV-17363 Compressed columns cannot be restored from dump
7 #
8 CREATE TABLE t1 (a VARCHAR(1000) COMPRESSED CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL);
9 INSERT INTO `t1` VALUES (REPEAT('a', 256));
10 # Begin testing mysqldump output + restore
11 # Create 'original table name - <table>_orig
12 SET @orig_table_name = CONCAT('test.t1', '_orig');
13 # Rename original table
14 ALTER TABLE test.t1 RENAME to test.t1_orig;
15 # Recreate table from mysqldump output
16 # Compare original and recreated tables
17 # Recreated table: test.t1
18 # Original table: test.t1_orig
19 include/diff_tables.inc [test.t1, test.t1_orig]
20 # Cleanup
21 DROP TABLE test.t1, test.t1_orig;
22 CREATE TABLE t1 (a LONGTEXT COMPRESSED CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL);
23 INSERT INTO `t1` VALUES (REPEAT('a', 256));
24 # Begin testing mysqldump output + restore
25 # Create 'original table name - <table>_orig
26 SET @orig_table_name = CONCAT('test.t1', '_orig');
27 # Rename original table
28 ALTER TABLE test.t1 RENAME to test.t1_orig;
29 # Recreate table from mysqldump output
30 # Compare original and recreated tables
31 # Recreated table: test.t1
32 # Original table: test.t1_orig
33 include/diff_tables.inc [test.t1, test.t1_orig]
34 # Cleanup
35 DROP TABLE test.t1, test.t1_orig;
36 #
37 # End of 10.3 tests
38 #