Bugs item #2041785, was opened at 2008-08-07 16:50 Message generated for change (Comment added) made by stmane 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: Stefan Manegold (stmane) Date: 2008-08-13 11:38 Message: Logged In: YES user_id=572415 Originator: NO (Just?) for completeness: To benefit from the fixes, please do the following 1) In case you built MonetDB from cvs sources, please update to the latest code version from the latest "Stable" release branches: buildtools: MonetDB_1-24 MonetDB: MonetDB_1-24 clients: Clients_1-24 MonetDB5: MonetDB_5-6 sql: SQL_2-24 2) In case you built MonetDB using the "monetdb-install.sh" script, rerun the script with `monetdb-install.sh --enable-sql --nightly=stable` 3) In case you built MonetDB "by hand" from the individual tarballs, please get their latest "Stable" versions from http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./0_latest/SourceTarBalls/ ---------------------------------------------------------------------- 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
