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: algebra join between lng and int BATs undefined #6519

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

Sqlitelogictest: algebra join between lng and int BATs undefined #6519

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

Comments

@monetdb-team
Copy link

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

Date: 2018-01-19 16:48:28 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

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

Comment 26105

Date: 2018-01-19 16:48:28 +0100
From: @PedroTadim

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

The following SQL query cannot be executed due to a nonexistent algebra join between BATs of different numeric atom types.

Reproducible: Always

Steps to Reproduce:

  1. CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER);
  2. INSERT INTO tab2 VALUES (64,77,40), (75,67,58), (46,51,23);
  3. SELECT * FROM tab2 WHERE col2 NOT IN ( - + col1, col2 * + col1, + - col0 * + + 36, + + col2, 84 * + + col0 ) AND NOT NULL IS NULL;

Actual Results:

The following MAL error:
TypeException:user.main[48]:'algebra.join' undefined in: algebra.join(X_98531:bat[:int], X_98533:bat[:lng], nil:BAT, nil:BAT, false:bit, nil:lng);

Expected Results:

An empty result set.

Comment 26107

Date: 2018-01-19 17:00:04 +0100
From: MonetDB Mercurial Repository <>

Changeset 63944bc2d4a4 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=63944bc2d4a4

Changeset description:

Added tests for bugs 6518 and 6519 (enough bugs for some time)

Comment 26112

Date: 2018-01-24 18:28:46 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixes for bugs 6518 and 6519
added type checks in (not) in correlated case (only when needed)
in case of correlated (not) in we should add the identity column (and join on that)

Comment 26114

Date: 2018-01-24 18:45:53 +0100
From: @njnes

added missing type checks

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