Changeset: bee449562033 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bee449562033
Modified Files:
        monetdb5/mal/mal_interpreter.c
        sql/backends/monet5/Tests/pyapi29.stable.out
        sql/backends/monet5/UDF/cudf/Tests/udf-fuse.stable.out
        sql/backends/monet5/UDF/cudf/Tests/udf-reverse.stable.out
        sql/backends/monet5/rel_bin.c
        sql/backends/monet5/sql_execute.c
        sql/backends/monet5/vaults/bam/Tests/bam_lib.stable.out
        sql/backends/monet5/vaults/bam/Tests/mergetable.stable.out
        sql/backends/monet5/vaults/bam/Tests/query1.1.stable.out
        sql/backends/monet5/vaults/bam/Tests/query1.2.stable.out
        sql/backends/monet5/vaults/bam/Tests/query2.1.stable.out
        sql/backends/monet5/vaults/bam/Tests/query2.10.stable.out
        sql/backends/monet5/vaults/bam/Tests/query2.11.stable.out
        sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out
        sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out.int128
        sql/backends/monet5/vaults/bam/Tests/query2.5.stable.out
        sql/backends/monet5/vaults/bam/Tests/query2.5.stable.out.int128
        sql/backends/monet5/vaults/bam/Tests/query2.6.stable.out
        sql/backends/monet5/vaults/bam/Tests/query2.7.stable.out
        sql/backends/monet5/vaults/bam/Tests/query2.8.stable.out
        sql/backends/monet5/vaults/bam/Tests/sam_export.stable.out
        sql/benchmarks/ssbm/Tests/01-13.stable.out
        sql/benchmarks/ssbm/Tests/01-13.stable.out.int128
        sql/benchmarks/ssbm/Tests/01-explain.stable.out
        sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/01-plan.stable.out
        sql/benchmarks/ssbm/Tests/01.stable.out
        sql/benchmarks/ssbm/Tests/01.stable.out.int128
        sql/benchmarks/ssbm/Tests/02-explain.stable.out
        sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/02-plan.stable.out
        sql/benchmarks/ssbm/Tests/02.stable.out
        sql/benchmarks/ssbm/Tests/02.stable.out.int128
        sql/benchmarks/ssbm/Tests/03-explain.stable.out
        sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/03-plan.stable.out
        sql/benchmarks/ssbm/Tests/03.stable.out
        sql/benchmarks/ssbm/Tests/03.stable.out.int128
        sql/benchmarks/ssbm/Tests/04-explain.stable.out
        sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/04-plan.stable.out
        sql/benchmarks/ssbm/Tests/04.stable.out.int128
        sql/benchmarks/ssbm/Tests/05-explain.stable.out
        sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/05-plan.stable.out
        sql/benchmarks/ssbm/Tests/05.stable.out.int128
        sql/benchmarks/ssbm/Tests/06-explain.stable.out
        sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/06-plan.stable.out
        sql/benchmarks/ssbm/Tests/06.stable.out.int128
        sql/benchmarks/ssbm/Tests/07-explain.stable.out
        sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/07-plan.stable.out
        sql/benchmarks/ssbm/Tests/07.stable.out
        sql/benchmarks/ssbm/Tests/07.stable.out.int128
        sql/benchmarks/ssbm/Tests/08-explain.stable.out
        sql/benchmarks/ssbm/Tests/08-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/08-plan.stable.out
        sql/benchmarks/ssbm/Tests/08.stable.out
        sql/benchmarks/ssbm/Tests/08.stable.out.int128
        sql/benchmarks/ssbm/Tests/09-explain.stable.out
        sql/benchmarks/ssbm/Tests/09-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/09-plan.stable.out
        sql/benchmarks/ssbm/Tests/09.stable.out
        sql/benchmarks/ssbm/Tests/09.stable.out.int128
        sql/benchmarks/ssbm/Tests/10-explain.stable.out
        sql/benchmarks/ssbm/Tests/10-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/10-plan.stable.out
        sql/benchmarks/ssbm/Tests/10.stable.out
        sql/benchmarks/ssbm/Tests/10.stable.out.int128
        sql/benchmarks/ssbm/Tests/11-explain.stable.out
        sql/benchmarks/ssbm/Tests/11-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/11-plan.stable.out
        sql/benchmarks/ssbm/Tests/11.stable.out
        sql/benchmarks/ssbm/Tests/11.stable.out.int128
        sql/benchmarks/ssbm/Tests/12-explain.stable.out
        sql/benchmarks/ssbm/Tests/12-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/12-plan.stable.out
        sql/benchmarks/ssbm/Tests/12.stable.out
        sql/benchmarks/ssbm/Tests/12.stable.out.int128
        sql/benchmarks/ssbm/Tests/13-explain.stable.out
        sql/benchmarks/ssbm/Tests/13-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/13-plan.stable.out
        sql/benchmarks/ssbm/Tests/13.stable.out
        sql/benchmarks/ssbm/Tests/13.stable.out.int128
        sql/benchmarks/ssbm/Tests/check1.stable.out
        sql/benchmarks/ssbm/Tests/load.stable.out
        sql/benchmarks/tpch/Tests/01-22.stable.out
        sql/benchmarks/tpch/Tests/01-22.stable.out.int128
        sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/01-plan.stable.out.int128
        sql/benchmarks/tpch/Tests/01.stable.out
        sql/benchmarks/tpch/Tests/01.stable.out.int128
        sql/benchmarks/tpch/Tests/02-plan.stable.out
        sql/benchmarks/tpch/Tests/02-plan.stable.out.32bit
        sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/03-plan.stable.out.int128
        sql/benchmarks/tpch/Tests/03.stable.out
        sql/benchmarks/tpch/Tests/03.stable.out.int128
        sql/benchmarks/tpch/Tests/04-explain.stable.out
        sql/benchmarks/tpch/Tests/04-plan.stable.out
        sql/benchmarks/tpch/Tests/04.stable.out
        sql/benchmarks/tpch/Tests/05-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/05-plan.stable.out.int128
        sql/benchmarks/tpch/Tests/05.stable.out
        sql/benchmarks/tpch/Tests/05.stable.out.int128
        sql/benchmarks/tpch/Tests/06-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/06-plan.stable.out.int128
        sql/benchmarks/tpch/Tests/06.stable.out
        sql/benchmarks/tpch/Tests/06.stable.out.int128
        sql/benchmarks/tpch/Tests/07-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/07-plan.stable.out.int128
        sql/benchmarks/tpch/Tests/07.stable.out
        sql/benchmarks/tpch/Tests/07.stable.out.int128
        sql/benchmarks/tpch/Tests/08-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/08-plan.stable.out.int128
        sql/benchmarks/tpch/Tests/08.stable.out
        sql/benchmarks/tpch/Tests/08.stable.out.int128
        sql/benchmarks/tpch/Tests/09-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/09-plan.stable.out.int128
        sql/benchmarks/tpch/Tests/09.stable.out
        sql/benchmarks/tpch/Tests/09.stable.out.int128
        sql/benchmarks/tpch/Tests/10-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/10-plan.stable.out.int128
        sql/benchmarks/tpch/Tests/10.stable.out
        sql/benchmarks/tpch/Tests/10.stable.out.int128
        sql/benchmarks/tpch/Tests/11-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/11-plan.stable.out
        sql/benchmarks/tpch/Tests/11-plan.stable.out.int128
        sql/benchmarks/tpch/Tests/11.stable.out
        sql/benchmarks/tpch/Tests/11.stable.out.int128
        sql/benchmarks/tpch/Tests/12-explain.stable.out
        sql/benchmarks/tpch/Tests/12-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/12-plan.stable.out
        sql/benchmarks/tpch/Tests/12.stable.out
        sql/benchmarks/tpch/Tests/12.stable.out.int128
        sql/benchmarks/tpch/Tests/13-explain.stable.out
        sql/benchmarks/tpch/Tests/13-plan.stable.out
        sql/benchmarks/tpch/Tests/13.stable.out
        sql/benchmarks/tpch/Tests/14-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/14-plan.stable.out.int128
        sql/benchmarks/tpch/Tests/14.stable.out
        sql/benchmarks/tpch/Tests/14.stable.out.int128
        sql/benchmarks/tpch/Tests/15-plan.stable.out.int128
        sql/benchmarks/tpch/Tests/16-explain.stable.out
        sql/benchmarks/tpch/Tests/16-plan.stable.out
        sql/benchmarks/tpch/Tests/16.stable.out
        sql/benchmarks/tpch/Tests/17-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/17-plan.stable.out
        sql/benchmarks/tpch/Tests/17-plan.stable.out.int128
        sql/benchmarks/tpch/Tests/17.stable.out
        sql/benchmarks/tpch/Tests/17.stable.out.int128
        sql/benchmarks/tpch/Tests/18-explain.stable.out
        sql/benchmarks/tpch/Tests/18-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/18-plan.stable.out
        sql/benchmarks/tpch/Tests/18-plan.stable.out.int128
        sql/benchmarks/tpch/Tests/18.stable.out
        sql/benchmarks/tpch/Tests/18.stable.out.int128
        sql/benchmarks/tpch/Tests/19-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/19-plan.stable.out.int128
        sql/benchmarks/tpch/Tests/19.stable.out
        sql/benchmarks/tpch/Tests/19.stable.out.int128
        sql/benchmarks/tpch/Tests/20-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/20-plan.stable.out.int128
        sql/benchmarks/tpch/Tests/21-explain.stable.out
        sql/benchmarks/tpch/Tests/21-plan.stable.out
        sql/benchmarks/tpch/Tests/21.stable.out
        sql/benchmarks/tpch/Tests/22-explain.stable.out
        sql/benchmarks/tpch/Tests/22-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/22-plan.stable.out
        sql/benchmarks/tpch/Tests/22.stable.out
        sql/benchmarks/tpch/Tests/22.stable.out.int128
        sql/benchmarks/tpch/Tests/check1.stable.out
        sql/benchmarks/tpch/Tests/load.stable.out
        sql/benchmarks/tpch/Tests/lowcardinality.stable.out
        sql/jdbc/tests/Tests/Test_JdbcClient.stable.out
        sql/jdbc/tests/Tests/Test_PSmetadata.stable.out
        sql/server/rel_rel.c
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/BATpropcheck_error.SF-1012739.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-1.SF-921673.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/basic_arithmetics.SF-922252.stable.out
        sql/test/BugDay_2005-10-06_2.9.3/Tests/bool_boolean.SF-935601.stable.out
        sql/test/BugDay_2005-10-06_2.9.3/Tests/case.SF-929151.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/cast_to_interval.SF-1019079.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/cross_product.SF-1122802.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/custom_function_in_where.SF-937859.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.stable.out.int128
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/max_min_sum_null.SF-1123132.stable.out.int128
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/multiple_select_cast.SF-938419.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/multiple_select_on_view.SF-935639.stable.out
        sql/test/BugDay_2005-10-06_2.9.3/Tests/not_null.SF-933194.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/quoted_keywords.SF-922288.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/reserved_words.SF-939112.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/select_not_true.SF-1314945.stable.out
        sql/test/BugDay_2005-10-06_2.9.3/Tests/set_types.SF-932360.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/singleton_view.SF-933573.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting_1.SF-923709.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting_2.SF-923709.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/timestamp_parsing.SF-927300.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/type_dump_test.SF-989257.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/union_limitation.SF-921992.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/var_char_cast_truncate.SF-1150907.stable.out
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/variable_arg_substring.SF_942981.stable.out
        sql/test/BugTracker-2009/Tests/AVG_ReturnsNoLines.SF-2596084.stable.out
        sql/test/BugTracker-2009/Tests/AVG_of_SQRT.SF-2757642.stable.out
        sql/test/BugTracker-2009/Tests/BOM.SF-2787813.stable.out
        
