Debian Codegraph @

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

raw
1 SET sql_mode=ORACLE;
2 #
3 # Start of 10.2 tests
4 #
5 #
6 # MDEV-27690 Crash on `CHARACTER SET csname COLLATE DEFAULT` in column definition
7 #
8 CREATE TABLE t1 (a CHAR(10) CHARACTER SET latin1 COLLATE DEFAULT);
9 DROP TABLE t1;
10 SELECT CAST('a' AS CHAR(10) CHARACTER SET latin1 COLLATE DEFAULT);
11 CAST('a' AS CHAR(10) CHARACTER SET latin1 COLLATE DEFAULT)
12 a
13 SELECT COLUMN_GET(COLUMN_CREATE(0, 'string'),0 AS CHAR CHARACTER SET latin1 COLLATE DEFAULT) AS c1;
14 c1
15 string
16 #
17 # End of 10.2 tests
18 #
19 #
20 # Start of 10.3 tests
21 #
22 #
23 # MDEV-12086 sql_mode=ORACLE: allow SELECT UNIQUE as a synonym for SELECT DISTINCT
24 #
25 CREATE TABLE t1 (a INT);
26 INSERT INTO t1 VALUES (10),(20),(20),(30),(30),(30);
27 SELECT UNIQUE a FROM t1;
28 a
29 10
30 20
31 30
32 DROP TABLE t1;
33 #
34 # End of 10.3 tests
35 #