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

Sqlitelogictest - Select query with an IN clause parse error #6490

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

Sqlitelogictest - Select query with an IN clause parse error #6490

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

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

Date: 2017-12-11 12:10:15 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

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

Comment 25979

Date: 2017-12-11 12:10:15 +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:

In a select query with an IN clause, it seems that it is not possible to provide a table a column there.

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 ALL * FROM tab0 AS cor0 WHERE NOT CAST ( NULL AS INTEGER ) NOT IN ( col3 / col1 );

Actual Results:

Parse error: SELECT: identifier 'col3' unknown

Expected Results:

An empty result set.

Comment 25980

Date: 2017-12-11 12:15:35 +0100
From: MonetDB Mercurial Repository <>

Changeset 68357599b75f 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=68357599b75f

Changeset description:

Added test for Bug #6490

Comment 25986

Date: 2017-12-12 07:42:05 +0100
From: MonetDB Mercurial Repository <>

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

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

Changeset description:

fix bug #6490, ie add missing 'in' function and handeling

Comment 25990

Date: 2017-12-12 11:01:59 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

Added queries related to bug #6490 still failing

Comment 26016

Date: 2017-12-16 12:00:50 +0100
From: MonetDB Mercurial Repository <>

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

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

Changeset description:

fixes for bug #6491 (select returns null)
	  bug #6497 (incorrect not between)
 	  bug #6490 (handle multiple columns in in in selection)

fixed type checking, allowed more equal types (int with 17 bits equals one with 31 etc)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant