Bugs item #2879011, was opened at 2009-10-14 16:09
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2879011&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 "stable"
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Wouter Alink (vzzzbx)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: leftjoin undefined
Initial Comment:
(Aug2009, todays checkout)
The following script returns a mal-error.
CREATE TABLE a (name VARCHAR(10));
CREATE TABLE b (name VARCHAR(10));
INSERT INTO a VALUES ('a'),('b');
INSERT INTO b VALUES ('a'),('b');
SELECT a.name as x, b.name as y FROM a,b WHERE a.name LIKE b.name;
Yields:
!TypeException:user.s0_2[42]:'algebra.leftjoin' undefined in: _55:any :=
algebra.leftjoin(_54:bat[:oid,:void], _27:bat[:oid,:str], _50:lng)
!SQLException:SQLengine:Program contains errors
0 tuples
This does not happen when only selecting 1 column, as in:
SELECT a.name as x FROM a,b WHERE a.name LIKE b.name;
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2009-11-22 20:27
Message:
fixed by properly implementing join based on like expressions (ie
crossproduct + filter on like)
----------------------------------------------------------------------
Comment By: Wouter Alink (vzzzbx)
Date: 2009-11-15 15:55
Message:
added test leftjoin_undefined.SF-2879011 in src/test/BugTracker-2009. Test
still fails.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2879011&group_id=56967
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
