SourceForge.net wrote: > Bugs item #2654300, was opened at 2009-03-02 12:41 > 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=2654300&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: Open > Resolution: None > Priority: 5 > Private: No > Submitted By: Roberto Cornacchia (cornuz) > Assigned to: Niels Nes (nielsnes) > Summary: problem with views reusing aliases ? > > Initial Comment: > [ on Feb2009 branch ] > > create table x (n int, s varchar(10)); > insert into x values (1, 'one'); > insert into x values (2, 'two'); > insert into x values (3, 'three'); > > -- swap the two attributes > create view x1 as > select s as a1, n as a2 from x; > > -- swap them again > create view x2 as > select a2 as a1, a1 as a2 from x1; > > -- select on the original 's' attribute fails > select * from x2 where a2='two'; > > This is the output: > > $ mclient -lsql -dtest02 -G < bug2.sql The algebra version is the default one in the current as well as in the stable branch... So how the -G option is still valid?
Romulo > [ 1 ] > [ 1 ] > [ 1 ] > MAPI = mone...@localhost:50000 > QUERY = select * from x2 where a2='two'; > ERROR = !TypeException:user.s0_1[4]:'algebra.uselect' undefined in: _9:any := > algebra.uselect(_2:bat[:oid,:str], _8:int) > !TypeException:user.s0_1[6]:'algebra.kdifference' undefined in: > _12:any := algebra.kdifference(_9:any, _10:bat[:oid,:str]) > !TypeException:user.s0_1[7]:'algebra.uselect' undefined in: _13:any > := algebra.uselect(_10:bat[:oid,:str], _8:int) > !TypeException:user.s0_1[8]:'algebra.kunion' undefined in: _14:any := > algebra.kunion(_12:any, _13:any) > !TypeException:user.s0_1[10]:'algebra.uselect' undefined in: _17:any > := algebra.uselect(_15:bat[:oid,:str], _8:int) > !TypeException:user.s0_1[11]:'algebra.kunion' undefined in: _18:any > := algebra.kunion(_14:any, _17:any) > !TypeException:user.s0_1[14]:'algebra.kdifference' undefined in: > _21:any := algebra.kdifference(_18:any, _20:bat[:oid,:oid]) > !TypeException:user.s0_1[16]:'algebra.markT' undefined in: _24:any := > algebra.markT(_21:any, _22:oid) > !TypeException:user.s0_1[17]:'bat.reverse' undefined in: _25:any := > bat.reverse(_24:any) > !TypeException:user.s0_1[24]:'algebra.join' undefined in: _33:any := > algebra.join(_25:any, _32:bat[:oid,:int]) > !TypeException:user.s0_1[28]:'algebra.join' undefined in: _37:any := > algebra.join(_25:any, _36:bat[:oid,:str]) > !SQLException:int:conversion of string 'two' failed > > > ---------------------------------------------------------------------- > > You can respond by visiting: > https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2654300&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 ------------------------------------------------------------------------------ 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-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
