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...

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 = monetdb@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...

---

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 Monetdb-bugs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-bugs