sql/test/BugTracker-2009/Tests/Division_by_zero_error.SF-2791361.stable.out
        
sql/test/BugTracker-2009/Tests/Floating_point_exception.SF-2791356.stable.out
        sql/test/BugTracker-2009/Tests/IS_NULL_in_CASE.stable.out
        sql/test/BugTracker-2009/Tests/LE_vs_GE_in_CASE.SF-2562264.stable.out
        sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
        
sql/test/BugTracker-2009/Tests/TribooleanFailureWithSubquery.SF-2679434.stable.out
        
sql/test/BugTracker-2009/Tests/TribooleanFailureWithSubquery.SF-2679434.stable.out.int128
        
sql/test/BugTracker-2009/Tests/TypeException_having_count_distinct.SF-2494227.stable.out
        sql/test/BugTracker-2009/Tests/addmonths_missing.SF-2854949.stable.out
        
sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.stable.out.int128
        sql/test/BugTracker-2009/Tests/avg-bug.SF-2132666.stable.out.int128
        sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.out.int128
        
sql/test/BugTracker-2009/Tests/case_evaluates_all_branches.SF-2893484.stable.out
        
sql/test/BugTracker-2009/Tests/case_evaluates_all_branches.SF-2893484.stable.out.int128
        sql/test/BugTracker-2009/Tests/caselessthen.stable.out
        sql/test/BugTracker-2009/Tests/coercion.stable.out
        sql/test/BugTracker-2009/Tests/correlated-selection-bug.stable.out
        sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.stable.out.int128
        sql/test/BugTracker-2009/Tests/count_distinct_bug.SF-2826015.stable.out
        
sql/test/BugTracker-2009/Tests/double_count_limit_bug.SF-2862146.stable.out
        sql/test/BugTracker-2009/Tests/except_error_wrong.SF-2808409.stable.out
        
sql/test/BugTracker-2009/Tests/function_call_not_handled.SF-2864179.stable.out
        sql/test/BugTracker-2009/Tests/having_or_bug.stable.out
        sql/test/BugTracker-2009/Tests/leftjoin_undefined.SF-2879011.stable.out
        sql/test/BugTracker-2009/Tests/like_bug.SF-2878994.stable.out
        
sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.stable.out
        
sql/test/BugTracker-2009/Tests/order_by_column_position_rel_name_bug.stable.out
        
sql/test/BugTracker-2009/Tests/orderby_with_row_number.SF-2895791.stable.out
        
sql/test/BugTracker-2009/Tests/parallel_bulk-load.SF-2771052.test.stable.out
        sql/test/BugTracker-2009/Tests/pow_operator.SF-2812721.stable.out
        sql/test/BugTracker-2009/Tests/primekeyconstraint.SF-2783425.stable.out
        
sql/test/BugTracker-2009/Tests/push-select-div-down.SF-2593341.stable.out
        sql/test/BugTracker-2009/Tests/push_select_down_crash.stable.out
        sql/test/BugTracker-2009/Tests/random.SF-2737889.stable.out
        
sql/test/BugTracker-2009/Tests/restart_with_large_int.SF-2846238.stable.out
        sql/test/BugTracker-2009/Tests/set_and_arg_null.SF-2812729.stable.out
        
sql/test/BugTracker-2009/Tests/subtraction_between_two_columns.SF-2582389.stable.out
        
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.stable.out
        
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.stable.out
        
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.stable.out
        
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.stable.out
        
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.stable.out
        sql/test/BugTracker-2009/Tests/utf8_bug.SF-2822855.stable.out
        
sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.stable.out
        
sql/test/BugTracker-2010/Tests/TypeException_with_missing_function.Bug-2674.stable.out
        sql/test/BugTracker-2010/Tests/and_not_broken.Bug-2602.stable.out
        sql/test/BugTracker-2010/Tests/between-timestamp.Bug-2718.stable.out
        sql/test/BugTracker-2010/Tests/cast-varchar.Bug-2682.stable.out
        
sql/test/BugTracker-2010/Tests/concat_type_check_problem.Bug-2354.stable.out
        sql/test/BugTracker-2010/Tests/constants-optimizer.Bug-2317.stable.out
        sql/test/BugTracker-2010/Tests/count-and-not.Bug-2663.stable.out
        
sql/test/BugTracker-2010/Tests/crash_on_complex_join_exp.Bug-2353.stable.out
        sql/test/BugTracker-2010/Tests/crash_on_where_in.Bug-2333.stable.out
        sql/test/BugTracker-2010/Tests/decimal-function.BUG-2624.stable.out
        sql/test/BugTracker-2010/Tests/decimal_div_whole_nrs.Bug-2579.stable.out
        
sql/test/BugTracker-2010/Tests/distinct-order-by-limit.Bug-2691.stable.out
        sql/test/BugTracker-2010/Tests/function_results_NULL.Bug-2626.stable.out
        
sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
        sql/test/BugTracker-2010/Tests/join_problem.Bug-2694.stable.out
        sql/test/BugTracker-2010/Tests/keycheck_crash.Bug-2583.stable.out
        
sql/test/BugTracker-2010/Tests/not-in-union-except-union.Bug-2577.stable.out
        sql/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.stable.out
        sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.out
        
sql/test/BugTracker-2010/Tests/rank-over-crash.SF-2926454.stable.out.int128
        
sql/test/BugTracker-2010/Tests/sequence-restart-with-null.Bug-2648.stable.out
        sql/test/BugTracker-2010/Tests/shift_with_cast.Bug-2638.stable.out
        
sql/test/BugTracker-2010/Tests/substring_display_width.Bug-2683.stable.out
        sql/test/BugTracker-2010/Tests/unicode-bom.Bug-2641.stable.out
        
sql/test/BugTracker-2010/Tests/update_statement_in_function_ignored.Bug-2614.stable.out
        sql/test/BugTracker-2010/Tests/with-between.Bug-2732.stable.out
        
sql/test/BugTracker-2011/Tests/CASE_division_exception.Bug-2822.stable.out
        sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.stable.out
        
sql/test/BugTracker-2011/Tests/Multiplication_and_cast.Bug-2923.stable.out
        sql/test/BugTracker-2011/Tests/aggregate-in-subquery.Bug-2739.stable.out
        sql/test/BugTracker-2011/Tests/and-power.Bug-3013.stable.out
        sql/test/BugTracker-2011/Tests/and-power.Bug-3013.stable.out.int128
        
sql/test/BugTracker-2011/Tests/bulk_rotate_xor_hash-error.Bug-2734.stable.out
        sql/test/BugTracker-2011/Tests/case-overflow.Bug-2239.stable.out.int128
        sql/test/BugTracker-2011/Tests/case-when-alias.Bug-2848.stable.out
        sql/test/BugTracker-2011/Tests/cast-crash.Bug-2678.stable.out
        sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out
        
sql/test/BugTracker-2011/Tests/crash_in_push_exp_down.Bug-2811.stable.out
        sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out
        sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128
        sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.stable.out
        sql/test/BugTracker-2011/Tests/div_by_zero.Bug-2887.stable.out
        sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out
        sql/test/BugTracker-2011/Tests/extract_seconds.Bug-2793.stable.out
        sql/test/BugTracker-2011/Tests/history.Bug-2909.stable.out
        sql/test/BugTracker-2011/Tests/jena-optional-1-test.Bug-2915.stable.out
        sql/test/BugTracker-2011/Tests/many-connects-cache.Bug-2904.stable.out
        sql/test/BugTracker-2011/Tests/multiple-joins.Bug-2879.stable.out
        
sql/test/BugTracker-2011/Tests/non-stable-select-bug.Bug-2894.stable.out.int128
        sql/test/BugTracker-2011/Tests/predicate.Bug-2908.stable.out
        sql/test/BugTracker-2011/Tests/rand-with-seed.Bug-2900.stable.out
        sql/test/BugTracker-2011/Tests/recursive_case.Bug-2838.stable.out
        sql/test/BugTracker-2011/Tests/sqltables.Bug-2921.stable.out
        
sql/test/BugTracker-2011/Tests/subquery_in_from_clause.Bug-2812.stable.out
        
sql/test/BugTracker-2011/Tests/subquery_in_from_clause.Bug-2812.stable.out.int128
        sql/test/BugTracker-2011/Tests/supertype.Bug-2830.stable.out
        sql/test/BugTracker-2011/Tests/time_precision.Bug-2873.stable.out
        
sql/test/BugTracker-2011/Tests/view_avg_incorrect_result.Bug-2790.stable.out
        sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128
        sql/test/BugTracker-2013/Tests/php-size-limit-bug.stable.out
        sql/test/BugTracker-2014/Tests/BOM-in-string.Bug-3641.stable.out
        sql/test/BugTracker-2014/Tests/aggr-with-limit.Bug-3498.stable.out
        sql/test/BugTracker-2014/Tests/bug_in_cse.Bug-3511.stable.out
        sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.stable.out
        sql/test/BugTracker-2014/Tests/column-with-comma.Bug-3616.stable.out
        
sql/test/BugTracker-2014/Tests/crash_on_groupby_distinct_serial.Bug-3463.stable.out
        sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.stable.out
        sql/test/BugTracker-2014/Tests/div_by_zero_in_return.Bug-3555.stable.out
        
sql/test/BugTracker-2014/Tests/empty_intermediate_quantile.Bug-3611.stable.out
        sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.out.int128
        sql/test/BugTracker-2014/Tests/groupby_distict.Bug-3423.stable.out
        
sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out.int128
        sql/test/BugTracker-2014/Tests/ifthenelse.Bug-3546.stable.out
        sql/test/BugTracker-2014/Tests/ifthenelse.Bug-3546.stable.out.int128
        sql/test/BugTracker-2014/Tests/ifthenelse.Bug-3629.stable.out
        
sql/test/BugTracker-2014/Tests/incorrect_floating_point_cast.Bug-3633.stable.out
        sql/test/BugTracker-2014/Tests/indices.Bug-3435.stable.out
        sql/test/BugTracker-2014/Tests/locate-offset.Bug-3563.stable.out
        sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out
        sql/test/BugTracker-2014/Tests/missing_alias.Bug-3626.stable.out
        sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out
        sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out.single
        sql/test/BugTracker-2014/Tests/orderby_count.Bug-3526.stable.out
        sql/test/BugTracker-2014/Tests/orderby_on_constant.Bug-3554.stable.out
        sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out
        sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out.single
        sql/test/BugTracker-2014/Tests/queueError.Bug-3604.stable.out
        sql/test/BugTracker-2014/Tests/round-properties.Bug-3515.stable.out
        sql/test/BugTracker-2014/Tests/round-sorted.Bug-3562.stable.out
        sql/test/BugTracker-2014/Tests/round.Bug-3542.stable.out.int128
        sql/test/BugTracker-2014/Tests/select-having.Bug-3458.stable.out
        sql/test/BugTracker-2014/Tests/select_in_crash.Bug-3491.stable.out
        sql/test/BugTracker-2014/Tests/sign-sorted.Bug-3594.stable.out
        sql/test/BugTracker-2014/Tests/stddev-empty.Bug-3628.stable.out
        
sql/test/BugTracker-2014/Tests/two-column-aggr-with-null.Bug-3428.stable.out
        sql/test/BugTracker-2014/Tests/type_resolution.Bug-3622.stable.out
        sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.stable.out
        
sql/test/BugTracker-2014/Tests/union_with_subqueries.Bug-3518.stable.out.int128
        
sql/test/BugTracker-2014/Tests/unsafe_project_push_down.Bug-3523.stable.out
        sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
        
sql/test/BugTracker-2015/Tests/quantile_function_resolution.Bug-3773.stable.out
        sql/test/BugTracker-2015/Tests/schemadiff.Bug-3778.stable.out
        sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out
        sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.stable.out
        
sql/test/BugTracker-2016/Tests/prepare_without_querycache.Bug-4047.stable.out
        sql/test/BugTracker-2016/Tests/rename_exps.Bug-3974.stable.out
        sql/test/BugTracker/Tests/authorization.SF-1430616.stable.out
        sql/test/BugTracker/Tests/auto_increment.SF-1834820.stable.out
        sql/test/BugTracker/Tests/bug_in_selection.SF-1892413.stable.out
        sql/test/BugTracker/Tests/case_in_aggr_bug.SF-1506545.stable.out
        sql/test/BugTracker/Tests/case_with_aggr.SF-1876779.stable.out.int128
        sql/test/BugTracker/Tests/cast_interval2time.SF-1488247.stable.out
        sql/test/BugTracker/Tests/connect_crash.SF-1436626.stable.out
        sql/test/BugTracker/Tests/convert_dec2varchar.SF-1774312.stable.out
        
sql/test/BugTracker/Tests/convert_dec2varchar_crash.SF-1775550.stable.out
        sql/test/BugTracker/Tests/count_crash.SF-1918780.stable.out
        sql/test/BugTracker/Tests/crash_on_cast.SF-1357271.stable.out
        sql/test/BugTracker/Tests/crash_on_delete.SF-1639108.stable.out
        sql/test/BugTracker/Tests/crash_on_delete.SF-1651567.stable.out
        sql/test/BugTracker/Tests/crash_on_insert.SF-1639113.stable.out
        sql/test/BugTracker/Tests/drop_schema_crash.SF-1504794.stable.out
        sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
        sql/test/BugTracker/Tests/full_join_crash.SF-1841754.stable.out
        
sql/test/BugTracker/Tests/groupby_with_alias.SF-1520575.stable.out.int128
        sql/test/BugTracker/Tests/insert_not_exists.SF-1380287.stable.out
        sql/test/BugTracker/Tests/intersect_in_subquery.SF-1339411.stable.out
        sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
        sql/test/BugTracker/Tests/large_prepare_2.SF-1363729.stable.out
        sql/test/BugTracker/Tests/like_for_time_values.SF-1715659.stable.out
        
sql/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.stable.out
        sql/test/BugTracker/Tests/ms_round.SF-1907063.stable.out
        sql/test/BugTracker/Tests/orderby_in_function.SF-1892708.stable.out
        sql/test/BugTracker/Tests/proc_insert_into.SF-1958572.stable.out
        
sql/test/BugTracker/Tests/rand_not_executed_for_every_row.SF-1723791.stable.out
        sql/test/BugTracker/Tests/rank_over.SF-1691098.stable.out
        
sql/test/BugTracker/Tests/select_crashes_in_the_optimization.SF-1848553.stable.out
        sql/test/BugTracker/Tests/select_mod.SF-1838813.stable.out
        sql/test/BugTracker/Tests/set_a_new_user_password.SF-1844050.stable.out
        
sql/test/BugTracker/Tests/set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out
        sql/test/BugTracker/Tests/sql_prepare_prob.SF-1909638.stable.out
        sql/test/BugTracker/Tests/union_order.stable.out
        sql/test/BugTracker/Tests/variable_names.SF-1838816.stable.out
        sql/test/BugTracker/Tests/variables.SF-1508160.stable.out
        sql/test/BugTracker/Tests/with_only_once.SF-1720293.stable.out
        sql/test/BugTracker/Tests/with_row_number.SF-1898089.stable.out
        sql/test/Skyserver/Tests/Skyserver.stable.out
        sql/test/Tests/50ways.stable.out
        sql/test/Tests/alastair_udf_mergetable_bug.stable.out
        sql/test/Tests/alastair_udf_mergetable_bug.stable.out.int128
        sql/test/Tests/coalesce.stable.out
        sql/test/Tests/count.stable.out
        sql/test/Tests/decimal2.stable.out
        sql/test/Tests/identifiers.stable.out
        sql/test/Tests/marcin1.stable.out
        sql/test/Tests/marcin3.stable.out
        sql/test/Tests/marcin3.stable.out.int128
        sql/test/Tests/median_stdev.stable.out
        sql/test/Tests/order_by_complex_exp.stable.out
        sql/test/Tests/order_by_simple_exp.stable.out
        sql/test/Tests/orderby_limit.stable.out
        sql/test/Tests/outerref_in_selection.stable.out
        sql/test/Tests/outerref_in_selection.stable.out.int128
        sql/test/Tests/psm.stable.out
        sql/test/Tests/rank.stable.out
        sql/test/Tests/restart-sequence.stable.out
        sql/test/Tests/round.stable.out
        sql/test/Tests/session_vars.stable.out
        sql/test/Tests/setoptimizer.stable.out
        sql/test/Tests/setoptimizer.stable.out.Windows
        sql/test/Tests/str-pad.stable.out
        sql/test/Tests/str-trim.stable.out
        sql/test/Tests/string.stable.out
        sql/test/Tests/timezone.stable.out
        sql/test/Tests/zones.stable.out
        sql/test/Tests/zones.stable.out.int128
        sql/test/Tests/zones2.stable.out
        sql/test/VOC/Tests/VOC.stable.out
        sql/test/VOC/Tests/double_is_null.Bug-3116.stable.out
        sql/test/VOC/Tests/median.Bug-3096.stable.out
        sql/test/bugs/Tests/aggr_single_value.stable.out.int128
        sql/test/bugs/Tests/arith-bug-sf-949228.stable.out
        sql/test/bugs/Tests/case_cast-bug-sf-1019506.stable.out
        sql/test/bugs/Tests/case_parenthesis-bug-sf-1023056.stable.out
        sql/test/bugs/Tests/case_substring.stable.out
        sql/test/bugs/Tests/cast_bool2int-bug-sf-1000576.stable.out
        sql/test/bugs/Tests/cast_bool2int-bug-sf-951800.stable.out
        sql/test/bugs/Tests/cast_varchar2int-bug-sf-964165.stable.out
        sql/test/bugs/Tests/crash_order_by.stable.out
        sql/test/bugs/Tests/create_insert_select_aggr-bug-00001.stable.out
        sql/test/bugs/Tests/cur_date_crash-JIRA-42.stable.out
        sql/test/bugs/Tests/date_parsing-bug-sf-960166.stable.out
        sql/test/bugs/Tests/dbl_sht_cast_bug.stable.out
        sql/test/bugs/Tests/default_with_cast.SF-1334486.stable.out
        sql/test/bugs/Tests/distinct_count.stable.out
        sql/test/bugs/Tests/div_zero_bug.stable.out
        sql/test/bugs/Tests/escape_quote-bug-sf-1006469.stable.out
        sql/test/bugs/Tests/except-union-intersect-bug-sf-1146079.stable.out
        sql/test/bugs/Tests/extract_interval_bug-sf-1274088.stable.out
        sql/test/bugs/Tests/float2dec.stable.out
        sql/test/bugs/Tests/float_arith_cast2int-bug-sf-949255.stable.out
        sql/test/bugs/Tests/floor-bug-sf-967066.stable.out
        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/innerjoin_between-bug-sf-960672.stable.out
        sql/test/bugs/Tests/insert_delete-bug-sf-904025.stable.out
        sql/test/bugs/Tests/interval_convert_bugs-sf-1274077-1274085.stable.out
        
