- developers-list - monetdb.org

MonetDB concurrent commits exception
by Vijay Krishna 13 Nov '15

13 Nov '15

Hi, I am running a setup on MonetDB where in concurrent transactions take place. Everything works very fine but for a few transactions getting aborted due to SQLExceptions. I have set *auto commit to false* for all these transactions. I am getting frequent SQLExceptions with the message as *java.sql.SQLException: COMMIT: failed* But if I retry the same transaction, this works fine. Any idea on what would be the reason for frequent commit fails? When I set *auto commit to true* for the transactions, I get similarly frequent Exceptions but the message becomes *java.sql.SQLException: COMMIT: transaction is aborted because of concurrency conflicts* Is it like both the exception thrown be for the same cause? Any help much appreciated. Thanks in Advance. Vijayakrishna.P. Mobile : (+91) 9500402305.

2 1

Import bug on bug tracker
by andy.barlow＠datum360.com 12 Nov '15

12 Nov '15

Hello there I reported what I believe to be a bug in the import routines towards the end of September: https://www.monetdb.org/bugzilla/show_bug.cgi?id=3812#c0 <https://www.monetdb.org/bugzilla/show_bug.cgi?id=3812#c0> Below is a summary of the issue I encountered, I wasn’t sure if the bug tracker is live/active so trying on this mailing list. Of course, this may be expected behaviour (though I doubt it) in which case would be useful to know. [reply <https://www.monetdb.org/bugzilla/process_bug.cgi#add_comment>] [−] <https://www.monetdb.org/bugzilla/process_bug.cgi#>Description <https://www.monetdb.org/bugzilla/show_bug.cgi?id=3812#c0>Andy Barlow <mailto:andy.barlow@datum360.com> 2015-09-25 15:19:43 CEST User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_1) AppleWebKit/601.2.4 (KHTML, like Gecko) Version/9.0.1 Safari/601.2.4 Build Identifier: If your import file contains a number of character combinations, such as \560, \561, \700 and probably lots of others, the copy into fails with a message like: Failed to import table line 5 field 1 'varchar(20)' expected in 'FIVE\700' Reproducible: Always Steps to Reproduce: 1. create table test (test varchar(20)); 2. create a load file test.txt with the following: ONE TWO THREE FOUR FIVE\700 3. copy into test from 'test.txt' using delimiters '\t','\n'; 4. fails with message: Failed to import table line 5 field 1 'varchar(20)' expected in 'FIVE\700' Actual Results: Failed to import table line 5 field 1 'varchar(20)' expected in 'FIVE\700' Expected Results: should import OK, the character combinations are valid [reply <https://www.monetdb.org/bugzilla/process_bug.cgi#add_comment>] [−] <https://www.monetdb.org/bugzilla/process_bug.cgi#>Comment 1 <https://www.monetdb.org/bugzilla/show_bug.cgi?id=3812#c1>Andy Barlow <mailto:andy.barlow@datum360.com> 2015-09-25 16:04:00 CEST it appears that the copy command is treating the input as octal. If you convert the backslash \ into its octal equivalent, \134 then it “works”. In some cases, such as \700 an error is thrown. With an import file test.txt: ONE\101 ONE\134101 When imported into table test (test varchar(20)), you get: ONEA ONE\101 So the copy command is converting octal to UTF-8,ASCII equivalen Andy Barlow t: +44 7830 302268 www.datum360.com <http://www.datum360.com/> ...delivering a measured approach to engineering information Please be advised that this email may contain confidential information. If you are not the intended recipient, please do not read, copy or re-transmit this email. If you have received this email in error, please notify us by email by replying to the sender or by telephone and delete this message and any attachments. Thank you in advance for your cooperation and assistance. In addition, Datum360 disclaim that the content of this email constitutes an offer to enter into, or the acceptance of, any contract or agreement or any amendment thereto; provided that the foregoing disclaimer does not invalidate the binding effect of any digital or other electronic reproduction of a manual signature that is included in any attachment to this email.

2 1

BigDecimal Bug in MonetDB JDBC Driver
by Søren Haagerup 09 Nov '15

09 Nov '15

Hello developers, I found a bug when using BigDecimals in prepared statements with MonetDB¹s JDBC driver. If I have a column of type DECIMAL(15,2) and insert a big decimal with the value 627000.00 through a PreparedStatement, it will turn out as 630000.00 in the DB, since the MonetDB JDBC driver currently mixes up "precision" and "scale", and rounds 627000.00 to a precision of 2 ciphers. I made a bugfix for it, and it can be seen here: https://github.com/shaagerup/monet-jdbc/commit/ ebc5e654dc28e3b56d4c4b610d3d339e675d6c2c I¹m sorry for not committing it directly to your repository, but since I am not a Mercurial user, I hope someone else will use this information to improve the official JDBC driver. Best regards Søren Haagerup

2 1

Announcement: New Jul2015-SP1 Bugfix release of MonetDB suite
by Sjoerd Mullender 03 Nov '15

03 Nov '15

