Commits included in testrun 73499:c90f9f0143c1

changeset 73482:816edc54851b
date:2020-03-16 09:06 +0100
user:Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>
branch:default
files:sql/test/subquery/Tests/subquery4.sql
message:Starting the week with queries with wrong results
 
changeset 73484:97c90267a76e
date:2020-03-16 09:47 +0100
user:Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>
branch:default
files:sql/server/rel_unnest.c sql/test/subquery/Tests/subquery4.sql sql/test/subquery/Tests/subquery4.stable.out
message:Reset window functions cardinality during unnesting, so the rel_distinct_project2groupby optimizer gets right
 
changeset 73485:945aa956dcc3
date:2020-03-16 09:54 +0100
user:Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>
branch:default
files:sql/test/subquery/Tests/subquery4.sql sql/test/subquery/Tests/subquery4.stable.out
message:Approved query result, we unionize the IN inputs
 
changeset 73487:79d0aee9e4ee
date:2020-03-16 11:48 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:clients/odbc/driver/SQLBindParameter.c clients/odbc/driver/SQLExecute.c
message:Treat SQL_NUMERIC/SQL_FLOAT the same as SQL_DECIMAL/SQL_DOUBLE.
 
changeset 73488:fe2544b023c7
date:2020-03-16 11:49 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_assert.c
message:English.
 
changeset 73489:9da7ad49ac99
date:2020-03-16 11:49 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_assert.c
message:Pass proper SQLSTATE on to client.
 
changeset 73493:f539c6ca8d0b
date:2020-03-16 15:40 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:clients/odbc/driver/ODBCConvert.c
message:Fix UUID handling for big-endian systems.
 
changeset 73494:cdf9cf3e6444
date:2020-03-16 15:42 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:sql/test/BugConstraints/Tests/delete_primarykey_1643845.stable.err sql/test/BugConstraints/Tests/update_primarykey_1643375.stable.err sql/test/BugDay_2005-10-06_2.9.3/Tests/inserts_with_defaults.SF-921977.stable.err sql/test/BugTracker-2008/Tests/OOM_query.SF-2457195.stable.out sql/test/BugTracker-2008/Tests/alter_add_constraint_should_check_existing_data.SF-2075241.stable.err sql/test/BugTracker-2008/Tests/auto_coersion_bug.SF-2075157.stable.out sql/test/BugTracker-2008/Tests/extract_bug.SF-2075266.stable.out sql/test/BugTracker-2008/Tests/groupby_with_NULL.SF-2155606.stable.out sql/test/BugTracker-2008/Tests/insert_into_unique_column.SF-2075180.stable.err sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out sql/test/BugTracker-2009/Tests/unique_constraint_on_char.SF-2873564.stable.err sql/test/BugTracker-2011/Tests/UNIQUE_Constraint_reference.Bug-2835.stable.err sql/test/BugTracker-2011/Tests/crash_in_push_exp_down.Bug-2811.stable.out sql/test/BugTracker-2011/Tests/multicolumn_constraints.Bug-2849.stable.err sql/test/BugTracker-2011/Tests/perl-table_info.Bug-2885.stable.err sql/test/BugTracker-2012/Tests/foreign_key.Bug-3114.stable.err sql/test/BugTracker-2014/Tests/duplicate_primary_keys.Bug-3474.stable.err sql/test/BugTracker-2014/Tests/unsafe_project_push_down.Bug-3523.stable.out sql/test/BugTracker-2015/Tests/ambiguous.Bug-3803.stable.out sql/test/BugTracker-2015/Tests/mserver-crashes-under-specific-combination-of-JOIN-and-WHERE-conditions.Bug-3872.stable.out sql/test/BugTracker-2015/Tests/null_is_null.Bug-3739.stable.out sql/test/BugTracker-2015/Tests/ukey_check_unaligned.Bug-3669.stable.err sql/test/BugTracker-2016/Tests/column_not_found.Bug-4064.stable.out sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out.int128 sql/test/BugTracker-2016/Tests/foreign_key.Bug-3938.stable.err sql/test/BugTracker-2016/Tests/name_conflict_in_union.Bug-6065.stable.out sql/test/BugTracker-2016/Tests/null_in_null.Bug-3900.stable.out sql/test/BugTracker-2016/Tests/select-in-from.Bug-6119.stable.out sql/test/BugTracker-2016/Tests/select-in-from.Bug-6121.stable.out sql/test/BugTracker-2017/Tests/drop_not_null_on_pkey.Bug-6189.stable.err sql/test/BugTracker-2017/Tests/python_loader_clobbers_default_with_null.Bug-6464.stable.err sql/test/BugTracker-2018/Tests/create_table_empty_column_name.Bug-6653.stable.err sql/test/BugTracker-2018/Tests/dependency_column_on_sequence.Bug-6618.stable.err sql/test/BugTracker-2018/Tests/grant-role-not-idempotent.Bug-6660.stable.out sql/test/BugTracker-2018/Tests/multi-column-hash-wrongly-NIL.Bug-6638.stable.err sql/test/BugTracker-2018/Tests/sqlitelogictest-case-coalesce.Bug-6550.stable.out sql/test/BugTracker-2018/Tests/sqlitelogictest-case-not-in-count.Bug-6587.stable.out sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-extra-columns.Bug-6555.stable.out sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-nullif-coalesce.Bug-6565.stable.out sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case.Bug-6552.stable.out sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.stable.out sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-having-in-cast.Bug-6561.stable.out sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-having-in.Bug-6560.stable.out sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-having-not-null-not-in.Bug-6562.stable.out sql/test/BugTracker-2018/Tests/sqlitelogictest-nested-case.Bug-6554.stable.out sql/test/BugTracker-2018/Tests/sqlitelogictest-not-in-wrong-results.Bug-6530.stable.out sql/test/BugTracker-2018/Tests/sqlitelogictest-overflow-in-conversion.Bug-6517.stable.out sql/test/BugTracker/Tests/alter_table_add_fkey.SF-1737668.stable.err sql/test/BugTracker/Tests/auto_increment.SF-1834820.stable.err sql/test/BugTracker/Tests/crash_on_fkey_update.SF-1703497.stable.err sql/test/BugTracker/Tests/crash_on_fkey_update2.SF-1703497.stable.err sql/test/BugTracker/Tests/explain.SF-1739353.stable.out sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out sql/test/BugTracker/Tests/multivalue_insert.SF-1509864.stable.err sql/test/BugTracker/Tests/number_null_first_row.SF-1833286.stable.err sql/test/BugTracker/Tests/update_fkey_with_value_not_in_the_pkey.SF-1734143.stable.err sql/test/BugTracker/Tests/update_pkey_bug.SF-1733712.stable.err sql/test/Tests/default.stable.err sql/test/Tests/null.stable.err sql/test/Update_Delete_action/Tests/delete_restrict.stable.err sql/test/Update_Delete_action/Tests/delete_set_default.stable.err sql/test/Update_Delete_action/Tests/delete_set_null.stable.err sql/test/Update_Delete_action/Tests/update_delete_set_null.stable.err sql/test/Update_Delete_action/Tests/update_delete_set_null_crash.stable.err sql/test/Update_Delete_action/Tests/update_restrict.stable.err sql/test/Update_Delete_action/Tests/update_set_default.stable.err sql/test/Update_Delete_action/Tests/update_set_default_crash.stable.err sql/test/Update_Delete_action/Tests/update_set_null.stable.err sql/test/Via-m/Tests/event_s07.stable.err sql/test/Via-m/Tests/event_s11.stable.err sql/test/Via-m/Tests/file_s02.stable.out sql/test/Via-m/Tests/file_s10.stable.err sql/test/Via-m/Tests/media_s12.stable.err sql/test/Via-m/Tests/media_s14.stable.err sql/test/Via-m/Tests/media_s16.stable.err sql/test/Via-m/Tests/media_s18.stable.err sql/test/Via-m/Tests/media_s19.stable.err sql/test/bugs/Tests/alter_table_add_column.stable.err sql/test/bugs/Tests/cur_date_crash-JIRA-42.stable.out sql/test/bugs/Tests/foreignkey_leftjoin-bug-sf-854312.stable.err sql/test/bugs/Tests/groupby_having-bug-sf-947600.stable.out sql/test/bugs/Tests/groupby_having_charlength-bug-sf-943566.stable.out sql/test/bugs/Tests/in_or_bug.stable.out sql/test/bugs/Tests/primary_key-bug-sf-975308.stable.err sql/test/bugs/Tests/unique-bug-sf-1043512.stable.err sql/test/copy/Tests/key_copy.stable.err sql/test/merge-statements/Tests/mergestmt02.stable.err sql/test/pg_regress/Tests/alter_table.stable.err sql/test/pg_regress/Tests/create_misc.stable.err sql/test/ssqq/Tests/insert_query.stable.err sql/test/ssqq/Tests/insert_queue.stable.err sql/test/ssqq/Tests/insert_quser.stable.err
message:Approve after changeset 9da7ad49ac99.
 
changeset 73496:2374e4677140
date:2020-03-16 16:19 +0100
user:Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>
branch:default
files:sql/server/rel_exp.c sql/server/rel_rel.c sql/server/rel_rel.h sql/server/rel_unnest.c sql/test/subquery/Tests/subquery4.sql sql/test/subquery/Tests/subquery4.stable.out
message:Reverting this morning changes and added rel_exp_visitor_bottomup and rel_exp_visitor_topdown.
 
changeset 73497:b840fdf46d77
date:2020-03-16 17:44 +0100
user:Niels Nes <niels@cwi.nl>
branch:default
files:sql/server/rel_unnest.c
message:reset cardinality during unnest, ie when a expression is added the cardinality goes up.
 
changeset 73498:4d2d38fdc3d5
date:2020-03-16 18:37 +0100
user:Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>
branch:default
files:sql/backends/monet5/rel_bin.c sql/backends/monet5/sql.c sql/backends/monet5/sql_cat.c sql/server/rel_psm.c sql/server/sql_mvc.c sql/test/BugTracker-2015/Tests/All sql/test/BugTracker-2015/Tests/trigger-old-row.Bug-3741.sql sql/test/BugTracker-2015/Tests/trigger-old-row.Bug-3741.stable.err sql/test/BugTracker-2015/Tests/trigger-old-row.Bug-3741.stable.out sql/test/Triggers/Tests/trigger_action.stable.err sql/test/Triggers/Tests/trigger_action.stable.out sql/test/Triggers/trigger_action.sql
message:Added fixes for bug related to bug 3741, ie when an error happens in the body of a trigger, throw the error. The trigger_action test is giving a wrong result, but I'm looking into it
 
changeset 73499:c90f9f0143c1
date:2020-03-16 19:02 +0100
user:Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>
branch:default
files:sql/test/Triggers/Tests/All
message:trigger_action needs KNOWNFAIL