Date: 2014-09-26 14:39:19 +0200
From: @bartscheers
To: SQL devs <>
Version: 11.17.21 (Jan2014-SP3)
CC: martin.van.dinther, @njnes

Last updated: 2014-10-31 14:14:52 +0100

Comment 20199

Date: 2014-09-26 14:39:19 +0200
From: @bartscheers

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:32.0) Gecko/20100101 Firefox/32.0
Build Identifier:

An incorrect sql statement terminates connection, where a normal error message would have been expected.

Reproducible: Always

Steps to Reproduce:

1. create a db (+ schema)
2. run script
3. 3 of 4 queries give crash, whereas all 4 are incorrect

Actual Results:

connection terminated

Expected Results:

error mesasage for all 4 queries, complaining about group by, something like:
SELECT: cannot use non GROUP BY column

When defined in view this should also be messaged.

Comment 20200

Date: 2014-09-26 14:40:37 +0200
From: @bartscheers

Created attachment 298
creation of table, plus queries

Attached file: create.tables.sql (application/sql, 336 bytes)
Description: creation of table, plus queries

Comment 20203

Date: 2014-09-26 16:44:07 +0200
From: Martin van Dinther <<martin.van.dinther>>

Execute SQL:
create table runcat (id int not null, dp double not null);
SELECT * FROM runcat GROUP BY id;
SELECT r.* FROM runcat r GROUP BY r.id;

mserver5 output:

could not find r.dp
r.id
r.id
mserver5: rel_bin.c:2234: rel2bin_project: Assertion `0' failed.

Comment 20209

Date: 2014-09-28 14:19:48 +0200
From: @njnes

r.* is now handled as *, ie lookup the columns (in the group by intermediate). In this case that is only the id column

Comment 20394

Date: 2014-10-31 14:14:52 +0100
From: @sjoerdmullender

Oct2014 has been released.