Changeset: 799859bfffd7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=799859bfffd7
Added Files:
        sql/test/BugTracker-2018/Tests/ordered-index-error.Bug-6572.sql
        sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case.Bug-6573.sql
Modified Files:
        sql/test/BugTracker-2018/Tests/All
Branch: Mar2018
Log Message:

Added tests for bugs 6572 and 6573


diffs (38 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
@@ -45,3 +45,5 @@ sqlitelogictest-mal-calc-undefined.Bug-6
 sqlitelogictest-complex-case.Bug-6568
 sqlitelogictest-not-between-wrong.Bug-6569
 sqlitelogictest-undefined-calc.Bug-6570
+ordered-index-error.Bug-6572
+sqlitelogictest-complex-case.Bug-6573
diff --git a/sql/test/BugTracker-2018/Tests/ordered-index-error.Bug-6572.sql 
b/sql/test/BugTracker-2018/Tests/ordered-index-error.Bug-6572.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/ordered-index-error.Bug-6572.sql
@@ -0,0 +1,15 @@
+create table t1(v0 int, v1 char(1));
+insert into t1 values (1,'a'),(2,'b'),(3,'c');
+create ordered index index_t1_v1 on t1(v1);
+
+create table t2(v1 char(1));
+insert into t2 values ('a');
+
+create temp table t3 as
+(select t1.v0 from t1,t2 where trim(t2.v1)=t1.v1)
+on commit preserve rows;
+
+drop index index_t1_v1;
+drop table t1;
+drop table t2;
+drop table t3;
diff --git 
a/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case.Bug-6573.sql 
b/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case.Bug-6573.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case.Bug-6573.sql
@@ -0,0 +1,4 @@
+SELECT - ( 5 ) AS col1, + CASE WHEN NOT - 43 NOT IN ( + + 33 * 65, - 31 ) THEN 
NULL WHEN ( + ( - 41 ) ) IN
+( 73 * CASE + + 33 WHEN - 25 THEN - CAST ( NULL AS INTEGER ) ELSE NULL END ) 
THEN 64 WHEN NOT
+( + CAST ( + CASE + 52 WHEN COUNT ( * ) THEN NULL WHEN 51 THEN - 68 ELSE NULL 
END AS INTEGER ) ) = 50
+THEN NULL END * 11 + NULLIF ( ( - 3 ) + 51, 32 ) AS col1;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to