Bugs item #2546109, was opened at 2009-01-29 17:50
Message generated for change (Comment added) made by nielsnes
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: Closed
>Resolution: Fixed
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 |
+----+-----+
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2009-02-11 19:52
Message:
fixed (we now detect projects which cannot be push up or down). Test added
to bugTracker-2009
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2546109&group_id=56967
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
