Bugs item #2075097, was opened at 2008-08-26 14:04 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=2075097&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: MonetDB5 5.6 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Qian Qiao (drizzlerain) Assigned to: Niels Nes (nielsnes) Summary: select view repliy wrong Initial Comment: OS : RedHat Linux AS 4 GCC: 3.4.6 1.setup: CREATE TABLE GROUPS1 (EMPNUM INT, GRP INT); CREATE TABLE NAMES1 (EMPNUM INT, NAME CHAR(5)); CREATE VIEW NAMGRP1 AS SELECT * FROM NAMES1 NATURAL JOIN GROUPS1; 2.insert: INSERT INTO GROUPS1 VALUES (0, 10); INSERT INTO GROUPS1 VALUES (1, 20); INSERT INTO GROUPS1 VALUES (2, 30); INSERT INTO NAMES1 VALUES (5, 'HARRY'); INSERT INTO NAMES1 VALUES (1, 'MARY'); INSERT INTO NAMES1 VALUES (0, 'KERI'); 3.result: SELECT EMPNUM FROM NAMGRP1 WHERE NAME = 'KERI' AND GRP = 10; !SELECT: identifier 'name' unknown 4.question The view by NATURAL JOIN,INNER JOIN,or RIGHT OUTER JOIN can be created,but when you select view replied wrong. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075097&group_id=56967 ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