sql/test/bugs/Tests/interval_data_commutative_add_bug-sf-1263928.stable.out
        sql/test/bugs/Tests/interval_parse_bug-sf-1263967.stable.out
        sql/test/bugs/Tests/not.stable.out
        sql/test/bugs/Tests/or_in_crash.stable.out
        sql/test/bugs/Tests/polymorphism.stable.out
        sql/test/bugs/Tests/rangejoin_optimize_bug.stable.out
        sql/test/bugs/Tests/seconds2timestamp.stable.out
        
sql/test/bugs/Tests/select_constant_from_where_1=1-bug-sf-1019529.stable.out
        sql/test/bugs/Tests/select_into.stable.out
        sql/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.stable.out
        sql/test/bugs/Tests/select_select_bug.stable.out
        sql/test/bugs/Tests/selectlist_subquery-sf-1208599.stable.out
        
sql/test/bugs/Tests/subselect_multiple_unionall_where_1=1-bug-sf-1005596.stable.out
        sql/test/bugs/Tests/subselect_single_value-bug-sf-962099.stable.out
        sql/test/bugs/Tests/timestamp_comparison-bug-sf-1158581.stable.out
        sql/test/bugs/Tests/trimtest-bug-sf-1023588.stable.out
        sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_JdbcClient.stable.out
        sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_MapiClient.stable.out
        sql/test/bugs/Tests/union-bug-sf-978045.stable.out
        sql/test/bugs/Tests/zero_or_one_bug.stable.out
        sql/test/mapi/Tests/perl_dbi.stable.out
        sql/test/mapi/Tests/smack01.stable.out
        sql/test/mapi/Tests/sql_int128.stable.out
        sql/test/pg_regress/Tests/alter_table.stable.out
        sql/test/pg_regress/Tests/boolean.stable.out
        sql/test/pg_regress/Tests/box.stable.out
        sql/test/pg_regress/Tests/case.stable.out
        sql/test/pg_regress/Tests/char.stable.out
        sql/test/pg_regress/Tests/comments.stable.out
        sql/test/pg_regress/Tests/date.stable.out
        sql/test/pg_regress/Tests/float4.stable.out
        sql/test/pg_regress/Tests/float8.stable.out
        sql/test/pg_regress/Tests/float8.stable.out.Windows
        sql/test/pg_regress/Tests/horology.stable.out
        sql/test/pg_regress/Tests/inet.stable.out
        sql/test/pg_regress/Tests/int2.stable.out
        sql/test/pg_regress/Tests/int4.stable.out
        sql/test/pg_regress/Tests/int4.stable.out.int128
        sql/test/pg_regress/Tests/int8.stable.out
        sql/test/pg_regress/Tests/int8.stable.out.int128
        sql/test/pg_regress/Tests/interval.stable.out
        sql/test/pg_regress/Tests/interval.stable.out.int128
        sql/test/pg_regress/Tests/limit.stable.out
        sql/test/pg_regress/Tests/numeric.stable.out
        sql/test/pg_regress/Tests/numerology.stable.out
        sql/test/pg_regress/Tests/oid.stable.out
        sql/test/pg_regress/Tests/oid.stable.out.oid32
        sql/test/pg_regress/Tests/path.stable.out
        sql/test/pg_regress/Tests/point.stable.out
        sql/test/pg_regress/Tests/polygon.stable.out
        sql/test/pg_regress/Tests/random.stable.out
        sql/test/pg_regress/Tests/reltime.stable.out
        sql/test/pg_regress/Tests/strings.stable.out
        sql/test/pg_regress/Tests/strings_cast.stable.out
        sql/test/pg_regress/Tests/strings_concat.stable.out
        sql/test/pg_regress/Tests/strings_like.stable.out
        sql/test/pg_regress/Tests/text.stable.out
        sql/test/pg_regress/Tests/time.stable.out
        sql/test/pg_regress/Tests/timestamp.stable.out
        sql/test/pg_regress/Tests/timestamptz.stable.out
        sql/test/pg_regress/Tests/timetz.stable.out
        sql/test/pg_regress/Tests/vacuum.stable.out
        sql/test/pg_regress/Tests/varchar.stable.out
        sql/test/pg_regress/Tests/without_oid.stable.out
Branch: default
Log Message:

merged with Dec2016


diffs (truncated from 29627 to 300 lines):

diff --git a/monetdb5/mal/mal_interpreter.c b/monetdb5/mal/mal_interpreter.c
--- a/monetdb5/mal/mal_interpreter.c
+++ b/monetdb5/mal/mal_interpreter.c
@@ -422,7 +422,12 @@ callMAL(Client cntxt, MalBlkPtr mb, MalS
                        stk = prepareMALstack(mb, mb->vsize);
                        stk->up = 0;
                        *env = stk;
-               } else stk = *env;
+               } else {
+                       ValPtr lhs, rhs;
+
+                       stk = *env;
+                       initStack(0);
+               }
                assert(stk);
                for (i = pci->retc; i < pci->argc; i++) {
                        lhs = &stk->stk[pci->argv[i]];
@@ -445,6 +450,8 @@ callMAL(Client cntxt, MalBlkPtr mb, MalS
        }
        if ( ret == MAL_SUCCEED && cntxt->qtimeout && GDKusec()- mb->starttime 
> cntxt->qtimeout)
                throw(MAL, "mal.interpreter", RUNTIME_QRY_TIMEOUT);
+       if (stk) 
+               garbageCollector(cntxt, mb, stk, TRUE);
        return ret;
 }
 
