Changeset: 5ad88b364ee5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5ad88b364ee5
Added Files:
sql/test/BugTracker-2019/Tests/view-where-cast-error.Bug-6712.sql
Modified Files:
sql/test/BugTracker-2019/Tests/All
Branch: Apr2019
Log Message:
Added test for bug 6712.
diffs (25 lines):
diff --git a/sql/test/BugTracker-2019/Tests/All
b/sql/test/BugTracker-2019/Tests/All
--- a/sql/test/BugTracker-2019/Tests/All
+++ b/sql/test/BugTracker-2019/Tests/All
@@ -12,3 +12,4 @@ KNOWNFAIL?subselect.Bug-6700
alter_table_set_schema.Bug-6701
crash-in-rel_dependencies.Bug-6703
prepared-merge-statement.Bug-6706
+view-where-cast-error.Bug-6712
diff --git a/sql/test/BugTracker-2019/Tests/view-where-cast-error.Bug-6712.sql
b/sql/test/BugTracker-2019/Tests/view-where-cast-error.Bug-6712.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2019/Tests/view-where-cast-error.Bug-6712.sql
@@ -0,0 +1,12 @@
+start transaction;
+CREATE TABLE x ("id" INTEGER, "attribute" CHARACTER LARGE OBJECT, "value"
CHARACTER LARGE OBJECT);
+INSERT INTO x VALUES (1, 'version', '3.15.0');
+INSERT INTO x VALUES (1, 'executiontime', '100848');
+INSERT INTO x VALUES (2, 'version', '3.15.0');
+INSERT INTO x VALUES (2, 'executiontime', '54340');
+INSERT INTO x VALUES (3, 'version', '3.15.0');
+INSERT INTO x VALUES (3, 'executiontime', '96715');
+create view executiontimes as select * from x where attribute =
'executiontime';
+
+select id from executiontimes where cast(value as bigint) > 80000;
+rollback;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
