Changeset: af014158cc7e for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=af014158cc7e
Modified Files:
sql/test/BugDay_2005-12-19_2.9.3/Tests/prepare_doesnot_like_LIKE.SF-1234205.sql
sql/test/BugTracker/Tests/bind_with_cast.SF-1720934.sql
sql/test/BugTracker/Tests/bind_with_cast.SF-1720934.stable.err
sql/test/BugTracker/Tests/prepare_decimal_float.SF-1675795.sql
Branch: Aug2011
Log Message:
fix/approve some tests wrt prepared ids
diffs (47 lines):
diff --git
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/prepare_doesnot_like_LIKE.SF-1234205.sql
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/prepare_doesnot_like_LIKE.SF-1234205.sql
---
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/prepare_doesnot_like_LIKE.SF-1234205.sql
+++
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/prepare_doesnot_like_LIKE.SF-1234205.sql
@@ -2,6 +2,6 @@ create table t1234205 (name varchar(1024
insert into t1234205 values ('niels'),('fabian'),('martin');
prepare select name from t1234205 where name like ?;
-execute 1 ('%');
+execute 3 ('%');
prepare select name from t1234205 where name like 'n%';
-execute 2 ();
+execute 4 ();
diff --git a/sql/test/BugTracker/Tests/bind_with_cast.SF-1720934.sql
b/sql/test/BugTracker/Tests/bind_with_cast.SF-1720934.sql
--- a/sql/test/BugTracker/Tests/bind_with_cast.SF-1720934.sql
+++ b/sql/test/BugTracker/Tests/bind_with_cast.SF-1720934.sql
@@ -4,4 +4,4 @@ col1 INTEGER,
col2 VARCHAR(5)
) ;
PREPARE select id from data_1mto10m where id > CAST(? AS INTEGER) limit 10;
-exec 0('100');
+exec 2('100');
diff --git a/sql/test/BugTracker/Tests/bind_with_cast.SF-1720934.stable.err
b/sql/test/BugTracker/Tests/bind_with_cast.SF-1720934.stable.err
--- a/sql/test/BugTracker/Tests/bind_with_cast.SF-1720934.stable.err
+++ b/sql/test/BugTracker/Tests/bind_with_cast.SF-1720934.stable.err
@@ -79,8 +79,8 @@ stderr of test 'bind_with_cast.SF-172093
# 19:38:47 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=37754
# 19:38:47 >
-MAPI = monetdb@ottar:34070
-QUERY = exec 0('100');
+MAPI = monetdb@volund:39146
+QUERY = exec 2('100');
ERROR = !SQLException:sql.prepare:wrong type for argument 1 of prepared
statement: char, expected int
# 19:38:47 >
diff --git a/sql/test/BugTracker/Tests/prepare_decimal_float.SF-1675795.sql
b/sql/test/BugTracker/Tests/prepare_decimal_float.SF-1675795.sql
--- a/sql/test/BugTracker/Tests/prepare_decimal_float.SF-1675795.sql
+++ b/sql/test/BugTracker/Tests/prepare_decimal_float.SF-1675795.sql
@@ -1,6 +1,6 @@
create table xy ( time timestamp, x decimal(6,4), y decimal(6,4));
prepare insert into xy values (?,?,?);
-exec 0 (timestamp '2007-03-07 15:28:16.577', 0.6841, 0.684);
-exec 0 (timestamp '2007-03-07 15:28:16.577', -0.6841, -0.684);
+exec 2 (timestamp '2007-03-07 15:28:16.577', 0.6841, 0.684);
+exec 2 (timestamp '2007-03-07 15:28:16.577', -0.6841, -0.684);
select * from xy;
DROP TABLE xy;
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
