Changeset: ce0bdd28c306 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ce0bdd28c306 Added Files: sql/test/BugTracker-2013/Tests/python-explain.Bug-3380.SQL.py sql/test/BugTracker-2013/Tests/python-explain.Bug-3380.stable.err sql/test/BugTracker-2013/Tests/python-explain.Bug-3380.stable.out sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.sql sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.err sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out Modified Files: clients/Tests/SQL-dump.stable.out clients/odbc/driver/SQLGetTypeInfo.c clients/python2/monetdb/mapi.py clients/python2/monetdb/sql/cursors.py clients/python3/monetdb/mapi.py clients/python3/monetdb/sql/cursors.py gdk/gdk_align.c sql/backends/monet5/LSST/Tests/lsst_htmxmatch.stable.out sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_gencode.c sql/backends/monet5/sql_statement.c sql/backends/monet5/sql_statement.h sql/benchmarks/tpch/LOCKED/Tests/01-22.stable.out sql/benchmarks/tpch/LOCKED/Tests/01.stable.out sql/benchmarks/tpch/LOCKED/Tests/03.stable.out sql/benchmarks/tpch/LOCKED/Tests/05.stable.out sql/benchmarks/tpch/LOCKED/Tests/06.stable.out sql/benchmarks/tpch/LOCKED/Tests/07.stable.out sql/benchmarks/tpch/LOCKED/Tests/08.stable.out sql/benchmarks/tpch/LOCKED/Tests/09.stable.out sql/benchmarks/tpch/LOCKED/Tests/10.stable.out sql/benchmarks/tpch/LOCKED/Tests/11.stable.out sql/benchmarks/tpch/LOCKED/Tests/14.stable.out sql/benchmarks/tpch/LOCKED/Tests/15.stable.out sql/benchmarks/tpch/LOCKED/Tests/19.stable.out sql/benchmarks/tpch/Tests/01-22.stable.out sql/benchmarks/tpch/Tests/01-explain.stable.out sql/benchmarks/tpch/Tests/01.stable.out sql/benchmarks/tpch/Tests/03-explain.stable.out sql/benchmarks/tpch/Tests/03.stable.out sql/benchmarks/tpch/Tests/05-explain.stable.out sql/benchmarks/tpch/Tests/05.stable.out sql/benchmarks/tpch/Tests/06-explain.stable.out sql/benchmarks/tpch/Tests/06.stable.out sql/benchmarks/tpch/Tests/07-explain.stable.out sql/benchmarks/tpch/Tests/07.stable.out sql/benchmarks/tpch/Tests/08-explain.stable.out sql/benchmarks/tpch/Tests/08-plan.stable.out sql/benchmarks/tpch/Tests/08.stable.out sql/benchmarks/tpch/Tests/09-explain.stable.out sql/benchmarks/tpch/Tests/09.stable.out sql/benchmarks/tpch/Tests/10-explain.stable.out sql/benchmarks/tpch/Tests/10.stable.out sql/benchmarks/tpch/Tests/11-explain.stable.out sql/benchmarks/tpch/Tests/11.stable.out sql/benchmarks/tpch/Tests/14-explain.stable.out sql/benchmarks/tpch/Tests/14-plan.stable.out sql/benchmarks/tpch/Tests/14.stable.out sql/benchmarks/tpch/Tests/15-explain.stable.out sql/benchmarks/tpch/Tests/15.stable.out sql/benchmarks/tpch/Tests/19-explain.stable.out sql/benchmarks/tpch/Tests/19.stable.out sql/benchmarks/tpch/Tests/20-explain.stable.out sql/benchmarks/tpch/Tests/20-plan.stable.out sql/common/sql_types.c sql/server/rel_exp.c sql/server/rel_select.c sql/test/BugTracker-2008/Tests/extract_bug.SF-2075266.stable.out sql/test/BugTracker-2008/Tests/mul_div_bug.SF-2075135.stable.out sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.stable.out sql/test/BugTracker-2011/Tests/and-power.Bug-3013.stable.out sql/test/BugTracker-2011/Tests/non-stable-select-bug.Bug-2894.stable.out sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.out sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.stable.out sql/test/BugTracker-2013/Tests/All Branch: default Log Message:
Merge with Feb2013 branch. diffs (truncated from 1888 to 300 lines): diff --git a/clients/Tests/SQL-dump.stable.out b/clients/Tests/SQL-dump.stable.out --- a/clients/Tests/SQL-dump.stable.out +++ b/clients/Tests/SQL-dump.stable.out @@ -2021,9 +2021,9 @@ 2225 75 "arg_2" "decimal" 4 0 2 2226 76 "result" "decimal" 9 0 0 2227 76 "arg_1" "decimal" 9 0 1 2228 76 "arg_2" "decimal" 9 0 2 -2229 77 "result" "decimal" 18 0 0 -2230 77 "arg_1" "decimal" 18 0 1 -2231 77 "arg_2" "decimal" 18 0 2 +2229 77 "result" "decimal" 19 0 0 +2230 77 "arg_1" "decimal" 19 0 1 +2231 77 "arg_2" "decimal" 19 0 2 2232 78 "result" "real" 24 0 0 2233 78 "arg_1" "real" 24 0 1 2234 78 "arg_2" "real" 24 0 2 @@ -2709,71 +2709,71 @@ 2913 319 "arg_2" "decimal" 9 0 2 2914 320 "result" "sec_interval" 19 0 0 2915 320 "arg_1" "sec_interval" 19 0 1 2916 320 "arg_2" "decimal" 9 0 2 -2917 321 "result" "decimal" 18 0 0 -2918 321 "arg_1" "decimal" 18 0 1 -2919 321 "arg_2" "decimal" 18 0 2 -2920 322 "result" "decimal" 18 0 0 -2921 322 "arg_1" "decimal" 18 0 1 -2922 322 "arg_2" "decimal" 18 0 2 -2923 323 "result" "decimal" 18 0 0 -2924 323 "arg_1" "decimal" 18 0 1 -2925 323 "arg_2" "decimal" 18 0 2 -2926 324 "result" "decimal" 18 0 0 -2927 324 "arg_1" "decimal" 18 0 1 -2928 324 "arg_2" "decimal" 18 0 2 -2929 325 "result" "decimal" 18 0 0 -2930 325 "arg_1" "decimal" 18 0 1 -2931 325 "arg_2" "decimal" 18 0 2 -2932 326 "result" "decimal" 18 0 0 -2933 326 "arg_1" "decimal" 18 0 1 -2934 326 "arg_2" "decimal" 18 0 2 -2935 327 "result" "decimal" 18 0 0 -2936 327 "arg_1" "decimal" 18 0 1 -2937 327 "arg_2" "decimal" 18 0 2 -2938 328 "result" "decimal" 18 0 0 -2939 328 "arg_1" "decimal" 18 0 1 -2940 329 "result" "decimal" 18 0 0 -2941 329 "arg_1" "decimal" 18 0 1 +2917 321 "result" "decimal" 19 0 0 +2918 321 "arg_1" "decimal" 19 0 1 +2919 321 "arg_2" "decimal" 19 0 2 +2920 322 "result" "decimal" 19 0 0 +2921 322 "arg_1" "decimal" 19 0 1 +2922 322 "arg_2" "decimal" 19 0 2 +2923 323 "result" "decimal" 19 0 0 +2924 323 "arg_1" "decimal" 19 0 1 +2925 323 "arg_2" "decimal" 19 0 2 +2926 324 "result" "decimal" 19 0 0 +2927 324 "arg_1" "decimal" 19 0 1 +2928 324 "arg_2" "decimal" 19 0 2 +2929 325 "result" "decimal" 19 0 0 +2930 325 "arg_1" "decimal" 19 0 1 +2931 325 "arg_2" "decimal" 19 0 2 +2932 326 "result" "decimal" 19 0 0 +2933 326 "arg_1" "decimal" 19 0 1 +2934 326 "arg_2" "decimal" 19 0 2 +2935 327 "result" "decimal" 19 0 0 +2936 327 "arg_1" "decimal" 19 0 1 +2937 327 "arg_2" "decimal" 19 0 2 +2938 328 "result" "decimal" 19 0 0 +2939 328 "arg_1" "decimal" 19 0 1 +2940 329 "result" "decimal" 19 0 0 +2941 329 "arg_1" "decimal" 19 0 1 2942 329 "arg_2" "int" 32 0 2 -2943 330 "result" "decimal" 18 0 0 -2944 330 "arg_1" "decimal" 18 0 1 +2943 330 "result" "decimal" 19 0 0 +2944 330 "arg_1" "decimal" 19 0 1 2945 330 "arg_2" "int" 32 0 2 -2946 331 "result" "decimal" 18 0 0 -2947 331 "arg_1" "decimal" 18 0 1 -2948 332 "result" "decimal" 18 0 0 -2949 332 "arg_1" "decimal" 18 0 1 +2946 331 "result" "decimal" 19 0 0 +2947 331 "arg_1" "decimal" 19 0 1 +2948 332 "result" "decimal" 19 0 0 +2949 332 "arg_1" "decimal" 19 0 1 2950 333 "result" "tinyint" 8 0 0 -2951 333 "arg_1" "decimal" 18 0 1 -2952 334 "result" "decimal" 18 0 0 -2953 334 "arg_1" "decimal" 18 0 1 +2951 333 "arg_1" "decimal" 19 0 1 +2952 334 "result" "decimal" 19 0 0 +2953 334 "arg_1" "decimal" 19 0 1 2954 334 "arg_2" "bigint" 64 0 2 -2955 335 "result" "decimal" 18 0 0 -2956 335 "arg_1" "decimal" 18 0 1 +2955 335 "result" "decimal" 19 0 0 +2956 335 "arg_1" "decimal" 19 0 1 2957 335 "arg_2" "bigint" 64 0 2 2958 336 "result" "month_interval" 32 0 0 2959 336 "arg_1" "month_interval" 32 0 1 -2960 336 "arg_2" "decimal" 18 0 2 +2960 336 "arg_2" "decimal" 19 0 2 2961 337 "result" "month_interval" 32 0 0 2962 337 "arg_1" "month_interval" 32 0 1 -2963 337 "arg_2" "decimal" 18 0 2 +2963 337 "arg_2" "decimal" 19 0 2 2964 338 "result" "month_interval" 32 0 0 2965 338 "arg_1" "month_interval" 32 0 1 -2966 338 "arg_2" "decimal" 18 0 2 +2966 338 "arg_2" "decimal" 19 0 2 2967 339 "result" "month_interval" 32 0 0 2968 339 "arg_1" "month_interval" 32 0 1 -2969 339 "arg_2" "decimal" 18 0 2 +2969 339 "arg_2" "decimal" 19 0 2 2970 340 "result" "sec_interval" 19 0 0 2971 340 "arg_1" "sec_interval" 19 0 1 -2972 340 "arg_2" "decimal" 18 0 2 +2972 340 "arg_2" "decimal" 19 0 2 2973 341 "result" "sec_interval" 19 0 0 2974 341 "arg_1" "sec_interval" 19 0 1 -2975 341 "arg_2" "decimal" 18 0 2 +2975 341 "arg_2" "decimal" 19 0 2 2976 342 "result" "sec_interval" 19 0 0 2977 342 "arg_1" "sec_interval" 19 0 1 -2978 342 "arg_2" "decimal" 18 0 2 +2978 342 "arg_2" "decimal" 19 0 2 2979 343 "result" "sec_interval" 19 0 0 2980 343 "arg_1" "sec_interval" 19 0 1 -2981 343 "arg_2" "decimal" 18 0 2 +2981 343 "arg_2" "decimal" 19 0 2 2982 344 "result" "real" 24 0 0 2983 344 "arg_1" "real" 24 0 1 2984 344 "arg_2" "real" 24 0 2 @@ -2954,48 +2954,48 @@ 3158 406 "arg_2" "decimal" 4 0 2 3159 407 "result" "decimal" 9 0 0 3160 407 "arg_1" "decimal" 4 0 1 3161 407 "arg_2" "decimal" 9 0 2 -3162 408 "result" "decimal" 18 0 0 -3163 408 "arg_1" "decimal" 18 0 1 +3162 408 "result" "decimal" 19 0 0 +3163 408 "arg_1" "decimal" 19 0 1 3164 408 "arg_2" "tinyint" 8 0 2 -3165 409 "result" "decimal" 18 0 0 +3165 409 "result" "decimal" 19 0 0 3166 409 "arg_1" "tinyint" 8 0 1 -3167 409 "arg_2" "decimal" 18 0 2 -3168 410 "result" "decimal" 18 0 0 -3169 410 "arg_1" "decimal" 18 0 1 +3167 409 "arg_2" "decimal" 19 0 2 +3168 410 "result" "decimal" 19 0 0 +3169 410 "arg_1" "decimal" 19 0 1 3170 410 "arg_2" "smallint" 16 0 2 -3171 411 "result" "decimal" 18 0 0 +3171 411 "result" "decimal" 19 0 0 3172 411 "arg_1" "smallint" 16 0 1 -3173 411 "arg_2" "decimal" 18 0 2 -3174 412 "result" "decimal" 18 0 0 -3175 412 "arg_1" "decimal" 18 0 1 +3173 411 "arg_2" "decimal" 19 0 2 +3174 412 "result" "decimal" 19 0 0 +3175 412 "arg_1" "decimal" 19 0 1 3176 412 "arg_2" "int" 32 0 2 -3177 413 "result" "decimal" 18 0 0 +3177 413 "result" "decimal" 19 0 0 3178 413 "arg_1" "int" 32 0 1 -3179 413 "arg_2" "decimal" 18 0 2 -3180 414 "result" "decimal" 18 0 0 -3181 414 "arg_1" "decimal" 18 0 1 +3179 413 "arg_2" "decimal" 19 0 2 +3180 414 "result" "decimal" 19 0 0 +3181 414 "arg_1" "decimal" 19 0 1 3182 414 "arg_2" "wrd" 64 0 2 -3183 415 "result" "decimal" 18 0 0 +3183 415 "result" "decimal" 19 0 0 3184 415 "arg_1" "wrd" 64 0 1 -3185 415 "arg_2" "decimal" 18 0 2 -3186 416 "result" "decimal" 18 0 0 -3187 416 "arg_1" "decimal" 18 0 1 +3185 415 "arg_2" "decimal" 19 0 2 +3186 416 "result" "decimal" 19 0 0 +3187 416 "arg_1" "decimal" 19 0 1 3188 416 "arg_2" "decimal" 2 0 2 -3189 417 "result" "decimal" 18 0 0 +3189 417 "result" "decimal" 19 0 0 3190 417 "arg_1" "decimal" 2 0 1 -3191 417 "arg_2" "decimal" 18 0 2 -3192 418 "result" "decimal" 18 0 0 -3193 418 "arg_1" "decimal" 18 0 1 +3191 417 "arg_2" "decimal" 19 0 2 +3192 418 "result" "decimal" 19 0 0 +3193 418 "arg_1" "decimal" 19 0 1 3194 418 "arg_2" "decimal" 4 0 2 -3195 419 "result" "decimal" 18 0 0 +3195 419 "result" "decimal" 19 0 0 3196 419 "arg_1" "decimal" 4 0 1 -3197 419 "arg_2" "decimal" 18 0 2 -3198 420 "result" "decimal" 18 0 0 -3199 420 "arg_1" "decimal" 18 0 1 +3197 419 "arg_2" "decimal" 19 0 2 +3198 420 "result" "decimal" 19 0 0 +3199 420 "arg_1" "decimal" 19 0 1 3200 420 "arg_2" "decimal" 9 0 2 -3201 421 "result" "decimal" 18 0 0 +3201 421 "result" "decimal" 19 0 0 3202 421 "arg_1" "decimal" 9 0 1 -3203 421 "arg_2" "decimal" 18 0 2 +3203 421 "arg_2" "decimal" 19 0 2 3204 422 "result" "decimal" 2 0 0 3205 422 "arg_1" "decimal" 2 0 1 3206 422 "arg_2" "tinyint" 8 0 2 @@ -3005,8 +3005,8 @@ 3209 423 "arg_2" "tinyint" 8 0 2 3210 424 "result" "decimal" 9 0 0 3211 424 "arg_1" "decimal" 9 0 1 3212 424 "arg_2" "tinyint" 8 0 2 -3213 425 "result" "decimal" 18 0 0 -3214 425 "arg_1" "decimal" 18 0 1 +3213 425 "result" "decimal" 19 0 0 +3214 425 "arg_1" "decimal" 19 0 1 3215 425 "arg_2" "tinyint" 8 0 2 3216 426 "result" "real" 24 0 0 3217 426 "arg_1" "real" 24 0 1 @@ -3042,7 +3042,7 @@ 3246 436 "result" "tinyint" 8 0 0 3247 436 "arg_1" "decimal" 9 0 1 3248 436 "arg_2" "tinyint" 8 0 2 3249 437 "result" "tinyint" 8 0 0 -3250 437 "arg_1" "decimal" 18 0 1 +3250 437 "arg_1" "decimal" 19 0 1 3251 437 "arg_2" "tinyint" 8 0 2 3252 438 "result" "tinyint" 8 0 0 3253 438 "arg_1" "real" 24 0 1 @@ -3102,7 +3102,7 @@ 3306 456 "result" "smallint" 16 0 0 3307 456 "arg_1" "decimal" 9 0 1 3308 456 "arg_2" "smallint" 16 0 2 3309 457 "result" "smallint" 16 0 0 -3310 457 "arg_1" "decimal" 18 0 1 +3310 457 "arg_1" "decimal" 19 0 1 3311 457 "arg_2" "smallint" 16 0 2 3312 458 "result" "smallint" 16 0 0 3313 458 "arg_1" "real" 24 0 1 @@ -3162,7 +3162,7 @@ 3366 476 "result" "int" 32 0 0 3367 476 "arg_1" "decimal" 9 0 1 3368 476 "arg_2" "int" 32 0 2 3369 477 "result" "int" 32 0 0 -3370 477 "arg_1" "decimal" 18 0 1 +3370 477 "arg_1" "decimal" 19 0 1 3371 477 "arg_2" "int" 32 0 2 3372 478 "result" "int" 32 0 0 3373 478 "arg_1" "real" 24 0 1 @@ -3222,7 +3222,7 @@ 3426 496 "result" "bigint" 64 0 0 3427 496 "arg_1" "decimal" 9 0 1 3428 496 "arg_2" "bigint" 64 0 2 3429 497 "result" "bigint" 64 0 0 -3430 497 "arg_1" "decimal" 18 0 1 +3430 497 "arg_1" "decimal" 19 0 1 3431 497 "arg_2" "bigint" 64 0 2 3432 498 "result" "bigint" 64 0 0 3433 498 "arg_1" "real" 24 0 1 @@ -3282,7 +3282,7 @@ 3486 516 "result" "oid" 63 0 0 3487 516 "arg_1" "decimal" 9 0 1 3488 516 "arg_2" "oid" 63 0 2 3489 517 "result" "oid" 63 0 0 -3490 517 "arg_1" "decimal" 18 0 1 +3490 517 "arg_1" "decimal" 19 0 1 3491 517 "arg_2" "oid" 63 0 2 3492 518 "result" "oid" 63 0 0 3493 518 "arg_1" "real" 24 0 1 @@ -3342,7 +3342,7 @@ 3546 536 "result" "wrd" 64 0 0 3547 536 "arg_1" "decimal" 9 0 1 3548 536 "arg_2" "wrd" 64 0 2 3549 537 "result" "wrd" 64 0 0 -3550 537 "arg_1" "decimal" 18 0 1 +3550 537 "arg_1" "decimal" 19 0 1 3551 537 "arg_2" "wrd" 64 0 2 3552 538 "result" "wrd" 64 0 0 3553 538 "arg_1" "real" 24 0 1 @@ -3402,7 +3402,7 @@ 3606 556 "result" "decimal" 2 0 0 3607 556 "arg_1" "decimal" 9 0 1 3608 556 "arg_2" "decimal" 2 0 2 3609 557 "result" "decimal" 2 0 0 -3610 557 "arg_1" "decimal" 18 0 1 +3610 557 "arg_1" "decimal" 19 0 1 3611 557 "arg_2" "decimal" 2 0 2 3612 558 "result" "decimal" 2 0 0 3613 558 "arg_1" "real" 24 0 1 @@ -3462,7 +3462,7 @@ 3666 576 "result" "decimal" 4 0 0 3667 576 "arg_1" "decimal" 9 0 1 3668 576 "arg_2" "decimal" 4 0 2 3669 577 "result" "decimal" 4 0 0 -3670 577 "arg_1" "decimal" 18 0 1 +3670 577 "arg_1" "decimal" 19 0 1 3671 577 "arg_2" "decimal" 4 0 2 3672 578 "result" "decimal" 4 0 0 3673 578 "arg_1" "real" 24 0 1 @@ -3522,7 +3522,7 @@ 3726 596 "result" "decimal" 9 0 0 3727 596 "arg_1" "decimal" 9 0 1 3728 596 "arg_2" "decimal" 9 0 2 3729 597 "result" "decimal" 9 0 0 -3730 597 "arg_1" "decimal" 18 0 1 +3730 597 "arg_1" "decimal" 19 0 1 3731 597 "arg_2" "decimal" 9 0 2 3732 598 "result" "decimal" 9 0 0 _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list