Update of /cvsroot/monetdb/sql/src/test/null/Tests
In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv29430/null/Tests
Modified Files:
Tag: Feb2010
coalesce2.sql coalesce3.sql
Log Message:
CRLF -> LF.
Index: coalesce2.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/null/Tests/coalesce2.sql,v
retrieving revision 1.2
retrieving revision 1.2.14.1
diff -u -d -r1.2 -r1.2.14.1
--- coalesce2.sql 21 Feb 2008 13:42:37 -0000 1.2
+++ coalesce2.sql 5 Mar 2010 17:03:49 -0000 1.2.14.1
@@ -1,35 +1,35 @@
-CREATE TABLE my_table1 ( col1 VARCHAR(1) ) ;
-CREATE TABLE my_table2 ( col1 VARCHAR(1) NOT NULL, col2 INT NOT NULL) ;
-
-INSERT INTO my_table1 VALUES ('A') ;
-INSERT INTO my_table1 VALUES ('B') ;
-INSERT INTO my_table1 VALUES ('B') ;
-INSERT INTO my_table1 VALUES ('C') ;
-INSERT INTO my_table1 VALUES ('C') ;
-INSERT INTO my_table1 VALUES ('C') ;
-INSERT INTO my_table1 VALUES (NULL) ;
-INSERT INTO my_table1 VALUES (NULL) ;
-INSERT INTO my_table1 VALUES (NULL) ;
-INSERT INTO my_table1 VALUES (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 (SELECT y.col2 FROM my_table2 y WHERE y.col1 = x.col1) AS col1
-FROM (
- SELECT * FROM my_table1
- ) x
-;
-
--- Query 2
-SELECT COALESCE((SELECT y.col2 FROM my_table2 y WHERE y.col1 = x.col1),0) AS
col1
-FROM (
- SELECT * FROM my_table1
- ) x
-;
-
-DROP TABLE my_table1 ;
-DROP TABLE my_table2 ;
+CREATE TABLE my_table1 ( col1 VARCHAR(1) ) ;
+CREATE TABLE my_table2 ( col1 VARCHAR(1) NOT NULL, col2 INT NOT NULL) ;
+
+INSERT INTO my_table1 VALUES ('A') ;
+INSERT INTO my_table1 VALUES ('B') ;
+INSERT INTO my_table1 VALUES ('B') ;
+INSERT INTO my_table1 VALUES ('C') ;
+INSERT INTO my_table1 VALUES ('C') ;
+INSERT INTO my_table1 VALUES ('C') ;
+INSERT INTO my_table1 VALUES (NULL) ;
+INSERT INTO my_table1 VALUES (NULL) ;
+INSERT INTO my_table1 VALUES (NULL) ;
+INSERT INTO my_table1 VALUES (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 (SELECT y.col2 FROM my_table2 y WHERE y.col1 = x.col1) AS col1
+FROM (
+ SELECT * FROM my_table1
+ ) x
+;
+
+-- Query 2
+SELECT COALESCE((SELECT y.col2 FROM my_table2 y WHERE y.col1 = x.col1),0) AS
col1
+FROM (
+ SELECT * FROM my_table1
+ ) x
+;
+
+DROP TABLE my_table1 ;
+DROP TABLE my_table2 ;
Index: coalesce3.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/null/Tests/coalesce3.sql,v
retrieving revision 1.2
retrieving revision 1.2.14.1
diff -u -d -r1.2 -r1.2.14.1
--- coalesce3.sql 21 Feb 2008 13:42:39 -0000 1.2
+++ coalesce3.sql 5 Mar 2010 17:03:49 -0000 1.2.14.1
@@ -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
