Changeset: 5bde60a2042e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5bde60a2042e
Modified Files:
sql/backends/monet5/generator/Tests/execute-privilege-for-public-hge.test
sql/backends/monet5/generator/Tests/execute-privilege-for-public.test
sql/test/2023/Tests/unique_nulls_distinct.test
sql/test/2024/Tests/check.test
sql/test/2024/Tests/distinct_from.test
sql/test/BugConstraints/Tests/check_constraints.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/simple_union.SF-1005596.test
sql/test/BugTracker-2010/Tests/alter-table-restart-crash.SF-2975018.test
sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.test
sql/test/BugTracker-2018/Tests/truncate_sys_tables.Bug-6543.test
sql/test/BugTracker-2019/Tests/cte-union.Bug-6755.test
sql/test/BugTracker-2023/Tests/aggregate-vararg.Bug-7422.test
sql/test/BugTracker-2023/Tests/interval-day-and-second.Bug-7353.test
sql/test/BugTracker-2024/Tests/7045-do-not-push-down-converts.test
sql/test/BugTracker-2024/Tests/7465-fwf-block-boundary-error.test.in
sql/test/BugTracker-2024/Tests/7511-password-hash-missing-error.test
sql/test/BugTracker-2024/Tests/7512-concurrent-globaltmp-instantiate-crash.test
sql/test/BugTracker-2024/Tests/7513-uri-authority-parse-issue.test
sql/test/BugTracker-2024/Tests/7514-wrong-window-function.test
sql/test/BugTracker-2024/Tests/7524-right-outer-join.test
sql/test/BugTracker-2024/Tests/7525-cudf-aggr-var-input.test
sql/test/BugTracker-2024/Tests/7534-is-distinct-from.test
sql/test/BugTracker-2024/Tests/7535-create-view-groupby-func.test
sql/test/BugTracker-2024/Tests/7537-prepare_stmt_with_dropped_table.test
sql/test/BugTracker-2024/Tests/7538-reduce-cast.test
sql/test/BugTracker-2024/Tests/7539-is-distinct-from.test
sql/test/BugTracker-2024/Tests/7542-column-name-resolution.test
sql/test/BugTracker-2024/Tests/7544-startswith-bug.test
sql/test/BugTracker-2024/Tests/7545-groupby_on_index_col.test
sql/test/BugTracker-2024/Tests/7547-drop-login-trigger-crash.test
sql/test/BugTracker-2024/Tests/7550-select-statistics-auth.test
sql/test/BugTracker-2024/Tests/7552-nested-expression-with-null.test
sql/test/BugTracker-2024/Tests/7553-join-on-startswith-crash.test
sql/test/BugTracker-2024/Tests/7554-incorrect-result-between.test
sql/test/BugTracker-2024/Tests/7555-incorrect-semijoin-rewrite.test
sql/test/BugTracker-2024/Tests/7556-missing-ignore-case.test
sql/test/BugTracker-2024/Tests/SQLunionfunc-Bug-7473.test
sql/test/BugTracker-2024/Tests/analyze-in-proc-func-trig-body-Bug-7500.test
sql/test/BugTracker-2024/Tests/atom_cmp-Bug-7477.test
sql/test/BugTracker-2024/Tests/between-true-and-null-Bug-7465.test
sql/test/BugTracker-2024/Tests/bin_find_smallest_column-Bug-7482.test
sql/test/BugTracker-2024/Tests/contains-or-7469.test
sql/test/BugTracker-2024/Tests/conversion-string-to-bte-failed-7470.test
sql/test/BugTracker-2024/Tests/exp_equal-Bug-7475.test
sql/test/BugTracker-2024/Tests/exp_equal-Bug-7478.test
sql/test/BugTracker-2024/Tests/field-arg-error-Bug-7506.test
sql/test/BugTracker-2024/Tests/get_rel_count-Bug-7480.test
sql/test/BugTracker-2024/Tests/groupby-select1-Bug-7472.test
sql/test/BugTracker-2024/Tests/inner-join-contains-7466.test
sql/test/BugTracker-2024/Tests/multicolumn_IN_value_list-Bug-7497.test
sql/test/BugTracker-2024/Tests/mvc_row_result_wrap-Bug-7481.test
sql/test/BugTracker-2024/Tests/orderby-max-over-rows-Bug-7488.test
sql/test/BugTracker-2024/Tests/rel2bin_join-Bug-7476.test
sql/test/BugTracker-2024/Tests/rel2bin_select-Bug-7496.test
sql/test/BugTracker-2024/Tests/rel_groupby_cse-Bug-7484.test
sql/test/BugTracker-2024/Tests/sql_init_subtype-Bug-7487.test
sql/test/SQLancer/Tests/sqlancer03.test
sql/test/SQLancer/Tests/sqlancer04.test
sql/test/Tests/regexp.test
sql/test/Tests/union-corresponding.test
sql/test/Users/Tests/copyinto.test.in
sql/test/Users/Tests/create_user_options.test
sql/test/bugs/Tests/default-error.test
sql/test/copy/Tests/decimal_separators.test
sql/test/copy/Tests/select-from-file.test.in
sql/test/file_loader/Tests/file_loader_field_separator.test.in
sql/test/mapi/Tests/clientinfo-nonadmin.test
sql/test/miscellaneous/Tests/group_by_all.test
sql/test/miscellaneous/Tests/simple_selects.test
sql/test/rel-optimizers/Tests/merge-unions.test
sql/test/remote/Tests/create-remote-flavors.test
sql/test/rename/Tests/rename01.test
sql/test/sets/Tests/union.test
sql/test/strimps/Tests/strimps_stable_counts_contains.test
sql/test/strings/Tests/batstr_contains.test
sql/test/strings/Tests/batstr_endswith.test
sql/test/strings/Tests/batstr_startswith.test
sql/test/strings/Tests/contains.test
sql/test/strings/Tests/contains_join.test
sql/test/strings/Tests/endswith_join.test
sql/test/strings/Tests/startswith.test
sql/test/strings/Tests/startswith_join.test
sql/test/subquery/Tests/correlated.test
sql/test/testdb/Tests/load.test
sql/test/transactions/Tests/insert_drop_crash.test
sql/test/transactions/Tests/rollback_and_schema-Bug-7499.test
sql/test/transactions/Tests/update_drop_crash.test
sql/test/transactions/Tests/update_drop_crash2.test
testing/sqllogictest.py
Branch: Aug2024
Log Message:
Cleanup tests.
diffs (truncated from 2545 to 300 lines):
diff --git
a/sql/backends/monet5/generator/Tests/execute-privilege-for-public-hge.test
b/sql/backends/monet5/generator/Tests/execute-privilege-for-public-hge.test
--- a/sql/backends/monet5/generator/Tests/execute-privilege-for-public-hge.test
+++ b/sql/backends/monet5/generator/Tests/execute-privilege-for-public-hge.test
@@ -3,21 +3,21 @@ statement ok
create user test with password 'test' name 'test'
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(cast(1 as hugeint),3)
----
1
2
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(1,cast(4 as hugeint),2)
----
1
3
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(5,1,cast(-2 as hugeint))
----
5
@@ -35,3 +35,4 @@ drop schema test
@connection(id=c1, username=monetdb, password=monetdb)
statement ok
drop user test
+
diff --git
a/sql/backends/monet5/generator/Tests/execute-privilege-for-public.test
b/sql/backends/monet5/generator/Tests/execute-privilege-for-public.test
--- a/sql/backends/monet5/generator/Tests/execute-privilege-for-public.test
+++ b/sql/backends/monet5/generator/Tests/execute-privilege-for-public.test
@@ -3,182 +3,182 @@ statement ok
create user test with password 'test' name 'test'
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(1,3)
----
1
2
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(1,4,2)
----
1
3
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(5,1,-2)
----
5
3
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(cast(1 as tinyint),3)
----
1
2
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(1,cast(4 as tinyint),2)
----
1
3
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(5,1,cast(-2 as tinyint))
----
5
3
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(cast(1 as smallint),3)
----
1
2
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(1,cast(4 as smallint),2)
----
1
3
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(5,1,cast(-2 as smallint))
----
5
3
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(cast(1 as int),3)
----
1
2
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(1,cast(4 as int),2)
----
1
3
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(5,1,cast(-2 as int))
----
5
3
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(cast(1 as bigint),3)
----
1
2
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(1,cast(4 as bigint),2)
----
1
3
@connection(id=c2, username=test, password=test)
-query I
+query I nosort
SELECT * from generate_series(5,1,cast(-2 as bigint))
----
5
3
@connection(id=c2, username=test, password=test)
-query R
+query R nosort
SELECT * from generate_series(cast(1 as real),3,1)
----
1.000
2.000
@connection(id=c2, username=test, password=test)
-query R
+query R nosort
SELECT * from generate_series(1,cast(4 as real),2)
----
1.000
3.000
@connection(id=c2, username=test, password=test)
-query R
+query R nosort
SELECT * from generate_series(5,1,cast(-2 as real))
----
5.000
3.000
@connection(id=c2, username=test, password=test)
-query R
+query R nosort
SELECT * from generate_series(cast(1 as double),3,1)
----
1.000
2.000
@connection(id=c2, username=test, password=test)
-query R
+query R nosort
SELECT * from generate_series(1,cast(4 as double),2)
----
1.000
3.000
@connection(id=c2, username=test, password=test)
-query R
+query R nosort
SELECT * from generate_series(5,1,cast(-2 as double))
----
5.000
3.000
@connection(id=c2, username=test, password=test)
-query R
+query R nosort
SELECT * from generate_series(cast(1 as decimal(9)),3,1)
----
1.000
2.000
@connection(id=c2, username=test, password=test)
-query R
+query R nosort
SELECT * from generate_series(1,cast(4 as decimal(9)),2)
----
1.000
3.000
@connection(id=c2, username=test, password=test)
-query R
+query R nosort
SELECT * from generate_series(5,1,cast(-2 as decimal(9)))
----
5.000
3.000
@connection(id=c2, username=test, password=test)
-query T
+query T nosort
SELECT * from generate_series(cast('2024-12-28' as date),cast('2024-12-31' as
date),cast('2' as interval day))
----
2024-12-28
2024-12-30
@connection(id=c2, username=test, password=test)
-query T
+query T nosort
SELECT * from generate_series(cast('2024-02-28' as date),cast('2024-12-31' as
date),cast('3' as interval month))
----
2024-02-28
@@ -186,14 +186,14 @@ 2024-05-28
2024-08-28
@connection(id=c2, username=test, password=test)
-query T
+query T nosort
SELECT * from generate_series(cast('2024-12-28' as
timestamp),cast('2024-12-31' as timestamp),cast('2' as interval day))
----
2024-12-28 00:00:00
2024-12-30 00:00:00
@connection(id=c2, username=test, password=test)
-query T
+query T nosort
SELECT * from generate_series(cast('2024-12-28' as timestamp),cast('2024-12-28
01:01:01' as timestamp),cast('1800' as interval second))
----
2024-12-28 00:00:00
@@ -212,3 +212,4 @@ drop schema test
@connection(id=c1, username=monetdb, password=monetdb)
statement ok
drop user test
+
diff --git a/sql/test/2023/Tests/unique_nulls_distinct.test
b/sql/test/2023/Tests/unique_nulls_distinct.test
--- a/sql/test/2023/Tests/unique_nulls_distinct.test
+++ b/sql/test/2023/Tests/unique_nulls_distinct.test
@@ -1,4 +1,3 @@
-
statement ok
CREATE TABLE und1 (i1 int, i2 int, UNIQUE (i1, i2))
@@ -121,3 +120,4 @@ INSERT INTO unnd2 VALUES (10), (20)
statement error
INSERT INTO unnd2 VALUES (30), (30)
+
diff --git a/sql/test/2024/Tests/check.test b/sql/test/2024/Tests/check.test
--- a/sql/test/2024/Tests/check.test
+++ b/sql/test/2024/Tests/check.test
@@ -59,3 +59,4 @@ insert into t3335 values(-1)
statement error
insert into t3335 values(3)
+
diff --git a/sql/test/2024/Tests/distinct_from.test
b/sql/test/2024/Tests/distinct_from.test
--- a/sql/test/2024/Tests/distinct_from.test
+++ b/sql/test/2024/Tests/distinct_from.test
@@ -108,24 +108,24 @@ 1
0
query I nosort
-select s FROM foo WHERE s IS DISTINCT FROM 20;
+select s FROM foo WHERE s IS DISTINCT FROM 20
----
10
NULL
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
