Changeset: b13975a8a194 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b13975a8a194 Modified Files: sql/backends/monet5/vaults/parquet/Tests/parquet_testing.test.in sql/backends/monet5/vaults/parquet/Tests/test_parquet_reader.test.in 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/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/groupby_with_NULL.SF-2155606.test sql/test/BugTracker-2009/Tests/TribooleanFailureWithSubquery.SF-2679434.test sql/test/BugTracker-2012/Tests/null_except_null.Bug-3040.test sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.test sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.test sql/test/BugTracker-2015/Tests/null.Bug-3833.test sql/test/BugTracker-2024/Tests/7480-get_rel_count.test sql/test/BugTracker-2024/Tests/7524-right-outer-join.test sql/test/BugTracker-2025/Tests/7763-exits-with-null.test sql/test/BugTracker-2026/Tests/7766-assertion-failure.test sql/test/BugTracker-2026/Tests/7775-assertion-failure.test sql/test/BugTracker-2026/Tests/7780-unnest-slow.test sql/test/BugTracker-2026/Tests/7792-assertion-failure.test sql/test/BugTracker-2026/Tests/7795-assertion-failure.test sql/test/BugTracker-2026/Tests/7818-out-of-bounds-analytics.test sql/test/BugTracker-2026/Tests/7826-crash-in-optimizer.test sql/test/BugTracker-2026/Tests/7834-BATsubcross-more-than-one-match.test sql/test/BugTracker-2026/Tests/7835-strcmp-NULL-crash.test sql/test/BugTracker-2026/Tests/7841-BATsubcross-more-than-one-match.test sql/test/BugTracker-2026/Tests/7869-rel_propagate_statistics-crash.test sql/test/BugTracker-2026/Tests/7923-sum-decimal-conversion-overflow-bug.test sql/test/BugTracker-2026/Tests/7950-exp_set_type-crash.test sql/test/BugTracker-2026/Tests/7955-rel_setop_get_statistics-crash.test sql/test/BugTracker-2026/Tests/7961-list_empty-crash.test sql/test/BugTracker-2026/Tests/7981-not-x-lt-x-bug.test sql/test/BugTracker-2026/Tests/7984-exists-select-count-bug.test sql/test/BugTracker-2026/Tests/7987-where-null-bug.test sql/test/BugTracker-2026/Tests/7991-group_concat-null-separator-bug.test sql/test/BugTracker-2026/Tests/8006-field-function-bug.test sql/test/BugTracker-2026/Tests/8018-rel2bin_select-assert-failure.test sql/test/BugTracker-2026/Tests/8027-having-expression-issue.test sql/test/SQLancer/Tests/sqlancer15.test sql/test/SQLancer/Tests/sqlancer19.test.in sql/test/Tests/blob_query.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/rel-optimizers/Tests/simplify_math_optimizations.test Branch: default Log Message:
Fix test output column types. Use I for integer-like values, R for floating point, D for decimal, T for the rest. diffs (truncated from 2910 to 300 lines): diff --git a/sql/backends/monet5/vaults/parquet/Tests/parquet_testing.test.in b/sql/backends/monet5/vaults/parquet/Tests/parquet_testing.test.in --- a/sql/backends/monet5/vaults/parquet/Tests/parquet_testing.test.in +++ b/sql/backends/monet5/vaults/parquet/Tests/parquet_testing.test.in @@ -1,146 +1,26 @@ query IIIIIIRRTTT nosort SELECT * FROM '$QTSTDATAPATH/parquet/parquet_testing/alltypes_dictionary.parquet' ---- -0 -1 -0 -0 -0 -0 -0.000 -0.000 -30312F30312F3039 -30 -2009-01-01 00:00:00 -1 -0 -1 -1 -1 -10 -1.100 -10.100 -30312F30312F3039 -31 -2009-01-01 00:01:00 +0 1 0 0 0 0 0.000 0.000 30312F30312F3039 30 2009-01-01 00:00:00 +1 0 1 1 1 10 1.100 10.100 30312F30312F3039 31 2009-01-01 00:01:00 query IIIIIIRRTTT nosort SELECT * FROM '$QTSTDATAPATH/parquet/parquet_testing/alltypes_plain.parquet' ---- -4 -1 -0 -0 -0 -0 -0.000 -0.000 -30332F30312F3039 -30 -2009-03-01 00:00:00 -5 -0 -1 -1 -1 -10 -1.100 -10.100 -30332F30312F3039 -31 -2009-03-01 00:01:00 -6 -1 -0 -0 -0 -0 -0.000 -0.000 -30342F30312F3039 -30 -2009-04-01 00:00:00 -7 -0 -1 -1 -1 -10 -1.100 -10.100 -30342F30312F3039 -31 -2009-04-01 00:01:00 -2 -1 -0 -0 -0 -0 -0.000 -0.000 -30322F30312F3039 -30 -2009-02-01 00:00:00 -3 -0 -1 -1 -1 -10 -1.100 -10.100 -30322F30312F3039 -31 -2009-02-01 00:01:00 -0 -1 -0 -0 -0 -0 -0.000 -0.000 -30312F30312F3039 -30 -2009-01-01 00:00:00 -1 -0 -1 -1 -1 -10 -1.100 -10.100 -30312F30312F3039 -31 -2009-01-01 00:01:00 +4 1 0 0 0 0 0.000 0.000 30332F30312F3039 30 2009-03-01 00:00:00 +5 0 1 1 1 10 1.100 10.100 30332F30312F3039 31 2009-03-01 00:01:00 +6 1 0 0 0 0 0.000 0.000 30342F30312F3039 30 2009-04-01 00:00:00 +7 0 1 1 1 10 1.100 10.100 30342F30312F3039 31 2009-04-01 00:01:00 +2 1 0 0 0 0 0.000 0.000 30322F30312F3039 30 2009-02-01 00:00:00 +3 0 1 1 1 10 1.100 10.100 30322F30312F3039 31 2009-02-01 00:01:00 +0 1 0 0 0 0 0.000 0.000 30312F30312F3039 30 2009-01-01 00:00:00 +1 0 1 1 1 10 1.100 10.100 30312F30312F3039 31 2009-01-01 00:01:00 query IIIIIIRRTTT nosort SELECT * FROM '$QTSTDATAPATH/parquet/parquet_testing/alltypes_plain.snappy.parquet' ---- -6 -1 -0 -0 -0 -0 -0.000 -0.000 -30342F30312F3039 -30 -2009-04-01 00:00:00 -7 -0 -1 -1 -1 -10 -1.100 -10.100 -30342F30312F3039 -31 -2009-04-01 00:01:00 +6 1 0 0 0 0 0.000 0.000 30342F30312F3039 30 2009-04-01 00:00:00 +7 0 1 1 1 10 1.100 10.100 30342F30312F3039 31 2009-04-01 00:01:00 query IIIIIIRRTTTII nosort SELECT * FROM '$QTSTDATAPATH/parquet/parquet_testing/alltypes_tiny_pages.parquet' @@ -171,78 +51,18 @@ SELECT * FROM '$QTSTDATAPATH/parquet/par query TTTTTT nosort SELECT * FROM '$QTSTDATAPATH/parquet/parquet_testing/binary_truncated_min_max.parquet' ---- -Blart Versenwald III -426C6172742056657273656E77616C6420494949 -Blart Versenwald III -426C6172742056657273656E77616C6420494949 -Blart Versenwald III -426C6172742056657273656E77616C6420494949 -Alice Johnson -416C696365204A6F686E736F6E -Alice Johnson -416C696365204A6F686E736F6E -Al -416C -Bob Smith -426F6220536D697468 -Bob Smith -426F6220536D697468 -Bob Smith -426F6220536D697468 -Charlie Brown -436861726C69652042726F776E -Charlie Brown -436861726C69652042726F776E -Charlie Brown -436861726C69652042726F776E -Diana Prince -4469616E61205072696E6365 -Diana Prince -4469616E61205072696E6365 -Diana Prince -4469616E61205072696E6365 -Edward Norton -456477617264204E6F72746F6E -Edward Norton -456477617264204E6F72746F6E -Edward Norton -456477617264204E6F72746F6E -Fiona Apple -46696F6E61204170706C65 -Fiona Apple -46696F6E61204170706C65 -Fiona Apple -46696F6E61204170706C65 -George Lucas -47656F726765204C75636173 -George Lucas -47656F726765204C75636173 -George Lucas -47656F726765204C75636173 -Helen Keller -48656C656E204B656C6C6572 -Helen Keller -48656C656E204B656C6C6572 -Helen Keller -48656C656E204B656C6C6572 -Ivan Drago -4976616E20447261676F -Ivan Drago -4976616E20447261676F -Ivan Drago -4976616E20447261676F -Julia Roberts -4A756C696120526F6265727473 -Julia Roberts -4A756C696120526F6265727473 -Julia Roberts -4A756C696120526F6265727473 -Kevin Bacon -4B6576696E204261636F6E -🚀Kevin Bacon -FFFF0102 -Ke -4B65 +Blart Versenwald III 426C6172742056657273656E77616C6420494949 Blart Versenwald III 426C6172742056657273656E77616C6420494949 Blart Versenwald III 426C6172742056657273656E77616C6420494949 +Alice Johnson 416C696365204A6F686E736F6E Alice Johnson 416C696365204A6F686E736F6E Al 416C +Bob Smith 426F6220536D697468 Bob Smith 426F6220536D697468 Bob Smith 426F6220536D697468 +Charlie Brown 436861726C69652042726F776E Charlie Brown 436861726C69652042726F776E Charlie Brown 436861726C69652042726F776E +Diana Prince 4469616E61205072696E6365 Diana Prince 4469616E61205072696E6365 Diana Prince 4469616E61205072696E6365 +Edward Norton 456477617264204E6F72746F6E Edward Norton 456477617264204E6F72746F6E Edward Norton 456477617264204E6F72746F6E +Fiona Apple 46696F6E61204170706C65 Fiona Apple 46696F6E61204170706C65 Fiona Apple 46696F6E61204170706C65 +George Lucas 47656F726765204C75636173 George Lucas 47656F726765204C75636173 George Lucas 47656F726765204C75636173 +Helen Keller 48656C656E204B656C6C6572 Helen Keller 48656C656E204B656C6C6572 Helen Keller 48656C656E204B656C6C6572 +Ivan Drago 4976616E20447261676F Ivan Drago 4976616E20447261676F Ivan Drago 4976616E20447261676F +Julia Roberts 4A756C696120526F6265727473 Julia Roberts 4A756C696120526F6265727473 Julia Roberts 4A756C696120526F6265727473 +Kevin Bacon 4B6576696E204261636F6E 🚀Kevin Bacon FFFF0102 Ke 4B65 query RR nosort SELECT * FROM '$QTSTDATAPATH/parquet/parquet_testing/byte_stream_split.zstd.parquet' @@ -252,33 +72,33 @@ SELECT * FROM '$QTSTDATAPATH/parquet/par statement error /no support for LOGICAL_TYPE_FLOAT16/ SELECT * FROM '$QTSTDATAPATH/parquet/parquet_testing/byte_stream_split_extended.gzip.parquet' -query R nosort +query D nosort SELECT * FROM '$QTSTDATAPATH/parquet/parquet_testing/byte_array_decimal.parquet' ---- -1.000 -2.000 -3.000 -4.000 -5.000 -6.000 -7.000 -8.000 -9.000 -10.000 -11.000 -12.000 -13.000 -14.000 -15.000 -16.000 -17.000 -18.000 -19.000 -20.000 -21.000 -22.000 -23.000 -24.000 +1.00 +2.00 +3.00 +4.00 +5.00 +6.00 +7.00 +8.00 +9.00 +10.00 +11.00 +12.00 +13.00 +14.00 +15.00 _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
