Changeset: 2a350a557d86 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2a350a557d86
Modified Files:
sql/backends/monet5/sql_statement.c
sql/test/SQLancer/Tests/sqlancer03.sql
sql/test/SQLancer/Tests/sqlancer03.stable.out
Branch: Jun2020
Log Message:
Disable conditional executing on dates conversion because it doesn't exist yet,
like of temporal types
diffs (53 lines):
diff --git a/sql/backends/monet5/sql_statement.c
b/sql/backends/monet5/sql_statement.c
--- a/sql/backends/monet5/sql_statement.c
+++ b/sql/backends/monet5/sql_statement.c
@@ -3010,7 +3010,7 @@ stmt_convert(backend *be, stmt *v, sql_s
q = pushInt(mb, q, f->scale);
*/ //q = pushInt(mb, q,
((ValRecord)((atom*)(be->mvc)->args[1])->data).val.ival);
}
- if (cond && v->nrcols && f->type->eclass != EC_DEC &&
!EC_TEMP_FRAC(t->type->eclass) && !EC_INTERVAL(t->type->eclass))
+ if (cond && v->nrcols && f->type->eclass != EC_DEC &&
!EC_TEMP(t->type->eclass) && !EC_INTERVAL(t->type->eclass))
q = pushArgument(mb, q, cond->nr);
if (q) {
stmt *s = stmt_create(be->mvc->sa, st_convert);
diff --git a/sql/test/SQLancer/Tests/sqlancer03.sql
b/sql/test/SQLancer/Tests/sqlancer03.sql
--- a/sql/test/SQLancer/Tests/sqlancer03.sql
+++ b/sql/test/SQLancer/Tests/sqlancer03.sql
@@ -256,6 +256,7 @@ ROLLBACK;
START TRANSACTION; --Bug 6929
CREATE TEMPORARY TABLE IF NOT EXISTS t0(c0 TIMESTAMP) ON COMMIT PRESERVE ROWS;
+SELECT COALESCE(1, dayofmonth(t0.c0)) FROM t0;
SELECT CAST(SUM(COALESCE(0.67, dayofmonth(t0.c0))) AS BIGINT) FROM t0;
SELECT ALL CAST(SUM(ALL COALESCE (CAST(0.67090863 AS REAL),
dayofmonth(t0.c0))) AS BIGINT) FROM t0;
ROLLBACK;
diff --git a/sql/test/SQLancer/Tests/sqlancer03.stable.out
b/sql/test/SQLancer/Tests/sqlancer03.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer03.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer03.stable.out
@@ -434,6 +434,26 @@ stdout of test 'sqlancer03` in directory
% 1 # length
[ 5 ]
#ROLLBACK;
+#START TRANSACTION; --Bug 6929
+#CREATE TEMPORARY TABLE IF NOT EXISTS t0(c0 TIMESTAMP) ON COMMIT PRESERVE ROWS;
+#SELECT COALESCE(1, dayofmonth(t0.c0)) FROM t0;
+% .%1 # table_name
+% %1 # name
+% int # type
+% 1 # length
+#SELECT CAST(SUM(COALESCE(0.67, dayofmonth(t0.c0))) AS BIGINT) FROM t0;
+% .%2 # table_name
+% %2 # name
+% bigint # type
+% 1 # length
+[ NULL ]
+#SELECT ALL CAST(SUM(ALL COALESCE (CAST(0.67090863 AS REAL),
dayofmonth(t0.c0))) AS BIGINT) FROM t0;
+% .%4 # table_name
+% %4 # name
+% bigint # type
+% 1 # length
+[ NULL ]
+#ROLLBACK;
#START TRANSACTION; -- Bug 6924
#CREATE TABLE "sys"."t0" ("a" INTEGER, "b" INTEGER NOT NULL, CONSTRAINT
"t0_a_b_unique" UNIQUE ("a","b"));
#COPY 39 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
