Update of /cvsroot/monetdb/sql/src/test/bugs/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv18123/src/test/bugs/Tests
Modified Files:
zero_or_one_bug.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/bugs/Tests/zero_or_one_bug.sql,1.2.14.1
CRLF -> LF.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: zero_or_one_bug.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/zero_or_one_bug.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- zero_or_one_bug.sql 28 Feb 2008 15:56:47 -0000 1.2
+++ zero_or_one_bug.sql 10 Mar 2010 14:30:19 -0000 1.3
@@ -1,43 +1,43 @@
-CREATE TABLE my_table1 (
---
- id1 INT NOT NULL,
- col1a VARCHAR(10),
- col1b VARCHAR(1)
---
-) ;
-
-INSERT INTO my_table1 VALUES (1, 'a', '') ;
-INSERT INTO my_table1 VALUES (2, 'b', '') ;
-INSERT INTO my_table1 VALUES (3, 'c', '') ;
-INSERT INTO my_table1 VALUES (4, 'd', '') ;
-INSERT INTO my_table1 VALUES (5, 'e', '') ;
-INSERT INTO my_table1 VALUES (6, 'f', '') ;
-INSERT INTO my_table1 VALUES (7, 'g', '') ;
-INSERT INTO my_table1 VALUES (8, 'h', '') ;
-INSERT INTO my_table1 VALUES (9, 'i', '') ;
-
-CREATE TABLE my_table2 (
---
- id2 INT NOT NULL,
- col2 VARCHAR(10)
-
-) ;
-
--- Query 1
---
-SELECT
- COALESCE(id1,0),
- (SELECT col2 FROM my_table2 WHERE col2 = col1a)
-FROM my_table1 x
-;
-
--- Query 2
---
-SELECT
- COALESCE(id1,0),
- (SELECT col2 FROM my_table2 WHERE col2 = col1a) AS my_col1
-FROM my_table1 x
-;
-
-DROP TABLE my_table1 ;
-DROP TABLE my_table2 ;
+CREATE TABLE my_table1 (
+--
+ id1 INT NOT NULL,
+ col1a VARCHAR(10),
+ col1b VARCHAR(1)
+--
+) ;
+
+INSERT INTO my_table1 VALUES (1, 'a', '') ;
+INSERT INTO my_table1 VALUES (2, 'b', '') ;
+INSERT INTO my_table1 VALUES (3, 'c', '') ;
+INSERT INTO my_table1 VALUES (4, 'd', '') ;
+INSERT INTO my_table1 VALUES (5, 'e', '') ;
+INSERT INTO my_table1 VALUES (6, 'f', '') ;
+INSERT INTO my_table1 VALUES (7, 'g', '') ;
+INSERT INTO my_table1 VALUES (8, 'h', '') ;
+INSERT INTO my_table1 VALUES (9, 'i', '') ;
+
+CREATE TABLE my_table2 (
+--
+ id2 INT NOT NULL,
+ col2 VARCHAR(10)
+
+) ;
+
+-- Query 1
+--
+SELECT
+ COALESCE(id1,0),
+ (SELECT col2 FROM my_table2 WHERE col2 = col1a)
+FROM my_table1 x
+;
+
+-- Query 2
+--
+SELECT
+ COALESCE(id1,0),
+ (SELECT col2 FROM my_table2 WHERE col2 = col1a) AS my_col1
+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
