Changeset: 111e0929ee02 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/111e0929ee02
Modified Files:
sql/test/BugTracker-2015/Tests/reserved_keywords.Bug-3613.test
sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.test
sql/test/BugTracker-2025/Tests/7650_right_join_crash.test
sql/test/BugTracker-2025/Tests/7662-drop-role-user.test
sql/test/BugTracker-2025/Tests/7663-alter-user-role.test
sql/test/BugTracker-2025/Tests/7664-session-user.test
sql/test/BugTracker-2025/Tests/7666-temp-column-rename.test
sql/test/BugTracker-2025/Tests/7668-missing-key-dependency.test
sql/test/BugTracker-2025/Tests/7670-missing-table-compatibility-checks.test
sql/test/BugTracker-2025/Tests/7673-ud-aggregate-without-args-crash.test
sql/test/BugTracker-2025/Tests/7690-case_in_aggr.test
sql/test/BugTracker-2025/Tests/7691-slow-query-on-allways-false.test
sql/test/BugTracker-2025/Tests/7694-anti-join-and-filters.test
sql/test/BugTracker-2025/Tests/7695-antijoin-without-expressions.test
sql/test/BugTracker-2025/Tests/7696-antijoin-with-complex-expression.test
sql/test/BugTracker-2025/Tests/7697-exists-any-semantics.test
sql/test/BugTracker-2025/Tests/7698-get-statistics-problem.test
sql/test/BugTracker-2025/Tests/7699-create-user.test
sql/test/BugTracker-2025/Tests/7701-alter-user-max_workers.test
sql/test/BugTracker-2025/Tests/7702-stmt_convert_cands.test
sql/test/BugTracker-2025/Tests/7703-left-join.test
sql/test/BugTracker-2025/Tests/7705-anti-join.test
sql/test/BugTracker-2025/Tests/7706-set-user.test
sql/test/BugTracker-2025/Tests/7707-left-join.test
sql/test/BugTracker-2025/Tests/7708-inner-not-exists.test
sql/test/BugTracker-2025/Tests/7709-crash-on-field-subquery.test
sql/test/BugTracker-2025/Tests/7711-coalesc-crash.test
sql/test/BugTracker-2025/Tests/7712-cross-group.test
sql/test/BugTracker-2025/Tests/7713-crash-groupby-cse.test
sql/test/BugTracker-2025/Tests/7714-crash-in-window-with-subquery.test
sql/test/BugTracker-2025/Tests/7715-anti-like.test
sql/test/BugTracker-2025/Tests/7716-antijoin-not-exists-null.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.test
sql/test/Users/Tests/role.test
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/file_loader/Tests/file_loader_date_time.test.in
sql/test/miscellaneous/Tests/sequences.test
sql/test/remote/Tests/partition_elim.test
sql/test/sql_xml/Tests/cleanupfuncs.test
sql/test/subquery/Tests/subquery1.test
Branch: less_explain_info
Log Message:
Approve tests
diffs (truncated from 638 to 300 lines):
diff --git a/sql/test/BugTracker-2015/Tests/reserved_keywords.Bug-3613.test
b/sql/test/BugTracker-2015/Tests/reserved_keywords.Bug-3613.test
--- a/sql/test/BugTracker-2015/Tests/reserved_keywords.Bug-3613.test
+++ b/sql/test/BugTracker-2015/Tests/reserved_keywords.Bug-3613.test
@@ -91,3 +91,4 @@ 14
statement ok
drop table sql_keywords
+
diff --git
a/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.test
b/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.test
---
a/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.test
+++
b/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.test
@@ -6,7 +6,7 @@ CREATE TABLE sys.myfunctions ("id" INTEG
"schema_id" INTEGER,"system" BOOLEAN,"semantics" BOOLEAN)
statement ok
-insert into sys.myfunctions values( 10000000, 'test', 'func', 'mod', 0, 0,
false, false, false, 2000, true, false);
+insert into sys.myfunctions values( 10000000, 'test', 'func', 'mod', 0, 0,
false, false, false, 2000, true, false)
statement ok
CREATE VIEW sys.commented_function_signatures_6542 AS
diff --git a/sql/test/BugTracker-2025/Tests/7650_right_join_crash.test
b/sql/test/BugTracker-2025/Tests/7650_right_join_crash.test
--- a/sql/test/BugTracker-2025/Tests/7650_right_join_crash.test
+++ b/sql/test/BugTracker-2025/Tests/7650_right_join_crash.test
@@ -5,3 +5,4 @@ CREATE TABLE IF NOT EXISTS t1(c0 INTERVA
# sql correct result should be: NULL | NULL | 0
statement error GDK reported error: selectjoin: more than one match
SELECT ALL * FROM t1 RIGHT JOIN (VALUES (0)) AS subQuery1(col_1) ON ( t1.c0 <
ANY(VALUES (t1.c0+t1.c0)) ) AND (VALUES (subQuery1.col_1), (EXISTS (VALUES
(t1.c2))) )
+
diff --git a/sql/test/BugTracker-2025/Tests/7662-drop-role-user.test
b/sql/test/BugTracker-2025/Tests/7662-drop-role-user.test
--- a/sql/test/BugTracker-2025/Tests/7662-drop-role-user.test
+++ b/sql/test/BugTracker-2025/Tests/7662-drop-role-user.test
@@ -5,7 +5,7 @@ statement ok
CREATE USER alice WITH PASSWORD 'alice' NAME 'alice' SCHEMA sys
@connection(id=test, username=test, password=test)
-query T
+query T nosort
select CURRENT_ROLE
----
test
@@ -17,3 +17,4 @@ DROP ROLE alice
@connection(id=test)
statement error
DROP USER alice
+
diff --git a/sql/test/BugTracker-2025/Tests/7663-alter-user-role.test
b/sql/test/BugTracker-2025/Tests/7663-alter-user-role.test
--- a/sql/test/BugTracker-2025/Tests/7663-alter-user-role.test
+++ b/sql/test/BugTracker-2025/Tests/7663-alter-user-role.test
@@ -11,4 +11,5 @@ CREATE TABLE x (y INT)
@connection(id=test)
statement error M1M05!User has not been granted the role 'monetdb'
-ALTER USER test DEFAULT ROLE monetdb;
+ALTER USER test DEFAULT ROLE monetdb
+
diff --git a/sql/test/BugTracker-2025/Tests/7664-session-user.test
b/sql/test/BugTracker-2025/Tests/7664-session-user.test
--- a/sql/test/BugTracker-2025/Tests/7664-session-user.test
+++ b/sql/test/BugTracker-2025/Tests/7664-session-user.test
@@ -1,5 +1,5 @@
statement ok
-CREATE USER test WITH PASSWORD 'test' NAME 'test';
+CREATE USER test WITH PASSWORD 'test' NAME 'test'
@connection(id=test, username=test, password=test)
statement error M1M05!Insufficient privileges to change user 'monetdb'
@@ -7,8 +7,9 @@ ALTER USER monetdb MAX_WORKERS 10
@connection(id=test)
statement error HY009!Role (monetdb) missing
-SET SESSION AUTHORIZATION monetdb;
+SET SESSION AUTHORIZATION monetdb
@connection(id=test)
statement error M1M05!Insufficient privileges to change user 'monetdb'
-ALTER USER monetdb MAX_WORKERS 10;
+ALTER USER monetdb MAX_WORKERS 10
+
diff --git a/sql/test/BugTracker-2025/Tests/7666-temp-column-rename.test
b/sql/test/BugTracker-2025/Tests/7666-temp-column-rename.test
--- a/sql/test/BugTracker-2025/Tests/7666-temp-column-rename.test
+++ b/sql/test/BugTracker-2025/Tests/7666-temp-column-rename.test
@@ -3,3 +3,4 @@ CREATE GLOBAL TEMPORARY TABLE table1 (co
statement ok
ALTER TABLE table1 RENAME COLUMN column1 TO column2
+
diff --git a/sql/test/BugTracker-2025/Tests/7668-missing-key-dependency.test
b/sql/test/BugTracker-2025/Tests/7668-missing-key-dependency.test
--- a/sql/test/BugTracker-2025/Tests/7668-missing-key-dependency.test
+++ b/sql/test/BugTracker-2025/Tests/7668-missing-key-dependency.test
@@ -1,8 +1,9 @@
statement ok
-CREATE TABLE table1 (column1 INT, column2 INT, CONSTRAINT constraint1 UNIQUE
NULLS NOT DISTINCT (column1, column2));
+CREATE TABLE table1 (column1 INT, column2 INT, CONSTRAINT constraint1 UNIQUE
NULLS NOT DISTINCT (column1, column2))
statement ok
ALTER TABLE table1 DROP COLUMN column2 CASCADE
statement error 42000!ALTER TABLE: no such constraint 'constraint1'
ALTER TABLE table1 DROP CONSTRAINT constraint1 CASCADE
+
diff --git
a/sql/test/BugTracker-2025/Tests/7670-missing-table-compatibility-checks.test
b/sql/test/BugTracker-2025/Tests/7670-missing-table-compatibility-checks.test
---
a/sql/test/BugTracker-2025/Tests/7670-missing-table-compatibility-checks.test
+++
b/sql/test/BugTracker-2025/Tests/7670-missing-table-compatibility-checks.test
@@ -6,3 +6,4 @@ CREATE MERGE TABLE table2 (column3 INT,
statement error 3F000!ALTER LIST PARTITION TABLE: to be added table column
type doesn't match LIST PARTITION TABLE definition
ALTER TABLE table2 SET TABLE table1 AS PARTITION IN (4, 5, 6)
+
diff --git
a/sql/test/BugTracker-2025/Tests/7673-ud-aggregate-without-args-crash.test
b/sql/test/BugTracker-2025/Tests/7673-ud-aggregate-without-args-crash.test
--- a/sql/test/BugTracker-2025/Tests/7673-ud-aggregate-without-args-crash.test
+++ b/sql/test/BugTracker-2025/Tests/7673-ud-aggregate-without-args-crash.test
@@ -3,3 +3,4 @@ CREATE AGGREGATE function1() RETURNS big
statement error 42000!FUNCTION1: unable to perform 'function1(*)'
SELECT function1()
+
diff --git a/sql/test/BugTracker-2025/Tests/7690-case_in_aggr.test
b/sql/test/BugTracker-2025/Tests/7690-case_in_aggr.test
--- a/sql/test/BugTracker-2025/Tests/7690-case_in_aggr.test
+++ b/sql/test/BugTracker-2025/Tests/7690-case_in_aggr.test
@@ -4,10 +4,11 @@ create table test(doc_num string, doc_ty
statement ok
insert into test values('doc1', 'invoice', '1970-01-01'), ('doc1', 'invoice',
'1970-01-02'), ('doc2', 'order', '1970-01-01'), ('doc2', 'order', '1970-01-02')
-query TI
+query TR nosort
select doc_num, avg(case when doc_type = 'invoice' then epoch(inserted) else 0
end) from test group by doc_num
----
doc1
-36000
+36000.000
doc2
-0
+0.000
+
diff --git
a/sql/test/BugTracker-2025/Tests/7691-slow-query-on-allways-false.test
b/sql/test/BugTracker-2025/Tests/7691-slow-query-on-allways-false.test
--- a/sql/test/BugTracker-2025/Tests/7691-slow-query-on-allways-false.test
+++ b/sql/test/BugTracker-2025/Tests/7691-slow-query-on-allways-false.test
@@ -2,7 +2,7 @@ statement ok
create table test(value int, name string)
statement ok
-insert into test (select i, cast(i as string) from generate_series(0,
10000000) i(i)) ;
+insert into test (select i, cast(i as string) from generate_series(0,
10000000) i(i))
# optimize the base table away !
query T python .plan.filter
@@ -13,3 +13,4 @@ project (
| | [ int(31) NULL as "test"."value", varchar NULL as "test"."name" ]
| ) [ boolean(1) "false" ]
) [ "test"."value" NOT NULL UNIQUE, "test"."name" NOT NULL UNIQUE ]
+
diff --git a/sql/test/BugTracker-2025/Tests/7694-anti-join-and-filters.test
b/sql/test/BugTracker-2025/Tests/7694-anti-join-and-filters.test
--- a/sql/test/BugTracker-2025/Tests/7694-anti-join-and-filters.test
+++ b/sql/test/BugTracker-2025/Tests/7694-anti-join-and-filters.test
@@ -10,7 +10,8 @@ CREATE TABLE t1(c0 INT)
statement ok
INSERT INTO t1(c0) VALUES(0)
-query I
+query I nosort
SELECT * FROM t0 WHERE NOT EXISTS (SELECT 1 FROM t1 WHERE t1.c0 LIKE t0.c0)
----
60
+
diff --git
a/sql/test/BugTracker-2025/Tests/7695-antijoin-without-expressions.test
b/sql/test/BugTracker-2025/Tests/7695-antijoin-without-expressions.test
--- a/sql/test/BugTracker-2025/Tests/7695-antijoin-without-expressions.test
+++ b/sql/test/BugTracker-2025/Tests/7695-antijoin-without-expressions.test
@@ -4,6 +4,7 @@ CREATE TABLE t0(c0 INT)
statement ok
INSERT INTO t0(c0) VALUES(82)
-query I
+query I nosort
SELECT * FROM t0 WHERE NOT EXISTS (SELECT 1 FROM (VALUES (t0.c0)) WHERE TRUE)
----
+
diff --git
a/sql/test/BugTracker-2025/Tests/7696-antijoin-with-complex-expression.test
b/sql/test/BugTracker-2025/Tests/7696-antijoin-with-complex-expression.test
--- a/sql/test/BugTracker-2025/Tests/7696-antijoin-with-complex-expression.test
+++ b/sql/test/BugTracker-2025/Tests/7696-antijoin-with-complex-expression.test
@@ -4,8 +4,9 @@ CREATE TABLE t0(c0 INT, c1 INT)
statement ok
INSERT INTO t0(c0, c1) VALUES(-2, 1)
-query II
+query II nosort
SELECT * FROM t0 WHERE NOT EXISTS (SELECT 1 FROM (VALUES (t0.c1)) WHERE (NOT
(r'' NOT ILIKE r'')) AND FALSE)
----
-2
1
+
diff --git a/sql/test/BugTracker-2025/Tests/7697-exists-any-semantics.test
b/sql/test/BugTracker-2025/Tests/7697-exists-any-semantics.test
--- a/sql/test/BugTracker-2025/Tests/7697-exists-any-semantics.test
+++ b/sql/test/BugTracker-2025/Tests/7697-exists-any-semantics.test
@@ -4,7 +4,8 @@ CREATE TABLE t0(c0 INT)
statement ok
INSERT INTO t0(c0) VALUES(1)
-query I
+query I nosort
SELECT t0.c0 FROM t0 WHERE NOT EXISTS (SELECT 1 FROM (VALUES ((SELECT
t0.c0)!=NULL)) AS subQuery(c0) WHERE subQuery.c0)
----
1
+
diff --git a/sql/test/BugTracker-2025/Tests/7698-get-statistics-problem.test
b/sql/test/BugTracker-2025/Tests/7698-get-statistics-problem.test
--- a/sql/test/BugTracker-2025/Tests/7698-get-statistics-problem.test
+++ b/sql/test/BugTracker-2025/Tests/7698-get-statistics-problem.test
@@ -4,7 +4,7 @@ CREATE TABLE IF NOT EXISTS t0(c0 INT )
statement ok
INSERT INTO t0(c0) VALUES(1)
-query I
+query I nosort
SELECT t0.c0 FROM t0 RIGHT JOIN (SELECT DISTINCT (SELECT CASE WHEN TRUE THEN 1
END FROM t0 CROSS JOIN (SELECT 1 WHERE FALSE))) ON JSON.ISVALID((VALUES (TRUE)))
----
1
@@ -12,7 +12,8 @@ 1
statement ok
SET "sql_optimizer"='1'
-query I
+query I nosort
SELECT t0.c0 FROM t0 RIGHT JOIN (SELECT DISTINCT (SELECT CASE WHEN TRUE THEN 1
END FROM t0 CROSS JOIN (SELECT 1 WHERE FALSE))) ON JSON.ISVALID((VALUES (TRUE)))
----
1
+
diff --git a/sql/test/BugTracker-2025/Tests/7699-create-user.test
b/sql/test/BugTracker-2025/Tests/7699-create-user.test
--- a/sql/test/BugTracker-2025/Tests/7699-create-user.test
+++ b/sql/test/BugTracker-2025/Tests/7699-create-user.test
@@ -1,7 +1,7 @@
statement error
CREATE USER test WITH PASSWORD 'me' NAME 'tester' OPTIMIZER 'xyz'
-query TTITIITI
+query TTITIITI nosort
SELECT * FROM sys.users WHERE name = 'tester'
----
diff --git a/sql/test/BugTracker-2025/Tests/7701-alter-user-max_workers.test
b/sql/test/BugTracker-2025/Tests/7701-alter-user-max_workers.test
--- a/sql/test/BugTracker-2025/Tests/7701-alter-user-max_workers.test
+++ b/sql/test/BugTracker-2025/Tests/7701-alter-user-max_workers.test
@@ -4,7 +4,7 @@ ALTER USER monetdb MAX_WORKERS 0
statement ok
ALTER USER monetdb MAX_WORKERS 10
-query II
+query II nosort
SELECT "max_memory", "max_workers" FROM sys.users WHERE "name" = 'monetdb'
----
0
@@ -13,7 +13,7 @@ 10
statement ok
ALTER USER monetdb NO MAX_WORKERS
-query II
+query II nosort
SELECT "max_memory", "max_workers" FROM sys.users WHERE "name" = 'monetdb'
----
0
@@ -22,7 +22,7 @@ 0
statement ok
ALTER USER monetdb MAX_MEMORY 1234567 MAX_WORKERS 8
-query II
+query II nosort
SELECT "max_memory", "max_workers" FROM sys.users WHERE "name" = 'monetdb'
----
1234567
@@ -31,7 +31,7 @@ 8
statement ok
ALTER USER monetdb NO MAX_MEMORY NO MAX_WORKERS
-query II
+query II nosort
SELECT "max_memory", "max_workers" FROM sys.users WHERE "name" = 'monetdb'
----
0
@@ -40,7 +40,7 @@ 0
statement ok
ALTER USER monetdb MAX_MEMORY 1234568 MAX_WORKERS 2
-query II
+query II nosort
SELECT "max_memory", "max_workers" FROM sys.users WHERE "name" = 'monetdb'
----
1234568
@@ -49,7 +49,7 @@ 2
statement ok
ALTER USER monetdb NO MAX_MEMORY
-query II
+query II nosort
SELECT "max_memory", "max_workers" FROM sys.users WHERE "name" = 'monetdb'
----
0
@@ -58,7 +58,7 @@ 2
statement ok
ALTER USER monetdb NO MAX_WORKERS NO MAX_MEMORY
-query II
+query II nosort
SELECT "max_memory", "max_workers" FROM sys.users WHERE "name" = 'monetdb'
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
