Changeset: 9d064cd05291 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9d064cd05291
Modified Files:
        clients/Tests/SQL-dump_nogeom.stable.out
        clients/Tests/exports.stable.out
        clients/mapiclient/dump.c
        monetdb5/extras/rapi/Tests/rapi08.malC
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out
        sql/test/BugTracker-2010/Tests/slow-query.Bug-2671.sql
Branch: RIntegration-default
Log Message:

changed test output


diffs (truncated from 2648 to 300 lines):

diff --git a/clients/Tests/SQL-dump_nogeom.stable.out 
b/clients/Tests/SQL-dump_nogeom.stable.out
--- a/clients/Tests/SQL-dump_nogeom.stable.out
+++ b/clients/Tests/SQL-dump_nogeom.stable.out
@@ -263,7 +263,7 @@ CREATE TABLE "sys"."functions" (
        "name"        VARCHAR(256),
        "func"        VARCHAR(8196),
        "mod"         VARCHAR(8196),
-       "sql"         BOOLEAN,
+       "language"    INTEGER,
        "type"        INTEGER,
        "side_effect" BOOLEAN,
        "varres"      BOOLEAN,
@@ -1371,7 +1371,7 @@ 2017      "id"    "int"   32      0       2016    NULL    
true    0       NU
 2018   "name"  "varchar"       256     0       2016    NULL    true    1       
NULL
 2019   "func"  "varchar"       8196    0       2016    NULL    true    2       
NULL
 2020   "mod"   "varchar"       8196    0       2016    NULL    true    3       
NULL
-2021   "sql"   "boolean"       1       0       2016    NULL    true    4       
NULL
+2021   "language"      "int"   32      0       2016    NULL    true    4       
NULL
 2022   "type"  "int"   32      0       2016    NULL    true    5       NULL
 2023   "side_effect"   "boolean"       1       0       2016    NULL    true    
6       NULL
 2024   "varres"        "boolean"       1       0       2016    NULL    true    
7       NULL
@@ -5506,7 +5506,7 @@ CREATE TABLE "sys"."functions" (
        "name"        VARCHAR(256),
        "func"        VARCHAR(8196),
        "mod"         VARCHAR(8196),
-       "sql"         BOOLEAN,
+       "language"    INTEGER,
        "type"        INTEGER,
        "side_effect" BOOLEAN,
        "varres"      BOOLEAN,
@@ -5514,1274 +5514,1274 @@ CREATE TABLE "sys"."functions" (
        "schema_id"   INTEGER
 );
 COPY 1268 RECORDS INTO "sys"."functions" FROM stdin USING DELIMITERS 
'\t','\n','"';
-28     "not_uniques"   "not_uniques"   "sql"   false   1       false   false   
false   0
-29     "not_uniques"   "not_uniques"   "sql"   false   1       false   false   
false   0
-30     "hash"  "hash"  "mkey"  false   1       false   false   false   0
-31     "rotate_xor_hash"       "rotate_xor_hash"       "calc"  false   1       
false   false   false   0
-32     "="     "="     "calc"  false   1       false   false   false   0
-33     "<>"    "!="    "calc"  false   1       false   false   false   0
-34     "isnull"        "isnil" "calc"  false   1       false   false   false   0
-35     ">"     ">"     "calc"  false   1       false   false   false   0
-36     ">="    ">="    "calc"  false   1       false   false   false   0
-37     "<"     "<"     "calc"  false   1       false   false   false   0
-38     "<="    "<="    "calc"  false   1       false   false   false   0
-42     "in"    "in"    "calc"  false   1       false   false   false   0
-43     "identity"      "identity"      "calc"  false   1       false   false   
false   0
-44     "rowid" "identity"      "calc"  false   1       false   false   false   0
-45     "rowid" "rowid" "calc"  false   1       false   false   false   0
-48     "sql_min"       "min"   "calc"  false   1       false   false   false   0
-49     "sql_max"       "max"   "calc"  false   1       false   false   false   0
-50     "ifthenelse"    "ifthenelse"    "calc"  false   1       false   false   
false   0
-68     "mod"   "%"     "calc"  false   1       false   false   false   0
-69     "mod"   "%"     "calc"  false   1       false   false   false   0
-70     "mod"   "%"     "calc"  false   1       false   false   false   0
-71     "mod"   "%"     "calc"  false   1       false   false   false   0
-72     "mod"   "%"     "calc"  false   1       false   false   false   0
-73     "mod"   "%"     "calc"  false   1       false   false   false   0
-74     "mod"   "%"     "calc"  false   1       false   false   false   0
-75     "mod"   "%"     "calc"  false   1       false   false   false   0
-76     "mod"   "%"     "calc"  false   1       false   false   false   0
-77     "mod"   "%"     "calc"  false   1       false   false   false   0
-78     "mod"   "%"     "calc"  false   1       false   false   false   0
-79     "mod"   "%"     "calc"  false   1       false   false   false   0
-87     "rank"  "rank_grp"      "calc"  false   1       false   false   false   0
-88     "dense_rank"    "dense_rank_grp"        "calc"  false   1       false   
false   false   0
-89     "percent_rank"  "precent_rank_grp"      "calc"  false   1       false   
false   false   0
-90     "cume_dist"     "cume_dist_grp" "calc"  false   1       false   false   
false   0
-91     "row_number"    "mark_grp"      "calc"  false   1       false   false   
false   0
-92     "rank"  "rank_grp"      "calc"  false   1       false   false   false   0
-93     "dense_rank"    "dense_rank_grp"        "calc"  false   1       false   
false   false   0
-94     "percent_rank"  "precent_rank_grp"      "calc"  false   1       false   
false   false   0
-95     "cume_dist"     "cume_dist_grp" "calc"  false   1       false   false   
false   0
-96     "row_number"    "mark_grp"      "calc"  false   1       false   false   
false   0
-97     "rank"  "rank_grp"      "calc"  false   1       false   false   false   0
-98     "dense_rank"    "dense_rank_grp"        "calc"  false   1       false   
false   false   0
-99     "percent_rank"  "precent_rank_grp"      "calc"  false   1       false   
false   false   0
-100    "cume_dist"     "cume_dist_grp" "calc"  false   1       false   false   
false   0
-101    "row_number"    "mark_grp"      "calc"  false   1       false   false   
false   0
-102    "lag"   "lag_grp"       "calc"  false   1       false   false   false   0
-103    "lead"  "lead_grp"      "calc"  false   1       false   false   false   0
-104    "lag"   "lag_grp"       "calc"  false   1       false   false   false   0
-105    "lead"  "lead_grp"      "calc"  false   1       false   false   false   0
-106    "lag"   "lag_grp"       "calc"  false   1       false   false   false   0
-107    "lead"  "lead_grp"      "calc"  false   1       false   false   false   0
-108    "lag"   "lag_grp"       "calc"  false   1       false   false   false   0
-109    "lead"  "lead_grp"      "calc"  false   1       false   false   false   0
-110    "and"   "and"   "calc"  false   1       false   false   false   0
-111    "or"    "or"    "calc"  false   1       false   false   false   0
-112    "xor"   "xor"   "calc"  false   1       false   false   false   0
-113    "not"   "not"   "calc"  false   1       false   false   false   0
-114    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-115    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-116    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-117    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-118    "bit_and"       "and"   "calc"  false   1       false   false   false   0
-119    "bit_or"        "or"    "calc"  false   1       false   false   false   0
-120    "bit_xor"       "xor"   "calc"  false   1       false   false   false   0
-121    "bit_not"       "not"   "calc"  false   1       false   false   false   0
-122    "left_shift"    "<<"    "calc"  false   1       false   false   false   0
-123    "right_shift"   ">>"    "calc"  false   1       false   false   false   0
-124    "sql_neg"       "-"     "calc"  false   1       false   false   false   0
-125    "abs"   "abs"   "calc"  false   1       false   false   false   0
-126    "sign"  "sign"  "calc"  false   1       false   false   false   0
-127    "scale_up"      "*"     "calc"  false   1       false   false   false   0
-128    "scale_down"    "dec_round"     "sql"   false   1       false   false   
false   0
-129    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-130    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-131    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-132    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-133    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-134    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-135    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-136    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-137    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-138    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-139    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-140    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-141    "bit_and"       "and"   "calc"  false   1       false   false   false   0
-142    "bit_or"        "or"    "calc"  false   1       false   false   false   0
-143    "bit_xor"       "xor"   "calc"  false   1       false   false   false   0
-144    "bit_not"       "not"   "calc"  false   1       false   false   false   0
-145    "left_shift"    "<<"    "calc"  false   1       false   false   false   0
-146    "right_shift"   ">>"    "calc"  false   1       false   false   false   0
-147    "sql_neg"       "-"     "calc"  false   1       false   false   false   0
-148    "abs"   "abs"   "calc"  false   1       false   false   false   0
-149    "sign"  "sign"  "calc"  false   1       false   false   false   0
-150    "scale_up"      "*"     "calc"  false   1       false   false   false   0
-151    "scale_down"    "dec_round"     "sql"   false   1       false   false   
false   0
-152    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-153    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-154    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-155    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-156    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-157    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-158    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-159    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-160    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-161    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-162    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-163    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-164    "bit_and"       "and"   "calc"  false   1       false   false   false   0
-165    "bit_or"        "or"    "calc"  false   1       false   false   false   0
-166    "bit_xor"       "xor"   "calc"  false   1       false   false   false   0
-167    "bit_not"       "not"   "calc"  false   1       false   false   false   0
-168    "left_shift"    "<<"    "calc"  false   1       false   false   false   0
-169    "right_shift"   ">>"    "calc"  false   1       false   false   false   0
-170    "sql_neg"       "-"     "calc"  false   1       false   false   false   0
-171    "abs"   "abs"   "calc"  false   1       false   false   false   0
-172    "sign"  "sign"  "calc"  false   1       false   false   false   0
-173    "scale_up"      "*"     "calc"  false   1       false   false   false   0
-174    "scale_down"    "dec_round"     "sql"   false   1       false   false   
false   0
-175    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-176    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-177    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-178    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-179    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-180    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-181    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-182    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-183    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-184    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-185    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-186    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-187    "bit_and"       "and"   "calc"  false   1       false   false   false   0
-188    "bit_or"        "or"    "calc"  false   1       false   false   false   0
-189    "bit_xor"       "xor"   "calc"  false   1       false   false   false   0
-190    "bit_not"       "not"   "calc"  false   1       false   false   false   0
-191    "left_shift"    "<<"    "calc"  false   1       false   false   false   0
-192    "right_shift"   ">>"    "calc"  false   1       false   false   false   0
-193    "sql_neg"       "-"     "calc"  false   1       false   false   false   0
-194    "abs"   "abs"   "calc"  false   1       false   false   false   0
-195    "sign"  "sign"  "calc"  false   1       false   false   false   0
-196    "scale_up"      "*"     "calc"  false   1       false   false   false   0
-197    "scale_down"    "dec_round"     "sql"   false   1       false   false   
false   0
-198    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-199    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-200    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-201    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-202    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-203    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-204    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-205    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-206    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-207    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-208    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-209    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-210    "bit_and"       "and"   "calc"  false   1       false   false   false   0
-211    "bit_or"        "or"    "calc"  false   1       false   false   false   0
-212    "bit_xor"       "xor"   "calc"  false   1       false   false   false   0
-213    "bit_not"       "not"   "calc"  false   1       false   false   false   0
-214    "left_shift"    "<<"    "calc"  false   1       false   false   false   0
-215    "right_shift"   ">>"    "calc"  false   1       false   false   false   0
-216    "sql_neg"       "-"     "calc"  false   1       false   false   false   0
-217    "abs"   "abs"   "calc"  false   1       false   false   false   0
-218    "sign"  "sign"  "calc"  false   1       false   false   false   0
-219    "scale_up"      "*"     "calc"  false   1       false   false   false   0
-220    "scale_down"    "dec_round"     "sql"   false   1       false   false   
false   0
-221    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-222    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-223    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-224    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-225    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-226    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-227    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-228    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-229    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-230    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-231    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-232    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-233    "bit_and"       "and"   "calc"  false   1       false   false   false   0
-234    "bit_or"        "or"    "calc"  false   1       false   false   false   0
-235    "bit_xor"       "xor"   "calc"  false   1       false   false   false   0
-236    "bit_not"       "not"   "calc"  false   1       false   false   false   0
-237    "left_shift"    "<<"    "calc"  false   1       false   false   false   0
-238    "right_shift"   ">>"    "calc"  false   1       false   false   false   0
-239    "sql_neg"       "-"     "calc"  false   1       false   false   false   0
-240    "abs"   "abs"   "calc"  false   1       false   false   false   0
-241    "sign"  "sign"  "calc"  false   1       false   false   false   0
-242    "scale_up"      "*"     "calc"  false   1       false   false   false   0
-243    "scale_down"    "dec_round"     "sql"   false   1       false   false   
false   0
-244    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-245    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-246    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-247    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-248    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-249    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-250    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-251    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-252    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-253    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-254    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-255    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-256    "bit_and"       "and"   "calc"  false   1       false   false   false   0
-257    "bit_or"        "or"    "calc"  false   1       false   false   false   0
-258    "bit_xor"       "xor"   "calc"  false   1       false   false   false   0
-259    "bit_not"       "not"   "calc"  false   1       false   false   false   0
-260    "left_shift"    "<<"    "calc"  false   1       false   false   false   0
-261    "right_shift"   ">>"    "calc"  false   1       false   false   false   0
-262    "sql_neg"       "-"     "calc"  false   1       false   false   false   0
-263    "abs"   "abs"   "calc"  false   1       false   false   false   0
-264    "sign"  "sign"  "calc"  false   1       false   false   false   0
-265    "scale_up"      "*"     "calc"  false   1       false   false   false   0
-266    "scale_down"    "dec_round"     "sql"   false   1       false   false   
false   0
-267    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-268    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-269    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-270    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-271    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-272    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-273    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-274    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-275    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-276    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-277    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-278    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-279    "bit_and"       "and"   "calc"  false   1       false   false   false   0
-280    "bit_or"        "or"    "calc"  false   1       false   false   false   0
-281    "bit_xor"       "xor"   "calc"  false   1       false   false   false   0
-282    "bit_not"       "not"   "calc"  false   1       false   false   false   0
-283    "left_shift"    "<<"    "calc"  false   1       false   false   false   0
-284    "right_shift"   ">>"    "calc"  false   1       false   false   false   0
-285    "sql_neg"       "-"     "calc"  false   1       false   false   false   0
-286    "abs"   "abs"   "calc"  false   1       false   false   false   0
-287    "sign"  "sign"  "calc"  false   1       false   false   false   0
-288    "scale_up"      "*"     "calc"  false   1       false   false   false   0
-289    "scale_down"    "dec_round"     "sql"   false   1       false   false   
false   0
-290    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-291    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-292    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-293    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-294    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-295    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-296    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-297    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-298    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-299    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-300    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-301    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-302    "bit_and"       "and"   "calc"  false   1       false   false   false   0
-303    "bit_or"        "or"    "calc"  false   1       false   false   false   0
-304    "bit_xor"       "xor"   "calc"  false   1       false   false   false   0
-305    "bit_not"       "not"   "calc"  false   1       false   false   false   0
-306    "left_shift"    "<<"    "calc"  false   1       false   false   false   0
-307    "right_shift"   ">>"    "calc"  false   1       false   false   false   0
-308    "sql_neg"       "-"     "calc"  false   1       false   false   false   0
-309    "abs"   "abs"   "calc"  false   1       false   false   false   0
-310    "sign"  "sign"  "calc"  false   1       false   false   false   0
-311    "scale_up"      "*"     "calc"  false   1       false   false   false   0
-312    "scale_down"    "dec_round"     "sql"   false   1       false   false   
false   0
-313    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-314    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-315    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-316    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-317    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-318    "sql_add"       "+"     "calc"  false   1       false   false   false   0
-319    "sql_mul"       "*"     "calc"  false   1       false   false   false   0
-320    "sql_div"       "/"     "calc"  false   1       false   false   false   0
-321    "sql_sub"       "-"     "calc"  false   1       false   false   false   0
-322    "sql_add"       "+"     "calc"  false   1       false   false   false   0
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to