Changeset: 4f57c5fda8d8 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4f57c5fda8d8
Added Files:
gdk/gdk_mvcc.c
gdk/gdk_mvcc.h
Removed Files:
sql/scripts/20_vacuum.sql
sql/test/BugTracker-2010/Tests/vacuum.sql
sql/test/BugTracker-2010/Tests/vacuum.stable.err
sql/test/BugTracker-2010/Tests/vacuum.stable.out
sql/test/pg_regress/Tests/vacuum.sql
sql/test/pg_regress/Tests/vacuum.stable.err
sql/test/pg_regress/Tests/vacuum.stable.out
Modified Files:
clients/Tests/MAL-signatures_all.stable.out
clients/Tests/MAL-signatures_all.stable.out.int128
clients/Tests/SQL-dump_all.stable.out
clients/Tests/SQL-dump_all.stable.out.int128
clients/Tests/SQL-dump_all.stable.out.oid32
clients/Tests/SQL-dump_all.stable.out.oid32.int128
clients/Tests/exports.stable.out
gdk/Makefile.ag
gdk/gdk_atoms.c
gdk/gdk_logger.c
gdk/gdk_logger.h
geom/monetdb5/geom.c
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
monetdb5/modules/atoms/blob.c
monetdb5/modules/kernel/logger.c
monetdb5/optimizer/opt_pipes.c
sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
sql/backends/monet5/bam/bam_db_interface.c
sql/backends/monet5/rel_bin.c
sql/backends/monet5/rest/Tests/jsonstore01.stable.out
sql/backends/monet5/sql.c
sql/backends/monet5/sql.h
sql/backends/monet5/sql.mal
sql/backends/monet5/sql_execute.c
sql/backends/monet5/sql_gencode.c
sql/backends/monet5/sql_result.c
sql/backends/monet5/sql_statement.c
sql/backends/monet5/sql_statement.h
sql/backends/monet5/sql_user.c
sql/backends/monet5/vaults/fits.c
sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/01-plan.stable.out
sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/02-plan.stable.out
sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/03-plan.stable.out
sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/04-plan.stable.out
sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/05-plan.stable.out
sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/06-plan.stable.out
sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/07-plan.stable.out
sql/benchmarks/ssbm/Tests/08-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/08-plan.stable.out
sql/benchmarks/ssbm/Tests/09-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/09-plan.stable.out
sql/benchmarks/ssbm/Tests/10-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/10-plan.stable.out
sql/benchmarks/ssbm/Tests/11-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/11-plan.stable.out
sql/benchmarks/ssbm/Tests/12-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/12-plan.stable.out
sql/benchmarks/ssbm/Tests/13-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/13-plan.stable.out
sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
sql/benchmarks/tpch/Tests/02-explain.stable.out
sql/benchmarks/tpch/Tests/02-plan.stable.out
sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
sql/benchmarks/tpch/Tests/03-plan.stable.out.int128
sql/benchmarks/tpch/Tests/04-explain.stable.out
sql/benchmarks/tpch/Tests/05-explain.stable.out.int128
sql/benchmarks/tpch/Tests/05-plan.stable.out
sql/benchmarks/tpch/Tests/05-plan.stable.out.int128
sql/benchmarks/tpch/Tests/06-explain.stable.out.int128
sql/benchmarks/tpch/Tests/07-explain.stable.out.int128
sql/benchmarks/tpch/Tests/07-plan.stable.out
sql/benchmarks/tpch/Tests/07-plan.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/09-explain.stable.out.int128
sql/benchmarks/tpch/Tests/09-plan.stable.out
sql/benchmarks/tpch/Tests/09-plan.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/11-explain.stable.out.int128
sql/benchmarks/tpch/Tests/11-plan.stable.out.int128
sql/benchmarks/tpch/Tests/12-explain.stable.out.int128
sql/benchmarks/tpch/Tests/12-plan.stable.out
sql/benchmarks/tpch/Tests/13-explain.stable.out
sql/benchmarks/tpch/Tests/13-plan.stable.out
sql/benchmarks/tpch/Tests/14-explain.stable.out.int128
sql/benchmarks/tpch/Tests/14-plan.stable.out.int128
sql/benchmarks/tpch/Tests/15-explain.stable.out.int128
sql/benchmarks/tpch/Tests/16-explain.stable.out
sql/benchmarks/tpch/Tests/16-plan.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/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/19-explain.stable.out.int128
sql/benchmarks/tpch/Tests/19-plan.stable.out
sql/benchmarks/tpch/Tests/19-plan.stable.out.int128
sql/benchmarks/tpch/Tests/20-explain.stable.out.int128
sql/benchmarks/tpch/Tests/21-explain.stable.out
sql/benchmarks/tpch/Tests/21-plan.stable.out
sql/benchmarks/tpch/Tests/22-explain.stable.out.int128
sql/include/sql_catalog.h
sql/scripts/Makefile.ag
sql/server/rel_optimizer.c
sql/server/rel_updates.c
sql/server/sql_mvc.c
sql/storage/bat/Makefile.ag
sql/storage/bat/bat_logger.c
sql/storage/bat/bat_storage.c
sql/storage/bat/bat_storage.h
sql/storage/bat/bat_table.c
sql/storage/restrict/restrict_storage.c
sql/storage/sql_storage.h
sql/storage/store.c
sql/test/BugDay_2005-11-09_2.9.3/Tests/updates_got_lost.SF-1119178.stable.out
sql/test/BugTracker-2008/Tests/insert_into_unique_column.SF-2075180.stable.out
sql/test/BugTracker-2008/Tests/update_error.SF-2254506.stable.out
sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out
sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.stable.out
sql/test/BugTracker-2010/Tests/All
sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out
sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out
sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out
sql/test/BugTracker-2015/Tests/reserved_keywords.Bug-3613.stable.out
sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
sql/test/BugTracker/Tests/update_pkey_bug.SF-1733712.stable.out
sql/test/Dependencies/Tests/Dependencies_bam.stable.out
sql/test/Dependencies/Tests/Dependencies_bam.stable.out.int128
sql/test/Tests/systemfunctions_bam.stable.out.int128
sql/test/Tests/trace.stable.out.int128
sql/test/Triggers/Tests/cascaded_triggers.stable.out
sql/test/Triggers/Tests/referencing_clause_new.stable.out
sql/test/Triggers/Tests/referencing_clause_old.stable.out
sql/test/Triggers/Tests/trigger_action.stable.out
sql/test/Update_Delete_action/Tests/delete_set_default.stable.out
sql/test/Update_Delete_action/Tests/delete_set_null.stable.out
sql/test/Update_Delete_action/Tests/update_cascade.stable.out
sql/test/Update_Delete_action/Tests/update_delete_cascade.stable.out
sql/test/Update_Delete_action/Tests/update_no_action.stable.out
sql/test/Update_Delete_action/Tests/update_set_null.stable.out
sql/test/Users/Tests/test_privs2_p1.stable.out
sql/test/Via-m/Tests/media_s19.stable.err
sql/test/bugs/Tests/alter_drop_column_insert_crash.stable.out
sql/test/leaks/Tests/check0_bam.stable.out.int128
sql/test/leaks/Tests/check1_bam.stable.out
sql/test/leaks/Tests/check1_bam.stable.out.int128
sql/test/leaks/Tests/check2_bam.stable.out
sql/test/leaks/Tests/check2_bam.stable.out.int128
sql/test/leaks/Tests/check3_bam.stable.out
sql/test/leaks/Tests/check3_bam.stable.out.int128
sql/test/leaks/Tests/check4_bam.stable.out
sql/test/leaks/Tests/check4_bam.stable.out.int128
sql/test/leaks/Tests/check5_bam.stable.out
sql/test/leaks/Tests/check5_bam.stable.out.int128
sql/test/leaks/Tests/drop3_bam.stable.out.int128
sql/test/leaks/Tests/select1_bam.stable.out.int128
sql/test/leaks/Tests/select2_bam.stable.out.int128
sql/test/leaks/Tests/temp1_bam.stable.out.int128
sql/test/leaks/Tests/temp2_bam.stable.out.int128
sql/test/leaks/Tests/temp3_bam.stable.out.int128
sql/test/mapi/Tests/sql_int128.stable.out
sql/test/mergetables/Tests/mergequery.stable.out
sql/test/pg_regress/Tests/All
sql/test/pg_regress/Tests/alter_table.sql
sql/test/pg_regress/Tests/alter_table.stable.err
sql/test/pg_regress/Tests/create_misc.stable.err
sql/test/pg_regress/Tests/float4.stable.out
sql/test/pg_regress/Tests/float8.stable.out
sql/test/pg_regress/Tests/inet.stable.err
sql/test/pg_regress/Tests/numeric.sql
sql/test/pg_regress/Tests/numeric.stable.out
sql/test/pg_regress/Tests/numeric_big.sql
sql/test/pg_regress/Tests/numeric_big.stable.err.int128
sql/test/pg_regress/Tests/without_oid.sql
sql/test/pg_regress/Tests/without_oid.stable.out
sql/test/ssqq/Tests/insert_query.stable.err
sql/test/ssqq/Tests/insert_query.stable.out
sql/test/ssqq/Tests/insert_queue.stable.err
sql/test/ssqq/Tests/insert_queue.stable.out
sql/test/ssqq/Tests/insert_quser.stable.err
sql/test/ssqq/Tests/insert_quser.stable.out
sql/test/ssqq/insert_query.sql
sql/test/ssqq/insert_queue.sql
Branch: newstorage
Log Message:
reimplemented the direct storage model
diffs (truncated from 27955 to 300 lines):
diff --git a/clients/Tests/MAL-signatures_all.stable.out
b/clients/Tests/MAL-signatures_all.stable.out
--- a/clients/Tests/MAL-signatures_all.stable.out
+++ b/clients/Tests/MAL-signatures_all.stable.out
@@ -40421,7 +40421,7 @@ pattern sql.affectedRows{unsafe}(mvc:int
address mvc_affected_rows_wrap;
comment export the number of affected rows by the current query
-pattern sql.append(mvc:int,sname:str,tname:str,cname:str,ins:any):int
+pattern sql.append(mvc:int,sname:str,tname:str,cname:str,rid:oid,ins:any):int
address mvc_append_wrap;
comment Append b to the column tname.cname (possibly optimized to replace the
insert bat of tname.cname (returns sequence number for order dependence)
@@ -40505,6 +40505,22 @@ pattern sql.clear_table{unsafe}(sname:st
address mvc_clear_table_wrap;
comment Clear table
+pattern sql.claim(mvc:int,sname:str,tname:str,rid:bat[:oid,:oid])
(rid:bat[:oid,:oid],mvc_res:int)
+address mvc_update_rids_wrap;
+comment Update the row's with the given row id, ie for old rows, reinsert and
delete.
+
+pattern sql.claim(mvc:int,sname:str,tname:str,rid:oid) (rid:oid,mvc_res:int)
+address mvc_update_rid_wrap;
+comment Update the row's with the given row id, ie for old rows, reinsert and
delete.
+
+pattern sql.claim(mvc:int,sname:str,tname:str,cnt:wrd) (rid:oid,mvc_res:int)
+address mvc_claim;
+comment Claim number of buns.
+
+pattern sql.claim(mvc:int,sname:str,tname:str,cnt:wrd) (rid:oid,mvc_res:int)
+address mvc_claim;
+comment Claim number of buns.
+
pattern sql.catalog(type:int,iname:str,itype:int,sname:str,tname:str...):void
address SQLcatalog;
comment a create index catalog statement
@@ -40627,14 +40643,6 @@ pattern sql.delete{unsafe}(mvc:int,sname
address mvc_delete_wrap;
comment delete from table
-command
sql.delta(col:bat[:oid,:any_3],uid:bat[:oid,:oid],uval:bat[:oid,:any_3]):bat[:oid,:any_3]
-address DELTAbat2;
-comment Return column bat with delta's applied.
-
-command
sql.delta(col:bat[:oid,:any_3],uid:bat[:oid,:oid],uval:bat[:oid,:any_3],ins:bat[:oid,:any_3]):bat[:oid,:any_3]
-address DELTAbat;
-comment Return column bat with delta's applied.
-
command sql.epilogue():void
address SQLepilogue;
pattern
sql.exportValue{unsafe}(qtype:int,tname:str,name:str,typename:str,digits:int,scale:int,eclass:int,val:any_1,w:str):void
@@ -40737,14 +40745,6 @@ pattern sql.password(user:str):str
address db_password_wrap;
comment Return password hash of user
-command
sql.projectdelta(subselect:bat[:oid,:oid],col:bat[:oid,:any_3],uid:bat[:oid,:oid],uval:bat[:oid,:any_3]):bat[:oid,:any_3]
-address DELTAproject2;
-comment Return column bat with delta's applied.
-
-command
sql.projectdelta(subselect:bat[:oid,:oid],col:bat[:oid,:any_3],uid:bat[:oid,:oid],uval:bat[:oid,:any_3],ins:bat[:oid,:any_3]):bat[:oid,:any_3]
-address DELTAproject;
-comment Return column bat with delta's applied.
-
command sql.querylog_disable():void
address QLOGdisable;
command sql.querylog_enable(thres:int):void
@@ -40769,10 +40769,6 @@ command sql.rank_grp(b:bat[:oid,:any_1],
address sql_rank_grp;
comment return the ranked groups
-pattern sql.reuse(sch:str,tbl:str):void
-address SQLreuse;
-comment Consolidate the deletion table over all columns reusing deleted slots
-
command sql.round(v:dbl,r:bte):dbl
address dbl_round_wrap;
comment round off the floating point v to r digits behind the dot (if r < 0,
before the dot)
@@ -40831,10 +40827,6 @@ comment restart the sequence with value
function sql.sql_environment() (name:bat[:oid,:str],value:bat[:oid,:str]);
function
sql.subzero_or_one{inline}(b:bat[:oid,:any_1],gp:bat[:oid,:oid],gpe:bat[:oid,:oid],no_nil:bit):bat[:oid,:any_1];
-pattern sql.shrink(sch:str,tbl:str):void
-address SQLshrink;
-comment Consolidate the deletion table over all columns using shrinking
-
pattern sql.sysmon_stop(tag:lng):void
address SYSMONstop;
pattern sql.sysmon_stop(tag:int):void
@@ -40877,14 +40869,6 @@ comment return the table with session va
pattern sql.single(x:any_2):bat[:oid,:any_2]
address CMDBATsingle;
-command
sql.subdelta(col:bat[:oid,:oid],cand:bat[:oid,:oid],uid:bat[:oid,:oid],uval:bat[:oid,:oid]):bat[:oid,:oid]
-address DELTAsub2;
-comment Return a single bat of subselected delta.
-
-command
sql.subdelta(col:bat[:oid,:oid],cand:bat[:oid,:oid],uid:bat[:oid,:oid],uval:bat[:oid,:oid],ins:bat[:oid,:oid]):bat[:oid,:oid]
-address DELTAsub;
-comment Return a single bat of subselected delta.
-
pattern sql.setVariable(mvc:int,varname:str,value:any_1):int
address setVariable;
comment Set the value of a session variable
@@ -40929,10 +40913,6 @@ pattern sql.update(mvc:int,sname:str,tna
address mvc_update_wrap;
comment Update the values of the column tname.cname
-pattern sql.vacuum(sch:str,tbl:str):void
-address SQLvacuum;
-comment Choose an approach to consolidate the deletions
-
command sql.zero_or_one(col:bat[:oid,:any_1]):any_1
address zero_or_one;
comment if col contains exactly one value return this. Incase of more raise an
exception else return nil
diff --git a/clients/Tests/MAL-signatures_all.stable.out.int128
b/clients/Tests/MAL-signatures_all.stable.out.int128
--- a/clients/Tests/MAL-signatures_all.stable.out.int128
+++ b/clients/Tests/MAL-signatures_all.stable.out.int128
@@ -51356,7 +51356,7 @@ pattern sql.affectedRows{unsafe}(mvc:int
address mvc_affected_rows_wrap;
comment export the number of affected rows by the current query
-pattern sql.append(mvc:int,sname:str,tname:str,cname:str,ins:any):int
+pattern sql.append(mvc:int,sname:str,tname:str,cname:str,rid:oid,ins:any):int
address mvc_append_wrap;
comment Append b to the column tname.cname (possibly optimized to replace the
insert bat of tname.cname (returns sequence number for order dependence)
@@ -51440,6 +51440,22 @@ pattern sql.clear_table{unsafe}(sname:st
address mvc_clear_table_wrap;
comment Clear table
+pattern sql.claim(mvc:int,sname:str,tname:str,rid:bat[:oid,:oid])
(rid:bat[:oid,:oid],mvc_res:int)
+address mvc_update_rids_wrap;
+comment Update the row's with the given row id, ie for old rows, reinsert and
delete.
+
+pattern sql.claim(mvc:int,sname:str,tname:str,rid:oid) (rid:oid,mvc_res:int)
+address mvc_update_rid_wrap;
+comment Update the row's with the given row id, ie for old rows, reinsert and
delete.
+
+pattern sql.claim(mvc:int,sname:str,tname:str,cnt:wrd) (rid:oid,mvc_res:int)
+address mvc_claim;
+comment Claim number of buns.
+
+pattern sql.claim(mvc:int,sname:str,tname:str,cnt:wrd) (rid:oid,mvc_res:int)
+address mvc_claim;
+comment Claim number of buns.
+
pattern sql.catalog(type:int,iname:str,itype:int,sname:str,tname:str...):void
address SQLcatalog;
comment a create index catalog statement
@@ -51566,14 +51582,6 @@ pattern sql.delete{unsafe}(mvc:int,sname
address mvc_delete_wrap;
comment delete from table
-command
sql.delta(col:bat[:oid,:any_3],uid:bat[:oid,:oid],uval:bat[:oid,:any_3]):bat[:oid,:any_3]
-address DELTAbat2;
-comment Return column bat with delta's applied.
-
-command
sql.delta(col:bat[:oid,:any_3],uid:bat[:oid,:oid],uval:bat[:oid,:any_3],ins:bat[:oid,:any_3]):bat[:oid,:any_3]
-address DELTAbat;
-comment Return column bat with delta's applied.
-
command sql.epilogue():void
address SQLepilogue;
pattern
sql.exportValue{unsafe}(qtype:int,tname:str,name:str,typename:str,digits:int,scale:int,eclass:int,val:any_1,w:str):void
@@ -51676,14 +51684,6 @@ pattern sql.password(user:str):str
address db_password_wrap;
comment Return password hash of user
-command
sql.projectdelta(subselect:bat[:oid,:oid],col:bat[:oid,:any_3],uid:bat[:oid,:oid],uval:bat[:oid,:any_3]):bat[:oid,:any_3]
-address DELTAproject2;
-comment Return column bat with delta's applied.
-
-command
sql.projectdelta(subselect:bat[:oid,:oid],col:bat[:oid,:any_3],uid:bat[:oid,:oid],uval:bat[:oid,:any_3],ins:bat[:oid,:any_3]):bat[:oid,:any_3]
-address DELTAproject;
-comment Return column bat with delta's applied.
-
command sql.querylog_disable():void
address QLOGdisable;
command sql.querylog_enable(thres:int):void
@@ -51712,10 +51712,6 @@ command sql.rank_grp(b:bat[:oid,:any_1],
address sql_rank_grp;
comment return the ranked groups
-pattern sql.reuse(sch:str,tbl:str):void
-address SQLreuse;
-comment Consolidate the deletion table over all columns reusing deleted slots
-
command sql.round(v:dbl,r:bte):dbl
address dbl_round_wrap;
comment round off the floating point v to r digits behind the dot (if r < 0,
before the dot)
@@ -51774,10 +51770,6 @@ comment restart the sequence with value
function sql.sql_environment() (name:bat[:oid,:str],value:bat[:oid,:str]);
function
sql.subzero_or_one{inline}(b:bat[:oid,:any_1],gp:bat[:oid,:oid],gpe:bat[:oid,:oid],no_nil:bit):bat[:oid,:any_1];
-pattern sql.shrink(sch:str,tbl:str):void
-address SQLshrink;
-comment Consolidate the deletion table over all columns using shrinking
-
pattern sql.sysmon_stop(tag:lng):void
address SYSMONstop;
pattern sql.sysmon_stop(tag:int):void
@@ -51820,14 +51812,6 @@ comment return the table with session va
pattern sql.single(x:any_2):bat[:oid,:any_2]
address CMDBATsingle;
-command
sql.subdelta(col:bat[:oid,:oid],cand:bat[:oid,:oid],uid:bat[:oid,:oid],uval:bat[:oid,:oid]):bat[:oid,:oid]
-address DELTAsub2;
-comment Return a single bat of subselected delta.
-
-command
sql.subdelta(col:bat[:oid,:oid],cand:bat[:oid,:oid],uid:bat[:oid,:oid],uval:bat[:oid,:oid],ins:bat[:oid,:oid]):bat[:oid,:oid]
-address DELTAsub;
-comment Return a single bat of subselected delta.
-
pattern sql.setVariable(mvc:int,varname:str,value:any_1):int
address setVariable;
comment Set the value of a session variable
@@ -51872,10 +51856,6 @@ pattern sql.update(mvc:int,sname:str,tna
address mvc_update_wrap;
comment Update the values of the column tname.cname
-pattern sql.vacuum(sch:str,tbl:str):void
-address SQLvacuum;
-comment Choose an approach to consolidate the deletions
-
command sql.zero_or_one(col:bat[:oid,:any_1]):any_1
address zero_or_one;
comment if col contains exactly one value return this. Incase of more raise an
exception else return nil
diff --git a/clients/Tests/SQL-dump_all.stable.out
b/clients/Tests/SQL-dump_all.stable.out
--- a/clients/Tests/SQL-dump_all.stable.out
+++ b/clients/Tests/SQL-dump_all.stable.out
@@ -216,7 +216,6 @@ SYSTEM FUNCTION sys.queue
SYSTEM FUNCTION sys.radians
SYSTEM FUNCTION sys.relate
SYSTEM FUNCTION sys.resume
-SYSTEM FUNCTION sys.reuse
SYSTEM FUNCTION sys.reverse
SYSTEM FUNCTION sys.right_shift
SYSTEM FUNCTION sys.right_shift_assign
@@ -224,7 +223,6 @@ SYSTEM FUNCTION sys.sessions
SYSTEM FUNCTION sys.setmasklen
SYSTEM FUNCTION sys.setsession
SYSTEM FUNCTION sys.settimeout
-SYSTEM FUNCTION sys.shrink
SYSTEM FUNCTION sys.shutdown
SYSTEM FUNCTION sys.srid
SYSTEM FUNCTION sys.stddev_pop
@@ -240,7 +238,6 @@ SYSTEM FUNCTION sys.times
SYSTEM FUNCTION sys.touches
SYSTEM FUNCTION sys.tracelog
SYSTEM FUNCTION sys.uuid
-SYSTEM FUNCTION sys.vacuum
SYSTEM FUNCTION sys.var
SYSTEM FUNCTION sys.var_pop
SYSTEM FUNCTION sys.var_samp
@@ -1043,8 +1040,6 @@ create procedure sys.resume(tag int)
external name sql.sysmon_resume;
create procedure sys.resume(tag bigint)
external name sql.sysmon_resume;
-create procedure reuse(sys string, tab string)
- external name sql.reuse;
-- This Source Code Form is subject to the terms of the Mozilla Public
-- License, v. 2.0. If a copy of the MPL was not distributed with this
-- file, You can obtain one at http://mozilla.org/MPL/2.0/.
@@ -1069,21 +1064,6 @@ create procedure sys.settimeout("query"
external name sql.settimeout;
create procedure sys.settimeout("query" bigint, "session" bigint)
external name sql.settimeout;
--- This Source Code Form is subject to the terms of the Mozilla Public
--- License, v. 2.0. If a copy of the MPL was not distributed with this
--- file, You can obtain one at http://mozilla.org/MPL/2.0/.
---
--- Copyright 2008-2015 MonetDB B.V.
-
--- Vacuum a relational table should be done with care.
--- For, the oid's are used in join-indices.
-
--- Vacuum of tables may improve IO performance and disk footprint.
--- The foreign key constraints should be dropped before
--- and re-established after the cluster operation.
-
-create procedure shrink(sys string, tab string)
- external name sql.shrink;
create procedure sys.shutdown(delay tinyint)
external name sql.shutdown;
create procedure sys.shutdown(delay tinyint, force bool)
@@ -1260,8 +1240,6 @@ create function sys.tracelog()
-- generate a new uuid
create function sys.uuid()
returns uuid external name uuid."new";
-create procedure vacuum(sys string, tab string)
- external name sql.vacuum;
CREATE FUNCTION var() RETURNS TABLE( name varchar(1024)) EXTERNAL NAME
sql.sql_variables;
create aggregate var_pop(val tinyint) returns double
external name "aggr"."variancep";
diff --git a/clients/Tests/SQL-dump_all.stable.out.int128
b/clients/Tests/SQL-dump_all.stable.out.int128
--- a/clients/Tests/SQL-dump_all.stable.out.int128
+++ b/clients/Tests/SQL-dump_all.stable.out.int128
@@ -212,7 +212,6 @@ SYSTEM FUNCTION sys.queue
SYSTEM FUNCTION sys.radians
SYSTEM FUNCTION sys.relate
SYSTEM FUNCTION sys.resume
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
