Bugs item #2656762, was opened at 2009-03-03 10:43
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=2656762&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: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Roberto Cornacchia (cornuz)
Assigned to: Nobody/Anonymous (nobody)
Summary: Views with select on top of join - attribute lookup problem
Initial Comment:
This bug seems to be related to bug #2654300, which is now fixed in CVS.
However, the fix doesn't solve the problem below:
drop table x cascade;
drop table y cascade;
create table x (id int);
insert into x (id) values (1);
insert into x (id) values (2);
insert into x (id) values (3);
create table y (n int, s varchar(10));
insert into y (n,s) values (1, 'one');
insert into y (n,s) values (2, 'two');
insert into y (n,s) values (3, 'three');
create view yv as select s as a1, n as a2 from y;
create view j as select yv.a2 as a1, yv.a1 as a2 from x,yv where x.id = yv.a2;
select * from j where a2='y-three';
drop table x cascade;
drop table y cascade;
Output:
MAPI = mone...@localhost:50000
QUERY = select * from j where a2='y-three';
ERROR = !TypeException:user.s0_1[13]:'algebra.uselect' undefined in: _22:any :=
algebra.uselect(_17:bat[:oid,:str], _21:int)
!TypeException:user.s0_1[15]:'algebra.kdifference' undefined in:
_24:any := algebra.kdifference(_22:any, _23:bat[:oid,:str])
!TypeException:user.s0_1[16]:'algebra.uselect' undefined in: _25:any :=
algebra.uselect(_23:bat[:oid,:str], _21:int)
!TypeException:user.s0_1[17]:'algebra.kunion' undefined in: _26:any :=
algebra.kunion(_24:any, _25:any)
!TypeException:user.s0_1[19]:'algebra.uselect' undefined in: _28:any :=
algebra.uselect(_27:bat[:oid,:str], _21:int)
!TypeException:user.s0_1[20]:'algebra.kunion' undefined in: _29:any :=
algebra.kunion(_26:any, _28:any)
!TypeException:user.s0_1[23]:'algebra.kdifference' undefined in:
_32:any := algebra.kdifference(_29:any, _31:bat[:oid,:oid])
!TypeException:user.s0_1[25]:'algebra.markT' undefined in: _35:any :=
algebra.markT(_32:any, _33:oid)
!TypeException:user.s0_1[26]:'bat.reverse' undefined in: _36:any :=
bat.reverse(_35:any)
!TypeException:user.s0_1[33]:'algebra.join' undefined in: _48:any :=
algebra.join(_36:any, _47:bat[:oid,:int])
!TypeException:user.s0_1[34]:'bat.reverse' undefined in: _49:any :=
bat.reverse(_48:any)
!TypeException:user.s0_1[35]:'algebra.join' undefined in: _50:any :=
algebra.join(_16:bat[:oid,:int], _49:any)
!TypeException:user.s0_1[36]:'bat.reverse' undefined in: _51:any :=
bat.reverse(_50:any)
!TypeException:user.s0_1[38]:'algebra.markT' undefined in: _53:any :=
algebra.markT(_51:any, _52:oid)
!TypeException:user.s0_1[39]:'bat.reverse' undefined in: _54:any :=
bat.reverse(_53:any)
!TypeException:user.s0_1[40]:'algebra.join' undefined in: _55:any :=
algebra.join(_54:any, _48:any)
!TypeException:user.s0_1[44]:'algebra.join' undefined in: _59:any :=
algebra.join(_36:any, _58:bat[:oid,:str])
!TypeException:user.s0_1[45]:'algebra.join' undefined in: _60:any :=
algebra.join(_54:any, _59:any)
!SQLException:int:conversion of string 'y-three' failed
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2656762&group_id=56967
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
