Changeset: 2ea27bde71d2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/2ea27bde71d2
Modified Files:
geom/sql/functions/Tests/ST_DWithin.test
geom/sql/functions/Tests/ST_DWithin2.test
geom/sql/functions/Tests/ST_DWithinRTree.test
geom/sql/functions/Tests/ST_Intersects.test
geom/sql/functions/Tests/ST_IntersectsRTree.test
geom/sql/functions/Tests/ST_MakeLine.test
geom/sql/functions/Tests/createRTreeIndex.test
geom/sql/functions/Tests/loadTestPolygons.test
monetdb5/modules/atoms/Tests/asciify.test
monetdb5/modules/atoms/Tests/contains.test
monetdb5/modules/atoms/Tests/endswith.test
monetdb5/modules/atoms/Tests/startswith.test
monetdb5/modules/atoms/Tests/ts_and_tstz_to_str_bug.test
monetdb5/modules/kernel/Tests/batstr_asciify.test
monetdb5/modules/kernel/Tests/batstr_contains.test
monetdb5/modules/kernel/Tests/batstr_endswith.test
monetdb5/modules/kernel/Tests/batstr_startswith.test
monetdb5/modules/mal/Tests/txtsim_jarowinkler.test
monetdb5/modules/mal/Tests/txtsim_levenshtein.test
sql/backends/monet5/UDF/capi/Tests/capi17.test
sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_19.test
sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_25.test
sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_27.test
sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_29.test
sql/backends/monet5/generator/Tests/generator01.test
sql/backends/monet5/generator/Tests/generator03.test
sql/backends/monet5/generator/Tests/generator04.test
sql/benchmarks/tpcds/Tests/one.test.in
sql/benchmarks/tpch/Tests/one.test.in
sql/test/2023/Tests/any_value.test
sql/test/2023/Tests/btrim.test
sql/test/2023/Tests/literals.test
sql/test/BugDay_2005-10-06_2.8/Tests/select_null.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/BATpropcheck_error.SF-1012739.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-1.SF-921673.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/jdbc_crashes_on_getTables.SF_944316.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/quoted_keywords.SF-922288.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/simple_union.SF-1005596.test
sql/test/BugTracker-2008/Tests/copy-format.SF-2468513.test
sql/test/BugTracker-2008/Tests/groupby_with_NULL.SF-2155606.test
sql/test/BugTracker-2008/Tests/subselect_with_or.SF-2466725.test
sql/test/BugTracker-2008/Tests/varchar.SF-2471371.test
sql/test/BugTracker-2009/Tests/TribooleanFailureWithSubquery.SF-2679434.test
sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.test
sql/test/BugTracker-2009/Tests/count_distinct_bug.SF-2826015.test
sql/test/BugTracker-2009/Tests/overflow.SF-2853458.test
sql/test/BugTracker-2010/Tests/concat_type_check_problem.Bug-2354.test
sql/test/BugTracker-2010/Tests/function_results_NULL.Bug-2626.test
sql/test/BugTracker-2010/Tests/huge_nr_of_columns.Bug-2609.test
sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.test
sql/test/BugTracker-2011/Tests/multicolumn_constraints.Bug-2849.test
sql/test/BugTracker-2011/Tests/rand-with-seed.Bug-2900.test
sql/test/BugTracker-2011/Tests/str_cast_exception.Bug-2847.test
sql/test/BugTracker-2012/Tests/boolean_coersion.Bug-3012.test
sql/test/BugTracker-2012/Tests/case_evaluated_too_early.Bug-3186.test
sql/test/BugTracker-2012/Tests/insert_into_table_with_2_foreignkeys.Bug-3124.test
sql/test/BugTracker-2012/Tests/null_except_null.Bug-3040.test
sql/test/BugTracker-2012/Tests/outerjoin_select.Bug-2946.test
sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.test
sql/test/BugTracker-2014/Tests/empty_intermediate_quantile.Bug-3611.test
sql/test/BugTracker-2014/Tests/indices.Bug-3435.test
sql/test/BugTracker-2014/Tests/stringfloatshtcompare.Bug-3512.test
sql/test/BugTracker-2014/Tests/varchar_conversion_crash.Bug-3506.test
sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.test
sql/test/BugTracker-2015/Tests/missed-error.Bug-3842.test
sql/test/BugTracker-2015/Tests/null.Bug-3833.test
sql/test/BugTracker-2015/Tests/null_is_null.Bug-3739.test
sql/test/BugTracker-2016/Tests/RELEASE_SAVEPOINT_after_ALTER_TABLE_crash.Bug-4010.test
sql/test/BugTracker-2016/Tests/column_name_lost_in_in_operator.Bug-6123.test
sql/test/BugTracker-2016/Tests/dce.Bug-6114.test
sql/test/BugTracker-2016/Tests/dce2.Bug-6115.test
sql/test/BugTracker-2016/Tests/update_crash.Bug-3954.test
sql/test/BugTracker-2018/Tests/grant-role-not-idempotent.Bug-6660.test
sql/test/BugTracker-2019/Tests/cte-union.Bug-6755.test
sql/test/BugTracker-2021/Tests/remote-table-rollback.Bug-7094.test
sql/test/BugTracker-2022/Tests/distinct-crash.Bug-7342.test
sql/test/BugTracker-2022/Tests/rerun-temp-table-index-crashes-server.Bug.test
sql/test/BugTracker-2022/Tests/rerun-temp-table-index-fails-to-restart-server.Bug.test
sql/test/BugTracker-2022/Tests/temp-table-index.Bug.test
sql/test/BugTracker-2022/Tests/values.Bug-7336.test
sql/test/BugTracker-2023/Tests/add-drop-column-crash-7381.test
sql/test/BugTracker-2023/Tests/alter-inc-seq-crash-7387.test
sql/test/BugTracker-2023/Tests/ambiguous-identifiers-7372.test
sql/test/BugTracker-2023/Tests/blob-crash-7380.test
sql/test/BugTracker-2023/Tests/corr-issue-7414.test
sql/test/BugTracker-2023/Tests/empty-optimizer-crash-7384.test
sql/test/BugTracker-2023/Tests/empty-result-aggr-crash-7274.test
sql/test/BugTracker-2023/Tests/greatest-least-multi-arg-7391.test
sql/test/BugTracker-2023/Tests/ifnull-6933.test
sql/test/BugTracker-2023/Tests/insert-delete-insert-crash-7415.test
sql/test/BugTracker-2023/Tests/misc-crashes-7390.test
sql/test/BugTracker-2023/Tests/newurl-issue-7417.test
sql/test/BugTracker-2023/Tests/orderby-debug-crash-7416.test
sql/test/BugTracker-2023/Tests/parse_interval-crash-7412.test
sql/test/BugTracker-2023/Tests/recursive-trigger-crash-7383.test
sql/test/BugTracker-2023/Tests/rel_order_by-assertion-7418.test
sql/test/BugTracker-2023/Tests/temp-on-savepoint-truncate-rollback-crash-7382.test
sql/test/BugTracker-2023/Tests/temp-table-foreign-key-crash-7378.test
sql/test/BugTracker-2023/Tests/union-query-7401.test
sql/test/BugTracker-2023/Tests/view-on-alias-crash-7386.test
sql/test/BugTracker-2024/Tests/add-partition-crash-7437.test
sql/test/BugTracker-2024/Tests/aggr-exp-copy-crash-7435.test
sql/test/BugTracker-2024/Tests/alloc-overflow-7432.test
sql/test/BugTracker-2024/Tests/bind-exps-crash-7438.test
sql/test/BugTracker-2024/Tests/count-unnest-crash-7436.test
sql/test/BugTracker-2024/Tests/create-index-query-issue-7430.test
sql/test/BugTracker-2024/Tests/exp-bin-crash-7434.test
sql/test/BugTracker-2024/Tests/exps-cards-crash-7439.test
sql/test/BugTracker-2024/Tests/function_return_issue.test
sql/test/BugTracker-2024/Tests/gc-col-crash-7440.test
sql/test/BugTracker-2024/Tests/greatest-as-colname-7444.test
sql/test/BugTracker-2024/Tests/inequality-hash-issue-7426.test
sql/test/BugTracker-2024/Tests/is-col-uniq-crash-7441.test
sql/test/BugTracker-2024/Tests/pkey-check-failed-7425.test
sql/test/BugTracker-2024/Tests/recursive-merge-table-crash-7443.test
sql/test/BugTracker-2024/Tests/rewrite-count-crash-7433.test
sql/test/BugTracker-2024/Tests/unaligned_mats-7442.test
sql/test/BugTracker-2024/Tests/where-between-issue-7428.test
sql/test/BugTracker-2024/Tests/where-case-null-issue-7429.test
sql/test/BugTracker-2024/Tests/where-cond-issue-7447.test
sql/test/BugTracker-2024/Tests/where-cond-issue-7448.test
sql/test/BugTracker/Tests/between_on_strings.SF-2021508.test
sql/test/BugTracker/Tests/between_with_column.SF-1959410.test
sql/test/BugTracker/Tests/full_join_crash.SF-1841754.test
sql/test/BugTracker/Tests/groupby_orderby_nonselected.SF-1723863.test
sql/test/BugTracker/Tests/variable_names.SF-1838816.test
sql/test/LSST/Tests/schema_3_1_88.test
sql/test/SQLancer/Tests/sqlancer10.test
sql/test/SQLancer/Tests/sqlancer11.test
sql/test/SQLancer/Tests/sqlancer13.test
sql/test/SQLancer/Tests/sqlancer15.test
sql/test/SQLancer/Tests/sqlancer16.test
sql/test/SQLancer/Tests/sqlancer19.test.in
sql/test/SQLancer/Tests/sqlancer20.test.in
sql/test/SQLancer/Tests/sqlancer24.test
sql/test/Skyserver/Tests/Skyserver_dropConstraints_v6.test
sql/test/Skyserver/Tests/Skyserver_dropFunctions.test
sql/test/Skyserver/Tests/Skyserver_dropFunctions_v6.test
sql/test/Skyserver/Tests/Skyserver_dropViews.test
sql/test/Skyserver/Tests/Skyserver_dropViews_v6.test
sql/test/Skyserver/Tests/Skyserver_functions.test
sql/test/Skyserver/Tests/Skyserver_functions_v6.test
sql/test/Skyserver/Tests/Skyserver_tables.test
sql/test/Skyserver/Tests/Skyserver_tables_v6.test
sql/test/Skyserver/Tests/Skyserver_views.test
sql/test/Skyserver/Tests/Skyserver_views_v6.test
sql/test/Tests/antiselect.test
sql/test/Tests/blob_query.test
sql/test/Tests/cast_str2num.test
sql/test/Tests/decimal2.test
sql/test/Tests/limit_offset_fetchfirst.test
sql/test/Tests/load_with_offset.test
sql/test/Tests/marcin2.test
sql/test/Tests/more_like_tests.test
sql/test/Tests/order_by_complex_exp.test
sql/test/Tests/order_by_simple_exp.test
sql/test/Tests/regexp.test
sql/test/Tests/select_window_pushdown.test
sql/test/Tests/zones.test
sql/test/Triggers/Tests/auth-triggers.test
sql/test/Users/Tests/create_user_options.test
sql/test/Users/Tests/user_default_role.test
sql/test/VOC/Tests/VOCmanual_examples.test
sql/test/VOC/Tests/VOCquery.test
sql/test/Via-m/Tests/event_s01.test
sql/test/Views/Tests/Views.test
sql/test/bincopy/Tests/bincopy_decimal_range.test.in
sql/test/bincopy/Tests/bincopy_string_width.test.in
sql/test/bugs/Tests/alter_drop_column_insert_crash.test
sql/test/bugs/Tests/case_substring.test
sql/test/bugs/Tests/copy_into_quote.test
sql/test/bugs/Tests/default_with_cast.SF-1334486.test
sql/test/bugs/Tests/delete-or-not-in-bug.test
sql/test/bugs/Tests/ifthenelse_bug.test
sql/test/bugs/Tests/rse_bug.test
sql/test/bugs/Tests/select_from_values.test
sql/test/bugs/Tests/select_not_equal.test
sql/test/bugs/Tests/subselect_multiple_unionall_where_1=1-bug-sf-1005596.test
sql/test/bugs/Tests/union_all-bug-sf-941788.test
sql/test/bugs/Tests/zero_or_one_bug.test
sql/test/copy/Tests/format_date.test
sql/test/file_loader/Tests/file_loader_field_separator.test.in
sql/test/file_loader/Tests/file_loader_function.test
sql/test/group-concat/Tests/groupconcat05.test
sql/test/information-schema/Tests/columns.test
sql/test/mergetables/Tests/merge-tables-limitations.test
sql/test/mergetables/Tests/mergetable-perms-base.test
sql/test/mergetables/Tests/mergetable-select-perms.test
sql/test/miscellaneous/Tests/simple_selects.test
sql/test/miscellaneous/Tests/special_character_names.test
sql/test/miscellaneous/Tests/sqlfuncnames.test
sql/test/miscellaneous/Tests/table_alias_on_cte.test
sql/test/null/Tests/coalesce.test
sql/test/null/Tests/coalesce2.test
sql/test/null/Tests/coalesce3.test
sql/test/odbc-escape-sequences/Tests/call-procedures.test
sql/test/odbc-escape-sequences/Tests/convert-func-hge.test
sql/test/odbc-escape-sequences/Tests/convert-functions.test
sql/test/odbc-escape-sequences/Tests/join.test
sql/test/odbc-escape-sequences/Tests/like-sequences.test
sql/test/odbc-escape-sequences/Tests/numeric-functions.test
sql/test/odbc-escape-sequences/Tests/string-functions.test
sql/test/odbc-escape-sequences/Tests/system-functions.test
sql/test/odbc-escape-sequences/Tests/time-date-interval-functions.test
sql/test/pg_regress/Tests/create_view.test
sql/test/pg_regress/Tests/float8.test
sql/test/pg_regress/Tests/inet.test
sql/test/pg_regress/Tests/interval.test
sql/test/pg_regress/Tests/point.test
sql/test/pg_regress/Tests/strings.test
sql/test/pg_regress/Tests/timestamp.test
sql/test/pg_regress/Tests/timestamptz.test
sql/test/pg_regress/Tests/without_oid.test
sql/test/prepare/Tests/named_placeholders.test
sql/test/rel-optimizers/Tests/groupjoin.test
sql/test/rel-optimizers/Tests/replicas-base.test
sql/test/strimps/Tests/small_string_crash.test
sql/test/strimps/Tests/strimps_stable_counts2.test
sql/test/strimps/Tests/strimps_with_nulls.test
sql/test/subquery/Tests/subquery9.test
sql/test/sys-schema/Tests/webExamplesComparisonFunctionsOperators.test
sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.test
sql/test/sys-schema/Tests/webExamplesStringFunctions.test
Branch: default
Log Message:
Reapprove (normalize/canonicalize) tests.
diffs (truncated from 16442 to 300 lines):
diff --git a/geom/sql/functions/Tests/ST_DWithin.test
b/geom/sql/functions/Tests/ST_DWithin.test
--- a/geom/sql/functions/Tests/ST_DWithin.test
+++ b/geom/sql/functions/Tests/ST_DWithin.test
@@ -48,7 +48,7 @@ SELECT
FROM geometries
WHERE
[ST_POINT(17.5,17.5)]
- ST_DWITHIN
+ ST_DWITHIN
[geom,2]
----
POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
@@ -61,7 +61,7 @@ SELECT
FROM geometries
WHERE
[ST_POINT(5,15)]
- ST_DWITHIN
+ ST_DWITHIN
[geom,3]
----
POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
@@ -73,7 +73,7 @@ SELECT
FROM geometries
WHERE
[ST_GEOMFROMTEXT('LINESTRING (0 0, 15 15)')]
- ST_DWITHIN
+ ST_DWITHIN
[geom,0]
----
POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
@@ -94,3 +94,4 @@ POLYGON ((0 20, 10 20, 20 20, 20 10, 0 2
POLYGON ((10 10, 20 10, 10 20, 10 10))
POLYGON ((10 10, 20 10, 20 20, 10 20, 10 10))
POLYGON ((10 20, 20 10, 20 20, 10 20))
+
diff --git a/geom/sql/functions/Tests/ST_DWithin2.test
b/geom/sql/functions/Tests/ST_DWithin2.test
--- a/geom/sql/functions/Tests/ST_DWithin2.test
+++ b/geom/sql/functions/Tests/ST_DWithin2.test
@@ -1,7 +1,7 @@
# TODO: Those test must be part of the ST_DWithin.test
# for gbox, hbox let us define
-# ambiguous_zone_min = dist(gbox, hbox) - diagonal(gbox)/2 - diagonal(hbox)/2
+# ambiguous_zone_min = dist(gbox, hbox) - diagonal(gbox)/2 - diagonal(hbox)/2
# ambiguous_zone_max = dist(gbox, hbox)
# for every distance d in the ST_DWithin (last arg) that falls in the
# zone we need to calculate the exact distance between for each
@@ -13,7 +13,7 @@
# - distance < ambiguous_zone_min expect false
# - dstance in ambiguous_zone AND distance > actual_distance expect true
# - distance > ambiguous_zone_max expect true
-query T rowsort
+query I rowsort
SELECT
ST_DWithin2(g, h, mbr(g), mbr(h), dist)
FROM (
@@ -23,16 +23,16 @@ FROM (
(ST_WKTToSQL('LINESTRING(1 1, 2 2)'), ST_WKTToSQL('LINESTRING(3 3, 4
4)'), 3)
) AS REL(g, h, dist)
----
-False
-True
-True
+0
+1
+1
# ambiguous_zone = [sqrt(2), 2 * sqrt(2)]
# actual_distance = 2 * sqrt(2)
# - distance < ambiguous_zone_min expect false
# - dstance in ambiguous_zone AND distance < actual_distance expect false
# - distance > ambiguous_zone_max expect true
-query T rowsort
+query I rowsort
SELECT
ST_DWithin2(g, h, mbr(g), mbr(h), dist)
FROM (
@@ -42,9 +42,9 @@ FROM (
(ST_WKTToSQL('LINESTRING(1 2, 2 1)'), ST_WKTToSQL('LINESTRING(3 4, 4
3)'), 3)
) AS REL(g, h, dist)
----
-False
-False
-True
+0
+0
+1
# the shapes are equilateral rhombuses
# ambiguous_zone = [sqrt(2), 2 * sqrt(2)]
@@ -53,7 +53,7 @@ True
# - distance in ambiguous_zone AND distance < actual_distance expect false
# - distance in ambiguous_zone AND distance > actual_distance expect true
# - distance > ambiguous_zone_max expect true
-query T rowsort
+query I rowsort
SELECT
ST_DWithin2(g, h, mbr(g), mbr(h), dist)
FROM (
@@ -80,8 +80,8 @@ FROM (
)
) AS REL(g, h, dist)
----
-False
-False
-True
-True
+0
+0
+1
+1
diff --git a/geom/sql/functions/Tests/ST_DWithinRTree.test
b/geom/sql/functions/Tests/ST_DWithinRTree.test
--- a/geom/sql/functions/Tests/ST_DWithinRTree.test
+++ b/geom/sql/functions/Tests/ST_DWithinRTree.test
@@ -48,7 +48,7 @@ SELECT
FROM geometries_rtree
WHERE
[ST_POINT(17.5,17.5)]
- ST_DWITHIN
+ ST_DWITHIN
[geom,2]
----
POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
@@ -61,7 +61,7 @@ SELECT
FROM geometries_rtree
WHERE
[ST_POINT(5,15)]
- ST_DWITHIN
+ ST_DWITHIN
[geom,3]
----
POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
@@ -73,7 +73,7 @@ SELECT
FROM geometries_rtree
WHERE
[ST_GEOMFROMTEXT('LINESTRING (0 0, 15 15)')]
- ST_DWITHIN
+ ST_DWITHIN
[geom,0]
----
POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
diff --git a/geom/sql/functions/Tests/ST_Intersects.test
b/geom/sql/functions/Tests/ST_Intersects.test
--- a/geom/sql/functions/Tests/ST_Intersects.test
+++ b/geom/sql/functions/Tests/ST_Intersects.test
@@ -7,7 +7,7 @@ SELECT
FROM geometries
WHERE
[ST_POINT(10,10)]
- ST_INTERSECTS
+ ST_INTERSECTS
[geom]
----
POLYGON ((10 10, 20 10, 10 20, 10 10))
@@ -19,7 +19,7 @@ SELECT
FROM geometries
WHERE
[ST_POINT(15,10)]
- ST_INTERSECTS
+ ST_INTERSECTS
[geom]
----
POLYGON ((10 10, 20 10, 10 20, 10 10))
@@ -31,7 +31,7 @@ SELECT
FROM geometries
WHERE
[ST_POINT(15,15)]
- ST_INTERSECTS
+ ST_INTERSECTS
[geom]
----
POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
@@ -45,7 +45,7 @@ SELECT
FROM geometries
WHERE
[ST_POINT(17.5,17.5)]
- ST_INTERSECTS
+ ST_INTERSECTS
[geom]
----
POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
@@ -58,11 +58,10 @@ SELECT
FROM geometries
WHERE
[ST_POINT(5,15)]
- ST_INTERSECTS
+ ST_INTERSECTS
[geom]
----
-
## Line - Polygon
query T rowsort
SELECT
@@ -70,7 +69,7 @@ SELECT
FROM geometries
WHERE
[ST_GEOMFROMTEXT('LINESTRING (0 0, 15 15)')]
- ST_INTERSECTS
+ ST_INTERSECTS
[geom]
----
POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
diff --git a/geom/sql/functions/Tests/ST_IntersectsRTree.test
b/geom/sql/functions/Tests/ST_IntersectsRTree.test
--- a/geom/sql/functions/Tests/ST_IntersectsRTree.test
+++ b/geom/sql/functions/Tests/ST_IntersectsRTree.test
@@ -7,7 +7,7 @@ SELECT
FROM geometries_rtree
WHERE
[ST_POINT(10,10)]
- ST_INTERSECTS
+ ST_INTERSECTS
[geom]
----
POLYGON ((10 10, 20 10, 10 20, 10 10))
@@ -19,7 +19,7 @@ SELECT
FROM geometries_rtree
WHERE
[ST_POINT(15,10)]
- ST_INTERSECTS
+ ST_INTERSECTS
[geom]
----
POLYGON ((10 10, 20 10, 10 20, 10 10))
@@ -31,7 +31,7 @@ SELECT
FROM geometries_rtree
WHERE
[ST_POINT(15,15)]
- ST_INTERSECTS
+ ST_INTERSECTS
[geom]
----
POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
@@ -45,7 +45,7 @@ SELECT
FROM geometries_rtree
WHERE
[ST_POINT(17.5,17.5)]
- ST_INTERSECTS
+ ST_INTERSECTS
[geom]
----
POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
@@ -58,11 +58,10 @@ SELECT
FROM geometries_rtree
WHERE
[ST_POINT(5,15)]
- ST_INTERSECTS
+ ST_INTERSECTS
[geom]
----
-
## Line - Polygon
query T rowsort
SELECT
@@ -70,7 +69,7 @@ SELECT
FROM geometries_rtree
WHERE
[ST_GEOMFROMTEXT('LINESTRING (0 0, 15 15)')]
- ST_INTERSECTS
+ ST_INTERSECTS
[geom]
----
POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
diff --git a/geom/sql/functions/Tests/ST_MakeLine.test
b/geom/sql/functions/Tests/ST_MakeLine.test
--- a/geom/sql/functions/Tests/ST_MakeLine.test
+++ b/geom/sql/functions/Tests/ST_MakeLine.test
@@ -44,3 +44,4 @@ FROM (
----
LINESTRING (0 0, 10 10)
LINESTRING (20 20, 5 5)
+
diff --git a/geom/sql/functions/Tests/createRTreeIndex.test
b/geom/sql/functions/Tests/createRTreeIndex.test
--- a/geom/sql/functions/Tests/createRTreeIndex.test
+++ b/geom/sql/functions/Tests/createRTreeIndex.test
@@ -15,3 +15,4 @@ INSERT INTO geometries_rtree (geom) VALU
statement ok
SELECT mbr(geom) FROM geometries_rtree
+
diff --git a/geom/sql/functions/Tests/loadTestPolygons.test
b/geom/sql/functions/Tests/loadTestPolygons.test
--- a/geom/sql/functions/Tests/loadTestPolygons.test
+++ b/geom/sql/functions/Tests/loadTestPolygons.test
@@ -12,3 +12,4 @@ INSERT INTO geometries (geom) VALUES (ST
statement ok
INSERT INTO geometries (geom) VALUES (ST_WKTToSQL('POLYGON((0 20, 10 20, 20
20, 20 10, 0 20))'))
+
diff --git a/monetdb5/modules/atoms/Tests/asciify.test
b/monetdb5/modules/atoms/Tests/asciify.test
--- a/monetdb5/modules/atoms/Tests/asciify.test
+++ b/monetdb5/modules/atoms/Tests/asciify.test
@@ -1,47 +1,48 @@
onlyif system=Linux
-query T
-select asciify('Olá Mundo!');
+query T nosort
+select asciify('Olá Mundo!')
----
Ola Mundo!
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
