Bugs item #2021508, was opened at 2008-07-18 14:09 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2021508&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 2.24 >Status: Closed >Resolution: Fixed Priority: 6 Private: No Submitted By: Martin Kersten (mlkersten) Assigned to: Niels Nes (nielsnes) Summary: SQL: thetajoin limitation Initial Comment: The following script produces a type error while it can be evaluated using a cross product. create table s1 (id int, v char(10)); create table s2 (id int, v char(10)); insert into s1 values (1,'s1'); insert into s1 values (2,'s2'); insert into s1 values (3,'s3'); insert into s1 values (4,'s4'); insert into s1 values (5,'s5'); insert into s1 values (6,'s6'); insert into s2 values (1,'s1'); insert into s2 values (2,'s2'); insert into s2 values (3,'s3'); insert into s2 values (4,'s4'); insert into s2 values (5,'s5'); insert into s2 values (6,'s6'); select s1.id from s1, s2 where s1.v between s2.v and s2.v||'c' ; ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2008-07-21 09:33 Message: Logged In: YES user_id=43556 Originator: NO missing implementation is added to MonetDB/src/gdk/gdk_rangejoin.mx also a test is added to sql/src/tests/BugTracker/Tests/between_on_strings.SF-2021508.sql ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2021508&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
