Changeset: 0650b0550ac1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/0650b0550ac1
Modified Files:
geom/sql/functions/Tests/geomcasts.test
sql/backends/monet5/UDF/capi/Tests/capi14.test
sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_04.test
sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_16.test
sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_17.test
sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_21.test
sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_28.test
sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_32.test
sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.test
sql/benchmarks/ATIS/Tests/one.test.in
sql/benchmarks/nobench/Tests/nobench.test.in
sql/benchmarks/ssbm/Tests/one.test.in
sql/benchmarks/tpcds/Tests/one.test.in
sql/benchmarks/tpch/Tests/one.test.in
sql/test/BugDay_2005-11-09_2.8/Tests/ORDER_BY_evaluation_error.SF-1023658.test
sql/test/BugTracker-2009/Tests/parallel_bulk-load.SF-2771052.test.test.in
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.test.in
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.test.in
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.test.in
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.test.in
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.test.in
sql/test/BugTracker-2012/Tests/url_script_test.Bug-2972.test.in
sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.test.in
sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.test.in
sql/test/BugTracker-2013/Tests/copy-into-compressed.Bug-3351.test.in
sql/test/BugTracker-2013/Tests/incorrect_subquery_delete.Bug-3315.test
sql/test/BugTracker-2013/Tests/segfault_in_aggregation.Bug-3225.test.in
sql/test/BugTracker-2013/Tests/select-around-zero.Bug-3220.test
sql/test/BugTracker-2014/Tests/groupby.Bug-3421.test
sql/test/BugTracker-2014/Tests/two-column-aggr-with-null.Bug-3428.test
sql/test/BugTracker-2015/Tests/inf-nan-handling.Bug-3696.test
sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.test
sql/test/BugTracker-2016/Tests/wrong-nonil-property-with-copy-binary-into.Bug-3937.test.in
sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.test
sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.test
sql/test/BugTracker-2017/Tests/crash_correlated_subqueries_not_in_select.Bug-6290.test
sql/test/BugTracker-2017/Tests/heapextend.Bug-6134.test.in
sql/test/BugTracker-2017/Tests/real-power.Bug-6228.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-cast-decimal.Bug-6445.test
sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.test
sql/test/BugTracker-2018/Tests/insert-null-second-interval-0.Bug-6515.test
sql/test/BugTracker-2018/Tests/sqlitelogictest-aritmetic-expressions-handling.Bug-6576.test
sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.test
sql/test/BugTracker-2021/Tests/WITH-alias-DELETE-1.deletes-wrong-tuples.Bug-7133.test
sql/test/BugTracker-2021/Tests/WITH-alias-DELETE-2.deletes-too-many-tuples.Bug-7133.test
sql/test/BugTracker-2021/Tests/aggregates-tables.Bug-7142.test
sql/test/BugTracker-2021/Tests/batappend-undefined.Bug-7130.test
sql/test/BugTracker-2021/Tests/batcalc-between-undefined.Bug-7129.test
sql/test/BugTracker-2021/Tests/conditional-execution-round.Bug-7125.test
sql/test/BugTracker-2021/Tests/count-distinct.Bug-7141.test
sql/test/BugTracker-2021/Tests/distinct-union.Bug-7148.test
sql/test/BugTracker-2021/Tests/lowercase-cryllic.Bug-7126.test
sql/test/BugTracker-2021/Tests/merge-delete.Bug-7136.test
sql/test/BugTracker-2021/Tests/merge-stmt.wrong-error.Bug-7109.test
sql/test/BugTracker-2021/Tests/merge-table-join.Bug-7172.test
sql/test/BugTracker-2021/Tests/ntile-wrong-result.Bug-7104.test
sql/test/BugTracker-2021/Tests/python-aggregates-empty.Bug-7158.test
sql/test/BugTracker-2021/Tests/python-aggregates-void-bat.Bug-7138.test
sql/test/BugTracker-2021/Tests/python-empty-arrays.Bug-7206.test
sql/test/BugTracker-2021/Tests/replace-transaction-conflict.Bug-7168.test
sql/test/BugTracker-2021/Tests/rollup-distinct-count.Bug-7146.test
sql/test/BugTracker-2021/Tests/subquery-missing.Bug-7128.test
sql/test/BugTracker-2021/Tests/sum-union.Bug-7147.test
sql/test/BugTracker-2021/Tests/type-upcasting-INT2BIGINT.Bug-7144.test
sql/test/BugTracker-2021/Tests/union-groupby.Bug-7108.test
sql/test/BugTracker-2021/Tests/unnest-union.Bug-7127.test
sql/test/Dependencies/Tests/dependency_functions.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-prologue.test
sql/test/SQLancer/Tests/sqlancer02.test
sql/test/SQLancer/Tests/sqlancer03.test
sql/test/SQLancer/Tests/sqlancer04.test
sql/test/SQLancer/Tests/sqlancer05.test
sql/test/SQLancer/Tests/sqlancer06.test
sql/test/SQLancer/Tests/sqlancer07.test
sql/test/SQLancer/Tests/sqlancer11.test
sql/test/SQLancer/Tests/sqlancer14.test
sql/test/SQLancer/Tests/sqlancer16.test
sql/test/SQLancer/Tests/sqlancer18.test
sql/test/Tests/bincopycollist.test.in
sql/test/Tests/copy-into-fwf.test.in
sql/test/Tests/copy_into.test.in
sql/test/Tests/rank.test
sql/test/Triggers/Tests/trigger_projection.test
sql/test/Via-m/Tests/file_s13.test
sql/test/Via-m/Tests/file_s17.test
sql/test/Via-m/Tests/media_s03.test
sql/test/Via-m/Tests/media_s05.test
sql/test/Via-m/Tests/media_s07.test
sql/test/Via-m/Tests/media_s09.test
sql/test/Via-m/Tests/media_s11.test
sql/test/Via-m/Tests/media_s13.test
sql/test/Via-m/Tests/media_s15.test
sql/test/Via-m/Tests/media_s17.test
sql/test/Via-m/Tests/media_s20.test
sql/test/analytics/Tests/analytics02.test
sql/test/bugs/Tests/savepoint-release.test
sql/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.test
sql/test/dict/Tests/dict01.test
sql/test/json/Tests/load_twitter_data.test.in
sql/test/merge-partitions/Tests/mergepart18.test
sql/test/merge-partitions/Tests/mergepart28.test.in
sql/test/merge-partitions/Tests/mergepart33.test
sql/test/mergetables/Tests/mergetabledependencies.test
sql/test/mergetables/Tests/multiple-merge-tables.test
sql/test/mergetables/Tests/replicas.test
sql/test/miscellaneous/Tests/analyze_test.test
sql/test/miscellaneous/Tests/declared_tables.test
sql/test/miscellaneous/Tests/groupby_expressions.test
sql/test/miscellaneous/Tests/sequences.test
sql/test/miscellaneous/Tests/simple_selects.test
sql/test/miscellaneous/Tests/vessels.test
sql/test/miscellaneous/Tests/view-mul-digits.test
sql/test/pg_regress/Tests/float4.test
sql/test/pg_regress/Tests/timetz.test
sql/test/sql_dump/Tests/dump.test
sql/test/subquery/Tests/all.test
sql/test/subquery/Tests/any.test
sql/test/subquery/Tests/any_all.test
sql/test/subquery/Tests/correlated.test
sql/test/subquery/Tests/exists.test
sql/test/subquery/Tests/scalar.test
sql/test/subquery/Tests/subquery2.test
sql/test/subquery/Tests/subquery3.test
sql/test/subquery/Tests/subquery4.test
sql/test/subquery/Tests/subquery5.test
sql/test/subquery/Tests/subquery6.test
sql/test/subquery/Tests/subquery7.test
sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.test
sql/test/sys-schema/Tests/check_Not_Nullable_columns.test
sql/test/sys-schema/Tests/check_PrimaryKey_uniqueness.test
sql/test/sys-schema/Tests/fkeys.test
sql/test/transactions/Tests/mergetable-deps-crash.test
sql/test/transactions/Tests/view-deps.test
Branch: Jan2022
Log Message:
Reapproved tests, using output of Mtest.py --approve.
diffs (truncated from 10891 to 300 lines):
diff --git a/geom/sql/functions/Tests/geomcasts.test
b/geom/sql/functions/Tests/geomcasts.test
--- a/geom/sql/functions/Tests/geomcasts.test
+++ b/geom/sql/functions/Tests/geomcasts.test
@@ -40,4 +40,3 @@ POINT (1 1)
POINT (2 2)
POINT (3 3)
-
diff --git a/sql/backends/monet5/UDF/capi/Tests/capi14.test
b/sql/backends/monet5/UDF/capi/Tests/capi14.test
--- a/sql/backends/monet5/UDF/capi/Tests/capi14.test
+++ b/sql/backends/monet5/UDF/capi/Tests/capi14.test
@@ -31,7 +31,7 @@ CREATE TABLE vals(i INTEGER, j REAL, k D
statement ok
INSERT INTO vals VALUES (1, NULL, 1), (NULL, 2, 2), (3, 3, NULL), (NULL, NULL,
NULL), (5, 5, 5)
-query ITRR rowsort
+query IRRR rowsort
SELECT i, j, k, capi14(i, j, k) FROM vals
----
1
@@ -39,15 +39,15 @@ NULL
1.000
1.000
3
-3.0
+3.000
NULL
5.000
5
-5.0
+5.000
5.000
15.000
NULL
-2.0
+2.000
2.000
3.000
NULL
diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_04.test
b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_04.test
--- a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_04.test
+++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_04.test
@@ -14,13 +14,13 @@ language P
return [True] * 4
}
-query T rowsort
+query I rowsort
SELECT pyapi04() FROM dval
----
-True
-True
-True
-True
+1
+1
+1
+1
statement ok
DROP FUNCTION pyapi04
diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_16.test
b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_16.test
--- a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_16.test
+++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_16.test
@@ -19,10 +19,10 @@ language P
return True
}
-query T rowsort
+query I rowsort
SELECT * FROM pyapi16( (SELECT * FROM vals) )
----
-True
+1
statement ok
DROP FUNCTION pyapi16
diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_17.test
b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_17.test
--- a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_17.test
+++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_17.test
@@ -13,13 +13,13 @@ language P
return retval
}
-query TTIT rowsort
+query TTII rowsort
SELECT * FROM pyapi17()
----
foo
bar
0
-True
+1
statement ok
DROP FUNCTION pyapi17
@@ -37,13 +37,13 @@ language P
return retval
}
-query TTIT rowsort
+query TTII rowsort
SELECT * FROM pyapi17()
----
foo
bar
0
-True
+1
statement ok
DROP FUNCTION pyapi17
diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_21.test
b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_21.test
--- a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_21.test
+++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_21.test
@@ -29,10 +29,10 @@ LANGUAGE P
statement ok
CREATE TABLE python_objects AS SELECT * FROM pyapi21_create() WITH DATA
-query T rowsort
+query I rowsort
SELECT pyapi21_load(s) FROM python_objects
----
-True
+1
statement ok
DROP FUNCTION pyapi21_create; DROP FUNCTION pyapi21_load; DROP TABLE
python_objects
diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_28.test
b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_28.test
--- a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_28.test
+++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_28.test
@@ -13,10 +13,10 @@ CREATE FUNCTION test_duplicates(s STRING
return True
}
-query T rowsort
+query I rowsort
SELECT test_duplicates(s) FROM duplicate_strings()
----
-True
+1
statement ok
ROLLBACK
diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_32.test
b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_32.test
--- a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_32.test
+++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_32.test
@@ -22,7 +22,106 @@ CREATE TABLE integers AS SELECT * FROM p
query I rowsort
SELECT pyapi32_function(i) FROM integers
----
-100 values hashing to c3672f1a3cbe048603a97455a52b9231
+0
+10
+100
+102
+104
+106
+108
+110
+112
+114
+116
+118
+12
+120
+122
+124
+126
+128
+130
+132
+134
+136
+138
+14
+140
+142
+144
+146
+148
+150
+152
+154
+156
+158
+16
+160
+162
+164
+166
+168
+170
+172
+174
+176
+178
+18
+180
+182
+184
+186
+188
+190
+192
+194
+196
+198
+2
+20
+22
+24
+26
+28
+30
+32
+34
+36
+38
+4
+40
+42
+44
+46
+48
+50
+52
+54
+56
+58
+6
+60
+62
+64
+66
+68
+70
+72
+74
+76
+78
+8
+80
+82
+84
+86
+88
+90
+92
+94
+96
+98
query I rowsort
SELECT pyapi32_function(i) FROM integers WHERE i > 50
@@ -80,7 +179,106 @@ 198
query I rowsort
SELECT pyapi32_function_mapped(i) FROM integers
----
-100 values hashing to c3672f1a3cbe048603a97455a52b9231
+0
+10
+100
+102
+104
+106
+108
+110
+112
+114
+116
+118
+12
+120
+122
+124
+126
+128
+130
+132
+134
+136
+138
+14
+140
+142
+144
+146
+148
+150
+152
+154
+156
+158
+16
+160
+162
+164
+166
+168
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
