Bugs item #2041785, was opened at 2008-08-07 17:50 Message generated for change (Tracker Item Submitted) made by Item Submitter 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: Open Resolution: None 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 ---------------------------------------------------------------------- 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
