Debian Codegraph @

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

raw
1 SET sql_mode=ORACLE;
2
3 --echo #
4 --echo # MDEV-13384: "window" seems like a reserved column name but it's not listed as one
5 --echo #
6 --echo # Currently we allow window as an identifier, except for table aliases.
7 --echo #
8
9 CREATE TABLE door (id INT, window VARCHAR(10));
10
11 --error ER_PARSE_ERROR
12 SELECT id
13 FROM door as window;
14
15 SELECT id, window
16 FROM door;
17
18 --error ER_PARSE_ERROR
19 SELECT id, window
20 FROM door as window;
21
22 DROP TABLE door;