Update of /cvsroot/monetdb/sql/src/test
In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv17916/src/test
Modified Files:
order_by_simple_exp.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/order_by_simple_exp.sql,1.1.22.1
CRLF -> LF.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: order_by_simple_exp.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/order_by_simple_exp.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- order_by_simple_exp.sql 29 May 2007 21:32:13 -0000 1.1
+++ order_by_simple_exp.sql 10 Mar 2010 14:29:58 -0000 1.2
@@ -1,31 +1,31 @@
-CREATE TABLE test01 (
-id INTEGER NOT NULL,
-col1 VARCHAR(10) NOT NULL,
-col2 INTEGER NOT NULL
-) ;
-
-INSERT INTO test01 VALUES (10,'ABC',21) ;
-INSERT INTO test01 VALUES (11,'ABD',22) ;
-INSERT INTO test01 VALUES (12,'ABE',23) ;
-INSERT INTO test01 VALUES (13,'ABF',24) ;
-INSERT INTO test01 VALUES (14,'ABC',25) ;
-INSERT INTO test01 VALUES (15,'ABD',26) ;
-INSERT INTO test01 VALUES (16,'ABE',27) ;
-INSERT INTO test01 VALUES (17,'ABD',28) ;
-INSERT INTO test01 VALUES (18,'ABE',29) ;
-INSERT INTO test01 VALUES (19,'ABF',30) ;
-
-select col1
-from test01
-group by col1
-order by col1;
-
-select col1 as c0
-from test01
-group by col1
-order by c0;
-
-select col1 as c0
-from test01
-group by col1
-order by col1;
+CREATE TABLE test01 (
+id INTEGER NOT NULL,
+col1 VARCHAR(10) NOT NULL,
+col2 INTEGER NOT NULL
+) ;
+
+INSERT INTO test01 VALUES (10,'ABC',21) ;
+INSERT INTO test01 VALUES (11,'ABD',22) ;
+INSERT INTO test01 VALUES (12,'ABE',23) ;
+INSERT INTO test01 VALUES (13,'ABF',24) ;
+INSERT INTO test01 VALUES (14,'ABC',25) ;
+INSERT INTO test01 VALUES (15,'ABD',26) ;
+INSERT INTO test01 VALUES (16,'ABE',27) ;
+INSERT INTO test01 VALUES (17,'ABD',28) ;
+INSERT INTO test01 VALUES (18,'ABE',29) ;
+INSERT INTO test01 VALUES (19,'ABF',30) ;
+
+select col1
+from test01
+group by col1
+order by col1;
+
+select col1 as c0
+from test01
+group by col1
+order by c0;
+
+select col1 as c0
+from test01
+group by col1
+order by col1;
------------------------------------------------------------------------------
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
