Changeset: b828d62760ce for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b828d62760ce
Modified Files:
sql/test/pg_regress/Tests/case.sql
sql/test/pg_regress/Tests/case.stable.err
sql/test/pg_regress/Tests/case.stable.out
Branch: default
Log Message:
Improved case.sql test and approved outputs
diffs (91 lines):
diff --git a/sql/test/pg_regress/Tests/case.sql
b/sql/test/pg_regress/Tests/case.sql
--- a/sql/test/pg_regress/Tests/case.sql
+++ b/sql/test/pg_regress/Tests/case.sql
@@ -141,7 +141,7 @@ UPDATE CASE_TBL
SELECT * FROM CASE_TBL;
UPDATE CASE_TBL
- SET i = CASE WHEN b.i >= 2 THEN (2 * i)
+ SET i = CASE WHEN i >= 2 THEN (2 * i)
ELSE (3 * i) END
-- FROM CASE2_TBL b
WHERE i = -CASE_TBL.i;
diff --git a/sql/test/pg_regress/Tests/case.stable.err
b/sql/test/pg_regress/Tests/case.stable.err
--- a/sql/test/pg_regress/Tests/case.stable.err
+++ b/sql/test/pg_regress/Tests/case.stable.err
@@ -29,13 +29,6 @@ stderr of test 'case` in directory 'sql/
# 17:11:19 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-1142" "--port=38959"
# 17:11:19 >
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
-QUERY = UPDATE CASE_TBL
- SET i = CASE WHEN b.i >= 2 THEN (2 * i)
- ELSE (3 * i) END
- -- FROM CASE2_TBL b
- WHERE i = -CASE_TBL.i;
-ERROR = !SELECT: no such column 'b.i'
# 17:11:19 >
# 17:11:19 > "Done."
diff --git a/sql/test/pg_regress/Tests/case.stable.out
b/sql/test/pg_regress/Tests/case.stable.out
--- a/sql/test/pg_regress/Tests/case.stable.out
+++ b/sql/test/pg_regress/Tests/case.stable.out
@@ -214,16 +214,16 @@ Ready.
[ -30.3 ]
[ 3 ]
[ 10.1 ]
-[ 10.1 ]
+[ 20.2 ]
+[ -30.3 ]
+[ 2 ]
[ 10.1 ]
[ 20.2 ]
-[ 20.2 ]
+[ -30.3 ]
+[ 1 ]
+[ 10.1 ]
[ 20.2 ]
[ -30.3 ]
-[ -30.3 ]
-[ -30.3 ]
-[ 2 ]
-[ 1 ]
[ -6 ]
#SELECT *
@@ -255,16 +255,16 @@ Ready.
[ "", NULL, 3 ]
[ "", 4, 3 ]
[ "", 1, 2 ]
+[ "", NULL, 2 ]
+[ "", 3, 2 ]
+[ "", 4, 2 ]
[ "", NULL, 1 ]
+[ "", 2, 1 ]
+[ "", 3, 1 ]
+[ "", 4, 1 ]
[ "", 1, NULL ]
-[ "", NULL, 2 ]
-[ "", 2, 1 ]
[ "", 2, NULL ]
-[ "", 3, 2 ]
-[ "", 3, 1 ]
[ "", 3, NULL ]
-[ "", 4, 2 ]
-[ "", 4, 1 ]
[ "", 4, NULL ]
#SELECT '' AS "Two", *
# FROM CASE_TBL a, CASE2_TBL b
@@ -301,6 +301,12 @@ Ready.
[ 8, 20.2 ]
[ -9, -30.3 ]
[ -12, NULL ]
+#UPDATE CASE_TBL
+# SET i = CASE WHEN i >= 2 THEN (2 * i)
+# ELSE (3 * i) END
+#-- FROM CASE2_TBL b
+# WHERE i = -CASE_TBL.i;
+[ 0 ]
#SELECT * FROM CASE_TBL;
% sys.case_tbl, sys.case_tbl # table_name
% i, f # name
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
