Bugs item #2869818, was opened at 2009-09-29 14:37
Message generated for change (Settings changed) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2869818&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL CVS Head
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Stefan de Konink (skinkie)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: Program contains errors
Initial Comment:
We had a super friendly user again that managed to create 11GB bats on disk,
therefore crashing the kernel and vmx drivers. So I decided to upgrade MonetDB
to Head again. Surprisingly this time no mega bats, but just a very friendly
error message :)
sql>select * from kvk,concernrelaties where upper(bedrijfsnaam) like 'VANAD%'
and (kvk.kvk=concernrelaties.kvk or kvk.kvk=ouderkvk) limit 10;
TypeException:user.s1_1[60]:'algebra.leftjoin' undefined in: _84:any :=
algebra.leftjoin(_83:bat[:oid,:void], _41:bat[:oid,:lng], _77:lng)
TypeException:user.s1_1[65]:'algebra.slice' undefined in: _92:any :=
algebra.slice(_84:any, _85:int, _90:int)
TypeException:user.s1_1[67]:'algebra.leftjoin' undefined in: _94:any :=
algebra.leftjoin(_83:bat[:oid,:void], _93:bat[:oid,:str], _77:lng)
TypeException:user.s1_1[68]:'algebra.semijoin' undefined in: _95:any :=
algebra.semijoin(_94:any, _92:any)
TypeException:user.s1_1[79]:'algebra.leftjoin' undefined in: _111:any :=
algebra.leftjoin(_83:bat[:oid,:void], _109:bat[:oid,:str], _110:lng)
TypeException:user.s1_1[80]:'algebra.semijoin' undefined in: _112:any :=
algebra.semijoin(_111:any, _92:any)
TypeException:user.s1_1[91]:'algebra.leftjoin' undefined in: _124:any :=
algebra.leftjoin(_83:bat[:oid,:void], _123:bat[:oid,:str], _110:lng)
TypeException:user.s1_1[92]:'algebra.semijoin' undefined in: _125:any :=
algebra.semijoin(_124:any, _92:any)
TypeException:user.s1_1[103]:'algebra.leftjoin' undefined in: _141:any :=
algebra.leftjoin(_83:bat[:oid,:void], _140:bat[:oid,:str], _110:lng)
TypeException:user.s1_1[104]:'algebra.semijoin' undefined in: _142:any :=
algebra.semijoin(_141:any, _92:any)
TypeException:user.s1_1[115]:'algebra.leftjoin' undefined in: _156:any :=
algebra.leftjoin(_83:bat[:oid,:void], _154:bat[:oid,:str], _155:lng)
TypeException:user.s1_1[116]:'algebra.semijoin' undefined in: _157:any :=
algebra.semijoin(_156:any, _92:any)
TypeException:user.s1_1[127]:'algebra.leftjoin' undefined in: _172:any :=
algebra.leftjoin(_83:bat[:oid,:void], _171:bat[:oid,:int], _155:lng)
TypeException:user.s1_1[128]:'algebra.semijoin' undefined in: _173:any :=
algebra.semijoin(_172:any, _92:any)
TypeException:user.s1_1[139]:'algebra.leftjoin' undefined in: _186:any :=
algebra.leftjoin(_83:bat[:oid,:void], _185:bat[:oid,:int], _155:lng)
TypeException:user.s1_1[140]:'algebra.semijoin' undefined in: _187:any :=
algebra.semijoin(_186:any, _92:any)
TypeException:user.s1_1[145]:'algebra.semijoin' undefined in: _194:any :=
algebra.semijoin(_192:bat[:oid,:lng], _92:any)
TypeException:user.s1_1[156]:'algebra.semijoin' undefined in: _210:any :=
algebra.semijoin(_209:bat[:oid,:str], _92:any)
TypeException:user.s1_1[167]:'algebra.semijoin' undefined in: _223:any :=
algebra.semijoin(_222:bat[:oid,:str], _92:any)
TypeException:user.s1_1[178]:'algebra.semijoin' undefined in: _238:any :=
algebra.semijoin(_236:bat[:oid,:str], _92:any)
TypeException:user.s1_1[180]:'algebra.semijoin' undefined in: _240:any :=
algebra.semijoin(_239:bat[:oid,:int], _92:any)
SQLException:SQLengine:Program contains errors
plan select * from kvk,concernrelaties where upper(bedrijfsnaam) like 'VANAD%'
and (kvk.kvk=concernrelaties.kvk or kvk.kvk=ouderkvk) limit 10;
top N (
| project (
| | join (
| | | table(sys.concernrelaties) [ concernrelaties.kvk, concernrelaties.ouder,
concernrelaties.postcode, concernrelaties.plaats, concernrelaties.ouderkvk,
concernrelaties.%TID% NOT NULL ],
| | | select (
| | | | table(sys.kvk) [ kvk.kvk, kvk.bedrijfsnaam, kvk.adres, kvk.postcode,
kvk.plaats, kvk.type, kvk.kvks, kvk.sub, kvk.%TID% NOT NULL ]
| | | ) [ convert(upper(kvk.bedrijfsnaam)) like convert('VANAD%') ]
| | ) [ (kvk.kvk = concernrelaties.kvk) or (kvk.kvk =
convert(concernrelaties.ouderkvk)) ]
| ) [ kvk.kvk, kvk.bedrijfsnaam, kvk.adres, kvk.postcode, kvk.plaats, kvk.type,
kvk.kvks, kvk.sub, concernrelaties.kvk, concernrelaties.ouder,
concernrelaties.postcode, concernrelaties.plaats, concernrelaties.ouderkvk ]
) [ 10 ]
CREATE TABLE "sys"."kvk" (
"kvk" bigint,
"bedrijfsnaam" varchar(255),
"adres" varchar(64),
"postcode" varchar(6),
"plaats" varchar(32),
"type" varchar(16),
"kvks" int,
"sub" int
);
CREATE TABLE "sys"."concernrelaties" (
"kvk" bigint,
"ouder" varchar(30),
"postcode" varchar(6),
"plaats" varchar(32),
"ouderkvk" int
);
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2009-10-05 20:41
Message:
added test to BugTracker-2009 semijoin_bug.SF-2869818.sql
fixed by only rewriting IN (values) into semijoins not (x.c0==y.c1 or
x.c1==y.c2)
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2869818&group_id=56967
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
