Sqlitelogictest - Omitting AS in a result set column alias name

[monetdb-team]

Date: 2017-12-13 16:09:40 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2018-02-12 16:12:04 +0100

Comment 26001

Date: 2017-12-13 16:09:40 +0100
From: @PedroTadim

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36
Build Identifier:

It is not possible to omit the AS keyword in a result set column alias definition: SELECT - col4 [AS] col0 FROM tab0 WHERE NOT NULL IS NULL;

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE tab0(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 TEXT, col3 INTEGER, col4 FLOAT, col5 TEXT);
2. SELECT - col4 col0 FROM tab0 WHERE NOT NULL IS NULL;

Actual Results:

Query compilation error:
syntax error, unexpected IDENT, expecting SCOLON in: "select - col4 col0"

Expected Results:

An empty result set.

Yesterday I fixed this by adding the extra grammar rule in the parser, but it created 2 new shift/reduce conflicts which caused the hexadecimal_literals.Bug-3621 test to fail :(

Comment 26005

Date: 2017-12-13 16:30:14 +0100
From: MonetDB Mercurial Repository <>

Changeset 6f3ac2786528 made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=6f3ac2786528

Changeset description:

Added tests for bugs 6494, 6495 and 6496

Comment 26018

Date: 2017-12-16 13:23:18 +0100
From: @njnes

the fix is correct. As now incorrect hex values gets accepted as column names (ie
0xg is value 0 with alias xg)