Debian Codegraph @

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

raw
1 # See comments in mysql-test/main/mysqldump_restore.test
2 --source include/not_embedded.inc
3
4 let $mysqldumpfile = $MYSQLTEST_VARDIR/tmp/mysqldump_func_qualified.sql;
5
6 --echo #
7 --echo # Start of 10.4 tests
8 --echo #
9
10 --echo #
11 --echo # MDEV-27744 LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE
12 --echo #
13
14 SET sql_mode=DEFAULT;
15 CREATE TABLE t1 (
16 a0 VARCHAR(64) NOT NULL DEFAULT LTRIM(now()),
17 a1 VARCHAR(64) AS (LTRIM(a0)) PERSISTENT,
18 b0 VARCHAR(64) NOT NULL DEFAULT LPAD(now(),10),
19 b1 VARCHAR(64) AS (LPAD(b0,10)) PERSISTENT
20 );
21 CREATE VIEW v1 AS SELECT
22 LTRIM(now()) AS a0,
23 LPAD(now(),10) AS b0;
24 SET sql_mode=ORACLE;
25 CREATE TABLE t2 (
26 a0 VARCHAR(64) NOT NULL DEFAULT LTRIM(now()),
27 a1 VARCHAR(64) AS (LTRIM(a0)) PERSISTENT,
28 b0 VARCHAR(64) NOT NULL DEFAULT LPAD(now(),10),
29 b1 VARCHAR(64) AS (LPAD(b0,10)) PERSISTENT
30 );
31 CREATE VIEW v2 AS SELECT
32 LTRIM(now()) AS a0,
33 LPAD(now(),10) AS b0;
34 --exec $MYSQL_DUMP --no-autocommit=0 --skip-extended-insert test --skip-comments --compact t1 t2 v1 v2
35 --exec $MYSQL_DUMP --skip-extended-insert test --skip-comments t1 t2 v1 v2 > $mysqldumpfile
36 DROP TABLE t1,t2;
37 DROP VIEW v1,v2;
38 --exec $MYSQL test < $mysqldumpfile
39 SET sql_mode=DEFAULT;
40 SHOW CREATE TABLE t1;
41 SHOW CREATE TABLE t2;
42 SHOW CREATE VIEW v1;
43 SHOW CREATE VIEW v2;
44 --remove_file $mysqldumpfile
45 DROP TABLE t1,t2;
46 DROP VIEW v1, v2;
47
48 --echo #
49 --echo # End of 10.4 tests
50 --echo #