Bugs item #2041785, was opened at 2008-08-07 16:50
Message generated for change (Comment added) made by lsidir
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2041785&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: None
>Status: Closed
Resolution: Fixed
Priority: 5
Private: No
Submitted By: Mike Mark (mmarkog)
Assigned to: Niels Nes (nielsnes)
Summary: range join exception
Initial Comment:
Operating system: Windows XP
I'm having trouble getting range joins on strings working properly.
I looked into it and I found out that
ALGrangejoin (algebra.c) calls BATrangejoin (gdk_rangejoin.c) that
performs the join and returns a BAT as a result. BATrangejoin has a
switch with a case for TYPE_chr that compares strings
When I try to perform a range join on a string attribute (char(n),
even for n=1, varchar(n)) I get an exception:
!MALException:algebra.rangejoin:GDKerror
!ERROR: BATrangejoin: type not implemented
The switch statement skips the TYPE_chr case and goes to the default.
For example,
sql>create table s1 (id int, v char(10)); create table s2 (id int, v
sql>char(10)); insert into s1 values (1,'s1'); insert into s1 values
sql>(2,'s2'); insert into s1 values (3,'s3'); insert into s1 values
sql>(4,'s4'); insert into s1 values (5,'s5'); insert into s1 values
sql>(6,'s6'); insert into s2 values (1,'s1'); insert into s2 values
sql>(2,'s2'); insert into s2 values (3,'s3'); insert into s2 values
sql>(4,'s4'); insert into s2 values (5,'s5'); insert into s2 values
sql>(6,'s6'); select s1.id from s1, s2 where s1.v between s2.v and
sql>s2.v||'c' ;
!MALException:algebra.rangejoin:GDKerror
!ERROR: BATrangejoin: type not implemented
whereas
sql>select s1.id from s1, s2 where s2.id=2 and s1.id between s2.idand s2.id+1 ;
+----+
| id |
+====+
| 2 |
| 3 |
+----+
Thanks
----------------------------------------------------------------------
>Comment By: Lefteris Sidirourgos (lsidir)
Date: 2008-08-10 17:24
Message:
Logged In: YES
user_id=1856546
Originator: NO
Added test with name 'range_join_any.SF-2041785`
Closing bug.
----------------------------------------------------------------------
Comment By: Lefteris Sidirourgos (lsidir)
Date: 2008-08-10 14:21
Message:
Logged In: YES
user_id=1856546
Originator: NO
This bug was already been fixed by Niels in the stable branch.
Modified Files:
Tag: MonetDB_1-24
gdk_rangejoin.mx
Log Message:
added missing (rangejoin) implemenation for any types
Changing resolution to fixed, but leaving the bug open because a test need
to be added.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2041785&group_id=56967
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
