You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
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.
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)
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.
The text was updated successfully, but these errors were encountered: