Sql

Sql module

MODULE sql;

UNSAFE PATTERN sql.abort():void;
COMMENT "";

UNSAFE PATTERN sql.affectedRows(X_0:int, X_1:lng):int;
COMMENT "";

PATTERN sql.all(X_0:bit, X_1:bit, X_2:bit):bit;
COMMENT "";

COMMAND sql.alpha(X_0:dbl, X_1:dbl):dbl;
COMMENT "";

UNSAFE PATTERN sql.analyze(X_0:int, X_1:lng):void;
COMMENT "";

UNSAFE PATTERN sql.analyze(X_0:int, X_1:lng, X_2:str):void;
COMMENT "";

UNSAFE PATTERN sql.analyze(X_0:int, X_1:lng, X_2:str, X_3:str):void;
COMMENT "";

UNSAFE PATTERN sql.analyze(X_0:int, X_1:lng, X_2:str, X_3:str, X_4:str):void;
COMMENT "";

PATTERN sql.any(X_0:bit, X_1:bit, X_2:bit):bit;
COMMENT "";

PATTERN sql.append(X_0:int, X_1:str, X_2:str, X_3:str, X_4:oid, X_5:bat[:oid], X_6:any):int;
COMMENT "";

PATTERN sql.argRecord():str;
COMMENT "";

PATTERN sql.argRecord(X_0:any...):str;
COMMENT "";

PATTERN sql.assert(X_0:bit, X_1:str):void;
COMMENT "";

PATTERN sql.assert(X_0:int, X_1:str):void;
COMMENT "";

PATTERN sql.assert(X_0:lng, X_1:str):void;
COMMENT "";

