Changeset: dede692aec19 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dede692aec19
Added Files:
sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-not-in.Bug-6594.sql
sql/test/BugTracker-2018/Tests/temp-table-performance.Bug-6577.sql
Modified Files:
sql/test/BugTracker-2018/Tests/All
Branch: Mar2018
Log Message:
Added tests for bugs 6577 and 6594
diffs (48 lines):
diff --git a/sql/test/BugTracker-2018/Tests/All
b/sql/test/BugTracker-2018/Tests/All
--- a/sql/test/BugTracker-2018/Tests/All
+++ b/sql/test/BugTracker-2018/Tests/All
@@ -49,7 +49,9 @@ ordered-index-error.Bug-6572
sqlitelogictest-complex-case.Bug-6573
create-temp-table-ordered-index-error.Bug-6574
sqlitelogictest-aritmetic-expressions-handling.Bug-6576
+HAVE_LIBPY?temp-table-performance.Bug-6577
multiple-insertinto-table-Bug-6578
concat-str-int.Bug-6583
nested-merge-tables.Bug-6585
sqlitelogictest-complex-expression.Bug-6589
+sqlitelogictest-complex-case-not-in.Bug-6594
diff --git
a/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-not-in.Bug-6594.sql
b/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-not-in.Bug-6594.sql
new file mode 100644
--- /dev/null
+++
b/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-not-in.Bug-6594.sql
@@ -0,0 +1,3 @@
+SELECT ALL + 62 * + - ( CASE WHEN NULL NOT IN ( CAST ( CAST ( - 77 AS INTEGER
) AS INTEGER ) )
+THEN NULL WHEN ( NULL ) NOT IN ( 94 * COUNT ( * ) ) THEN + ( NULLIF ( 45, 80 +
90 ) ) - COUNT ( * )
+ELSE NULL END ) AS col2;
diff --git a/sql/test/BugTracker-2018/Tests/temp-table-performance.Bug-6577.sql
b/sql/test/BugTracker-2018/Tests/temp-table-performance.Bug-6577.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/temp-table-performance.Bug-6577.sql
@@ -0,0 +1,22 @@
+create or replace function test1() RETURNS TABLE (v0 INT, v1 INT)
+LANGUAGE PYTHON {
+ import numpy as np
+ nrows=100000000
+ i_var=np.random.randint(1,10000000, (100000000,))
+ return [[i for i in range(nrows)],i_var]
+};
+
+create table t1 as (select * from test1()) with data;
+create table t2 as (select distinct v1 from t1) with data;
+
+select count(t1.v1) from t1, t2 where t1.v1=t2.v1;
+
+create temp table t3 as (select count(t1.v1) from t1, t2 where t1.v1=t2.v1) on
commit preserve rows;
+drop table t3;
+
+create temp table t3 as (select t1.v1 from t1, t2 where t1.v1=t2.v1) on commit
preserve rows;
+drop table t3;
+
+drop function test1;
+drop table t1;
+drop table t2;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