The MonetDB team at CWI/MonetDB BV is pleased to announce the Jul2015-SP1 bugfix release of the MonetDB suite of programs. More information about MonetDB can be found on our website at <http://www.monetdb.org/>. For details on this release, please see the release notes at <http://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <http://dev.monetdb.org/downloads/>. Jul 2015-SP1 bugfix release Client Package * In the SQL formatter of mclient (the default) we now properly align East Asian wide characters. Bug Fixes * 3789: Query on large string table fails on HEAPextend * 3794: table function sys.rejects() and view sys.rejects() are listed are metadata objects but give an (incorrect) error when they are queried * 3797: COPY INTO with incorrect number columns * 3798: SELECT query with INTERSECT causes assertion failure * 3800: LIKE is broken for many patterns * 3802: Disk space never freed: a logical ref is keeped on a deleted BATs * 3803: SQL query parser fails to parse valid SELECT query with a CASE .. END in it. It fails with parser error: identifier 'x' ambiguous * 3804: `monetdb status` command crashes under certain conditions * 3809: Inefficient plan is generated for queries with many (>= 24) joined tables which take a long time or an HEAPalloc error. I get Error: GDK reported error. HEAPalloc: Insufficie * 3810: Fix statistics gathering * 3811: NOT LIKE not working if the operand doesn't contains wildcards. * 3813: COPY INTO fails on perfectly clean CSV file * 3814: Server crash when using bitwise NOT operation in SQL query * 3816: Server crashes when trying to convert timestamp to str with incorrect format * 3818: Crash when performing UNION/GROUP BY over tables with different columns * 3819: order of tables in FROM-clause has negative impact on generated plan (using crossproducts instead of joins) * 3820: mclient accepts table with repeated constraint which causes crash on insert * 3821: Unexpected error when using a number instead of a boolean * 3822: Yet another LIKE operator issue * 3823: JDBC Connection to a schema - setSchema() error * 3825: MonetDB not cleaning intermediate results which leads to filling up disk space and ultimately server crash * 3827: Certains comparisons between UUID produce a MAL error * 3828: Schema corruption after several ALTER TABLE statements and server restart * 3829: Certains simple WHERE clause cause MonetDB to segfault without explanation * 3830: Coalesce typing inconsistencies * 3833: NULL literals refused at many places * 3834: Date comparison returns incorrect results * 3839: msqldump generates incorrect syntax ON UPDATE (null)

1 0

Crash in table.c
by 营营 02 Nov '15

02 Nov '15

Hi MonetDB Dev, I can import the data in Jul2015, but the latest code fails to import(Win7 64Bit). It crashes in table.c (I used the old version (Jul2015) of this file, there is no crash). To reproduce the crash: 1. execute bi_create_table.sql to create the table, 2. change the path of bi_data.txt in bi_copy_from_file.sql. 3. execute bi_copy_from_file.sql to copy data from file. 4. if server doesn't crash immediately, run #3 more times. Thanks Cline 从网易163邮箱发来的云附件 bi_copy_from_file.sql (109.03K, 2015年11月16日 17:11 到期) 下载 bi_create_table.sql (1.14K, 2015年11月16日 17:11 到期) 下载 bi_data.txt (50M, 2015年11月16日 17:11 到期) 下载

1 0

monetdb SIGSEGV fault
by darkbluehacker＠sohu.com 26 Oct '15

26 Oct '15

I tryied MonetDB-11.21.5 with below sql on two table. ods_ply_base has 50,000,000 rows of record, ods_agent has 100,000 rows of recored.c_cmpny_agt_cde and c_cha_cde are text column.But mserver5 exit with SIGSEGV signal.Below is the stack show by gdb.sql>select * from ods_ply_base left join (select * from ods_agent  where business_end_date > now()) as bb on c_cmpny_agt_cde=bb.c_cha_cde;81      T_PSEUDO (SYSCALL_SYMBOL, SYSCALL_NAME, SYSCALL_NARGS)Missing separate debuginfos, use: debuginfo-install keyutils-libs-1.5.8-3.el7.x86_64 krb5-libs-1.12.2-15.el7_1.x86_64 libcom_err-1.42.9-7.el7.x86_64 libselinux-2.2.2-6.el7.x86_64 libxml2-2.9.1-5.el7_1.2.x86_64 ncurses-libs-5.9-13.20130511.el7.x86_64 openssl-libs-1.0.1e-42.el7.9.x86_64 pcre-8.32-14.el7.x86_64 readline-6.2-9.el7.x86_64 xz-libs-5.1.2-9alpha.el7.x86_64 zlib-1.2.7-13.el7.x86_64(gdb) cContinuing.[New Thread 0x7f4603dfe700 (LWP 20663)]Program received signal SIGSEGV, Segmentation fault.[Switching to Thread 0x7f46353e9700 (LWP 20592)]incref (lock=<optimized out>, logical=<optimized out>, i=1567) at gdk_bbp.c:21562156                    hp = bs->B.H->heap.parentid;(gdb)(gdb) bt#0  incref (lock=<optimized out>, logical=<optimized out>, i=1567) at gdk_bbp.c:2156#1  BBPincref (i=i@entry=1567, logical=logical@entry=0) at gdk_bbp.c:2221#2  0x00007f46477252a8 in BATdescriptor (i=1567) at ../../../gdk/gdk.h:2599#3  do_join (r1=0x7f37bc354d30, r2=0x7f37bc354d50, rid=<optimized out>, r2id=r2id@entry=0x0, slid=0x7f37bc207490, srid=0x7f37bc207490, op=op@entry=0, c1=c1@entry=0x0, c2=c2@entry=0x0,    li=li@entry=0, hi=hi@entry=0, nil_matches=nil_matches@entry=0x7f37bc2074b0 "", estimate=estimate@entry=0x7f37bc2074d0, joinfunc=0x7f464734cb20 <BATsubjoin>,    thetafunc=thetafunc@entry=0x0, bandfunc=bandfunc@entry=0x0, rangefunc=rangefunc@entry=0x0, funcname=funcname@entry=0x7f46477db3ef "algebra.subjoin", lid=<optimized out>)    at algebra.c:614#4  0x00007f464772808c in ALGsubjoin (r1=<optimized out>, r2=<optimized out>, lid=<optimized out>, rid=<optimized out>, slid=<optimized out>, srid=<optimized out>,    nil_matches=0x7f37bc2074b0 "", estimate=0x7f37bc2074d0) at algebra.c:681#5  0x00007f46476d6b84 in malCommandCall (stk=stk@entry=0x7f37bc207020, pci=pci@entry=0x7f46315dd260) at mal_interpreter.c:119#6  0x00007f46476d815b in runMALsequence (cntxt=<optimized out>, mb=<optimized out>, startpc=<optimized out>, stoppc=<optimized out>, stk=<optimized out>, env=env@entry=0x0,    pcicaller=pcicaller@entry=0x0) at mal_interpreter.c:655#7  0x00007f46476d9d0e in DFLOWworker (T=<optimized out>) at mal_dataflow.c:376#8  0x00007f4645481df5 in start_thread (arg=0x7f46353e9700) at pthread_create.c:308#9  0x00007f46451af1ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113Is this bug of monetdb?zorpior