PATTERN sql.avg(X_0:bte, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.avg(X_0:dbl, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.avg(X_0:flt, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.avg(X_0:int, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.avg(X_0:lng, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.avg(X_0:sht, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.avg(X_0:bte, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):bte;
COMMENT "";

PATTERN sql.avg(X_0:int, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):int;
COMMENT "";

PATTERN sql.avg(X_0:lng, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):lng;
COMMENT "";

PATTERN sql.avg(X_0:sht, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):sht;
COMMENT "";

PATTERN sql.bind(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int) (X_5:bat[:oid], X_6:bat[:any_1]);
COMMENT "";

PATTERN sql.bind(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int):bat[:any_1];
COMMENT "";

PATTERN sql.bind(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int, X_5:int, X_6:int) (X_7:bat[:oid], X_8:bat[:any_1]);
COMMENT "";

PATTERN sql.bind(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int, X_5:int, X_6:int):bat[:any_1];
COMMENT "";

PATTERN sql.bind_idxbat(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int) (X_5:bat[:oid], X_6:bat[:any_1]);
COMMENT "";

PATTERN sql.bind_idxbat(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int):bat[:any_1];
COMMENT "";

PATTERN sql.bind_idxbat(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int, X_5:int, X_6:int) (X_7:bat[:oid], X_8:bat[:any_1]);
COMMENT "";

PATTERN sql.bind_idxbat(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int, X_5:int, X_6:int):bat[:any_1];
COMMENT "";

UNSAFE PATTERN sql.claim(X_0:int, X_1:str, X_2:str, X_3:lng) (X_4:oid, X_5:bat[:oid]);
COMMENT "";

UNSAFE PATTERN sql.clear_table(X_0:str, X_1:str):lng;
COMMENT "";

UNSAFE PATTERN sql.commit():void;
COMMENT "";

UNSAFE PATTERN sql.copy_from(X_0:ptr, X_1:str, X_2:str, X_3:str, X_4:str, X_5:str, X_6:lng, X_7:lng, X_8:int, X_9:str, X_10:int, X_11:int):bat[:any]...;
COMMENT "";

PATTERN sql.copy_rejects() (X_0:bat[:lng], X_1:bat[:int], X_2:bat[:str], X_3:bat[:str]);
COMMENT "";

UNSAFE PATTERN sql.copy_rejects_clear():void;
COMMENT "";

PATTERN sql.corr(X_0:bte, X_1:bte, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.corr(X_0:dbl, X_1:dbl, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.corr(X_0:flt, X_1:flt, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.corr(X_0:int, X_1:int, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.corr(X_0:lng, X_1:lng, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.corr(X_0:sht, X_1:sht, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.count(X_0:str, X_1:str):lng;
COMMENT "";

PATTERN sql.count(X_0:any_1, X_1:bit, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):lng;
COMMENT "";

PATTERN sql.covariance(X_0:bte, X_1:bte, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.covariance(X_0:dbl, X_1:dbl, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.covariance(X_0:flt, X_1:flt, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.covariance(X_0:int, X_1:int, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.covariance(X_0:lng, X_1:lng, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.covariance(X_0:sht, X_1:sht, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.covariancep(X_0:bte, X_1:bte, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.covariancep(X_0:dbl, X_1:dbl, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.covariancep(X_0:flt, X_1:flt, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.covariancep(X_0:int, X_1:int, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.covariancep(X_0:lng, X_1:lng, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

PATTERN sql.covariancep(X_0:sht, X_1:sht, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl;
COMMENT "";

UNSAFE PATTERN sql.createorderindex(X_0:str, X_1:str, X_2:str):void;
COMMENT "";

PATTERN sql.cume_dist(X_0:any_1, X_1:bit, X_2:bit):dbl;
COMMENT "";

PATTERN sql.current_time():daytime;
COMMENT "";

PATTERN sql.current_timestamp():timestamp;
COMMENT "";

COMMAND sql.date_trunc(X_0:str, X_1:bat[:timestamp]):bat[:timestamp];
COMMENT "";

COMMAND sql.date_trunc(X_0:str, X_1:timestamp):timestamp;
COMMENT "";

PATTERN sql.db_users():bat[:str];
COMMENT "";

UNSAFE PATTERN sql.delete(X_0:int, X_1:str, X_2:str, X_3:any):int;
COMMENT "";

COMMAND sql.delta(X_0:bat[:any_3], X_1:bat[:oid], X_2:bat[:any_3]):bat[:any_3];
COMMENT "";

PATTERN sql.deltas(X_0:str) (X_1:bat[:int], X_2:bat[:lng], X_3:bat[:lng], X_4:bat[:lng], X_5:bat[:lng], X_6:bat[:lng], X_7:bat[:int]);
COMMENT "";

PATTERN sql.deltas(X_0:str, X_1:str) (X_2:bat[:int], X_3:bat[:lng], X_4:bat[:lng], X_5:bat[:lng], X_6:bat[:lng], X_7:bat[:lng], X_8:bat[:int]);
COMMENT "";

PATTERN sql.deltas(X_0:str, X_1:str, X_2:str) (X_3:bat[:int], X_4:bat[:lng], X_5:bat[:lng], X_6:bat[:lng], X_7:bat[:lng], X_8:bat[:lng], X_9:bat[:int]);
COMMENT "";

PATTERN sql.dense_rank(X_0:any_1, X_1:bit, X_2:bit):int;
COMMENT "";

PATTERN sql.deregister():int;
COMMENT "";

PATTERN sql.diff(X_0:any_1):bit;
COMMENT "";

PATTERN sql.diff(X_0:bit, X_1:any_1):bit;
COMMENT "";

UNSAFE PATTERN sql.drop_hash(X_0:str, X_1:str):void;
COMMENT "";

UNSAFE PATTERN sql.droporderindex(X_0:str, X_1:str, X_2:str):void;
COMMENT "";

PATTERN sql.dump_cache() (X_0:bat[:str], X_1:bat[:int]);
COMMENT "";

PATTERN sql.dump_opt_stats() (X_0:bat[:str], X_1:bat[:int]);
COMMENT "";

PATTERN sql.dump_trace() (X_0:bat[:lng], X_1:bat[:str]);
COMMENT "";

PATTERN sql.emptybind(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int) (X_5:bat[:oid], X_6:bat[:any_1]);
COMMENT "";

PATTERN sql.emptybind(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int):bat[:any_1];
COMMENT "";

PATTERN sql.emptybind(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int, X_5:int, X_6:int) (X_7:bat[:oid], X_8:bat[:any_1]);
COMMENT "";

PATTERN sql.emptybind(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int, X_5:int, X_6:int):bat[:any_1];
COMMENT "";

PATTERN sql.emptybindidx(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int) (X_5:bat[:oid], X_6:bat[:any_1]);
COMMENT "";

PATTERN sql.emptybindidx(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int):bat[:any_1];
COMMENT "";

PATTERN sql.emptybindidx(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int, X_5:int, X_6:int) (X_7:bat[:oid], X_8:bat[:any_1]);
COMMENT "";

PATTERN sql.emptybindidx(X_0:int, X_1:str, X_2:str, X_3:str, X_4:int, X_5:int, X_6:int):bat[:any_1];
COMMENT "";

COMMAND sql.epilogue():void;
COMMENT "";

PATTERN sql.eval(X_0:str):void;
COMMENT "";

PATTERN sql.eval(X_0:str, X_1:bit):void;
COMMENT "";

PATTERN sql.evalAlgebra(X_0:str, X_1:bit):void;
COMMENT "";

UNSAFE PATTERN sql.exportChunk(X_0:streams, X_1:int):void;
COMMENT "";

UNSAFE PATTERN sql.exportChunk(X_0:streams, X_1:int, X_2:int, X_3:int):void;
COMMENT "";

UNSAFE PATTERN sql.exportHead(X_0:streams, X_1:int):void;
COMMENT "";

UNSAFE PATTERN sql.exportOperation():void;
COMMENT "";

UNSAFE PATTERN sql.exportResult(X_0:streams, X_1:int):void;
COMMENT "";

UNSAFE PATTERN sql.export_table(X_0:str, X_1:str, X_2:str, X_3:str, X_4:str, X_5:str, X_6:int, X_7:bat[:str], X_8:bat[:str], X_9:bat[:str], X_10:bat[:int], X_11:bat[:int], X_12:any...):int;
COMMENT "";

UNSAFE PATTERN sql.export_table(X_0:str, X_1:str, X_2:str, X_3:str, X_4:str, X_5:str, X_6:int, X_7:bat[:str], X_8:bat[:str], X_9:bat[:str], X_10:bat[:int], X_11:bat[:int], X_12:bat[:any]...):int;
COMMENT "";

PATTERN sql.first_value(X_0:any_1, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):any_1;
COMMENT "";

PATTERN sql.getVariable(X_0:int, X_1:str, X_2:str):any_1;
COMMENT "";

COMMAND sql.getVersion(X_0:int):lng;
COMMENT "";

PATTERN sql.get_value(X_0:str, X_1:str):lng;
COMMENT "";

PATTERN sql.grow(X_0:bat[:oid], X_1:any_1):int;
COMMENT "";

UNSAFE PATTERN sql.hot_snapshot(X_0:str):void;
COMMENT "";

UNSAFE PATTERN sql.hot_snapshot(X_0:str, X_1:bit):void;
COMMENT "";

PATTERN sql.importColumn(X_0:str, X_1:bit, X_2:str, X_3:int, X_4:oid) (X_5:bat[:any], X_6:oid);
COMMENT "";

UNSAFE PATTERN sql.importTable(X_0:str, X_1:str, X_2:int, X_3:bit, X_4:str...):bat[:any]...;
COMMENT "";

PATTERN sql.include(X_0:str):void;
COMMENT "";

COMMAND sql.index(X_0:str, X_1:bit):bte;
COMMENT "";

COMMAND sql.index(X_0:str, X_1:bit):int;
COMMENT "";

COMMAND sql.index(X_0:str, X_1:bit):sht;
COMMENT "";

PATTERN sql.lag(X_0:any_1, X_1:any, X_2:any_1, X_3:bit, X_4:bit):any_1;
COMMENT "";

PATTERN sql.lag(X_0:any_1, X_1:any, X_2:bit, X_3:bit):any_1;
COMMENT "";

PATTERN sql.lag(X_0:any_1, X_1:bit, X_2:bit):any_1;
COMMENT "";

PATTERN sql.last_value(X_0:any_1, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):any_1;
COMMENT "";

PATTERN sql.lead(X_0:any_1, X_1:any, X_2:any_1, X_3:bit, X_4:bit):any_1;
COMMENT "";

PATTERN sql.lead(X_0:any_1, X_1:any, X_2:bit, X_3:bit):any_1;
COMMENT "";

PATTERN sql.lead(X_0:any_1, X_1:bit, X_2:bit):any_1;
COMMENT "";

UNSAFE PATTERN sql.logfile(X_0:str):void;
COMMENT "";

PATTERN sql.max(X_0:any_1, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):any_1;
COMMENT "";

PATTERN sql.min(X_0:any_1, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):any_1;
COMMENT "";

COMMAND sql.ms_trunc(X_0:dbl, X_1:int):dbl;
COMMENT "";

COMMAND sql.ms_trunc(X_0:flt, X_1:int):flt;
COMMENT "";

PATTERN sql.mvc():int;
COMMENT "";

PATTERN sql.next_value(X_0:str, X_1:str):lng;
COMMENT "";

PATTERN sql.nth_value(X_0:any_1, X_1:lng, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):any_1;
COMMENT "";

PATTERN sql.ntile(X_0:any, X_1:any_1, X_2:bit, X_3:bit):any_1;
COMMENT "";

PATTERN sql.optimizer_updates():void;
COMMENT "";

COMMAND sql.optimizers() (X_0:bat[:str], X_1:bat[:str], X_2:bat[:str]);
COMMENT "";

PATTERN sql.password(X_0:str):str;
COMMENT "";

PATTERN sql.percent_rank(X_0:any_1, X_1:bit, X_2:bit):dbl;
COMMENT "";

PATTERN sql.prelude():void;
COMMENT "";

PATTERN sql.prepared_statements() (X_0:bat[:int], X_1:bat[:str], X_2:bat[:int], X_3:bat[:str], X_4:bat[:timestamp]);
COMMENT "";

PATTERN sql.prepared_statements_args() (X_0:bat[:int], X_1:bat[:str], X_2:bat[:int], X_3:bat[:int], X_4:bat[:bte], X_5:bat[:int], X_6:bat[:str], X_7:bat[:str], X_8:bat[:str]);
COMMENT "";

PATTERN sql.prod(X_0:bte, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):lng;
COMMENT "";

PATTERN sql.prod(X_0:dbl, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.prod(X_0:flt, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.prod(X_0:flt, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):flt;
COMMENT "";

PATTERN sql.prod(X_0:int, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):lng;
COMMENT "";

PATTERN sql.prod(X_0:lng, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):lng;
COMMENT "";

PATTERN sql.prod(X_0:sht, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):lng;
COMMENT "";

COMMAND sql.project(X_0:bat[:oid], X_1:bat[:oid], X_2:bat[:oid]):bat[:oid];
COMMENT "";

COMMAND sql.projectdelta(X_0:bat[:oid], X_1:bat[:any_3], X_2:bat[:oid], X_3:bat[:any_3]):bat[:any_3];
COMMENT "";

PATTERN sql.querylog_calls() (X_0:bat[:oid], X_1:bat[:timestamp], X_2:bat[:timestamp], X_3:bat[:str], X_4:bat[:lng], X_5:bat[:lng], X_6:bat[:lng], X_7:bat[:int], X_8:bat[:int]);
COMMENT "";

PATTERN sql.querylog_catalog() (X_0:bat[:oid], X_1:bat[:str], X_2:bat[:timestamp], X_3:bat[:str], X_4:bat[:str], X_5:bat[:str], X_6:bat[:int], X_7:bat[:lng]);
COMMENT "";

UNSAFE COMMAND sql.querylog_disable():void;
COMMENT "";

UNSAFE PATTERN sql.querylog_empty():void;
COMMENT "";

UNSAFE COMMAND sql.querylog_enable():void;
COMMENT "";

UNSAFE COMMAND sql.querylog_enable(X_0:int):void;
COMMENT "";

PATTERN sql.rank(X_0:any_1, X_1:bit, X_2:bit):int;
COMMENT "";

PATTERN sql.register(X_0:str, X_1:str, X_2:str, X_3:str):int;
COMMENT "";

PATTERN sql.register(X_0:str, X_1:str, X_2:str, X_3:str, X_4:str):int;
COMMENT "";

UNSAFE PATTERN sql.restart(X_0:str, X_1:str, X_2:lng):lng;
COMMENT "";

UNSAFE PATTERN sql.resultSet(X_0:bat[:str], X_1:bat[:str], X_2:bat[:str], X_3:bat[:int], X_4:bat[:int], X_5:any...):int;
COMMENT "";

UNSAFE PATTERN sql.resultSet(X_0:str, X_1:str, X_2:str, X_3:int, X_4:int, X_5:int, X_6:any):int;
COMMENT "";

UNSAFE PATTERN sql.resultSet(X_0:bat[:str], X_1:bat[:str], X_2:bat[:str], X_3:bat[:int], X_4:bat[:int], X_5:bat[:any]...):int;
COMMENT "";

UNSAFE PATTERN sql.resume_log_flushing():void;
COMMENT "";

PATTERN sql.row_number(X_0:any_1, X_1:bit, X_2:bit):int;
COMMENT "";

PATTERN sql.rt_credentials(X_0:str) (X_1:bat[:str], X_2:bat[:str], X_3:bat[:str]);
COMMENT "";

PATTERN sql.sessions() (X_0:bat[:int], X_1:bat[:str], X_2:bat[:timestamp], X_3:bat[:timestamp], X_4:bat[:str], X_5:bat[:int], X_6:bat[:int], X_7:bat[:int], X_8:bat[:int]);
COMMENT "";

UNSAFE PATTERN sql.setVariable(X_0:int, X_1:str, X_2:str, X_3:any_1):int;
COMMENT "";

UNSAFE PATTERN sql.set_protocol(X_0:int):int;
COMMENT "";

PATTERN sql.shutdown(X_0:bte):str;
COMMENT "";

PATTERN sql.shutdown(X_0:bte, X_1:bit):str;
COMMENT "";

PATTERN sql.shutdown(X_0:int):str;
COMMENT "";

PATTERN sql.shutdown(X_0:int, X_1:bit):str;
COMMENT "";

PATTERN sql.shutdown(X_0:sht):str;
COMMENT "";

PATTERN sql.shutdown(X_0:sht, X_1:bit):str;
COMMENT "";

PATTERN sql.sql_variables() (X_0:bat[:str], X_1:bat[:str], X_2:bat[:str], X_3:bat[:str]);
COMMENT "";

PATTERN sql.stdev(X_0:bte, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.stdev(X_0:dbl, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.stdev(X_0:flt, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.stdev(X_0:int, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.stdev(X_0:lng, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.stdev(X_0:sht, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.stdevp(X_0:bte, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.stdevp(X_0:dbl, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.stdevp(X_0:flt, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.stdevp(X_0:int, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.stdevp(X_0:lng, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.stdevp(X_0:sht, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.storage() (X_0:bat[:str], X_1:bat[:str], X_2:bat[:str], X_3:bat[:str], X_4:bat[:str], X_5:bat[:str], X_6:bat[:lng], X_7:bat[:int], X_8:bat[:lng], X_9:bat[:lng], X_10:bat[:lng], X_11:bat[:bit], X_12:bat[:lng], X_13:bat[:bit], X_14:bat[:bit], X_15:bat[:bit], X_16:bat[:lng]);
COMMENT "";

PATTERN sql.storage(X_0:str) (X_1:bat[:str], X_2:bat[:str], X_3:bat[:str], X_4:bat[:str], X_5:bat[:str], X_6:bat[:str], X_7:bat[:lng], X_8:bat[:int], X_9:bat[:lng], X_10:bat[:lng], X_11:bat[:lng], X_12:bat[:bit], X_13:bat[:lng], X_14:bat[:bit], X_15:bat[:bit], X_16:bat[:bit], X_17:bat[:lng]);
COMMENT "";

PATTERN sql.storage(X_0:str, X_1:str) (X_2:bat[:str], X_3:bat[:str], X_4:bat[:str], X_5:bat[:str], X_6:bat[:str], X_7:bat[:str], X_8:bat[:lng], X_9:bat[:int], X_10:bat[:lng], X_11:bat[:lng], X_12:bat[:lng], X_13:bat[:bit], X_14:bat[:lng], X_15:bat[:bit], X_16:bat[:bit], X_17:bat[:bit], X_18:bat[:lng]);
COMMENT "";

PATTERN sql.storage(X_0:str, X_1:str, X_2:str) (X_3:bat[:str], X_4:bat[:str], X_5:bat[:str], X_6:bat[:str], X_7:bat[:str], X_8:bat[:str], X_9:bat[:lng], X_10:bat[:int], X_11:bat[:lng], X_12:bat[:lng], X_13:bat[:lng], X_14:bat[:bit], X_15:bat[:lng], X_16:bat[:bit], X_17:bat[:bit], X_18:bat[:bit], X_19:bat[:lng]);
COMMENT "";

PATTERN sql.str_group_concat(X_0:str, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):str;
COMMENT "";

PATTERN sql.str_group_concat(X_0:str, X_1:str, X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):str;
COMMENT "";

COMMAND sql.strings(X_0:str):str;
COMMENT "";

COMMAND sql.subdelta(X_0:bat[:oid], X_1:bat[:oid], X_2:bat[:oid], X_3:bat[:oid]):bat[:oid];
COMMENT "";

PATTERN sql.sum(X_0:bte, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):lng;
COMMENT "";

PATTERN sql.sum(X_0:dbl, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.sum(X_0:flt, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.sum(X_0:flt, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):flt;
COMMENT "";

PATTERN sql.sum(X_0:int, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):lng;
COMMENT "";

PATTERN sql.sum(X_0:lng, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):lng;
COMMENT "";

PATTERN sql.sum(X_0:sht, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):lng;
COMMENT "";

UNSAFE PATTERN sql.suspend_log_flushing():void;
COMMENT "";

PATTERN sql.tid(X_0:int, X_1:str, X_2:str):bat[:oid];
COMMENT "";

PATTERN sql.tid(X_0:int, X_1:str, X_2:str, X_3:int, X_4:int):bat[:oid];
COMMENT "";

UNSAFE PATTERN sql.transaction():void;
COMMENT "";

UNSAFE PATTERN sql.transaction():void;
COMMENT "";

UNSAFE PATTERN sql.transaction_begin(X_0:int, X_1:str):void;
COMMENT "";

UNSAFE PATTERN sql.transaction_commit(X_0:int, X_1:str):void;
COMMENT "";

UNSAFE PATTERN sql.transaction_release(X_0:int, X_1:str):void;
COMMENT "";

UNSAFE PATTERN sql.transaction_rollback(X_0:int, X_1:str):void;
COMMENT "";

PATTERN sql.unionfunc(X_0:str, X_1:str, X_2:any...):any...;
COMMENT "";

PATTERN sql.update(X_0:int, X_1:str, X_2:str, X_3:str, X_4:any, X_5:any):int;
COMMENT "";

UNSAFE PATTERN sql.update_schemas():void;
COMMENT "";

UNSAFE PATTERN sql.update_tables():void;
COMMENT "";

PATTERN sql.variance(X_0:bte, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.variance(X_0:dbl, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.variance(X_0:flt, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.variance(X_0:int, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.variance(X_0:lng, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.variance(X_0:sht, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.variancep(X_0:bte, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.variancep(X_0:dbl, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.variancep(X_0:flt, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.variancep(X_0:int, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.variancep(X_0:lng, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.variancep(X_0:sht, X_1:bit, X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl;
COMMENT "";

PATTERN sql.window_bound(X_0:any_1, X_1:int, X_2:int, X_3:int, X_4:bte):oid;
COMMENT "";

PATTERN sql.window_bound(X_0:any_1, X_1:int, X_2:int, X_3:int, X_4:dbl):oid;
COMMENT "";

PATTERN sql.window_bound(X_0:any_1, X_1:int, X_2:int, X_3:int, X_4:flt):oid;
COMMENT "";

PATTERN sql.window_bound(X_0:any_1, X_1:int, X_2:int, X_3:int, X_4:int):oid;
COMMENT "";

PATTERN sql.window_bound(X_0:any_1, X_1:int, X_2:int, X_3:int, X_4:lng):oid;
COMMENT "";

PATTERN sql.window_bound(X_0:any_1, X_1:int, X_2:int, X_3:int, X_4:sht):oid;
COMMENT "";

PATTERN sql.window_bound(X_0:bit, X_1:any_1, X_2:int, X_3:int, X_4:int, X_5:bte):oid;
COMMENT "";

PATTERN sql.window_bound(X_0:bit, X_1:any_1, X_2:int, X_3:int, X_4:int, X_5:dbl):oid;
COMMENT "";

PATTERN sql.window_bound(X_0:bit, X_1:any_1, X_2:int, X_3:int, X_4:int, X_5:flt):oid;
COMMENT "";

PATTERN sql.window_bound(X_0:bit, X_1:any_1, X_2:int, X_3:int, X_4:int, X_5:int):oid;
COMMENT "";

PATTERN sql.window_bound(X_0:bit, X_1:any_1, X_2:int, X_3:int, X_4:int, X_5:lng):oid;
COMMENT "";

PATTERN sql.window_bound(X_0:bit, X_1:any_1, X_2:int, X_3:int, X_4:int, X_5:sht):oid;
COMMENT "";

Batsql module

MODULE batsql;

PATTERN batsql.all(X_0:bat[:bit], X_1:bat[:bit], X_2:bat[:bit]):bat[:bit];
COMMENT "";

PATTERN batsql.all(X_0:bat[:bit], X_1:bat[:bit], X_2:bit):bat[:bit];
COMMENT "";

PATTERN batsql.all(X_0:bat[:bit], X_1:bit, X_2:bat[:bit]):bat[:bit];
COMMENT "";

PATTERN batsql.all(X_0:bat[:bit], X_1:bit, X_2:bit):bat[:bit];
COMMENT "";

PATTERN batsql.all(X_0:bit, X_1:bat[:bit], X_2:bat[:bit]):bat[:bit];
COMMENT "";

PATTERN batsql.all(X_0:bit, X_1:bat[:bit], X_2:bit):bat[:bit];
COMMENT "";

PATTERN batsql.all(X_0:bit, X_1:bit, X_2:bat[:bit]):bat[:bit];
COMMENT "";

COMMAND batsql.alpha(X_0:bat[:dbl], X_1:dbl):bat[:dbl];
COMMENT "";

COMMAND batsql.alpha(X_0:dbl, X_1:bat[:dbl]):bat[:dbl];
COMMENT "";

PATTERN batsql.any(X_0:bat[:bit], X_1:bat[:bit], X_2:bat[:bit]):bat[:bit];
COMMENT "";

PATTERN batsql.any(X_0:bat[:bit], X_1:bat[:bit], X_2:bit):bat[:bit];
COMMENT "";

PATTERN batsql.any(X_0:bat[:bit], X_1:bit, X_2:bat[:bit]):bat[:bit];
COMMENT "";

PATTERN batsql.any(X_0:bat[:bit], X_1:bit, X_2:bit):bat[:bit];
COMMENT "";

PATTERN batsql.any(X_0:bit, X_1:bat[:bit], X_2:bat[:bit]):bat[:bit];
COMMENT "";

PATTERN batsql.any(X_0:bit, X_1:bat[:bit], X_2:bit):bat[:bit];
COMMENT "";

PATTERN batsql.any(X_0:bit, X_1:bit, X_2:bat[:bit]):bat[:bit];
COMMENT "";

PATTERN batsql.avg(X_0:bat[:bte], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.avg(X_0:bat[:dbl], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.avg(X_0:bat[:flt], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.avg(X_0:bat[:int], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.avg(X_0:bat[:lng], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.avg(X_0:bat[:sht], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.avg(X_0:bat[:bte], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:bte];
COMMENT "";

PATTERN batsql.avg(X_0:bat[:int], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:int];
COMMENT "";

PATTERN batsql.avg(X_0:bat[:lng], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:lng];
COMMENT "";

PATTERN batsql.avg(X_0:bat[:sht], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:sht];
COMMENT "";

PATTERN batsql.corr(X_0:bat[:bte], X_1:bat[:bte], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:bat[:bte], X_1:bte, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:bat[:dbl], X_1:bat[:dbl], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:bat[:dbl], X_1:dbl, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:bat[:flt], X_1:bat[:flt], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:bat[:flt], X_1:flt, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:bat[:int], X_1:bat[:int], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:bat[:int], X_1:int, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:bat[:lng], X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:bat[:lng], X_1:lng, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:bat[:sht], X_1:bat[:sht], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:bat[:sht], X_1:sht, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:bte, X_1:bat[:bte], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:dbl, X_1:bat[:dbl], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:flt, X_1:bat[:flt], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:int, X_1:bat[:int], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:lng, X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.corr(X_0:sht, X_1:bat[:sht], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.count(X_0:bat[:any_1], X_1:bit, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:lng];
COMMENT "";

PATTERN batsql.covariance(X_0:bat[:bte], X_1:bat[:bte], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:bat[:bte], X_1:bte, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:bat[:dbl], X_1:bat[:dbl], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:bat[:dbl], X_1:dbl, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:bat[:flt], X_1:bat[:flt], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:bat[:flt], X_1:flt, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:bat[:int], X_1:bat[:int], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:bat[:int], X_1:int, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:bat[:lng], X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:bat[:lng], X_1:lng, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:bat[:sht], X_1:bat[:sht], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:bat[:sht], X_1:sht, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:bte, X_1:bat[:bte], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:dbl, X_1:bat[:dbl], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:flt, X_1:bat[:flt], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:int, X_1:bat[:int], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:lng, X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariance(X_0:sht, X_1:bat[:sht], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:bat[:bte], X_1:bat[:bte], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:bat[:bte], X_1:bte, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:bat[:dbl], X_1:bat[:dbl], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:bat[:dbl], X_1:dbl, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:bat[:flt], X_1:bat[:flt], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:bat[:flt], X_1:flt, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:bat[:int], X_1:bat[:int], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:bat[:int], X_1:int, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:bat[:lng], X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:bat[:lng], X_1:lng, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:bat[:sht], X_1:bat[:sht], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:bat[:sht], X_1:sht, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:bte, X_1:bat[:bte], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:dbl, X_1:bat[:dbl], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:flt, X_1:bat[:flt], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:int, X_1:bat[:int], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:lng, X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.covariancep(X_0:sht, X_1:bat[:sht], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl];
COMMENT "";

PATTERN batsql.cume_dist(X_0:bat[:any_1], X_1:any_2, X_2:any_3):bat[:dbl];
COMMENT "";

PATTERN batsql.dense_rank(X_0:bat[:any_1], X_1:any_2, X_2:any_3):bat[:int];
COMMENT "";

PATTERN batsql.diff(X_0:bat[:any_1]):bat[:bit];
COMMENT "";

PATTERN batsql.diff(X_0:bat[:bit], X_1:any_1):bat[:bit];
COMMENT "";

PATTERN batsql.diff(X_0:bat[:bit], X_1:bat[:any_1]):bat[:bit];
COMMENT "";

PATTERN batsql.diff(X_0:bit, X_1:bat[:any_1]):bat[:bit];
COMMENT "";

PATTERN batsql.first_value(X_0:bat[:any_1], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:any_1];
COMMENT "";

PATTERN batsql.get_value(X_0:bat[:str], X_1:bat[:str]):bat[:lng];
COMMENT "";

PATTERN batsql.get_value(X_0:bat[:str], X_1:str):bat[:lng];
COMMENT "";

PATTERN batsql.get_value(X_0:str, X_1:bat[:str]):bat[:lng];
COMMENT "";

COMMAND batsql.index(X_0:bat[:str], X_1:bit):bat[:bte];
COMMENT "";

COMMAND batsql.index(X_0:bat[:str], X_1:bit):bat[:int];
COMMENT "";

COMMAND batsql.index(X_0:bat[:str], X_1:bit):bat[:sht];
COMMENT "";

PATTERN batsql.lag(X_0:any_1, X_1:any, X_2:bat[:any_1], X_3:any_2, X_4:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lag(X_0:any_1, X_1:bat[:any], X_2:any_1, X_3:any_2, X_4:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lag(X_0:any_1, X_1:bat[:any], X_2:any_2, X_3:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lag(X_0:any_1, X_1:bat[:any], X_2:bat[:any_1], X_3:any_2, X_4:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lag(X_0:bat[:any_1], X_1:any, X_2:any_1, X_3:any_2, X_4:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lag(X_0:bat[:any_1], X_1:any, X_2:any_2, X_3:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lag(X_0:bat[:any_1], X_1:any, X_2:bat[:any_1], X_3:any_2, X_4:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lag(X_0:bat[:any_1], X_1:any_2, X_2:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lag(X_0:bat[:any_1], X_1:bat[:any], X_2:any_1, X_3:any_2, X_4:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lag(X_0:bat[:any_1], X_1:bat[:any], X_2:any_2, X_3:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lag(X_0:bat[:any_1], X_1:bat[:any], X_2:bat[:any_1], X_3:any_2, X_4:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.last_value(X_0:bat[:any_1], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:any_1];
COMMENT "";

PATTERN batsql.lead(X_0:any_1, X_1:any, X_2:bat[:any_1], X_3:any_2, X_4:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lead(X_0:any_1, X_1:bat[:any], X_2:any_1, X_3:any_2, X_4:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lead(X_0:any_1, X_1:bat[:any], X_2:any_2, X_3:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lead(X_0:any_1, X_1:bat[:any], X_2:bat[:any_1], X_3:any_2, X_4:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lead(X_0:bat[:any_1], X_1:any, X_2:any_1, X_3:any_2, X_4:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lead(X_0:bat[:any_1], X_1:any, X_2:any_2, X_3:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lead(X_0:bat[:any_1], X_1:any, X_2:bat[:any_1], X_3:any_2, X_4:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lead(X_0:bat[:any_1], X_1:any_2, X_2:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lead(X_0:bat[:any_1], X_1:bat[:any], X_2:any_1, X_3:any_2, X_4:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lead(X_0:bat[:any_1], X_1:bat[:any], X_2:any_2, X_3:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.lead(X_0:bat[:any_1], X_1:bat[:any], X_2:bat[:any_1], X_3:any_2, X_4:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.max(X_0:bat[:any_1], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:any_1];
COMMENT "";

PATTERN batsql.min(X_0:bat[:any_1], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:any_1];
COMMENT "";

PATTERN batsql.next_value(X_0:bat[:str], X_1:bat[:str]):bat[:lng];
COMMENT "";

PATTERN batsql.next_value(X_0:bat[:str], X_1:str):bat[:lng];
COMMENT "";

PATTERN batsql.next_value(X_0:str, X_1:bat[:str]):bat[:lng];
COMMENT "";

PATTERN batsql.nth_value(X_0:any_1, X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1];
COMMENT "";

PATTERN batsql.nth_value(X_0:bat[:any_1], X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1];
COMMENT "";

PATTERN batsql.nth_value(X_0:bat[:any_1], X_1:lng, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1];
COMMENT "";

PATTERN batsql.ntile(X_0:any, X_1:bat[:any_1], X_2:any_2, X_3:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.ntile(X_0:bat[:any], X_1:any_1, X_2:any_2, X_3:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.ntile(X_0:bat[:any], X_1:bat[:any_1], X_2:any_2, X_3:any_3):bat[:any_1];
COMMENT "";

PATTERN batsql.password(X_0:bat[:str]):bat[:str];
COMMENT "";

PATTERN batsql.percent_rank(X_0:bat[:any_1], X_1:any_2, X_2:any_3):bat[:dbl];
COMMENT "";

PATTERN batsql.prod(X_0:bat[:bte], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:lng];
COMMENT "";

PATTERN batsql.prod(X_0:bat[:dbl], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.prod(X_0:bat[:flt], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.prod(X_0:bat[:flt], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:flt];
COMMENT "";

PATTERN batsql.prod(X_0:bat[:int], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:lng];
COMMENT "";

PATTERN batsql.prod(X_0:bat[:lng], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:lng];
COMMENT "";

PATTERN batsql.prod(X_0:bat[:sht], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:lng];
COMMENT "";

PATTERN batsql.rank(X_0:bat[:any_1], X_1:any_2, X_2:any_3):bat[:int];
COMMENT "";

UNSAFE PATTERN batsql.restart(X_0:bat[:str], X_1:bat[:str], X_2:bat[:lng]):bat[:lng];
COMMENT "";

UNSAFE PATTERN batsql.restart(X_0:bat[:str], X_1:bat[:str], X_2:lng):bat[:lng];
COMMENT "";

UNSAFE PATTERN batsql.restart(X_0:bat[:str], X_1:str, X_2:bat[:lng]):bat[:lng];
COMMENT "";

UNSAFE PATTERN batsql.restart(X_0:bat[:str], X_1:str, X_2:lng):bat[:lng];
COMMENT "";

UNSAFE PATTERN batsql.restart(X_0:str, X_1:bat[:str], X_2:bat[:lng]):bat[:lng];
COMMENT "";

UNSAFE PATTERN batsql.restart(X_0:str, X_1:bat[:str], X_2:lng):bat[:lng];
COMMENT "";

UNSAFE PATTERN batsql.restart(X_0:str, X_1:str, X_2:bat[:lng]):bat[:lng];
COMMENT "";

PATTERN batsql.row_number(X_0:bat[:any_1], X_1:any_2, X_2:any_3):bat[:int];
COMMENT "";

PATTERN batsql.stdev(X_0:bat[:bte], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.stdev(X_0:bat[:dbl], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.stdev(X_0:bat[:flt], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.stdev(X_0:bat[:int], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.stdev(X_0:bat[:lng], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.stdev(X_0:bat[:sht], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.stdevp(X_0:bat[:bte], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.stdevp(X_0:bat[:dbl], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.stdevp(X_0:bat[:flt], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.stdevp(X_0:bat[:int], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.stdevp(X_0:bat[:lng], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.stdevp(X_0:bat[:sht], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.str_group_concat(X_0:bat[:str], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:str];
COMMENT "";

PATTERN batsql.str_group_concat(X_0:bat[:str], X_1:bat[:str], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:str];
COMMENT "";

PATTERN batsql.str_group_concat(X_0:bat[:str], X_1:str, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:str];
COMMENT "";

PATTERN batsql.str_group_concat(X_0:str, X_1:bat[:str], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:str];
COMMENT "";

COMMAND batsql.strings(X_0:bat[:str]):bat[:str];
COMMENT "";

PATTERN batsql.sum(X_0:bat[:bte], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:lng];
COMMENT "";

PATTERN batsql.sum(X_0:bat[:dbl], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.sum(X_0:bat[:flt], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.sum(X_0:bat[:flt], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:flt];
COMMENT "";

PATTERN batsql.sum(X_0:bat[:int], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:lng];
COMMENT "";

PATTERN batsql.sum(X_0:bat[:lng], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:lng];
COMMENT "";

PATTERN batsql.sum(X_0:bat[:sht], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:lng];
COMMENT "";

PATTERN batsql.variance(X_0:bat[:bte], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.variance(X_0:bat[:dbl], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.variance(X_0:bat[:flt], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.variance(X_0:bat[:int], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.variance(X_0:bat[:lng], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.variance(X_0:bat[:sht], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.variancep(X_0:bat[:bte], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.variancep(X_0:bat[:dbl], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.variancep(X_0:bat[:flt], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.variancep(X_0:bat[:int], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.variancep(X_0:bat[:lng], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.variancep(X_0:bat[:sht], X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:dbl];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int, X_4:bat[:bte]):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int, X_4:bat[:dbl]):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int, X_4:bat[:flt]):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int, X_4:bat[:int]):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int, X_4:bat[:lng]):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int, X_4:bat[:sht]):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int, X_4:bte):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int, X_4:dbl):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int, X_4:flt):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int, X_4:int):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int, X_4:lng):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int, X_4:sht):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int, X_4:int, X_5:bat[:bte]):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int, X_4:int, X_5:bat[:dbl]):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int, X_4:int, X_5:bat[:flt]):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int, X_4:int, X_5:bat[:int]):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int, X_4:int, X_5:bat[:lng]):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int, X_4:int, X_5:bat[:sht]):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int, X_4:int, X_5:bte):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int, X_4:int, X_5:dbl):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int, X_4:int, X_5:flt):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int, X_4:int, X_5:int):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int, X_4:int, X_5:lng):bat[:oid];
COMMENT "";

PATTERN batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int, X_4:int, X_5:sht):bat[:oid];
COMMENT "";