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

LIKE join: BATfetchjoin does not hit always #3375

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

LIKE join: BATfetchjoin does not hit always #3375

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

Comments

@monetdb-team
Copy link

Date: 2013-09-27 16:28:52 +0200
From: @swingbit
To: SQL devs <>
Version: 11.15.3 (Feb2013-SP1)
CC: @njnes

Last updated: 2013-10-22 14:42:08 +0200

Comment 19203

Date: 2013-09-27 16:28:52 +0200
From: @swingbit

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

create table x (s string);
insert into x values('%able%');
select * from sys.tables, x where name like s;

This gives:

GDK reported error.
BATfetchjoin(tmpr_11744,tmp_11736) does not hit always (|bn|=0 != 4=|l|) => can't use fetchjoin.

Reproducible: Always

Comment 19230

Date: 2013-10-02 11:08:07 +0200
From: MonetDB Mercurial Repository <>

Changeset 2255b42087dd 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=2255b42087dd

Changeset description:

fixed bug #3375. Handle swapping of join operants (in case of filter joins).

Comment 19231

Date: 2013-10-02 11:08:32 +0200
From: @njnes

fixed, properly handle the swapped join condition

Comment 19246

Date: 2013-10-04 18:16:23 +0200
From: MonetDB Mercurial Repository <>

Changeset 44580ebcfa76 made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

swapped_likejoin.Bug-3375: approve default branch output
@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