[prev in list] [next in list] [prev in thread] [next in thread] 

List:       monetdb-checkins
Subject:    MonetDB: Mar2018 - Adding a CAST (  AS INT) to the query such th...
From:       Martin van Dinther <commits+martin.van.dinther=monetdbsolutions.com () monetdb ! org>
Date:       2018-03-29 13:20:56
Message-ID: hg.23184cef7909.1522329656.6315528441665844383 () monetdb-vm0 ! spin-off ! cwi ! nl
[Download RAW message or body]

Changeset: 23184cef7909 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=23184cef7909
Modified Files:
	sql/test/BugTracker-2018/Tests/All
	sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.sql
	sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.stable.out
Branch: Mar2018
Log Message:

Adding a CAST (  AS INT) to the query such that the output becomes a bigint (instead \
of hugeint) and the test can run on all platforms


diffs (37 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
@@ -7,7 +7,7 @@ sqlitelogictest-select-range-null.Bug-65
 insert-null-second-interval-0.Bug-6515
 sqlitelogictest-bat-undefined.Bug-6516
 sqlitelogictest-overflow-in-conversion.Bug-6517
-HAVE_HGE?sqlitelogictest-count-not-in.Bug-6518
+sqlitelogictest-count-not-in.Bug-6518
 sqlitelogictest-algebra-join-not-in.Bug-6519
 update-with-correlated-subquery.Bug-6520
 sqlitelogictest-in-single-column.Bug-6522
diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.sql \
                b/sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.sql
                
--- a/sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.sql
+++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.sql
@@ -1,4 +1,4 @@
 CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER);
 INSERT INTO tab2 VALUES (64,77,40), (75,67,58), (46,51,23);
-SELECT DISTINCT - 15 * - 19 + - COUNT ( * ) * + 70 FROM tab2 WHERE ( col2 ) NOT IN ( \
+ 12 + col0 ); +SELECT DISTINCT - 15 * - 19 + - CAST( COUNT ( * ) AS INT) * + 70 FROM \
tab2 WHERE ( col2 ) NOT IN ( + 12 + col0 );  DROP TABLE tab2;
diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.stable.out \
                b/sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.stable.out
                
--- a/sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.stable.out
+++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.stable.out
@@ -27,10 +27,10 @@ Ready.
 #CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER);
 #INSERT INTO tab2 VALUES (64,77,40), (75,67,58), (46,51,23);
 [ 3	]
-#SELECT DISTINCT - 15 * - 19 + - COUNT ( * ) * + 70 FROM tab2 WHERE ( col2 ) NOT IN \
( + 12 + col0 ); +#SELECT DISTINCT - 15 * - 19 + - CAST( COUNT ( * ) AS INT) * + 70 \
FROM tab2 WHERE ( col2 ) NOT IN ( + 12 + col0 );  % sys.L10 # table_name
 % L10 # name
-% hugeint # type
+% bigint # type
 % 2 # length
 [ 75	]
 #DROP TABLE tab2;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list


[prev in list] [next in list] [prev in thread] [next in thread]