Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

CTE with row number and union fails within MAL #6065

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

CTE with row number and union fails within MAL #6065

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working normal SQL

Comments

@monetdb-team
Copy link

Date: 2016-10-03 19:41:53 +0200
From: muesli4
To: SQL devs <>
Version: 11.23.7 (Jun2016-SP1)
CC: @njnes

Last updated: 2016-10-13 10:04:21 +0200

Comment 24450

Date: 2016-10-03 19:41:53 +0200
From: muesli4

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

Run this query:

WITH t0(so) AS (
SELECT ROW_NUMBER() OVER (ORDER BY v0 ASC) AS so
FROM (values (0)) as t(v0)
)
SELECT 1 AS k1, a3.so AS k2
FROM t0 AS a3

UNION ALL

SELECT 2 AS k2, a8.so AS k2
FROM t0 AS a8;

Executing the query results in the following error message (somehow the types of the append from the union all don't match):

TypeException:user.s2_1[23]:'bat.append' undefined in: bat.append(X_38:bat[:int],X_34:bat[:bte],true:bit);

Reproducible: Always

revision: http://dev.monetdb.org/hg/MonetDB/rev/5e7df26ea650

Comment 24451

Date: 2016-10-03 19:42:32 +0200
From: muesli4

Created attachment 470
The problematic query

Attached file: test.sql (application/sql, 212 bytes)
Description: The problematic query

Comment 24453

Date: 2016-10-05 10:03:40 +0200
From: @njnes

added missing checks for duplicate names.

Comment 24455

Date: 2016-10-05 12:59:49 +0200
From: MonetDB Mercurial Repository <>

Changeset e5e5c8649705 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=e5e5c8649705

Changeset description:

add test for bug #6065

Comment 24458

Date: 2016-10-05 14:58:21 +0200
From: MonetDB Mercurial Repository <>

Changeset a2ba71b00ff7 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=a2ba71b00ff7

Changeset description:

fixes for bug #6065

Comment 24497

Date: 2016-10-13 10:04:21 +0200
From: @sjoerdmullender

Jun2016-SP2 has been released.

@monetdb-team monetdb-team added bug Something isn't working normal SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working normal SQL
Projects
None yet
Development

No branches or pull requests

2 participants