2 1

Re: MonetDB: embedded-java - Fix miltiple column type cast
by Sjoerd Mullender 21 Oct '15

21 Oct '15

Columns do not contain values of type short, long, float or double. They might contain values of type sht, lng, flt and dbl. You should not use type long in your code unless an external API requires it. Long is not portable since it can be either 32 or 64 bits, even on a 64 bit architecture. A good rule is, if you created a BAT with a TYPE_xxx, use xxx as the name of the C type. On 21/10/15 14:55, Dimitar Nedev wrote: > Changeset: bf487cfa489a for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bf487cfa489a > Modified Files: > java/embedded/org_monetdb_embedded_result_EmbeddedQueryResult.c > Branch: embedded-java > Log Message: > > Fix miltiple column type cast > > > diffs (90 lines): > > diff --git a/java/embedded/org_monetdb_embedded_result_EmbeddedQueryResult.c b/java/embedded/org_monetdb_embedded_result_EmbeddedQueryResult.c > --- a/java/embedded/org_monetdb_embedded_result_EmbeddedQueryResult.c > +++ b/java/embedded/org_monetdb_embedded_result_EmbeddedQueryResult.c > @@ -29,18 +29,18 @@ static jobject getBooleanColumn(JNIEnv * > jboolean nul_tmp[size]; > if (b->T->nonil && !b->T->nil) { > for (i = 0; i < size; i++) { > - val_tmp[i] = (jboolean) ((jboolean*) Tloc(b, BUNfirst(b)))[i]; > + val_tmp[i] = (bit) ((bit*) Tloc(b, BUNfirst(b)))[i]; > nul_tmp[i] = false; > } > } > else { > for (i = 0; i < size; i++) { > - int v = ((jboolean*) Tloc(b, BUNfirst(b)))[i]; > + int v = ((bit*) Tloc(b, BUNfirst(b)))[i]; > if (v == bit_nil) { > val_tmp[i] = 0; > nul_tmp[i] = true; > } else { > - val_tmp[i] = (jboolean)v; > + val_tmp[i] = (bit)v; > nul_tmp[i] = false; > } > } > @@ -78,7 +78,7 @@ static jobject getByteColumn(JNIEnv *env > } > else { > for (i = 0; i < size; i++) { > - int v = ((bte*) Tloc(b, BUNfirst(b)))[i]; > + bte v = ((bte*) Tloc(b, BUNfirst(b)))[i]; > if (v == bte_nil) { > val_tmp[i] = 0; > nul_tmp[i] = true; > @@ -121,7 +121,7 @@ static jobject getShortColumn(JNIEnv *en > } > else { > for (i = 0; i < size; i++) { > - int v = ((short*) Tloc(b, BUNfirst(b)))[i]; > + short v = ((short*) Tloc(b, BUNfirst(b)))[i]; > if (v == sht_nil) { > val_tmp[i] = 0; > nul_tmp[i] = true; > @@ -207,7 +207,7 @@ static jobject getLongColumn(JNIEnv *env > } > else { > for (i = 0; i < size; i++) { > - int v = ((long*) Tloc(b, BUNfirst(b)))[i]; > + long v = ((long*) Tloc(b, BUNfirst(b)))[i]; > if (v == lng_nil) { > val_tmp[i] = 0; > nul_tmp[i] = true; > @@ -250,7 +250,7 @@ static jobject getFloatColumn(JNIEnv *en > } > else { > for (i = 0; i < size; i++) { > - int v = ((float*) Tloc(b, BUNfirst(b)))[i]; > + float v = ((float*) Tloc(b, BUNfirst(b)))[i]; > if (v == flt_nil) { > val_tmp[i] = 0.0; > nul_tmp[i] = true; > @@ -293,7 +293,7 @@ static jobject getDoubleColumn(JNIEnv *e > } > else { > for (i = 0; i < size; i++) { > - int v = ((double*) Tloc(b, BUNfirst(b)))[i]; > + double v = ((double*) Tloc(b, BUNfirst(b)))[i]; > if (v == dbl_nil) { > val_tmp[i] = 0.0; > nul_tmp[i] = true; > @@ -346,7 +346,6 @@ static jobject getStringColumn(JNIEnv *e > j++; > } > } > - > // Create the column object > // from Java StringColumn(String[] values, int columnSize, boolean[] nullIndex) > column = (*env)->NewObject(env, columnClass, columnConstructor, values, size, nulls); > @@ -380,11 +379,9 @@ JNIEXPORT jobject JNICALL Java_org_monet > return getLongColumn(env, b); > break; > case TYPE_flt: > - printf("float1\n"); > return getFloatColumn(env, b); > break; > case TYPE_dbl: > - printf("double1\n"); > return getDoubleColumn(env, b); > break; > case TYPE_str: > _______________________________________________ > checkin-list mailing list > checkin-list(a)monetdb.org > https://www.monetdb.org/mailman/listinfo/checkin-list > -- Sjoerd Mullender

2 3

Boolean columns
by Dimitar Nedev 21 Oct '15

21 Oct '15

Hey guys, A boolean type column seems to fit in a byte, I guess the extra space is to represent nulls (since it ain't a qubit). But does that mean that no column type is actually ':bit'? Given a BAT, how to distinguish between a byte (tinyint) column and a boolean one? Thanks, Dimitar

3 4

Concurrent Transaction control in MonetDB
by Vijay Krishna 19 Oct '15

19 Oct '15

Hi, I read the following lines in a thesis on MonetDB titled - "Improving Transactional Stability in MonetDB" where in they had explained the concurrency control in MonetDB as "Concurrent updates (writers) are not anticipated and in case of N con􏰃icting transactions, only one of them (the one having the earliest time-stamp) is guaranteed to eventually commit its changes. Concurrent appends (on the same table) are detected as write-to-write conflicts and only the writer carrying the earliest time-stamp will end up committing successfully, the rest will be aborted." Why is that the transaction having the earliest timestamp is allowed to commit, in case of a conflict? Shouldn't it be the latest transaction that should commit on a data, since the latest transaction would be having the latest version of data? Or, what am I getting wrong here? Any help much appreciated. Thanks & Regards, Vijayakrishna.P. Mobile : (+91) 9500402305.

2 3

Re: MonetDB: default - fixed bug in grant_role code (ie properly che...
by Ying Zhang 18 Oct '15

18 Oct '15

> On Oct 18, 2015, at 16:23, Niels Nes <commits(a)monetdb.org> wrote: > > Changeset: 6f3500c5cece for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6f3500c5cece > Modified Files: > clients/Tests/MAL-signatures.stable.out > clients/Tests/MAL-signatures.stable.out.int128 > clients/Tests/SQL-dump.stable.out.int128 > sql/backends/monet5/UDF/Tests/udf-fuse.stable.out > sql/backends/monet5/UDF/Tests/udf-reverse.stable.out > sql/backends/monet5/sql.c > sql/backends/monet5/sql.mal > sql/backends/monet5/sql_gencode.c > sql/backends/monet5/sql_gencode.h > sql/backends/monet5/sql_scenario.h > sql/benchmarks/tpch/Tests/01-explain.stable.out > sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit > sql/benchmarks/tpch/Tests/01-explain.stable.out.int128 > sql/benchmarks/tpch/Tests/04-explain.stable.out > sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit > sql/benchmarks/tpch/Tests/05-explain.stable.out > sql/benchmarks/tpch/Tests/05-explain.stable.out.32bit > sql/benchmarks/tpch/Tests/05-explain.stable.out.int128 > sql/benchmarks/tpch/Tests/06-explain.stable.out > sql/benchmarks/tpch/Tests/06-explain.stable.out.int128 > sql/benchmarks/tpch/Tests/10-explain.stable.out > sql/benchmarks/tpch/Tests/10-explain.stable.out.int128 > sql/benchmarks/tpch/Tests/11-explain.stable.out.int128 > sql/benchmarks/tpch/Tests/12-explain.stable.out > sql/benchmarks/tpch/Tests/12-explain.stable.out.int128 > sql/benchmarks/tpch/Tests/14-explain.stable.out.int128 > sql/benchmarks/tpch/Tests/15-explain.stable.out > sql/benchmarks/tpch/Tests/15-explain.stable.out.int128 > sql/benchmarks/tpch/Tests/17-explain.stable.out.int128 > sql/benchmarks/tpch/Tests/19-explain.stable.out > sql/benchmarks/tpch/Tests/19-explain.stable.out.int128 > sql/benchmarks/tpch/Tests/20-explain.stable.out > sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit > sql/benchmarks/tpch/Tests/20-explain.stable.out.int128 > sql/common/sql_types.c > sql/server/rel_dump.c > sql/server/rel_dump.h > sql/server/rel_optimizer.c > sql/server/sql_privileges.c > sql/server/sql_semantic.c > sql/server/sql_semantic.h > sql/test/BugTracker-2008/Tests/auto_coersion_bug.SF-2075157.stable.out > sql/test/BugTracker-2008/Tests/auto_coersion_bug.SF-2075157.stable.out.int128 > sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out > sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128 > 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-2015/Tests/ambiguous.Bug-3803.stable.out.int128 > sql/test/BugTracker-2015/Tests/backslash_predecing_separator.Bug-3775.stable.err > sql/test/BugTracker-2015/Tests/incorrect_result_type.Bug-3687.stable.out.int128 > sql/test/BugTracker-2015/Tests/sql2pcre.Bug-3800.stable.out > sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.stable.out > sql/test/Users/Tests/columnRights.stable.err > sql/test/Users/Tests/columnRights.stable.out > sql/test/Users/Tests/dropManyUsers.Bug-3764.stable.out > sql/test/Users/Tests/grantAndRevokeUserLogedIN.Bug-3476.SQL.py > sql/test/Users/Tests/grantAndRevokeUserLogedIN.Bug-3476.stable.err > sql/test/Users/Tests/grantAndRevokeUserLogedIN.Bug-3476.stable.out > sql/test/Users/Tests/grantMonetdb.SQL.py > sql/test/Users/Tests/grantMonetdbToRegularUser.Bug-3771.SQL.py > sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.SQL.py > sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.stable.err > sql/test/Users/Tests/grantPrivilegesNonDefaultRole.Bug-3365.stable.err > sql/test/Users/Tests/grantRevokeAndGrantAgain.Bug-3765.SQL.py > sql/test/Users/Tests/grantRevokeAndGrantAgain.Bug-3765.stable.err > sql/test/Users/Tests/grantRevokeAndGrantAgain.Bug-3765.stable.out > sql/test/leaks/Tests/check1.stable.out.int128 > sql/test/leaks/Tests/check2.stable.out.int128 > sql/test/leaks/Tests/check3.stable.out.int128 > sql/test/leaks/Tests/check4.stable.out.int128 > sql/test/leaks/Tests/check5.stable.out.int128 > sql/test/mapi/Tests/sql_int128.stable.out > sql/test/pg_regress/Tests/int2.stable.out > sql/test/pg_regress/Tests/int8.stable.out > sql/test/pg_regress/Tests/int8.stable.out.int128 > sql/test/pg_regress/Tests/select_views.stable.out > sql/test/pg_regress/Tests/strings.stable.err.int128 > sql/test/pg_regress/Tests/strings.stable.out > Branch: default > Log Message: > > fixed bug in grant_role code (ie properly check rights) is this the same bug you just fixed in Jul2015? Can you give me a SQL query so I can add a test for it (if you think is necessary)? Or two SQL queries, if they are different problems. Jennie > added check to not grant 'role' rights when the role is a user (ie > grant some_user to role_or_user, isn't allowed) > > fixed bug in topn rewriter (in combination with distinct) > > we now ship relational algebra instead of mal for remote execution > > more explicit typing in code generation (fixes problems with R/Python) > > > diffs (truncated from 15187 to 300 lines): > > diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out > --- a/clients/Tests/MAL-signatures.stable.out > +++ b/clients/Tests/MAL-signatures.stable.out > @@ -40743,6 +40743,10 @@ pattern sql.restart{unsafe}(sname:str,se > address mvc_restart_seq; > comment restart the sequence with value start > > +pattern sql.register(mod:str,fname:str,rel_stmt:str,sig:str):int > +address RAstatement2; > +comment Compile the relational statement (rel_smt) and register it as mal function, mod.fname(signature) > + > function sql.sql_environment() (name:bat[:oid,:str],value:bat[:oid,:str]); > pattern sql.shrink(sch:str,tbl:str):void > address SQLshrink; > diff --git a/clients/Tests/MAL-signatures.stable.out.int128 b/clients/Tests/MAL-signatures.stable.out.int128 > --- a/clients/Tests/MAL-signatures.stable.out.int128 > +++ b/clients/Tests/MAL-signatures.stable.out.int128 > @@ -51682,6 +51682,10 @@ pattern sql.restart{unsafe}(sname:str,se > address mvc_restart_seq; > comment restart the sequence with value start > > +pattern sql.register(mod:str,fname:str,rel_stmt:str,sig:str):int > +address RAstatement2; > +comment Compile the relational statement (rel_smt) and register it as mal function, mod.fname(signature) > + > function sql.sql_environment() (name:bat[:oid,:str],value:bat[:oid,:str]); > pattern sql.shrink(sch:str,tbl:str):void > address SQLshrink; > diff --git a/clients/Tests/SQL-dump.stable.out.int128 b/clients/Tests/SQL-dump.stable.out.int128 > --- a/clients/Tests/SQL-dump.stable.out.int128 > +++ b/clients/Tests/SQL-dump.stable.out.int128 > @@ -1534,234 +1534,234 @@ 2149 "statement" "varchar" 2048 0 2139 N > 2151 "id" "int" 32 0 2150 NULL true 0 NULL > 2152 "name" "varchar" 1024 0 2150 NULL true 1 NULL > 2153 "nr" "int" 32 0 2150 NULL true 2 NULL > -5598 "id" "int" 32 0 5597 NULL true 0 NULL > -5599 "name" "varchar" 1024 0 5597 NULL true 1 NULL > -5600 "schema_id" "int" 32 0 5597 NULL true 2 NULL > -5601 "query" "varchar" 2048 0 5597 NULL true 3 NULL > -5602 "type" "smallint" 16 0 5597 NULL true 4 NULL > -5603 "system" "boolean" 1 0 5597 NULL true 5 NULL > -5604 "commit_action" "smallint" 16 0 5597 NULL true 6 NULL > -5605 "access" "smallint" 16 0 5597 NULL true 7 NULL > -5606 "temporary" "smallint" 16 0 5597 NULL true 8 NULL > -5608 "id" "int" 32 0 5607 NULL true 0 NULL > -5609 "name" "varchar" 1024 0 5607 NULL true 1 NULL > -5610 "type" "varchar" 1024 0 5607 NULL true 2 NULL > -5611 "type_digits" "int" 32 0 5607 NULL true 3 NULL > -5612 "type_scale" "int" 32 0 5607 NULL true 4 NULL > -5613 "table_id" "int" 32 0 5607 NULL true 5 NULL > -5614 "default" "varchar" 2048 0 5607 NULL true 6 NULL > -5615 "null" "boolean" 1 0 5607 NULL true 7 NULL > -5616 "number" "int" 32 0 5607 NULL true 8 NULL > -5617 "storage" "varchar" 2048 0 5607 NULL true 9 NULL > -5624 "name" "varchar" 1024 0 5623 NULL true 0 NULL > -5625 "fullname" "varchar" 2048 0 5623 NULL true 1 NULL > -5626 "default_schema" "int" 9 0 5623 NULL true 2 NULL > -5630 "name" "varchar" 1024 0 5629 NULL true 0 NULL > -5631 "fullname" "varchar" 2024 0 5629 NULL true 1 NULL > -5632 "default_schema" "int" 9 0 5629 NULL true 2 NULL > -5634 "login_id" "int" 32 0 5633 NULL true 0 NULL > -5635 "role_id" "int" 32 0 5633 NULL true 1 NULL > -5637 "id" "int" 32 0 5636 NULL true 0 NULL > -5638 "name" "varchar" 1024 0 5636 NULL true 1 NULL > -5639 "grantor" "int" 32 0 5636 NULL true 2 NULL > -5641 "obj_id" "int" 32 0 5640 NULL true 0 NULL > -5642 "auth_id" "int" 32 0 5640 NULL true 1 NULL > -5643 "privileges" "int" 32 0 5640 NULL true 2 NULL > -5644 "grantor" "int" 32 0 5640 NULL true 3 NULL > -5645 "grantable" "int" 32 0 5640 NULL true 4 NULL > -5854 "id" "oid" 63 0 5862 NULL true 0 NULL > -5855 "owner" "clob" 0 0 5862 NULL true 1 NULL > -5856 "defined" "timestamp" 7 0 5862 NULL true 2 NULL > -5857 "query" "clob" 0 0 5862 NULL true 3 NULL > -5858 "pipe" "clob" 0 0 5862 NULL true 4 NULL > -5859 "plan" "clob" 0 0 5862 NULL true 5 NULL > -5860 "mal" "int" 32 0 5862 NULL true 6 NULL > -5861 "optimize" "bigint" 64 0 5862 NULL true 7 NULL > -5864 "id" "oid" 63 0 5873 NULL true 0 NULL > -5865 "start" "timestamp" 7 0 5873 NULL true 1 NULL > -5866 "stop" "timestamp" 7 0 5873 NULL true 2 NULL > -5867 "arguments" "clob" 0 0 5873 NULL true 3 NULL > -5868 "tuples" "wrd" 64 0 5873 NULL true 4 NULL > -5869 "run" "bigint" 64 0 5873 NULL true 5 NULL > -5870 "ship" "bigint" 64 0 5873 NULL true 6 NULL > -5871 "cpu" "int" 32 0 5873 NULL true 7 NULL > -5872 "io" "int" 32 0 5873 NULL true 8 NULL > -5875 "id" "oid" 63 0 5891 NULL true 0 NULL > -5876 "owner" "clob" 0 0 5891 NULL true 1 NULL > -5877 "defined" "timestamp" 7 0 5891 NULL true 2 NULL > -5878 "query" "clob" 0 0 5891 NULL true 3 NULL > -5879 "pipe" "clob" 0 0 5891 NULL true 4 NULL > -5880 "plan" "clob" 0 0 5891 NULL true 5 NULL > -5881 "mal" "int" 32 0 5891 NULL true 6 NULL > -5882 "optimize" "bigint" 64 0 5891 NULL true 7 NULL > -5883 "start" "timestamp" 7 0 5891 NULL true 8 NULL > -5884 "stop" "timestamp" 7 0 5891 NULL true 9 NULL > -5885 "arguments" "clob" 0 0 5891 NULL true 10 NULL > -5886 "tuples" "wrd" 64 0 5891 NULL true 11 NULL > -5887 "run" "bigint" 64 0 5891 NULL true 12 NULL > -5888 "ship" "bigint" 64 0 5891 NULL true 13 NULL > -5889 "cpu" "int" 32 0 5891 NULL true 14 NULL > -5890 "io" "int" 32 0 5891 NULL true 15 NULL > -5917 "event" "int" 32 0 5930 NULL true 0 NULL > -5918 "clk" "varchar" 20 0 5930 NULL true 1 NULL > -5919 "pc" "varchar" 50 0 5930 NULL true 2 NULL > -5920 "thread" "int" 32 0 5930 NULL true 3 NULL > -5921 "ticks" "bigint" 64 0 5930 NULL true 4 NULL > -5922 "rrsmb" "bigint" 64 0 5930 NULL true 5 NULL > -5923 "vmmb" "bigint" 64 0 5930 NULL true 6 NULL > -5924 "reads" "bigint" 64 0 5930 NULL true 7 NULL > -5925 "writes" "bigint" 64 0 5930 NULL true 8 NULL > -5926 "minflt" "bigint" 64 0 5930 NULL true 9 NULL > -5927 "majflt" "bigint" 64 0 5930 NULL true 10 NULL > -5928 "nvcsw" "bigint" 64 0 5930 NULL true 11 NULL > -5929 "stmt" "clob" 0 0 5930 NULL true 12 NULL > -6064 "user" "clob" 0 0 6070 NULL true 0 NULL > -6065 "login" "timestamp" 7 0 6070 NULL true 1 NULL > -6066 "sessiontimeout" "bigint" 64 0 6070 NULL true 2 NULL > -6067 "lastcommand" "timestamp" 7 0 6070 NULL true 3 NULL > -6068 "querytimeout" "bigint" 64 0 6070 NULL true 4 NULL > -6069 "active" "boolean" 1 0 6070 NULL true 5 NULL > -6147 "name" "clob" 0 0 6150 NULL true 0 NULL > -6148 "def" "clob" 0 0 6150 NULL true 1 NULL > -6149 "status" "clob" 0 0 6150 NULL true 2 NULL > -6156 "name" "clob" 0 0 6158 NULL true 0 NULL > -6157 "value" "clob" 0 0 6158 NULL true 1 NULL > -6194 "qtag" "bigint" 64 0 6202 NULL true 0 NULL > -6195 "user" "clob" 0 0 6202 NULL true 1 NULL > -6196 "started" "timestamp" 7 0 6202 NULL true 2 NULL > -6197 "estimate" "timestamp" 7 0 6202 NULL true 3 NULL > -6198 "progress" "int" 32 0 6202 NULL true 4 NULL > -6199 "status" "clob" 0 0 6202 NULL true 5 NULL > -6200 "tag" "oid" 63 0 6202 NULL true 6 NULL > -6201 "query" "clob" 0 0 6202 NULL true 7 NULL > -6228 "rowid" "bigint" 64 0 6232 NULL true 0 NULL > -6229 "fldid" "int" 32 0 6232 NULL true 1 NULL > -6230 "message" "clob" 0 0 6232 NULL true 2 NULL > -6231 "input" "clob" 0 0 6232 NULL true 3 NULL > -6887 "keyword" "varchar" 40 0 6890 NULL false 0 NULL > -6892 "table_type_id" "smallint" 16 0 6898 NULL false 0 NULL > -6895 "table_type_name" "varchar" 25 0 6898 NULL false 1 NULL > -6900 "dependency_type_id" "smallint" 16 0 6906 NULL false 0 NULL > -6903 "dependency_type_name" "varchar" 15 0 6906 NULL false 1 NULL > -6921 "file_id" "int" 32 0 6923 NULL true 0 NULL > -6922 "location" "char" 256 0 6923 NULL true 1 NULL > -6925 "dim_id" "int" 32 0 6929 NULL true 0 NULL > -6926 "file_id" "int" 32 0 6929 NULL true 1 NULL > -6927 "name" "varchar" 64 0 6929 NULL true 2 NULL > -6928 "length" "int" 32 0 6929 NULL true 3 NULL > -6931 "var_id" "int" 32 0 6937 NULL true 0 NULL > -6932 "file_id" "int" 32 0 6937 NULL true 1 NULL > -6933 "name" "varchar" 64 0 6937 NULL true 2 NULL > -6934 "vartype" "varchar" 64 0 6937 NULL true 3 NULL > -6935 "ndim" "int" 32 0 6937 NULL true 4 NULL > -6936 "coord_dim_id" "int" 32 0 6937 NULL true 5 NULL > -6939 "var_id" "int" 32 0 6943 NULL true 0 NULL > -6940 "dim_id" "int" 32 0 6943 NULL true 1 NULL > -6941 "file_id" "int" 32 0 6943 NULL true 2 NULL > -6942 "dimpos" "int" 32 0 6943 NULL true 3 NULL > -6945 "obj_name" "varchar" 256 0 6951 NULL true 0 NULL > -6946 "att_name" "varchar" 256 0 6951 NULL true 1 NULL > -6947 "att_type" "varchar" 64 0 6951 NULL true 2 NULL > -6948 "value" "clob" 0 0 6951 NULL true 3 NULL > -6949 "file_id" "int" 32 0 6951 NULL true 4 NULL > -6950 "gr_name" "varchar" 256 0 6951 NULL true 5 NULL > -6976 "schema" "clob" 0 0 6990 NULL true 0 NULL > -6977 "table" "clob" 0 0 6990 NULL true 1 NULL > -6978 "column" "clob" 0 0 6990 NULL true 2 NULL > -6979 "type" "clob" 0 0 6990 NULL true 3 NULL > -6980 "mode" "clob" 0 0 6990 NULL true 4 NULL > -6981 "location" "clob" 0 0 6990 NULL true 5 NULL > -6982 "count" "bigint" 64 0 6990 NULL true 6 NULL > -6983 "typewidth" "int" 32 0 6990 NULL true 7 NULL > -6984 "columnsize" "bigint" 64 0 6990 NULL true 8 NULL > -6985 "heapsize" "bigint" 64 0 6990 NULL true 9 NULL > -6986 "hashes" "bigint" 64 0 6990 NULL true 10 NULL > -6987 "phash" "boolean" 1 0 6990 NULL true 11 NULL > -6988 "imprints" "bigint" 64 0 6990 NULL true 12 NULL > -6989 "sorted" "boolean" 1 0 6990 NULL true 13 NULL > -6992 "schema" "clob" 0 0 7002 NULL true 0 NULL > -6993 "table" "clob" 0 0 7002 NULL true 1 NULL > -6994 "column" "clob" 0 0 7002 NULL true 2 NULL > -6995 "type" "clob" 0 0 7002 NULL true 3 NULL > -6996 "typewidth" "int" 32 0 7002 NULL true 4 NULL > -6997 "count" "bigint" 64 0 7002 NULL true 5 NULL > -6998 "distinct" "bigint" 64 0 7002 NULL true 6 NULL > -6999 "atomwidth" "int" 32 0 7002 NULL true 7 NULL > -7000 "reference" "boolean" 1 0 7002 NULL true 8 NULL > -7001 "sorted" "boolean" 1 0 7002 NULL true 9 NULL > -7040 "schema" "clob" 0 0 7050 NULL true 0 NULL > -7041 "table" "clob" 0 0 7050 NULL true 1 NULL > -7042 "column" "clob" 0 0 7050 NULL true 2 NULL > -7043 "type" "clob" 0 0 7050 NULL true 3 NULL > -7044 "count" "bigint" 64 0 7050 NULL true 4 NULL > -7045 "columnsize" "bigint" 64 0 7050 NULL true 5 NULL > -7046 "heapsize" "bigint" 64 0 7050 NULL true 6 NULL > -7047 "hashes" "bigint" 64 0 7050 NULL true 7 NULL > -7048 "imprints" "bigint" 64 0 7050 NULL true 8 NULL > -7049 "sorted" "boolean" 1 0 7050 NULL true 9 NULL > -7052 "schema" "clob" 0 0 7060 NULL true 0 NULL > -7053 "table" "clob" 0 0 7060 NULL true 1 NULL > -7054 "count" "bigint" 64 0 7060 NULL true 2 NULL > -7055 "columnsize" "hugeint" 128 0 7060 NULL true 3 NULL > -7056 "heapsize" "hugeint" 128 0 7060 NULL true 4 NULL > -7057 "hashes" "hugeint" 128 0 7060 NULL true 5 NULL > -7058 "imprints" "hugeint" 128 0 7060 NULL true 6 NULL > -7059 "auxiliary" "hugeint" 128 0 7060 NULL true 7 NULL > -7062 "column_id" "int" 32 0 7073 NULL true 0 NULL > -7063 "type" "clob" 0 0 7073 NULL true 1 NULL > -7064 "width" "int" 32 0 7073 NULL true 2 NULL > -7065 "stamp" "timestamp" 7 0 7073 NULL true 3 NULL > -7066 "sample" "bigint" 64 0 7073 NULL true 4 NULL > -7067 "count" "bigint" 64 0 7073 NULL true 5 NULL > -7068 "unique" "bigint" 64 0 7073 NULL true 6 NULL > -7069 "nils" "bigint" 64 0 7073 NULL true 7 NULL > -7070 "minval" "clob" 0 0 7073 NULL true 8 NULL > -7071 "maxval" "clob" 0 0 7073 NULL true 9 NULL > -7072 "sorted" "boolean" 1 0 7073 NULL true 10 NULL > -7163 "file_id" "bigint" 64 0 7171 NULL false 0 NULL > -7164 "file_location" "clob" 0 0 7171 NULL false 1 NULL > -7165 "dbschema" "smallint" 16 0 7171 NULL false 2 NULL > -7166 "format_version" "varchar" 7 0 7171 NULL true 3 NULL > -7167 "sorting_order" "varchar" 10 0 7171 NULL true 4 NULL > -7168 "comments" "clob" 0 0 7171 NULL true 5 NULL > -7173 "sn" "clob" 0 0 7184 NULL false 0 NULL > -7174 "file_id" "bigint" 64 0 7184 NULL false 1 NULL > -7175 "ln" "int" 32 0 7184 NULL true 2 NULL > -7176 "as" "int" 32 0 7184 NULL true 3 NULL > -7177 "m5" "clob" 0 0 7184 NULL true 4 NULL > -7178 "sp" "clob" 0 0 7184 NULL true 5 NULL > -7179 "ur" "clob" 0 0 7184 NULL true 6 NULL > -7186 "id" "clob" 0 0 7203 NULL false 0 NULL > -7187 "file_id" "bigint" 64 0 7203 NULL false 1 NULL > -7188 "cn" "clob" 0 0 7203 NULL true 2 NULL > -7189 "ds" "clob" 0 0 7203 NULL true 3 NULL > -7190 "dt" "timestamp" 7 0 7203 NULL true 4 NULL > -7191 "fo" "clob" 0 0 7203 NULL true 5 NULL > -7192 "ks" "clob" 0 0 7203 NULL true 6 NULL > -7193 "lb" "clob" 0 0 7203 NULL true 7 NULL > -7194 "pg" "clob" 0 0 7203 NULL true 8 NULL > -7195 "pi" "int" 32 0 7203 NULL true 9 NULL > -7196 "pl" "clob" 0 0 7203 NULL true 10 NULL > -7197 "pu" "clob" 0 0 7203 NULL true 11 NULL > -7198 "sm" "clob" 0 0 7203 NULL true 12 NULL > -7205 "id" "clob" 0 0 7215 NULL false 0 NULL > -7206 "file_id" "bigint" 64 0 7215 NULL false 1 NULL > -7207 "pn" "clob" 0 0 7215 NULL true 2 NULL > -7208 "cl" "clob" 0 0 7215 NULL true 3 NULL > -7209 "pp" "clob" 0 0 7215 NULL true 4 NULL > -7210 "vn" "clob" 0 0 7215 NULL true 5 NULL > -7217 "qname" "clob" 0 0 7228 NULL false 0 NULL > -7218 "flag" "smallint" 16 0 7228 NULL false 1 NULL > -7219 "rname" "clob" 0 0 7228 NULL false 2 NULL > -7220 "pos" "int" 32 0 7228 NULL false 3 NULL > -7221 "mapq" "smallint" 16 0 7228 NULL false 4 NULL > -7222 "cigar" "clob" 0 0 7228 NULL false 5 NULL > -7223 "rnext" "clob" 0 0 7228 NULL false 6 NULL > -7224 "pnext" "int" 32 0 7228 NULL false 7 NULL > -7225 "tlen" "int" 32 0 7228 NULL false 8 NULL > -7226 "seq" "clob" 0 0 7228 NULL false 9 NULL > -7227 "qual" "clob" 0 0 7228 NULL false 10 NULL > -7309 "function_id" "int" 32 0 7310 NULL true 0 NULL > +5688 "id" "int" 32 0 5687 NULL true 0 NULL > +5689 "name" "varchar" 1024 0 5687 NULL true 1 NULL > +5690 "schema_id" "int" 32 0 5687 NULL true 2 NULL > +5691 "query" "varchar" 2048 0 5687 NULL true 3 NULL > +5692 "type" "smallint" 16 0 5687 NULL true 4 NULL > +5693 "system" "boolean" 1 0 5687 NULL true 5 NULL > +5694 "commit_action" "smallint" 16 0 5687 NULL true 6 NULL > +5695 "access" "smallint" 16 0 5687 NULL true 7 NULL > +5696 "temporary" "smallint" 16 0 5687 NULL true 8 NULL > +5698 "id" "int" 32 0 5697 NULL true 0 NULL > +5699 "name" "varchar" 1024 0 5697 NULL true 1 NULL > +5700 "type" "varchar" 1024 0 5697 NULL true 2 NULL > +5701 "type_digits" "int" 32 0 5697 NULL true 3 NULL > +5702 "type_scale" "int" 32 0 5697 NULL true 4 NULL > +5703 "table_id" "int" 32 0 5697 NULL true 5 NULL > +5704 "default" "varchar" 2048 0 5697 NULL true 6 NULL > +5705 "null" "boolean" 1 0 5697 NULL true 7 NULL > +5706 "number" "int" 32 0 5697 NULL true 8 NULL > +5707 "storage" "varchar" 2048 0 5697 NULL true 9 NULL > +5714 "name" "varchar" 1024 0 5713 NULL true 0 NULL > +5715 "fullname" "varchar" 2048 0 5713 NULL true 1 NULL > +5716 "default_schema" "int" 9 0 5713 NULL true 2 NULL > +5720 "name" "varchar" 1024 0 5719 NULL true 0 NULL > +5721 "fullname" "varchar" 2024 0 5719 NULL true 1 NULL > +5722 "default_schema" "int" 9 0 5719 NULL true 2 NULL > +5724 "login_id" "int" 32 0 5723 NULL true 0 NULL > +5725 "role_id" "int" 32 0 5723 NULL true 1 NULL > +5727 "id" "int" 32 0 5726 NULL true 0 NULL > +5728 "name" "varchar" 1024 0 5726 NULL true 1 NULL > +5729 "grantor" "int" 32 0 5726 NULL true 2 NULL > +5731 "obj_id" "int" 32 0 5730 NULL true 0 NULL > +5732 "auth_id" "int" 32 0 5730 NULL true 1 NULL > +5733 "privileges" "int" 32 0 5730 NULL true 2 NULL > +5734 "grantor" "int" 32 0 5730 NULL true 3 NULL > +5735 "grantable" "int" 32 0 5730 NULL true 4 NULL > +5944 "id" "oid" 63 0 5952 NULL true 0 NULL > +5945 "owner" "clob" 0 0 5952 NULL true 1 NULL > _______________________________________________ > checkin-list mailing list > checkin-list(a)monetdb.org > https://www.monetdb.org/mailman/listinfo/checkin-list

1 0