Debian Codegraph @

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

raw
1 #
2 # Start of 10.4 tests
3 #
4 #
5 # MDEV-27744 LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE
6 #
7 SET sql_mode=DEFAULT;
8 CREATE TABLE t1 (
9 a0 VARCHAR(64) NOT NULL DEFAULT LTRIM(now()),
10 a1 VARCHAR(64) AS (LTRIM(a0)) PERSISTENT,
11 b0 VARCHAR(64) NOT NULL DEFAULT LPAD(now(),10),
12 b1 VARCHAR(64) AS (LPAD(b0,10)) PERSISTENT
13 );
14 CREATE VIEW v1 AS SELECT
15 LTRIM(now()) AS a0,
16 LPAD(now(),10) AS b0;
17 SET sql_mode=ORACLE;
18 CREATE TABLE t2 (
19 a0 VARCHAR(64) NOT NULL DEFAULT LTRIM(now()),
20 a1 VARCHAR(64) AS (LTRIM(a0)) PERSISTENT,
21 b0 VARCHAR(64) NOT NULL DEFAULT LPAD(now(),10),
22 b1 VARCHAR(64) AS (LPAD(b0,10)) PERSISTENT
23 );
24 CREATE VIEW v2 AS SELECT
25 LTRIM(now()) AS a0,
26 LPAD(now(),10) AS b0;
27 /*M!999999\- enable the sandbox mode */
28 /*!40101 SET @saved_cs_client = @@character_set_client */;
29 /*!40101 SET character_set_client = utf8mb4 */;
30 CREATE TABLE `t1` (
31 `a0` varchar(64) NOT NULL DEFAULT ltrim(current_timestamp()),
32 `a1` varchar(64) GENERATED ALWAYS AS (ltrim(`a0`)) STORED,
33 `b0` varchar(64) NOT NULL DEFAULT lpad(current_timestamp(),10),
34 `b1` varchar(64) GENERATED ALWAYS AS (lpad(`b0`,10)) STORED
35 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;
36 /*!40101 SET character_set_client = @saved_cs_client */;
37 /*!40101 SET @saved_cs_client = @@character_set_client */;
38 /*!40101 SET character_set_client = utf8mb4 */;
39 CREATE TABLE `t2` (
40 `a0` varchar(64) NOT NULL DEFAULT ltrim_oracle(current_timestamp()),
41 `a1` varchar(64) GENERATED ALWAYS AS (ltrim_oracle(`a0`)) STORED,
42 `b0` varchar(64) NOT NULL DEFAULT lpad_oracle(current_timestamp(),10),
43 `b1` varchar(64) GENERATED ALWAYS AS (lpad_oracle(`b0`,10)) STORED
44 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;
45 /*!40101 SET character_set_client = @saved_cs_client */;
46 SET @saved_cs_client = @@character_set_client;
47 SET character_set_client = utf8mb4;
48 /*!50001 CREATE VIEW `v1` AS SELECT
49 NULL AS `a0`,
50 NULL AS `b0` */;
51 SET character_set_client = @saved_cs_client;
52 SET @saved_cs_client = @@character_set_client;
53 SET character_set_client = utf8mb4;
54 /*!50001 CREATE VIEW `v2` AS SELECT
55 NULL AS `a0`,
56 NULL AS `b0` */;
57 SET character_set_client = @saved_cs_client;
58 /*!50001 DROP VIEW IF EXISTS `v1`*/;
59 /*!50001 SET @saved_cs_client = @@character_set_client */;
60 /*!50001 SET @saved_cs_results = @@character_set_results */;
61 /*!50001 SET @saved_col_connection = @@collation_connection */;
62 /*!50001 SET character_set_client = latin1 */;
63 /*!50001 SET character_set_results = latin1 */;
64 /*!50001 SET collation_connection = latin1_swedish_ci */;
65 /*!50001 CREATE ALGORITHM=UNDEFINED */
66 /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
67 /*!50001 VIEW `v1` AS select ltrim(current_timestamp()) AS `a0`,lpad(current_timestamp(),10) AS `b0` */;
68 /*!50001 SET character_set_client = @saved_cs_client */;
69 /*!50001 SET character_set_results = @saved_cs_results */;
70 /*!50001 SET collation_connection = @saved_col_connection */;
71 /*!50001 DROP VIEW IF EXISTS `v2`*/;
72 /*!50001 SET @saved_cs_client = @@character_set_client */;
73 /*!50001 SET @saved_cs_results = @@character_set_results */;
74 /*!50001 SET @saved_col_connection = @@collation_connection */;
75 /*!50001 SET character_set_client = latin1 */;
76 /*!50001 SET character_set_results = latin1 */;
77 /*!50001 SET collation_connection = latin1_swedish_ci */;
78 /*!50001 CREATE ALGORITHM=UNDEFINED */
79 /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
80 /*!50001 VIEW `v2` AS select oracle_schema.ltrim(current_timestamp()) AS `a0`,oracle_schema.lpad(current_timestamp(),10) AS `b0` */;
81 /*!50001 SET character_set_client = @saved_cs_client */;
82 /*!50001 SET character_set_results = @saved_cs_results */;
83 /*!50001 SET collation_connection = @saved_col_connection */;
84 DROP TABLE t1,t2;
85 DROP VIEW v1,v2;
86 SET sql_mode=DEFAULT;
87 SHOW CREATE TABLE t1;
88 Table Create Table
89 t1 CREATE TABLE `t1` (
90 `a0` varchar(64) NOT NULL DEFAULT ltrim(current_timestamp()),
91 `a1` varchar(64) GENERATED ALWAYS AS (ltrim(`a0`)) STORED,
92 `b0` varchar(64) NOT NULL DEFAULT lpad(current_timestamp(),10),
93 `b1` varchar(64) GENERATED ALWAYS AS (lpad(`b0`,10)) STORED
94 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
95 SHOW CREATE TABLE t2;
96 Table Create Table
97 t2 CREATE TABLE `t2` (
98 `a0` varchar(64) NOT NULL DEFAULT ltrim_oracle(current_timestamp()),
99 `a1` varchar(64) GENERATED ALWAYS AS (ltrim_oracle(`a0`)) STORED,
100 `b0` varchar(64) NOT NULL DEFAULT lpad_oracle(current_timestamp(),10),
101 `b1` varchar(64) GENERATED ALWAYS AS (lpad_oracle(`b0`,10)) STORED
102 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
103 SHOW CREATE VIEW v1;
104 View Create View character_set_client collation_connection
105 v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ltrim(current_timestamp()) AS `a0`,lpad(current_timestamp(),10) AS `b0` latin1 latin1_swedish_ci
106 SHOW CREATE VIEW v2;
107 View Create View character_set_client collation_connection
108 v2 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select oracle_schema.ltrim(current_timestamp()) AS `a0`,oracle_schema.lpad(current_timestamp(),10) AS `b0` latin1 latin1_swedish_ci
109 DROP TABLE t1,t2;
110 DROP VIEW v1, v2;
111 #
112 # End of 10.4 tests
113 #