Update of /cvsroot/monetdb/sql/src/test/null/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv18224/src/test/null/Tests
Modified Files:
coalesce3.sql
Log Message:
propagated changes of Friday Mar 05 2010 - Wednesday Mar 10 2010
from the Feb2010 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/03/05 - sjoerd: src/test/null/Tests/coalesce3.sql,1.2.14.1
CRLF -> LF.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: coalesce3.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/null/Tests/coalesce3.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- coalesce3.sql 21 Feb 2008 13:42:39 -0000 1.2
+++ coalesce3.sql 10 Mar 2010 14:30:27 -0000 1.3
@@ -1,29 +1,29 @@
-CREATE TABLE my_table1 ( id INT NOT NULL, col1 VARCHAR(1) ) ;
-CREATE TABLE my_table2 ( col1 VARCHAR(1) NOT NULL, col2 INT NOT NULL) ;
-
-INSERT INTO my_table1 VALUES (1, 'A') ;
-INSERT INTO my_table1 VALUES (2, 'B') ;
-INSERT INTO my_table1 VALUES (3, 'B') ;
-INSERT INTO my_table1 VALUES (4, 'C') ;
-INSERT INTO my_table1 VALUES (5, 'C') ;
-INSERT INTO my_table1 VALUES (6, 'C') ;
-INSERT INTO my_table1 VALUES (7, NULL) ;
-INSERT INTO my_table1 VALUES (8, NULL) ;
-INSERT INTO my_table1 VALUES (9, NULL) ;
-INSERT INTO my_table1 VALUES (10, NULL) ;
-
-INSERT INTO my_table2 VALUES ('A', 1) ;
-INSERT INTO my_table2 VALUES ('B', 2) ;
-INSERT INTO my_table2 VALUES ('C', 3) ;
-
--- Query 1
-
-SELECT id,
- (SELECT y.col2 FROM my_table2 y WHERE y.col1 = x.col1)
-FROM (
- SELECT * FROM my_table1
- ) x
-;
-
-DROP TABLE my_table1 ;
-DROP TABLE my_table2 ;
+CREATE TABLE my_table1 ( id INT NOT NULL, col1 VARCHAR(1) ) ;
+CREATE TABLE my_table2 ( col1 VARCHAR(1) NOT NULL, col2 INT NOT NULL) ;
+
+INSERT INTO my_table1 VALUES (1, 'A') ;
+INSERT INTO my_table1 VALUES (2, 'B') ;
+INSERT INTO my_table1 VALUES (3, 'B') ;
+INSERT INTO my_table1 VALUES (4, 'C') ;
+INSERT INTO my_table1 VALUES (5, 'C') ;
+INSERT INTO my_table1 VALUES (6, 'C') ;
+INSERT INTO my_table1 VALUES (7, NULL) ;
+INSERT INTO my_table1 VALUES (8, NULL) ;
+INSERT INTO my_table1 VALUES (9, NULL) ;
+INSERT INTO my_table1 VALUES (10, NULL) ;
+
+INSERT INTO my_table2 VALUES ('A', 1) ;
+INSERT INTO my_table2 VALUES ('B', 2) ;
+INSERT INTO my_table2 VALUES ('C', 3) ;
+
+-- Query 1
+
+SELECT id,
+ (SELECT y.col2 FROM my_table2 y WHERE y.col1 = x.col1)
+FROM (
+ SELECT * FROM my_table1
+ ) x
+;
+
+DROP TABLE my_table1 ;
+DROP TABLE my_table2 ;
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
