Bugs item #2021508, was opened at 2008-07-18 16:09 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=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: Open Resolution: None 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' ; ---------------------------------------------------------------------- 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
