Date: 2012-02-24 17:38:55 +0100
From: Gatis Ozolins <<g.ozolins>>
To: SQL devs <>
Version: 11.7.5 (Dec2011) [obsolete]
CC: @njnes

Last updated: 2012-03-16 14:56:51 +0100

Comment 16990

Date: 2012-02-24 17:38:55 +0100
From: Gatis Ozolins <<g.ozolins>>

User-Agent: Mozilla/5.0 (Windows; Windows NT 6.1; rv:10.0) Gecko/20100101 Firefox/9.0
Build Identifier: Dec2011

This should be valid SQL

Reproducible: Always

Steps to Reproduce:

SELECT * FROM (
WITH x AS (SELECT 1)
SELECT * FROM x
) y

Actual Results:

42000!syntax error, unexpected WITH in: "select *
from (with"

Expected Results:

1

Comment 16993

Date: 2012-02-25 09:45:17 +0100
From: @njnes

Changeset c0f7bbcff9ec made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=c0f7bbcff9ec

Changeset description:

added with in 'derived tables' see bug #3043

Comment 17092

Date: 2012-03-16 14:56:51 +0100
From: @grobian

Released in Dec2011-SP2