Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv21809/src/test/BugTracker-2008/Tests
Added Files:
view_reply_incorrect.SF-2075097.sql
Log Message:
propagated changes of Tuesday Aug 26 2008 - Thursday Aug 28 2008
from the SQL_2-24 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/08/26 - nielsnes:
src/test/BugTracker-2008/Tests/view_reply_incorrect.SF-2075097.sql,1.1.2.1
adding test scripts
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: view_reply_incorrect.SF-2075097.sql ---
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;
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');
select * from NAMGRP1;
SELECT EMPNUM
FROM NAMGRP1
WHERE NAME = 'KERI'
AND GRP = 10;
drop view NAMGRP1;
drop table NAMES1;
drop table GROUPS1;
-------------------------------------------------------------------------
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-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
