Date: 2012-11-28 00:40:56 +0100
From: @skinkie
To: SQL devs <>
Version: 11.13.3 (Oct2012)
CC: gordon, @mlkersten, @njnes

Last updated: 2014-02-20 15:02:24 +0100

Comment 18167

Date: 2012-11-28 00:40:56 +0100
From: @skinkie

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

I was doing a few queries on my dataset. Then I wondered about this query;

select * from adres where adres.huisletter is null and adres.huisnummertoevoeging is not null;

Which resulted in:

0x00007ffff6713c4d in insert_string_bat (b=0x7fffe419d0a0, n=0x7fffc4006010, append=0) at gdk_batop.c:196
196 bunfastins(b, hp, tp);
(gdb) bt
0 0x00007ffff6713c4d in insert_string_bat (b=0x7fffe419d0a0, n=0x7fffc4006010, append=0) at gdk_batop.c:196
1 0x00007ffff6717aeb in BATins (b=0x7fffe419d0a0, n=0x7fffc4006010, force=0 '\000') at gdk_batop.c:387
2 0x00007ffff7935367 in MATpackInternal (stk=0x7fffe41a7c20, p=0x7fffe4184a10) at mat.c:125
3 0x00007ffff79361a0 in MATpack (cntxt=0x7ffff30f3338, mb=0x7fffe4078d50, stk=0x7fffe41a7c20, p=0x7fffe4184a10) at mat.c:382
4 0x00007ffff6f749cc in runMALsequence (cntxt=0x7ffff30f3338, mb=0x7fffe4078d50, startpc=1, stoppc=0, stk=0x7fffe41a7c20, env=0x0, pcicaller=0x0) at mal_interpreter.c:707
5 0x00007ffff6f73f63 in callMAL (cntxt=0x7ffff30f3338, mb=0x7fffe4078d50, env=0x7ffff0bc3be0, argv=0x7ffff0bc3c80, debug=0 '\000') at mal_interpreter.c:542
6 0x00007ffff16048bf in SQLexecutePrepared (c=0x7ffff30f3338, be=0x7fffe40701b0, q=0x7fffe4079540) at sql_scenario.c:1763
7 0x00007ffff1604ba7 in SQLengineIntern (c=0x7ffff30f3338, be=0x7fffe40701b0) at sql_scenario.c:1816
8 0x00007ffff1605152 in SQLengine (c=0x7ffff30f3338) at sql_scenario.c:1942
9 0x00007ffff6fa447c in runPhase (c=0x7ffff30f3338, phase=4) at mal_scenario.c:522
10 0x00007ffff6fa4676 in runScenarioBody (c=0x7ffff30f3338) at mal_scenario.c:573
11 0x00007ffff6fa4886 in runScenario (c=0x7ffff30f3338) at mal_scenario.c:601
12 0x00007ffff6fa592a in MSserveClient (dummy=0x7ffff30f3338) at mal_session.c:430
13 0x00007ffff42c9ea7 in start_thread () from /lib64/libpthread.so.0
14 0x00007ffff400314d in clone () from /lib64/libc.so.6

Reproducible: Always

Expected Results:

It seems that:

select * from adres where adres.huisletter is null and adres.huisnummertoevoeging is not null limit 10;

Works, while the query without limit 10 doesn't. The data is already available at CWI.

Latest pull from Oct2012

Comment 18173

Date: 2012-11-28 11:09:27 +0100
From: @njnes

seems to work fine on the default. Looks similar to

*** This bug has been marked as a duplicate of bug #3165 ***

Comment 18175

Date: 2012-11-28 11:10:45 +0100
From: @njnes

also related 3165

*** This bug has been marked as a duplicate of bug #3153 ***

Comment 18177

Date: 2012-11-28 11:15:46 +0100
From: @njnes

lets point the other bugs into this one as we do have (usefull) data here

Comment 18179

Date: 2012-11-28 11:16:53 +0100
From: @njnes

*** Bug #3153 has been marked as a duplicate of this bug. ***

Comment 18181

Date: 2012-11-28 11:17:10 +0100
From: @njnes

*** Bug #3165 has been marked as a duplicate of this bug. ***

Comment 18184

Date: 2012-11-28 12:06:40 +0100
From: @njnes

fix insert_string_bat code. It didn't handle oid,str b, void,str n properly.
Now we need a small test....

Comment 18312

Date: 2012-12-27 22:20:46 +0100
From: @mlkersten

Is the bug still alive om KvK?

Comment 18313

Date: 2012-12-27 22:21:52 +0100
From: @skinkie

It was the last time I tested.

Comment 18314

Date: 2012-12-27 22:23:24 +0100
From: @skinkie

(In reply to comment 8)

It was the last time I tested.

But like Niels pointed out, it required a backport of the patch. Maybe I should again upgrade to default.

Comment 18446

Date: 2013-01-29 10:52:27 +0100
From: @sjoerdmullender

Is this bug still present on the Feb2013 branch?
If not, I'd like to close this with NEXTFEATURERELEASE since it's unlikely that we'll make another Oct2012-based release.

Comment 19593

Date: 2014-02-20 15:02:24 +0100
From: @sjoerdmullender

Jan2014 has been released.