Changeset: 139802b66396 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=139802b66396 Added Files: sql/test/BugTracker-2015/Tests/cast_to_num.Bug-3744.sql sql/test/BugTracker-2015/Tests/cast_to_num.Bug-3744.stable.err sql/test/BugTracker-2015/Tests/cast_to_num.Bug-3744.stable.out sql/test/BugTracker-2015/Tests/div_zero.Bug-3742.sql sql/test/BugTracker-2015/Tests/div_zero.Bug-3742.stable.err sql/test/BugTracker-2015/Tests/div_zero.Bug-3742.stable.out Modified Files: clients/Tests/SQL-dump.stable.out.int128 sql/backends/monet5/sql_cast_impl_down_from_int.h sql/common/sql_types.c sql/test/BugTracker-2012/Tests/incorrect_cast_from_double_to_int.Bug-2579.stable.err sql/test/BugTracker-2012/Tests/incorrect_cast_from_double_to_int.Bug-2579.stable.out sql/test/BugTracker-2012/Tests/now_results_in_illegal_argument.Bug-2978.sql sql/test/BugTracker-2012/Tests/now_results_in_illegal_argument.Bug-2978.stable.err sql/test/BugTracker-2012/Tests/now_results_in_illegal_argument.Bug-2978.stable.out sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out sql/test/BugTracker-2015/Tests/All sql/test/pg_regress/Tests/date.stable.err sql/test/pg_regress/Tests/time.stable.err sql/test/pg_regress/Tests/timetz.stable.err Branch: Jul2015 Log Message:
fixed bug 3744 and 3742 ie properly trunk when casting to an integer div_zero (allready worked) problem was the compare with interval 0 seconds failed diffs (truncated from 2016 to 300 lines): diff --git a/clients/Tests/SQL-dump.stable.out.int128 b/clients/Tests/SQL-dump.stable.out.int128 --- a/clients/Tests/SQL-dump.stable.out.int128 +++ b/clients/Tests/SQL-dump.stable.out.int128 @@ -2062,17 +2062,17 @@ 2391 139 "arg_2" "oid" 63 0 1 2 2392 140 "res_0" "month_interval" 32 0 0 0 2393 140 "arg_1" "month_interval" 32 0 1 1 2394 140 "arg_2" "oid" 63 0 1 2 -2395 141 "res_0" "sec_interval" 19 0 0 0 -2396 141 "arg_1" "sec_interval" 19 0 1 1 +2395 141 "res_0" "sec_interval" 13 0 0 0 +2396 141 "arg_1" "sec_interval" 13 0 1 1 2397 141 "arg_2" "oid" 63 0 1 2 -2398 142 "res_0" "sec_interval" 19 0 0 0 -2399 142 "arg_1" "sec_interval" 19 0 1 1 +2398 142 "res_0" "sec_interval" 13 0 0 0 +2399 142 "arg_1" "sec_interval" 13 0 1 1 2400 142 "arg_2" "oid" 63 0 1 2 -2401 143 "res_0" "sec_interval" 19 0 0 0 -2402 143 "arg_1" "sec_interval" 19 0 1 1 +2401 143 "res_0" "sec_interval" 13 0 0 0 +2402 143 "arg_1" "sec_interval" 13 0 1 1 2403 143 "arg_2" "oid" 63 0 1 2 -2404 144 "res_0" "sec_interval" 19 0 0 0 -2405 144 "arg_1" "sec_interval" 19 0 1 1 +2404 144 "res_0" "sec_interval" 13 0 0 0 +2405 144 "arg_1" "sec_interval" 13 0 1 1 2406 144 "arg_2" "oid" 63 0 1 2 2407 145 "res_0" "tinyint" 8 0 0 0 2408 145 "arg_1" "tinyint" 8 0 1 1 @@ -2127,17 +2127,17 @@ 2456 162 "arg_2" "tinyint" 8 0 1 2 2457 163 "res_0" "month_interval" 32 0 0 0 2458 163 "arg_1" "month_interval" 32 0 1 1 2459 163 "arg_2" "tinyint" 8 0 1 2 -2460 164 "res_0" "sec_interval" 19 0 0 0 -2461 164 "arg_1" "sec_interval" 19 0 1 1 +2460 164 "res_0" "sec_interval" 13 0 0 0 +2461 164 "arg_1" "sec_interval" 13 0 1 1 2462 164 "arg_2" "tinyint" 8 0 1 2 -2463 165 "res_0" "sec_interval" 19 0 0 0 -2464 165 "arg_1" "sec_interval" 19 0 1 1 +2463 165 "res_0" "sec_interval" 13 0 0 0 +2464 165 "arg_1" "sec_interval" 13 0 1 1 2465 165 "arg_2" "tinyint" 8 0 1 2 -2466 166 "res_0" "sec_interval" 19 0 0 0 -2467 166 "arg_1" "sec_interval" 19 0 1 1 +2466 166 "res_0" "sec_interval" 13 0 0 0 +2467 166 "arg_1" "sec_interval" 13 0 1 1 2468 166 "arg_2" "tinyint" 8 0 1 2 -2469 167 "res_0" "sec_interval" 19 0 0 0 -2470 167 "arg_1" "sec_interval" 19 0 1 1 +2469 167 "res_0" "sec_interval" 13 0 0 0 +2470 167 "arg_1" "sec_interval" 13 0 1 1 2471 167 "arg_2" "tinyint" 8 0 1 2 2472 168 "res_0" "smallint" 16 0 0 0 2473 168 "arg_1" "smallint" 16 0 1 1 @@ -2192,17 +2192,17 @@ 2521 185 "arg_2" "smallint" 16 0 1 2 2522 186 "res_0" "month_interval" 32 0 0 0 2523 186 "arg_1" "month_interval" 32 0 1 1 2524 186 "arg_2" "smallint" 16 0 1 2 -2525 187 "res_0" "sec_interval" 19 0 0 0 -2526 187 "arg_1" "sec_interval" 19 0 1 1 +2525 187 "res_0" "sec_interval" 13 0 0 0 +2526 187 "arg_1" "sec_interval" 13 0 1 1 2527 187 "arg_2" "smallint" 16 0 1 2 -2528 188 "res_0" "sec_interval" 19 0 0 0 -2529 188 "arg_1" "sec_interval" 19 0 1 1 +2528 188 "res_0" "sec_interval" 13 0 0 0 +2529 188 "arg_1" "sec_interval" 13 0 1 1 2530 188 "arg_2" "smallint" 16 0 1 2 -2531 189 "res_0" "sec_interval" 19 0 0 0 -2532 189 "arg_1" "sec_interval" 19 0 1 1 +2531 189 "res_0" "sec_interval" 13 0 0 0 +2532 189 "arg_1" "sec_interval" 13 0 1 1 2533 189 "arg_2" "smallint" 16 0 1 2 -2534 190 "res_0" "sec_interval" 19 0 0 0 -2535 190 "arg_1" "sec_interval" 19 0 1 1 +2534 190 "res_0" "sec_interval" 13 0 0 0 +2535 190 "arg_1" "sec_interval" 13 0 1 1 2536 190 "arg_2" "smallint" 16 0 1 2 2537 191 "res_0" "int" 32 0 0 0 2538 191 "arg_1" "int" 32 0 1 1 @@ -2257,17 +2257,17 @@ 2586 208 "arg_2" "int" 32 0 1 2 2587 209 "res_0" "month_interval" 32 0 0 0 2588 209 "arg_1" "month_interval" 32 0 1 1 2589 209 "arg_2" "int" 32 0 1 2 -2590 210 "res_0" "sec_interval" 19 0 0 0 -2591 210 "arg_1" "sec_interval" 19 0 1 1 +2590 210 "res_0" "sec_interval" 13 0 0 0 +2591 210 "arg_1" "sec_interval" 13 0 1 1 2592 210 "arg_2" "int" 32 0 1 2 -2593 211 "res_0" "sec_interval" 19 0 0 0 -2594 211 "arg_1" "sec_interval" 19 0 1 1 +2593 211 "res_0" "sec_interval" 13 0 0 0 +2594 211 "arg_1" "sec_interval" 13 0 1 1 2595 211 "arg_2" "int" 32 0 1 2 -2596 212 "res_0" "sec_interval" 19 0 0 0 -2597 212 "arg_1" "sec_interval" 19 0 1 1 +2596 212 "res_0" "sec_interval" 13 0 0 0 +2597 212 "arg_1" "sec_interval" 13 0 1 1 2598 212 "arg_2" "int" 32 0 1 2 -2599 213 "res_0" "sec_interval" 19 0 0 0 -2600 213 "arg_1" "sec_interval" 19 0 1 1 +2599 213 "res_0" "sec_interval" 13 0 0 0 +2600 213 "arg_1" "sec_interval" 13 0 1 1 2601 213 "arg_2" "int" 32 0 1 2 2602 214 "res_0" "bigint" 64 0 0 0 2603 214 "arg_1" "bigint" 64 0 1 1 @@ -2322,17 +2322,17 @@ 2651 231 "arg_2" "bigint" 64 0 1 2 2652 232 "res_0" "month_interval" 32 0 0 0 2653 232 "arg_1" "month_interval" 32 0 1 1 2654 232 "arg_2" "bigint" 64 0 1 2 -2655 233 "res_0" "sec_interval" 19 0 0 0 -2656 233 "arg_1" "sec_interval" 19 0 1 1 +2655 233 "res_0" "sec_interval" 13 0 0 0 +2656 233 "arg_1" "sec_interval" 13 0 1 1 2657 233 "arg_2" "bigint" 64 0 1 2 -2658 234 "res_0" "sec_interval" 19 0 0 0 -2659 234 "arg_1" "sec_interval" 19 0 1 1 +2658 234 "res_0" "sec_interval" 13 0 0 0 +2659 234 "arg_1" "sec_interval" 13 0 1 1 2660 234 "arg_2" "bigint" 64 0 1 2 -2661 235 "res_0" "sec_interval" 19 0 0 0 -2662 235 "arg_1" "sec_interval" 19 0 1 1 +2661 235 "res_0" "sec_interval" 13 0 0 0 +2662 235 "arg_1" "sec_interval" 13 0 1 1 2663 235 "arg_2" "bigint" 64 0 1 2 -2664 236 "res_0" "sec_interval" 19 0 0 0 -2665 236 "arg_1" "sec_interval" 19 0 1 1 +2664 236 "res_0" "sec_interval" 13 0 0 0 +2665 236 "arg_1" "sec_interval" 13 0 1 1 2666 236 "arg_2" "bigint" 64 0 1 2 2667 237 "res_0" "wrd" 64 0 0 0 2668 237 "arg_1" "wrd" 64 0 1 1 @@ -2387,17 +2387,17 @@ 2716 254 "arg_2" "wrd" 64 0 1 2 2717 255 "res_0" "month_interval" 32 0 0 0 2718 255 "arg_1" "month_interval" 32 0 1 1 2719 255 "arg_2" "wrd" 64 0 1 2 -2720 256 "res_0" "sec_interval" 19 0 0 0 -2721 256 "arg_1" "sec_interval" 19 0 1 1 +2720 256 "res_0" "sec_interval" 13 0 0 0 +2721 256 "arg_1" "sec_interval" 13 0 1 1 2722 256 "arg_2" "wrd" 64 0 1 2 -2723 257 "res_0" "sec_interval" 19 0 0 0 -2724 257 "arg_1" "sec_interval" 19 0 1 1 +2723 257 "res_0" "sec_interval" 13 0 0 0 +2724 257 "arg_1" "sec_interval" 13 0 1 1 2725 257 "arg_2" "wrd" 64 0 1 2 -2726 258 "res_0" "sec_interval" 19 0 0 0 -2727 258 "arg_1" "sec_interval" 19 0 1 1 +2726 258 "res_0" "sec_interval" 13 0 0 0 +2727 258 "arg_1" "sec_interval" 13 0 1 1 2728 258 "arg_2" "wrd" 64 0 1 2 -2729 259 "res_0" "sec_interval" 19 0 0 0 -2730 259 "arg_1" "sec_interval" 19 0 1 1 +2729 259 "res_0" "sec_interval" 13 0 0 0 +2730 259 "arg_1" "sec_interval" 13 0 1 1 2731 259 "arg_2" "wrd" 64 0 1 2 2732 260 "res_0" "hugeint" 128 0 0 0 2733 260 "arg_1" "hugeint" 128 0 1 1 @@ -2452,17 +2452,17 @@ 2781 277 "arg_2" "hugeint" 128 0 1 2 2782 278 "res_0" "month_interval" 32 0 0 0 2783 278 "arg_1" "month_interval" 32 0 1 1 2784 278 "arg_2" "hugeint" 128 0 1 2 -2785 279 "res_0" "sec_interval" 19 0 0 0 -2786 279 "arg_1" "sec_interval" 19 0 1 1 +2785 279 "res_0" "sec_interval" 13 0 0 0 +2786 279 "arg_1" "sec_interval" 13 0 1 1 2787 279 "arg_2" "hugeint" 128 0 1 2 -2788 280 "res_0" "sec_interval" 19 0 0 0 -2789 280 "arg_1" "sec_interval" 19 0 1 1 +2788 280 "res_0" "sec_interval" 13 0 0 0 +2789 280 "arg_1" "sec_interval" 13 0 1 1 2790 280 "arg_2" "hugeint" 128 0 1 2 -2791 281 "res_0" "sec_interval" 19 0 0 0 -2792 281 "arg_1" "sec_interval" 19 0 1 1 +2791 281 "res_0" "sec_interval" 13 0 0 0 +2792 281 "arg_1" "sec_interval" 13 0 1 1 2793 281 "arg_2" "hugeint" 128 0 1 2 -2794 282 "res_0" "sec_interval" 19 0 0 0 -2795 282 "arg_1" "sec_interval" 19 0 1 1 +2794 282 "res_0" "sec_interval" 13 0 0 0 +2795 282 "arg_1" "sec_interval" 13 0 1 1 2796 282 "arg_2" "hugeint" 128 0 1 2 2797 283 "res_0" "decimal" 2 0 0 0 2798 283 "arg_1" "decimal" 2 0 1 1 @@ -2517,17 +2517,17 @@ 2846 300 "arg_2" "decimal" 2 0 1 2 2847 301 "res_0" "month_interval" 32 0 0 0 2848 301 "arg_1" "month_interval" 32 0 1 1 2849 301 "arg_2" "decimal" 2 0 1 2 -2850 302 "res_0" "sec_interval" 19 0 0 0 -2851 302 "arg_1" "sec_interval" 19 0 1 1 +2850 302 "res_0" "sec_interval" 13 0 0 0 +2851 302 "arg_1" "sec_interval" 13 0 1 1 2852 302 "arg_2" "decimal" 2 0 1 2 -2853 303 "res_0" "sec_interval" 19 0 0 0 -2854 303 "arg_1" "sec_interval" 19 0 1 1 +2853 303 "res_0" "sec_interval" 13 0 0 0 +2854 303 "arg_1" "sec_interval" 13 0 1 1 2855 303 "arg_2" "decimal" 2 0 1 2 -2856 304 "res_0" "sec_interval" 19 0 0 0 -2857 304 "arg_1" "sec_interval" 19 0 1 1 +2856 304 "res_0" "sec_interval" 13 0 0 0 +2857 304 "arg_1" "sec_interval" 13 0 1 1 2858 304 "arg_2" "decimal" 2 0 1 2 -2859 305 "res_0" "sec_interval" 19 0 0 0 -2860 305 "arg_1" "sec_interval" 19 0 1 1 +2859 305 "res_0" "sec_interval" 13 0 0 0 +2860 305 "arg_1" "sec_interval" 13 0 1 1 2861 305 "arg_2" "decimal" 2 0 1 2 2862 306 "res_0" "decimal" 4 0 0 0 2863 306 "arg_1" "decimal" 4 0 1 1 @@ -2582,17 +2582,17 @@ 2911 323 "arg_2" "decimal" 4 0 1 2 2912 324 "res_0" "month_interval" 32 0 0 0 2913 324 "arg_1" "month_interval" 32 0 1 1 2914 324 "arg_2" "decimal" 4 0 1 2 -2915 325 "res_0" "sec_interval" 19 0 0 0 -2916 325 "arg_1" "sec_interval" 19 0 1 1 +2915 325 "res_0" "sec_interval" 13 0 0 0 +2916 325 "arg_1" "sec_interval" 13 0 1 1 2917 325 "arg_2" "decimal" 4 0 1 2 -2918 326 "res_0" "sec_interval" 19 0 0 0 -2919 326 "arg_1" "sec_interval" 19 0 1 1 +2918 326 "res_0" "sec_interval" 13 0 0 0 +2919 326 "arg_1" "sec_interval" 13 0 1 1 2920 326 "arg_2" "decimal" 4 0 1 2 -2921 327 "res_0" "sec_interval" 19 0 0 0 -2922 327 "arg_1" "sec_interval" 19 0 1 1 +2921 327 "res_0" "sec_interval" 13 0 0 0 +2922 327 "arg_1" "sec_interval" 13 0 1 1 2923 327 "arg_2" "decimal" 4 0 1 2 -2924 328 "res_0" "sec_interval" 19 0 0 0 -2925 328 "arg_1" "sec_interval" 19 0 1 1 +2924 328 "res_0" "sec_interval" 13 0 0 0 +2925 328 "arg_1" "sec_interval" 13 0 1 1 2926 328 "arg_2" "decimal" 4 0 1 2 2927 329 "res_0" "decimal" 9 0 0 0 2928 329 "arg_1" "decimal" 9 0 1 1 @@ -2647,17 +2647,17 @@ 2976 346 "arg_2" "decimal" 9 0 1 2 2977 347 "res_0" "month_interval" 32 0 0 0 2978 347 "arg_1" "month_interval" 32 0 1 1 2979 347 "arg_2" "decimal" 9 0 1 2 -2980 348 "res_0" "sec_interval" 19 0 0 0 -2981 348 "arg_1" "sec_interval" 19 0 1 1 +2980 348 "res_0" "sec_interval" 13 0 0 0 +2981 348 "arg_1" "sec_interval" 13 0 1 1 2982 348 "arg_2" "decimal" 9 0 1 2 -2983 349 "res_0" "sec_interval" 19 0 0 0 -2984 349 "arg_1" "sec_interval" 19 0 1 1 +2983 349 "res_0" "sec_interval" 13 0 0 0 +2984 349 "arg_1" "sec_interval" 13 0 1 1 2985 349 "arg_2" "decimal" 9 0 1 2 -2986 350 "res_0" "sec_interval" 19 0 0 0 -2987 350 "arg_1" "sec_interval" 19 0 1 1 +2986 350 "res_0" "sec_interval" 13 0 0 0 +2987 350 "arg_1" "sec_interval" 13 0 1 1 2988 350 "arg_2" "decimal" 9 0 1 2 -2989 351 "res_0" "sec_interval" 19 0 0 0 -2990 351 "arg_1" "sec_interval" 19 0 1 1 +2989 351 "res_0" "sec_interval" 13 0 0 0 +2990 351 "arg_1" "sec_interval" 13 0 1 1 2991 351 "arg_2" "decimal" 9 0 1 2 2992 352 "res_0" "decimal" 18 0 0 0 2993 352 "arg_1" "decimal" 18 0 1 1 @@ -2712,17 +2712,17 @@ 3041 369 "arg_2" "decimal" 18 0 1 2 3042 370 "res_0" "month_interval" 32 0 0 0 3043 370 "arg_1" "month_interval" 32 0 1 1 3044 370 "arg_2" "decimal" 18 0 1 2 -3045 371 "res_0" "sec_interval" 19 0 0 0 -3046 371 "arg_1" "sec_interval" 19 0 1 1 +3045 371 "res_0" "sec_interval" 13 0 0 0 +3046 371 "arg_1" "sec_interval" 13 0 1 1 3047 371 "arg_2" "decimal" 18 0 1 2 -3048 372 "res_0" "sec_interval" 19 0 0 0 -3049 372 "arg_1" "sec_interval" 19 0 1 1 +3048 372 "res_0" "sec_interval" 13 0 0 0 +3049 372 "arg_1" "sec_interval" 13 0 1 1 3050 372 "arg_2" "decimal" 18 0 1 2 -3051 373 "res_0" "sec_interval" 19 0 0 0 -3052 373 "arg_1" "sec_interval" 19 0 1 1 +3051 373 "res_0" "sec_interval" 13 0 0 0 +3052 373 "arg_1" "sec_interval" 13 0 1 1 3053 373 "arg_2" "decimal" 18 0 1 2 -3054 374 "res_0" "sec_interval" 19 0 0 0 -3055 374 "arg_1" "sec_interval" 19 0 1 1 +3054 374 "res_0" "sec_interval" 13 0 0 0 +3055 374 "arg_1" "sec_interval" 13 0 1 1 3056 374 "arg_2" "decimal" 18 0 1 2 3057 375 "res_0" "decimal" 39 0 0 0 3058 375 "arg_1" "decimal" 39 0 1 1 @@ -2777,17 +2777,17 @@ 3106 392 "arg_2" "decimal" 39 0 1 2 3107 393 "res_0" "month_interval" 32 0 0 0 3108 393 "arg_1" "month_interval" 32 0 1 1 3109 393 "arg_2" "decimal" 39 0 1 2 -3110 394 "res_0" "sec_interval" 19 0 0 0 -3111 394 "arg_1" "sec_interval" 19 0 1 1 +3110 394 "res_0" "sec_interval" 13 0 0 0 +3111 394 "arg_1" "sec_interval" 13 0 1 1 3112 394 "arg_2" "decimal" 39 0 1 2 -3113 395 "res_0" "sec_interval" 19 0 0 0 -3114 395 "arg_1" "sec_interval" 19 0 1 1 _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
