Changeset: 5957cbb8c8ba for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5957cbb8c8ba
Added Files:
sql/test/BugTracker-2017/Tests/aggr_udf_with_more_than_2params.Bug-6385.test
sql/test/BugTracker-2017/Tests/all_minus_count_star.Bug-6297.test
sql/test/BugTracker-2017/Tests/avggroupbysq.Bug-6178.test
sql/test/BugTracker-2017/Tests/caching_stats_bug.6374.test
sql/test/BugTracker-2017/Tests/case.Bug-6386.test
sql/test/BugTracker-2017/Tests/cast-with-many-decimals.Bug-6195.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/cleanup_statistics.Bug-6439.test
sql/test/BugTracker-2017/Tests/coalesc-limit.Bug-6316.test
sql/test/BugTracker-2017/Tests/complicated_logic.Bug-105.test
sql/test/BugTracker-2017/Tests/copy_into_crash.Bug-6404.test
sql/test/BugTracker-2017/Tests/corr_coersion.Bug-6287.test
sql/test/BugTracker-2017/Tests/crash-dce.Bug-6330.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-select_after_MAL_error.Bug-6332.test
sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.test
sql/test/BugTracker-2017/Tests/crash_correlated_subqueries_in_select.Bug-6254.test
sql/test/BugTracker-2017/Tests/crash_correlated_subqueries_not_in_select.Bug-6290.test
sql/test/BugTracker-2017/Tests/crash_function_returning_sample.Bug-6291.test
sql/test/BugTracker-2017/Tests/crash_in_in_handling.Bug-6260.test
sql/test/BugTracker-2017/Tests/crash_in_null_cast.Bug-6186.test
sql/test/BugTracker-2017/Tests/crash_on_NULL_ptr.Bug-6130.test
sql/test/BugTracker-2017/Tests/crash_on_count_div_count.Bug-6201.test
sql/test/BugTracker-2017/Tests/create_table_as-missing_not_null.Bug-6329.test
sql/test/BugTracker-2017/Tests/create_view_order_by.Bug-3465.test
sql/test/BugTracker-2017/Tests/createorreplace-system-func.Bug-6499.test
sql/test/BugTracker-2017/Tests/date-arithmetic.Bug-6415.test
sql/test/BugTracker-2017/Tests/date_to_str.Bug-6467.test
sql/test/BugTracker-2017/Tests/dce_bug-6177.test
sql/test/BugTracker-2017/Tests/default-insert-update.Bug-6249.test
sql/test/BugTracker-2017/Tests/delete_from_merge_table.Bug-3743.test
sql/test/BugTracker-2017/Tests/distinct_minus_count_distinct.Bug-6296.test
sql/test/BugTracker-2017/Tests/double-groupby-column.Bug-6207.test
sql/test/BugTracker-2017/Tests/drop_not_null_on_pkey.Bug-6189.test
sql/test/BugTracker-2017/Tests/drop_schema_restrict.Bug-6438.test
sql/test/BugTracker-2017/Tests/drop_system_schema.Bug-6437.test
sql/test/BugTracker-2017/Tests/empty-interval.Bug-6184.test
sql/test/BugTracker-2017/Tests/error-clean-cache.Bug-6351.test
sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.test
sql/test/BugTracker-2017/Tests/exists.Bug-6392.test
sql/test/BugTracker-2017/Tests/extract_quarter_week_from_date.Bug-3831.test
sql/test/BugTracker-2017/Tests/fullouterjoinfilter.Bug-6256.test
sql/test/BugTracker-2017/Tests/function-resolution.Bug-6436.test
sql/test/BugTracker-2017/Tests/function_and_mergetable.Bug-6288.test
sql/test/BugTracker-2017/Tests/generate-resolution.Bug-6471.test
sql/test/BugTracker-2017/Tests/group-by-on-constant.Bug-6082.test
sql/test/BugTracker-2017/Tests/groupby_assertion.Bug-6338.test
sql/test/BugTracker-2017/Tests/handle-values-subqueries.Bug-6336.test
sql/test/BugTracker-2017/Tests/heapextend.Bug-6134.test.in
sql/test/BugTracker-2017/Tests/incorrect_error.Bug-6141.test
sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.test
sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.test
sql/test/BugTracker-2017/Tests/integer_addition_overflow.Bug-6205.test
sql/test/BugTracker-2017/Tests/lateral.Bug-6310.test
sql/test/BugTracker-2017/Tests/lateral02.Bug-6314.test
sql/test/BugTracker-2017/Tests/limit.Bug-6322.test
sql/test/BugTracker-2017/Tests/limit_clause.Bug-6312.test
sql/test/BugTracker-2017/Tests/modulo.Bug-6225.test
sql/test/BugTracker-2017/Tests/name-interference.Bug-6348.test
sql/test/BugTracker-2017/Tests/nested_with.Bug-6187.test
sql/test/BugTracker-2017/Tests/nestedoperators.Bug-6292.test
sql/test/BugTracker-2017/Tests/not_plus.Bug-6294.test
sql/test/BugTracker-2017/Tests/null-quantile.Bug-6218.test
sql/test/BugTracker-2017/Tests/null_matches_in_outer.Bug-6398.test
sql/test/BugTracker-2017/Tests/oidx-on-strings.Bug-6202.test
sql/test/BugTracker-2017/Tests/one-plus-nil.Bug-6243.test
sql/test/BugTracker-2017/Tests/parsererror.Bug-6381.test
sql/test/BugTracker-2017/Tests/prepare.Bug-6133.test
sql/test/BugTracker-2017/Tests/push_subslice.Bug-6322.test
sql/test/BugTracker-2017/Tests/python_loader_clobbers_default_with_null.Bug-6464.test
sql/test/BugTracker-2017/Tests/real-power.Bug-6228.test
sql/test/BugTracker-2017/Tests/rel2bin_project-assert.Bug-6080.test
sql/test/BugTracker-2017/Tests/round-or-truncate.Bug-6193.test
sql/test/BugTracker-2017/Tests/select-in-returns-null.Bug-6491.test
sql/test/BugTracker-2017/Tests/select.Bug-6259.test
sql/test/BugTracker-2017/Tests/semijoinunion.Bug-6150.test
sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.test
sql/test/BugTracker-2017/Tests/simplify_math.Bug-6324.test
sql/test/BugTracker-2017/Tests/skip_problem_best_effort.Bug-6442.test
sql/test/BugTracker-2017/Tests/splitpart.Bug-6194.test
sql/test/BugTracker-2017/Tests/spurious_error.Bug-6344.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-distinct-coalesce.Bug-6431.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-distinct.Bug-6411.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-having-avg.Bug-6428.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-not-in.Bug-6416.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-algebra-operators.Bug-6494.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-cast-decimal.Bug-6445.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-comparisons-between-floating-points-and-NULL.Bug-6496.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-having-with-in.Bug-6410.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-having-with-not-in.Bug-6409.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-hidden-alias.Bug-6495.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-min-distinct-empty-table.Bug-6493.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-not-between.Bug-6497.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-select-in-column.Bug-6490.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-select-in.Bug-6433.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-select-not-in.Bug-6435.test
sql/test/BugTracker-2017/Tests/sqllitelogistest_case.Bug-6335.test
sql/test/BugTracker-2017/Tests/sqlsmith-semijoin-constant.bug-6417.test
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6216.test
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6217.test
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6219.test
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6418.test
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6423.test
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6424.test
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6425.test
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6432.test
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6449.test
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6477.test
sql/test/BugTracker-2017/Tests/sqlsmith01.test
sql/test/BugTracker-2017/Tests/sqlsmith02.test
sql/test/BugTracker-2017/Tests/sqlsmith03.test
sql/test/BugTracker-2017/Tests/sqlsmith04.test
sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.test
sql/test/BugTracker-2017/Tests/str2decimal.Bug-6206.test
sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.test
sql/test/BugTracker-2017/Tests/too-large-decimals.Bug-6192.test
sql/test/BugTracker-2017/Tests/type-resolution-error.Bugs-6313.test
sql/test/BugTracker-2017/Tests/udf_crash_subquery_scalar_paramters.Bug-6399.test
sql/test/BugTracker-2017/Tests/union_func_crash.Bug-6196.test
sql/test/BugTracker-2017/Tests/unknown_col_in_order_by.Bug-3535.test
sql/test/BugTracker-2017/Tests/update_on_procedure.Bug-6479.test
sql/test/BugTracker-2017/Tests/with-alias-bug.6246.test
sql/test/BugTracker-2017/Tests/wrong_aggregation_count.Bug-6257.test
Modified Files:
sql/test/BugTracker-2017/Tests/null-quantile.Bug-6218.sql
Branch: mtest
Log Message:
sql/test/BugTracker-2017
diffs (truncated from 9610 to 300 lines):
diff --git
a/sql/test/BugTracker-2017/Tests/aggr_udf_with_more_than_2params.Bug-6385.test
b/sql/test/BugTracker-2017/Tests/aggr_udf_with_more_than_2params.Bug-6385.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugTracker-2017/Tests/aggr_udf_with_more_than_2params.Bug-6385.test
@@ -0,0 +1,74 @@
+statement ok
+CREATE AGGREGATE aggr2(val INTEGER, val2 INTEGER)
+RETURNS INTEGER
+LANGUAGE PYTHON {
+ unique = numpy.unique(aggr_group)
+ x = numpy.zeros(shape=(unique.size))
+ for i in range(0, unique.size):
+ x[i] = numpy.sum(val[aggr_group==unique[i]])
+ return(x)
+}
+
+statement ok
+CREATE AGGREGATE aggr3(val INTEGER, val2 INTEGER, val3 INTEGER)
+RETURNS DOUBLE
+LANGUAGE PYTHON {
+ unique = numpy.unique(aggr_group)
+ x = numpy.zeros(shape=(unique.size))
+ for i in range(0, unique.size):
+ x[i] = numpy.sum(val[aggr_group==unique[i]])
+ return(x)
+}
+
+statement ok
+CREATE AGGREGATE aggr4(val INTEGER, val2 INTEGER, val3 INTEGER, val4 INTEGER)
+RETURNS DOUBLE
+LANGUAGE PYTHON {
+ unique = numpy.unique(aggr_group)
+ x = numpy.zeros(shape=(unique.size))
+ for i in range(0, unique.size):
+ x[i] = numpy.sum(val[aggr_group==unique[i]])
+ return(x)
+}
+
+statement ok
+CREATE TABLE grouped_ints (value INTEGER, groupnr INTEGER, dbvalue double)
+
+statement ok
+INSERT INTO grouped_ints VALUES (1, 0, 0.11), (2, 1, 0.22), (3, 0, 0.33),
(4,1, 0.44), (5,0, 0.55)
+
+query IR rowsort
+SELECT groupnr, aggr3(value, value, value) FROM grouped_ints GROUP BY groupnr
+----
+0
+9.000
+1
+6.000
+
+query IR rowsort
+SELECT groupnr, aggr4(value, value, value, value) FROM grouped_ints GROUP BY
groupnr
+----
+0
+9.000
+1
+6.000
+
+statement error
+SELECT groupnr, aggr2(value) FROM grouped_ints GROUP BY groupnr
+
+statement error
+SELECT groupnr, aggr2(value, value, value) FROM grouped_ints GROUP BY groupnr
+
+statement ok
+DROP TABLE grouped_ints
+
+statement ok
+DROP AGGREGATE aggr2
+
+statement ok
+DROP AGGREGATE aggr3
+
+statement ok
+DROP AGGREGATE aggr4
+
+
diff --git a/sql/test/BugTracker-2017/Tests/all_minus_count_star.Bug-6297.test
b/sql/test/BugTracker-2017/Tests/all_minus_count_star.Bug-6297.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2017/Tests/all_minus_count_star.Bug-6297.test
@@ -0,0 +1,23 @@
+query I rowsort
+SELECT - 0 + - 12 * 2 - 0 AS col2
+----
+-24
+
+statement ok
+CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER)
+
+statement ok
+CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER)
+
+query I rowsort
+SELECT ALL - CAST(COUNT ( * ) AS INT) + - 12 * - CAST(COUNT ( * ) AS INT) AS
col2 FROM tab2, tab1 AS cor0
+----
+0
+
+statement ok
+DROP TABLE tab2
+
+statement ok
+DROP TABLE tab1
+
+
diff --git a/sql/test/BugTracker-2017/Tests/avggroupbysq.Bug-6178.test
b/sql/test/BugTracker-2017/Tests/avggroupbysq.Bug-6178.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2017/Tests/avggroupbysq.Bug-6178.test
@@ -0,0 +1,60 @@
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE x (tailnum STRING, arr_delay INTEGER)
+
+statement ok
+COPY 2 RECORDS INTO x FROM STDIN USING DELIMITERS ',',E'\n','"' NULL as ''
+<COPY_INTO_DATA>
+"N907MQ",
+"N907MQ",191
+
+query R rowsort
+-- correct result, 191
+SELECT AVG( arr_delay ) FROM x
+----
+191.000
+
+query TR rowsort
+-- wrong result, NULL
+SELECT tailnum , AVG( arr_delay ) FROM x GROUP BY tailnum
+----
+N907MQ
+191.000
+
+query TI rowsort
+-- works fine with MIN
+SELECT tailnum , MIN( arr_delay ) FROM x GROUP BY tailnum
+----
+N907MQ
+191
+
+query TR rowsort
+-- correct again
+SELECT tailnum , AVG( arr_delay ) FROM x WHERE tailnum = 'N907MQ' GROUP BY
tailnum
+----
+N907MQ
+191.000
+
+query TR rowsort
+-- wrong again
+SELECT * FROM ( SELECT tailnum , AVG( arr_delay ) FROM x GROUP BY tailnum ) AS
xxx WHERE tailnum = 'N907MQ'
+----
+N907MQ
+191.000
+
+query TI rowsort
+-- both work fine with MIN
+SELECT tailnum , MIN( arr_delay ) FROM x WHERE tailnum = 'N907MQ' GROUP BY
tailnum
+----
+N907MQ
+191
+
+query TI rowsort
+SELECT * FROM ( SELECT tailnum , MIN( arr_delay ) FROM x GROUP BY tailnum ) AS
xxx WHERE tailnum = 'N907MQ'
+----
+N907MQ
+191
+
+
diff --git a/sql/test/BugTracker-2017/Tests/caching_stats_bug.6374.test
b/sql/test/BugTracker-2017/Tests/caching_stats_bug.6374.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2017/Tests/caching_stats_bug.6374.test
@@ -0,0 +1,81 @@
+statement ok
+create table sub1 (i int)
+
+statement ok
+create table sub2 (i int)
+
+statement ok
+create merge table mt as select * from sub1 with no data
+
+statement ok
+alter table mt add table sub1
+
+statement ok
+alter table mt add table sub2
+
+statement ok
+insert into sub1 values (1),(2)
+
+statement ok
+insert into sub2 values (11),(12)
+
+statement ok
+alter table sub1 set read only
+
+statement ok
+alter table sub2 set read only
+
+statement ok
+analyze sys.sub1
+
+statement ok
+analyze sys.sub2
+
+query I rowsort
+select count(*) from mt where i >= 5 and i < 100
+----
+2
+
+query T rowsort
+plan select count(*) from mt where i >= 5 and i < 100
+----
+) [ "%1"."%1" NOT NULL ]
+project (
+| ) [ ] [ sys.count() NOT NULL as "%1"."%1" ]
+| group by (
+| | ) [ int "5" <= "mt"."i" < int "100" BETWEEN ]
+| | select (
+| | | table(sys.sub2) [ "mt"."i" ] COUNT
+
+statement ok
+alter table sub1 set read write
+
+statement ok
+insert into sub1 values (7),(8)
+
+statement ok
+alter table sub1 set read only
+
+statement ok
+analyze sys.sub1
+
+query I rowsort
+select count(*) from mt where i >= 5 and i < 100
+----
+4
+
+query T rowsort
+plan select count(*) from mt where i >= 5 and i < 100
+----
+16 values hashing to 260dbb3b58a298ec9fac706651919100
+
+statement ok
+drop table mt
+
+statement ok
+drop table sub1
+
+statement ok
+drop table sub2
+
+
diff --git a/sql/test/BugTracker-2017/Tests/case.Bug-6386.test
b/sql/test/BugTracker-2017/Tests/case.Bug-6386.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2017/Tests/case.Bug-6386.test
@@ -0,0 +1,6 @@
+query R rowsort
+select cast(case privilege_code_name when 'SELECT' then 1 when 'UPDATE' then
60.3281 when 'INSERT' then 0.8415381117315 else 0 end as decimal(18,13)) as t1
from privilege_codes order by privilege_code_id
+----
+33 values hashing to 68758b38fa934afa88ba8220b2a93cca
+
+
diff --git
a/sql/test/BugTracker-2017/Tests/cast-with-many-decimals.Bug-6195.test
b/sql/test/BugTracker-2017/Tests/cast-with-many-decimals.Bug-6195.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2017/Tests/cast-with-many-decimals.Bug-6195.test
@@ -0,0 +1,6 @@
+query R rowsort
+select CAST(CAST(1 AS DECIMAL(20,19)) AS DECIMAL(12,8))
+----
+1.000
+
+
diff --git
a/sql/test/BugTracker-2017/Tests/cast_boolean_to_string.Bug-6110.test
b/sql/test/BugTracker-2017/Tests/cast_boolean_to_string.Bug-6110.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2017/Tests/cast_boolean_to_string.Bug-6110.test
@@ -0,0 +1,243 @@
+statement ok
+CREATE TABLE t_boolean (val BOOLEAN, valstr VARCHAR(5))
+
+statement ok
+INSERT INTO t_boolean VALUES (true, 'True')
+
+statement ok
+INSERT INTO t_boolean VALUES (false, 'False')
+
+statement ok
+INSERT INTO t_boolean VALUES (Null, 'Null')
+
+query TTT rowsort
+SELECT val, valstr, cast(val as bool) as cast2bool FROM t_boolean order by val
+----
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
