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

List:       monetdb-checkins
Subject:    MonetDB: default - Query with wrong results. Looking into it
From:       Pedro_Ferreira <commits+pedro.ferreira=monetdbsolutions.com () mon
Date:       2022-01-28 15:04:11
Message-ID: hg.23ce90a76cee.1643382251.130486291912221634 () dev ! monetdb ! org
[Download RAW message or body]

Changeset: 23ce90a76cee for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/23ce90a76cee
Modified Files:
	sql/test/SQLancer/Tests/sqlancer22.test
Branch: default
Log Message:

Query with wrong results. Looking into it


diffs (36 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer22.test \
                b/sql/test/SQLancer/Tests/sqlancer22.test
--- a/sql/test/SQLancer/Tests/sqlancer22.test
+++ b/sql/test/SQLancer/Tests/sqlancer22.test
@@ -113,3 +113,32 @@ update rt2v2 set c0 = (select rt2v2.c0 f
 
 statement ok
 ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+create table t0 (c0 int)
+
+statement ok
+create or replace view vx(vc0, vc1, vc2) as (values (1,0,2))
+
+query I nosort
+SELECT 1 FROM (values (0)) vx(vc1) WHERE 1 > ALL(SELECT vx.vc1 FROM t0)
+----
+1
+
+query I nosort
+SELECT vx.vc2 FROM vx JOIN (VALUES (1)) AS x(x) ON TRUE WHERE vx.vc0 >= ALL(SELECT \
t0.c0 FROM t0) AND 1 >= ALL(SELECT vx.vc1 FROM t0) +----
+2
+
+# this one is right
+query I nosort
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(vx.vc0 >= ALL(SELECT t0.c0 FROM \
t0) AND 1 >= ALL(SELECT vx.vc1 FROM t0) AS INT) +as count FROM vx JOIN (VALUES (1)) \
AS x(x) ON TRUE) as res +----
+1
+
+statement ok
+ROLLBACK
_______________________________________________
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]