summaryrefslogtreecommitdiff
path: root/mysql-test/suite/compat/oracle/t/win.test
blob: c6f0b6474cfaa12ed7f1f546d34f6c78aa41ede5 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
SET sql_mode=ORACLE;

--echo #
--echo # MDEV-13384: "window" seems like a reserved column name but it's not listed as one
--echo #
--echo # Currently we allow window as an identifier, except for table aliases.
--echo #

CREATE TABLE door (id INT, window VARCHAR(10));

--error ER_PARSE_ERROR
SELECT id
FROM door as window;

SELECT id, window
FROM door;

--error ER_PARSE_ERROR
SELECT id, window
FROM door as window;

DROP TABLE door;