Bugs item #2546109, was opened at 2009-01-29 18:50
Message generated for change (Comment added) made by stmane
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: Fixed
>Priority: 6
Private: No
Submitted By: Roberto Cornacchia (cornuz)
>Assigned to: Niels Nes (nielsnes)
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: Stefan Manegold (stmane)
Date: 2009-02-16 10:55
Message:
Niels,
which is the test that belong to this one?
The is none with number "2546109" ...
Stefan
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2009-02-11 20: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
------------------------------------------------------------------------------
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
