Changeset: 34f9a29bda02 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/34f9a29bda02
Modified Files:
geom/sql/conformance/Tests/T1.test
sql/backends/monet5/Tests/rapi05.test
sql/backends/monet5/generator/Tests/joins00.test
sql/backends/monet5/generator/Tests/joins01.test
sql/benchmarks/ATIS/Tests/one.test.in
sql/benchmarks/arno/Tests/one.test
sql/benchmarks/moa/Tests/one.test
sql/benchmarks/nobench/Tests/nobench.test
sql/benchmarks/ssbm/Tests/01-13.test
sql/benchmarks/ssbm/Tests/one.test.in
sql/benchmarks/tpcds/Tests/one.test.in
sql/benchmarks/tpch/Tests/one.test.in
sql/benchmarks/viam/Tests/viam.test
sql/test/2023/Tests/any_value.test
sql/test/ADT2006/Tests/benesamo.test
sql/test/ADT2006/Tests/bram.test
sql/test/ADT2006/Tests/slam.test
sql/test/ADT2006/Tests/woud.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-2.SF-921673.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/UNION_JOIN_vs_plain_set_UNION-2.SF-920585.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/not_null.SF-933194.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/simple_union.SF-1005596.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/type_dump_test.SF-989257.test
sql/test/BugDay_2005-11-09_2.8/Tests/ORDER_BY_evaluation_error.SF-1023658.test
sql/test/BugDay_2005-11-09_2.9.3/Tests/or_select.SF-1114540.test
sql/test/BugDay_2005-12-19_2.9.3/Tests/subselect_cardinality.SF-1240701.1242164.test
sql/test/BugTracker-2008/Tests/view_reply_incorrect.SF-2075097.test
sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.test
sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.test
sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.view1.test
sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.view2.test
sql/test/BugTracker-2009/Tests/order_by_column_position.test
sql/test/BugTracker-2009/Tests/order_by_column_position_rel_name_bug.test
sql/test/BugTracker-2009/Tests/orderby_with_row_number.SF-2895791.test
sql/test/BugTracker-2009/Tests/push_select_down_crash.test
sql/test/BugTracker-2009/Tests/subtraction_between_two_columns.SF-2582389.test
sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.test
sql/test/BugTracker-2010/Tests/between-timestamp.Bug-2718.test
sql/test/BugTracker-2010/Tests/crash_on_complex_join_exp.Bug-2353.test
sql/test/BugTracker-2010/Tests/distinct-order-by-limit.Bug-2691.test
sql/test/BugTracker-2010/Tests/join_problem.Bug-2694.test
sql/test/BugTracker-2010/Tests/multiple-common-table-expressions.Bug-2664.test
sql/test/BugTracker-2010/Tests/multiple-updates-in-transaction.Bug-2543.test
sql/test/BugTracker-2010/Tests/order_by_on_single_row_view.SF-2950453.test
sql/test/BugTracker-2010/Tests/orderby-limit.Bug-2634.test
sql/test/BugTracker-2010/Tests/rank-over-crash.SF-2926454.test
sql/test/BugTracker-2010/Tests/select-distinct-limit.Bug-2676.test
sql/test/BugTracker-2010/Tests/slow-query.Bug-2671.test
sql/test/BugTracker-2010/Tests/vacuum.test
sql/test/BugTracker-2010/Tests/with_row_number_crash.Bug-2631.test
sql/test/BugTracker-2011/Tests/bulk_rotate_xor_hash-error.Bug-2734.test
sql/test/BugTracker-2011/Tests/case-overflow.Bug-2239.test
sql/test/BugTracker-2011/Tests/cast-crash.Bug-2678.test
sql/test/BugTracker-2011/Tests/groupby_primary_key.Bug-2807.test
sql/test/BugTracker-2011/Tests/mclient-lsql-d.Bug-2861.test
sql/test/BugTracker-2011/Tests/missing_refine_reverse.Bug-2898.test
sql/test/BugTracker-2011/Tests/multiple-joins.Bug-2879.test
sql/test/BugTracker-2011/Tests/predicate.Bug-2908.test
sql/test/BugTracker-2011/Tests/sqltables.Bug-2921.test
sql/test/BugTracker-2012/Tests/correlated_groupby_in_selection.Bug-3011.test
sql/test/BugTracker-2012/Tests/inet-casts.Bug-3205.test
sql/test/BugTracker-2012/Tests/join_over_multitable_using_index.Bug-3181.test
sql/test/BugTracker-2012/Tests/leftjoin-Bug.3041.test
sql/test/BugTracker-2012/Tests/order_by_on_column_exp.Bug-3193.test
sql/test/BugTracker-2012/Tests/row_number_does_not_work_in_complex_query.Bug-2805.test
sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.test
sql/test/BugTracker-2012/Tests/set_operation.Bug-3059.test
sql/test/BugTracker-2012/Tests/with_and_exists.Bug-3099.test
sql/test/BugTracker-2013/Tests/case-orderby.Bug-3388.test
sql/test/BugTracker-2013/Tests/correlated_select.Bug-3250.test
sql/test/BugTracker-2013/Tests/hashed_exp.Bug-3313.test
sql/test/BugTracker-2013/Tests/numeric-column-alias.Bug-3279.test
sql/test/BugTracker-2013/Tests/numeric-column-orderby.Bug-3278.test
sql/test/BugTracker-2013/Tests/select-view-view.Bug-3245.test
sql/test/BugTracker-2014/Tests/aggr-with-limit.Bug-3498.test
sql/test/BugTracker-2014/Tests/orderby_column_exp.Bug-3620.test
sql/test/BugTracker-2014/Tests/orderby_count.Bug-3526.test
sql/test/BugTracker-2014/Tests/orderby_on_constant.Bug-3554.test
sql/test/BugTracker-2014/Tests/select-distinct-order-limit.Bug-3527.test
sql/test/BugTracker-2014/Tests/type_resolution.Bug-3622.test
sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.test
sql/test/BugTracker-2014/Tests/unsafe_project_push_down.Bug-3523.test
sql/test/BugTracker-2015/Tests/ambiguous.Bug-3803.test
sql/test/BugTracker-2015/Tests/assertHead.Bug-3706.test
sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.test
sql/test/BugTracker-2015/Tests/crash.Bug-3736.test
sql/test/BugTracker-2015/Tests/inet-ordering.Bug-3646.test
sql/test/BugTracker-2015/Tests/is_null_limit.Bug-3684.test
sql/test/BugTracker-2015/Tests/limit_dbl.Bug-3847.test
sql/test/BugTracker-2015/Tests/msqldump-merge-and-remote-tables.Bug-3774.test
sql/test/BugTracker-2015/Tests/project_rewrite.Bug-3693_2.test
sql/test/BugTracker-2015/Tests/ukey_check_unaligned.Bug-3669.test
sql/test/BugTracker-2016/Tests/CREATE_INDEX_breaks_table_queries.Bug-4053.test
sql/test/BugTracker-2016/Tests/DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920.test
sql/test/BugTracker-2016/Tests/cast_and_floor.Bug-6071.test
sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.test
sql/test/BugTracker-2016/Tests/column_name_lost_in_in_operator.Bug-6123.test
sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.test
sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.test
sql/test/BugTracker-2016/Tests/dce.Bug-6114.test
sql/test/BugTracker-2016/Tests/dce2.Bug-6115.test
sql/test/BugTracker-2016/Tests/groupby_on_column_expression.Bug-3832.test
sql/test/BugTracker-2016/Tests/isaUUID_function.Bug-3997.test
sql/test/BugTracker-2016/Tests/name_conflict_in_union.Bug-6065.test
sql/test/BugTracker-2016/Tests/projectionpath-prefix.Bug.test
sql/test/BugTracker-2016/Tests/semijoin.Bug-6116.test
sql/test/BugTracker-2016/Tests/split_project.Bug-6117.test
sql/test/BugTracker-2016/Tests/subcorr-missing.Bug-3978.test
sql/test/BugTracker-2017/Tests/case.Bug-6386.test
sql/test/BugTracker-2017/Tests/cast_boolean_to_string.Bug-6110.test
sql/test/BugTracker-2017/Tests/check_system_schema.Bug-6437.test
sql/test/BugTracker-2017/Tests/crash-in-topn.Bug-6478.test
sql/test/BugTracker-2017/Tests/crash-on-limit-rename.Bug-6502.test
sql/test/BugTracker-2017/Tests/crash_on_NULL_ptr.Bug-6130.test
sql/test/BugTracker-2017/Tests/create_view_order_by.Bug-3465.test
sql/test/BugTracker-2017/Tests/drop_system_schema.Bug-6437.test
sql/test/BugTracker-2017/Tests/extract_quarter_week_from_date.Bug-3831.test
sql/test/BugTracker-2017/Tests/null-quantile.Bug-6218.test
sql/test/BugTracker-2017/Tests/oidx-on-strings.Bug-6202.test
sql/test/BugTracker-2018/Tests/case_with_orderby_limit.Bug-6512.test
sql/test/BugTracker-2018/Tests/crash-orderby-alias.Bug-6527.test
sql/test/BugTracker-2018/Tests/groupby_having_orderby_count.Bug-6624.test
sql/test/BugTracker-2018/Tests/multi-column-hash-wrongly-NIL.Bug-6638.test
sql/test/BugTracker-2019/Tests/correlated-subquery-aggregation.Bug-6714.test
sql/test/BugTracker-2019/Tests/cte-union.Bug-6755.test
sql/test/BugTracker-2019/Tests/merge-table-limit.Bug-6756.test
sql/test/BugTracker-2019/Tests/next-get-value-bulk.Bug-6766.test
sql/test/BugTracker-2019/Tests/orderby-alias-expr.Bug-6799.test
sql/test/BugTracker-2019/Tests/rank-nan.Bug-6780.test
sql/test/BugTracker-2019/Tests/select_window_function_and_asterisk.Bug-6722.test
sql/test/BugTracker-2019/Tests/subselect.Bug-6688.test
sql/test/BugTracker-2019/Tests/subselect.Bug-6700.test
sql/test/BugTracker-2019/Tests/sum-over-hge.Bug.6738.test
sql/test/BugTracker-2020/Tests/cume-dist-wrong-results.Bug-6827.test
sql/test/BugTracker-2020/Tests/drop-stream-table.Bug-7005.test
sql/test/BugTracker-2020/Tests/ntile-wrong-results.Bug-6829.test
sql/test/BugTracker-2020/Tests/select-and.Bug-6878.test
sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.test
sql/test/BugTracker-2020/Tests/window-order-by-extract.Bug-6828.test
sql/test/BugTracker-2021/Tests/ntile-wrong-result.Bug-7104.test
sql/test/BugTracker-2021/Tests/plan-not-optimal-view.Bug-7140.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-2023/Tests/misc-crashes-7390.test
sql/test/BugTracker-2024/Tests/7563-is-distinct-from.test
sql/test/BugTracker-2024/Tests/7571-crash-orderby.test
sql/test/BugTracker-2024/Tests/7572-max-length-changes.test
sql/test/BugTracker/Tests/subquery_orderby.SF-1688915.test
sql/test/BugTracker/Tests/with_row_number.SF-1898089.test
sql/test/Dependencies/Tests/dependency_functions.test
sql/test/Dependencies/Tests/dependency_owner_schema_3.test
sql/test/LSST/Tests/dbQuery007.test
sql/test/SQLancer/Tests/sqlancer01.test
sql/test/SQLancer/Tests/sqlancer11.test
sql/test/SQLite_regress/sqllogictest/Tests/select3.test
sql/test/Tests/big-example.test
sql/test/Tests/count.test
sql/test/Tests/example.test
sql/test/Tests/keys.test
sql/test/Tests/limit_offset_fetchfirst.test
sql/test/Tests/marcin1.test
sql/test/Tests/marcin2.test
sql/test/Tests/median_stdev.test
sql/test/Tests/mediumint.test
sql/test/Tests/order_by_complex_exp.test
sql/test/Tests/order_by_simple_exp.test
sql/test/Tests/orderby_limit.test
sql/test/Tests/orderby_non_selection_column.test
sql/test/Tests/window_functions.test
sql/test/Users/Tests/create_user_options.test
sql/test/VOC/Tests/VOCmanual_examples.test
sql/test/VOC/Tests/VOCquery.test
sql/test/VOC/Tests/double_is_null.Bug-3116.test
sql/test/analytics/Tests/analytics00.test
sql/test/analytics/Tests/analytics01.test
sql/test/analytics/Tests/analytics02.test
sql/test/analytics/Tests/analytics03.test
sql/test/analytics/Tests/analytics04.test
sql/test/analytics/Tests/analytics05.test
sql/test/analytics/Tests/analytics07.test
sql/test/analytics/Tests/analytics08.test
sql/test/analytics/Tests/analytics09.test
sql/test/analytics/Tests/analytics10.test
sql/test/analytics/Tests/analytics11.test
sql/test/analytics/Tests/analytics12.test
sql/test/analytics/Tests/analytics13.test
sql/test/analytics/Tests/analytics14.test
sql/test/analytics/Tests/analytics15.test
sql/test/analytics/Tests/analytics17.test
sql/test/analytics/Tests/analytics18.test
sql/test/analytics/Tests/analytics19.test
sql/test/bugs/Tests/case_cast-bug-sf-1019506.test
sql/test/bugs/Tests/crash_order_by.test
sql/test/bugs/Tests/except-union-intersect-bug-sf-1146079.test
sql/test/bugs/Tests/groupby_having-bug-sf-947600.test
sql/test/bugs/Tests/innerjoin_between-bug-sf-960672.test
sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.test
sql/test/bugs/Tests/offset_bug.test
sql/test/bugs/Tests/or_in_crash.test
sql/test/bugs/Tests/order_disjunctive_bug.SF-1338309.test
sql/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.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/update_where-bug-sf-976963.test
sql/test/in-value-list/Tests/various-in-value-list-queries.test
sql/test/lateral/Tests/lateral.test
sql/test/merge-statements/Tests/mergestmt00.test
sql/test/mergetables/Tests/merge-tables-limitations.test
sql/test/miscellaneous/Tests/alter_table_add_column.test
sql/test/miscellaneous/Tests/groupby_error.test
sql/test/miscellaneous/Tests/groupby_expressions.test
sql/test/miscellaneous/Tests/groupings.test
sql/test/miscellaneous/Tests/simple_plans.test
sql/test/miscellaneous/Tests/simple_selects.test
sql/test/null/Tests/coalesce3.test
sql/test/orderidx/Tests/imprints_all_types.test
sql/test/orderidx/Tests/imprints_hge_type.test
sql/test/orderidx/Tests/oidx_all_types.test
sql/test/orderidx/Tests/oidx_hge_type.test
sql/test/pg_regress/Tests/boolean.test
sql/test/pg_regress/Tests/case.test
sql/test/pg_regress/Tests/horology.test
sql/test/pg_regress/Tests/interval.test
sql/test/pg_regress/Tests/limit.test
sql/test/pg_regress/Tests/numeric.test
sql/test/pg_regress/Tests/numerology.test
sql/test/pg_regress/Tests/point.test
sql/test/pg_regress/Tests/reltime.test
sql/test/pg_regress/Tests/select_views.test
sql/test/pg_regress/Tests/timestamptz.test
sql/test/pg_regress/Tests/timetz.test
sql/test/scripts/Tests/fsum.test
sql/test/scripts/Tests/fsum1.test
sql/test/sql_xml/Tests/load.test
sql/test/strings/Tests/batstr_contains.test
sql/test/strings/Tests/batstr_endswith.test
sql/test/subquery/Tests/subquery0.test
sql/test/subquery/Tests/subquery1.test
sql/test/sys-schema/Tests/webExamplesLogicalFunctionsOperators.test
sql/test/sysmon/Tests/sys_queue.test
sql/test/xquery/Tests/q01.test
Branch: Aug2024
Log Message:
If the query already has ORDER BY, we don't need to sort the results.
I.e. change rowsort into nosort for queries with ORDER BY.
diffs (truncated from 54663 to 300 lines):
diff --git a/geom/sql/conformance/Tests/T1.test
b/geom/sql/conformance/Tests/T1.test
--- a/geom/sql/conformance/Tests/T1.test
+++ b/geom/sql/conformance/Tests/T1.test
@@ -1,4 +1,4 @@
-query T rowsort
+query T nosort
SELECT f_table_name FROM geometry_columns ORDER BY f_table_name
----
bridges
diff --git a/sql/backends/monet5/Tests/rapi05.test
b/sql/backends/monet5/Tests/rapi05.test
--- a/sql/backends/monet5/Tests/rapi05.test
+++ b/sql/backends/monet5/Tests/rapi05.test
@@ -11,7 +11,7 @@ statement ok
CREATE FUNCTION kmeans(data float, ncluster integer) returns integer
language R {kmeans(data,ncluster)$cluster}
-query I rowsort
+query I nosort
SELECT cluster FROM (SELECT MIN(x) AS minx, MAX(x) AS maxx, kmeans(x,5) AS
cluster FROM xdata
GROUP BY cluster) as cdata ORDER BY cluster
----
diff --git a/sql/backends/monet5/generator/Tests/joins00.test
b/sql/backends/monet5/generator/Tests/joins00.test
--- a/sql/backends/monet5/generator/Tests/joins00.test
+++ b/sql/backends/monet5/generator/Tests/joins00.test
@@ -98,14 +98,14 @@ create table tmp(i tinyint)
statement ok
insert into tmp values(3),(4),(5)
-query I rowsort
+query I nosort
select * from tmp order by i
----
3
4
5
-query II rowsort
+query II nosort
select * from generate_series(9,0,-2) X, tmp Y where X.value = Y.i order by
X.value, Y.i
----
3
@@ -113,7 +113,7 @@ 3
5
5
-query II rowsort
+query II nosort
select * from generate_series(9,0,-2) X, tmp Y where Y.i = X.value order by
X.value, Y.i
----
3
@@ -121,13 +121,13 @@ 3
5
5
-query II rowsort
+query II nosort
select * from generate_series(9,0,-2) X, tmp Y where X.value = Y.i and value
<5 order by X.value, Y.i
----
3
3
-query II rowsort
+query II nosort
select * from generate_series(9,0,-2) as X, tmp Y where X.value = Y.i and
value <7 and value >3 order by X.value, Y.i
----
5
diff --git a/sql/backends/monet5/generator/Tests/joins01.test
b/sql/backends/monet5/generator/Tests/joins01.test
--- a/sql/backends/monet5/generator/Tests/joins01.test
+++ b/sql/backends/monet5/generator/Tests/joins01.test
@@ -7,14 +7,14 @@ insert into tmp values
(timestamp '2008-03-01 10:00'),
(timestamp '2008-03-01 20:00')
-query T rowsort
+query T nosort
select * from tmp order by i
----
2008-03-01 00:00:00
2008-03-01 10:00:00
2008-03-01 20:00:00
-query TT rowsort
+query TT nosort
select * from generate_series(timestamp '2008-03-01 00:00',timestamp
'2008-03-04 12:00',cast( '10' as interval hour)) X, tmp Y where X.value = Y.i
order by X.value, Y.i
----
2008-03-01 00:00:00
@@ -24,7 +24,7 @@ 2008-03-01 10:00:00
2008-03-01 20:00:00
2008-03-01 20:00:00
-query TT rowsort
+query TT nosort
select * from generate_series(timestamp '2008-03-01 00:00',timestamp
'2008-03-04 12:00',cast( '10' as interval hour)) X, tmp Y where Y.i = X.value
order by X.value, Y.i
----
2008-03-01 00:00:00
@@ -34,7 +34,7 @@ 2008-03-01 10:00:00
2008-03-01 20:00:00
2008-03-01 20:00:00
-query TT rowsort
+query TT nosort
select * from generate_series(timestamp '2008-03-01 00:00',timestamp
'2008-03-04 12:00',cast( '10' as interval hour)) X, tmp Y where X.value = Y.i
and value < timestamp '2008-03-01 20:00' order by X.value, Y.i
----
2008-03-01 00:00:00
@@ -42,7 +42,7 @@ 2008-03-01 00:00:00
2008-03-01 10:00:00
2008-03-01 10:00:00
-query TT rowsort
+query TT nosort
select * from generate_series(timestamp '2008-03-01 00:00',timestamp
'2008-03-04 12:00',cast( '10' as interval hour)) X, tmp Y where Y.i = X.value
and value < timestamp '2008-03-01 20:00' order by X.value, Y.i
----
2008-03-01 00:00:00
@@ -50,7 +50,7 @@ 2008-03-01 00:00:00
2008-03-01 10:00:00
2008-03-01 10:00:00
-query TT rowsort
+query TT nosort
select * from generate_series(timestamp '2008-03-01 00:00',timestamp
'2008-03-04 12:00',cast( '10' as interval hour)) as X, tmp Y where X.value =
Y.i and value < timestamp '2008-03-01 20:00' and value > timestamp '200-03-01
00:00' order by X.value, Y.i
----
2008-03-01 00:00:00
@@ -58,7 +58,7 @@ 2008-03-01 00:00:00
2008-03-01 10:00:00
2008-03-01 10:00:00
-query TT rowsort
+query TT nosort
select * from generate_series(timestamp '2008-03-01 00:00',timestamp
'2008-03-04 12:00',cast( '10' as interval hour)) as X, tmp Y where X.value =
Y.i and i < timestamp '2008-03-01 20:00' and i > timestamp '200-03-01 00:00'
order by X.value, Y.i
----
2008-03-01 00:00:00
@@ -66,7 +66,7 @@ 2008-03-01 00:00:00
2008-03-01 10:00:00
2008-03-01 10:00:00
-query T rowsort
+query T nosort
select * from generate_series(timestamp '2008-03-04 18:00',timestamp
'2008-03-01 00:00',cast( '-10' as interval hour)) X order by X.value
----
2008-03-01 10:00:00
@@ -79,7 +79,7 @@ 2008-03-03 22:00:00
2008-03-04 08:00:00
2008-03-04 18:00:00
-query TT rowsort
+query TT nosort
select * from generate_series(timestamp '2008-03-04 18:00',timestamp
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i
order by X.value, Y.i
----
2008-03-01 10:00:00
@@ -87,7 +87,7 @@ 2008-03-01 10:00:00
2008-03-01 20:00:00
2008-03-01 20:00:00
-query TT rowsort
+query TT nosort
select * from generate_series(timestamp '2008-03-04 18:00',timestamp
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where Y.i = X.value
order by X.value, Y.i
----
2008-03-01 10:00:00
@@ -95,26 +95,26 @@ 2008-03-01 10:00:00
2008-03-01 20:00:00
2008-03-01 20:00:00
-query TT rowsort
+query TT nosort
select * from generate_series(timestamp '2008-03-04 18:00',timestamp
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i
and value > timestamp '2008-03-01 11:00' order by X.value, Y.i
----
2008-03-01 20:00:00
2008-03-01 20:00:00
-query TT rowsort
+query TT nosort
select * from generate_series(timestamp '2008-03-04 18:00',timestamp
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i
and i > timestamp '2008-03-01 11:00' order by X.value, Y.i
----
2008-03-01 20:00:00
2008-03-01 20:00:00
-query T rowsort
+query T nosort
select * from generate_series(timestamp '2008-03-04 18:00',timestamp
'2008-03-01 00:00',cast( '-10' as interval hour)) X where value > timestamp
'2008-03-01 11:00' and value < timestamp '2008-03-01 21:00' order by X.value
----
2008-03-01 20:00:00
-query TT rowsort
+query TT nosort
select * from generate_series(timestamp '2008-03-04 18:00',timestamp
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i
and value > timestamp '2008-03-01 11:00'
and value < timestamp '2008-03-01 21:00' order by X.value, Y.i
@@ -122,7 +122,7 @@ and value < timestamp '2008-03-01 21:00'
2008-03-01 20:00:00
2008-03-01 20:00:00
-query TT rowsort
+query TT nosort
select * from generate_series(timestamp '2008-03-04 18:00',timestamp
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i
and i > timestamp '2008-03-01 11:00'
and i < timestamp '2008-03-01 21:00' order by X.value, Y.i
diff --git a/sql/benchmarks/ATIS/Tests/one.test.in
b/sql/benchmarks/ATIS/Tests/one.test.in
--- a/sql/benchmarks/ATIS/Tests/one.test.in
+++ b/sql/benchmarks/ATIS/Tests/one.test.in
@@ -179,7 +179,7 @@ ATLANTA
GEORGIA
MATL
-query TTT rowsort
+query TTT nosort
select city.city_name,state.state_name,city.city_code from state,city where
city.state_code=state.state_code order by city.city_name,state.state_name
----
ATLANTA
@@ -216,47 +216,47 @@ WASHINGTON
DISTRICT OF COLUMBIA
WWAS
-query TT rowsort
+query TT nosort
select month_name.month_name,day_name.day_name from month_name,day_name where
month_name.month_number=day_name.day_code order by month_name.month_number
----
-APRIL
-THURSDAY
-FEBRUARY
-TUESDAY
JANUARY
MONDAY
-JULY
-SUNDAY
+FEBRUARY
+TUESDAY
+MARCH
+WEDNESDAY
+APRIL
+THURSDAY
+MAY
+FRIDAY
JUNE
SATURDAY
-MARCH
-WEDNESDAY
-MAY
-FRIDAY
+JULY
+SUNDAY
-query TT rowsort
+query TT nosort
select month_name.month_name,day_name.day_name from month_name,day_name where
month_name.month_number=day_name.day_code and day_name.day_code >= 4 order by
month_name.month_number
----
APRIL
THURSDAY
-JULY
-SUNDAY
+MAY
+FRIDAY
JUNE
SATURDAY
-MAY
-FRIDAY
+JULY
+SUNDAY
-query IT rowsort
+query IT nosort
select flight.flight_code,aircraft.aircraft_type from flight,aircraft where
flight.aircraft_code=aircraft.aircraft_code order by flight.flight_code
----
1158 values hashing to 07d61913957a010682838ee6b1143e28
-query T rowsort
+query T nosort
select fare.fare_code from restrict_carrier,airline,fare where
restrict_carrier.airline_code=airline.airline_code and
fare.restrict_code=restrict_carrier.restrict_code order by fare.fare_code
----
5692 values hashing to 15f76b6565aff84c2ad9c6243b0b7532
-query T rowsort
+query T nosort
select distinct category from aircraft order by category
----
(empty)
@@ -266,7 +266,7 @@ JET
PROPELLER
TURBOPROP
-query T rowsort
+query T nosort
select distinct from_airport from flight order by from_airport
----
ATL
@@ -279,7 +279,7 @@ PHL
PIT
SFO
-query T rowsort
+query T nosort
select distinct aircraft_code from flight order by aircraft_code
----
100
@@ -310,17 +310,17 @@ select distinct * from fare
----
4272 values hashing to f56eaeef899632ebee916e30fa9350d4
-query I rowsort
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
