Bugs item #2546109, was opened at 2009-01-29 18:50
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=2546109&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: Core
Group: SQL "stable"
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Roberto Cornacchia (cornuz)
Assigned to: Nobody/Anonymous (nobody)
Summary: row_number() columns should be materialized after selection
Initial Comment:
On Feb2009 branch:
CREATE TABLE a(n varchar(255));
INSERT INTO a VALUES('ONE');
INSERT INTO a VALUES('TWO');
INSERT INTO a VALUES('THREE');
CREATE VIEW b AS
SELECT row_number() over () AS id, n
FROM a;
sql>select * from b;
+----+-------+
| id | n |
+====+=======+
| 1 | ONE |
| 2 | TWO |
| 3 | THREE |
+----+-------+
sql>SELECT * FROM b
WHERE n = 'TWO';
+----+-----+
| id | n |
+====+=====+
| 1 | TWO |
+----+-----+
I would expect
+====+=====+
| 2 | TWO |
+----+-----+
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2546109&group_id=56967
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