@@ -1433,11 +1440,11 @@ void garbageCollector(Client cntxt, MalB
 #endif
        (void) flag;
        for (k = 0; k < mb->vtop; k++) {
-               if (isVarCleanup(mb, k) ){
+       //      if (isVarCleanup(mb, k) ){
                        garbageElement(cntxt, v = &stk->stk[k]);
                        v->vtype = TYPE_int;
                        v->val.ival = int_nil;
-               }
+       //      }
        }
 #ifdef STACKTRACE
        if (cntxt) {
diff --git a/sql/backends/monet5/Tests/pyapi29.stable.out 
b/sql/backends/monet5/Tests/pyapi29.stable.out
--- a/sql/backends/monet5/Tests/pyapi29.stable.out
+++ b/sql/backends/monet5/Tests/pyapi29.stable.out
@@ -80,7 +80,7 @@ Ready.
 % n # name
 % clob # type
 % 20 # length
-[ "{'L1': array([ 5.])}"       ]
+[ "{'L5': array([ 5.])}"       ]
 #DROP TABLE mytable;
 #DROP FUNCTION myfunc;
 #ROLLBACK;
diff --git a/sql/backends/monet5/UDF/cudf/Tests/udf-fuse.stable.out 
b/sql/backends/monet5/UDF/cudf/Tests/udf-fuse.stable.out
--- a/sql/backends/monet5/UDF/cudf/Tests/udf-fuse.stable.out
+++ b/sql/backends/monet5/UDF/cudf/Tests/udf-fuse.stable.out
@@ -31,7 +31,7 @@ Ready.
 function user.s4_1():void;
     X_11:void := querylog.define("explain select 
fuse(1,2);","sequential_pipe",5);
     X_3:sht := udf.fuse(1,2);
-    sql.resultSet(".L1","L1","smallint",16,0,7,X_3);
+    sql.resultSet(".L2","L2","smallint",16,0,7,X_3);
 end user.s4_1;
 #inline               actions= 0 time=2 usec 
 #candidates           actions= 1 time=12 usec 
@@ -59,8 +59,8 @@ end user.s4_1;
 #garbageCollector     actions= 1 time=12 usec 
 #total                actions= 1 time=335 usec 
 #select fuse(1,2);
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
 % smallint # type
 % 3 # length
 [ 258  ]
@@ -72,7 +72,7 @@ end user.s4_1;
 function user.s6_1():void;
     X_11:void := querylog.define("explain select 
fuse(1000,2000);","sequential_pipe",5);
     X_3:int := udf.fuse(1000,2000);
-    sql.resultSet(".L1","L1","int",32,0,7,X_3);
+    sql.resultSet(".L2","L2","int",32,0,7,X_3);
 end user.s6_1;
 #inline               actions= 0 time=2 usec 
 #candidates           actions= 1 time=10 usec 
@@ -100,8 +100,8 @@ end user.s6_1;
 #garbageCollector     actions= 1 time=12 usec 
 #total                actions= 1 time=289 usec 
 #select fuse(1000,2000);
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
 % int # type
 % 8 # length
 [ 65538000     ]
@@ -113,7 +113,7 @@ end user.s6_1;
 function user.s8_1():void;
     X_11:void := querylog.define("explain select 
fuse(1000000,2000000);","sequential_pipe",5);
     X_3:lng := udf.fuse(1000000,2000000);
-    sql.resultSet(".L1","L1","bigint",64,0,7,X_3);
+    sql.resultSet(".L2","L2","bigint",64,0,7,X_3);
 end user.s8_1;
 #inline               actions= 0 time=3 usec 
 #candidates           actions= 1 time=10 usec 
@@ -141,8 +141,8 @@ end user.s8_1;
 #garbageCollector     actions= 1 time=13 usec 
 #total                actions= 1 time=284 usec 
 #select fuse(1000000,2000000);
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
 % bigint # type
 % 16 # length
 [ 4294967298000000     ]
@@ -172,9 +172,9 @@ end user.s8_1;
 function user.s16_1():void;
     X_42:void := querylog.define("explain select fuse(a,b) from 
udf_fuse;","sequential_pipe",21);
     X_25 := bat.new(nil:str);
-    X_32 := bat.append(X_25,"sys.L1");
+    X_32 := bat.append(X_25,"sys.L2");
     X_27 := bat.new(nil:str);
-    X_34 := bat.append(X_27,"L1");
+    X_34 := bat.append(X_27,"L2");
     X_28 := bat.new(nil:str);
     X_36 := bat.append(X_28,"smallint");
     X_29 := bat.new(nil:int);
@@ -223,9 +223,9 @@ end user.s16_1;
 function user.s18_1():void;
     X_42:void := querylog.define("explain select fuse(c,d) from 
udf_fuse;","sequential_pipe",21);
     X_25 := bat.new(nil:str);
-    X_32 := bat.append(X_25,"sys.L1");
+    X_32 := bat.append(X_25,"sys.L2");
     X_27 := bat.new(nil:str);
-    X_34 := bat.append(X_27,"L1");
+    X_34 := bat.append(X_27,"L2");
     X_28 := bat.new(nil:str);
     X_36 := bat.append(X_28,"int");
     X_29 := bat.new(nil:int);
@@ -274,9 +274,9 @@ end user.s18_1;
 function user.s20_1():void;
     X_42:void := querylog.define("explain select fuse(e,f) from 
udf_fuse;","sequential_pipe",21);
     X_25 := bat.new(nil:str);
-    X_32 := bat.append(X_25,"sys.L1");
+    X_32 := bat.append(X_25,"sys.L2");
     X_27 := bat.new(nil:str);
-    X_34 := bat.append(X_27,"L1");
+    X_34 := bat.append(X_27,"L2");
     X_28 := bat.new(nil:str);
     X_36 := bat.append(X_28,"bigint");
     X_29 := bat.new(nil:int);
@@ -318,8 +318,8 @@ end user.s20_1;
 #garbageCollector     actions= 1 time=19 usec 
 #total                actions= 1 time=348 usec 
 #select fuse(a,b) from udf_fuse;
-% sys.L1 # table_name
-% L1 # name
+% sys.L2 # table_name
+% L2 # name
 % smallint # type
 % 4 # length
 [ 258  ]
@@ -327,8 +327,8 @@ end user.s20_1;
 [ 1286 ]
 [ 1800 ]
 #select fuse(c,d) from udf_fuse;
-% sys.L1 # table_name
-% L1 # name
+% sys.L2 # table_name
+% L2 # name
 % int # type
 % 9 # length
 [ 65538000     ]
@@ -336,8 +336,8 @@ end user.s20_1;
 [ 327686000    ]
 [ 458760000    ]
 #select fuse(e,f) from udf_fuse;
-% sys.L1 # table_name
-% L1 # name
+% sys.L2 # table_name
+% L2 # name
 % bigint # type
 % 17 # length
 [ 4294967298000000     ]
diff --git a/sql/backends/monet5/UDF/cudf/Tests/udf-reverse.stable.out 
b/sql/backends/monet5/UDF/cudf/Tests/udf-reverse.stable.out
--- a/sql/backends/monet5/UDF/cudf/Tests/udf-reverse.stable.out
+++ b/sql/backends/monet5/UDF/cudf/Tests/udf-reverse.stable.out
@@ -52,7 +52,7 @@ Ready.
 function user.s4_1():void;
     X_10:void := querylog.define("explain select 
reverse(\\'MonetDB\\');","sequential_pipe",5);
     X_2:str := udf.reverse("MonetDB");
-    sql.resultSet(".L1","L1","clob",0,0,4,X_2);
+    sql.resultSet(".L2","L2","clob",0,0,4,X_2);
 end user.s4_1;
 #inline               actions= 0 time=2 usec 
 #candidates           actions= 1 time=8 usec 
@@ -80,8 +80,8 @@ end user.s4_1;
 #garbageCollector     actions= 1 time=9 usec 
 #total                actions= 1 time=204 usec 
 #select reverse('MonetDB');
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
 % clob # type
 % 7 # length
 [ "BDtenoM"    ]
@@ -111,9 +111,9 @@ end user.s4_1;
 function user.s12_1():void;
     X_33:void := querylog.define("explain select reverse(x) from 
udf_reverse;","sequential_pipe",19);
     X_18 := bat.new(nil:str);
-    X_25 := bat.append(X_18,"sys.L1");
+    X_25 := bat.append(X_18,"sys.L2");
     X_20 := bat.new(nil:str);
-    X_27 := bat.append(X_20,"L1");
+    X_27 := bat.append(X_20,"L2");
     X_21 := bat.new(nil:str);
     X_29 := bat.append(X_21,"clob");
     X_22 := bat.new(nil:int);
@@ -153,8 +153,8 @@ end user.s12_1;
 #garbageCollector     actions= 1 time=15 usec 
 #total                actions= 1 time=291 usec 
 #select reverse(x) from udf_reverse;
-% sys.L1 # table_name
-% L1 # name
+% sys.L2 # table_name
+% L2 # name
 % clob # type
 % 30 # length
 [ "BDtenoM"    ]
diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/rel_bin.c
--- a/sql/backends/monet5/rel_bin.c
+++ b/sql/backends/monet5/rel_bin.c
@@ -1926,11 +1926,11 @@ rel2bin_semijoin( mvc *sql, sql_rel *rel
                join = stmt_join(sql->sa, l, r, cmp_all); 
        }
        jl = stmt_result(sql->sa, join, 0);
-       jr = stmt_result(sql->sa, join, 1);
        if (en) {
                stmt *sub, *sel = NULL;
                list *nl;
 
+               jr = stmt_result(sql->sa, join, 1);
                /* construct relation */
                nl = sa_list(sql->sa);
 
diff --git a/sql/backends/monet5/sql_execute.c 
b/sql/backends/monet5/sql_execute.c
--- a/sql/backends/monet5/sql_execute.c
+++ b/sql/backends/monet5/sql_execute.c
@@ -252,9 +252,7 @@ SQLexecutePrepared(Client c, backend *be
                v->vtype = TYPE_int;
                v->val.ival = int_nil;
        }
-       if (glb && ret) /* error */
-               garbageCollector(c, mb, glb, glb != 0);
-       q->stk = (backend_stack) glb;
+       q->stk = (backend_stack) glb; /* save garbageCollected stack */
        if (glb && SQLdebug & 1)
                printStack(GDKstdout, mb, glb);
        if (pci->argc >= MAXARG)
diff --git a/sql/backends/monet5/vaults/bam/Tests/bam_lib.stable.out 
b/sql/backends/monet5/vaults/bam/Tests/bam_lib.stable.out
--- a/sql/backends/monet5/vaults/bam/Tests/bam_lib.stable.out
+++ b/sql/backends/monet5/vaults/bam/Tests/bam_lib.stable.out
@@ -26,218 +26,218 @@ Ready.
 
 #SET SCHEMA bam;
 #SELECT bam_flag(1, 'mult_segm');
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
 % boolean # type
 % 5 # length
 [ true ]
 #SELECT bam_flag(2, 'prop_alig');
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
 % boolean # type
 % 5 # length
 [ true ]
 #SELECT bam_flag(4, 'segm_unma');
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
 % boolean # type
 % 5 # length
 [ true ]
 #SELECT bam_flag(8, 'next_unma');
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
 % boolean # type
 % 5 # length
 [ true ]
 #SELECT bam_flag(16, 'segm_reve');
-% .L1 # table_name
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to