Update of /cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv11323/src/test/BugDay_2005-12-19_2.9.3/Tests
Modified Files:
Tag: Aug2009
prepare_doesnot_like_LIKE.SF-1234205.sql
subquery_syntax.SF-1296390.sql
Log Message:
bug fixing
prepare/execute statements now go to seperate query cache
check for ambiguous order by columns
U subquery_syntax.SF-1296390.sql
Index: subquery_syntax.SF-1296390.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests/subquery_syntax.SF-1296390.sql,v
retrieving revision 1.1
retrieving revision 1.1.28.1
diff -u -d -r1.1 -r1.1.28.1
--- subquery_syntax.SF-1296390.sql 19 Dec 2005 15:49:15 -0000 1.1
+++ subquery_syntax.SF-1296390.sql 7 Aug 2009 14:26:20 -0000 1.1.28.1
@@ -1,4 +1,4 @@
create table test1296390 (id int);
insert into test1296390 values (1);
-insert into test1296390 values (select max(id) + 1 from test1296390);
-insert into test1296390 values ((select max(id) + 1 from test1296390));
+insert into test1296390 (select max(id) + 1 from test1296390);
+insert into test1296390 ((select max(id) + 1 from test1296390));
U prepare_doesnot_like_LIKE.SF-1234205.sql
Index: prepare_doesnot_like_LIKE.SF-1234205.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests/prepare_doesnot_like_LIKE.SF-1234205.sql,v
retrieving revision 1.6
retrieving revision 1.6.22.1
diff -u -d -r1.6 -r1.6.22.1
--- prepare_doesnot_like_LIKE.SF-1234205.sql 3 Sep 2006 13:02:42 -0000
1.6
+++ prepare_doesnot_like_LIKE.SF-1234205.sql 7 Aug 2009 14:26:19 -0000
1.6.22.1
@@ -2,6 +2,6 @@
insert into t1234205 values ('niels'),('fabian'),('martin');
prepare select name from t1234205 where name like ?;
-execute 1 ('%');
+execute 0 ('%');
prepare select name from t1234205 where name like 'n%';
-execute 2 ();
+execute 1 ();
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
