March 2013 - developers-list

how to speed up the loading of data into a table
by Bouslah Ahmed 18 Jun '13

18 Jun '13

Good afternoon, I have 2 questions : - 1st question I have a csv file with 300000000 million lines. when I load it in a MonetDB table, it takes more than 16 hours, whereas in Oracle it only takes 15 minutes. Where is the problem? I use mclient as follows :? mclient -u user1 -d demo -ims -s " COPY 300000009 RECORDS INTO LINEORDER FROM STDIN USING DELIMITERS '|','\n'" - < D:\SSB\LINEORDER.tbl ?for information I use : MonetDB5 Windows Memory : 16 Go There are two constraints : primary key and foreign key on the table prior to loading data? 2nd question : how inner joins are made in MongoDB? cordialy.

3 4

Re: developers-list Digest, Vol 7, Issue 20
by Meenesh sharma 30 Mar '13

30 Mar '13

sir/mam, I unable to read the contents therefore neither get my query's answer nor able to open it .... . . .. do send way to open it . On Fri, Mar 29, 2013 at 4:30 PM, <developers-list-request(a)monetdb.org>wrote: > Send developers-list mailing list submissions to > developers-list(a)monetdb.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://mail.monetdb.org/mailman/listinfo/developers-list > or, via email, send a message with subject or body 'help' to > developers-list-request(a)monetdb.org > > You can reach the person managing the list at > developers-list-owner(a)monetdb.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of developers-list digest..." > > > Today's Topics: > > 1. Re: how to speed up the loading of data into a table (Niels Nes) > 2. Re: how to speed up the loading of data into a table (Niels Nes) > 3. Re: how to speed up the loading of data into a table > (Stefan Manegold) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 28 Mar 2013 20:17:08 +0100 > From: Niels Nes <Niels.Nes(a)cwi.nl> > To: "Communication channel for developers of the MonetDB suite." > <developers-list(a)monetdb.org> > Subject: Re: how to speed up the loading of data into a table > Message-ID: <20130328191708.GB13470(a)niels.cwi.nl> > Content-Type: text/plain; charset="utf-8" > > On Thu, Mar 28, 2013 at 06:41:08PM +0000, Bouslah Ahmed wrote: > > Good afternoon, > > > > I have 2 questions : > > - 1st question > > I have a csv file with 300000000 million lines. > > > > when I load it in a MonetDB table, it takes more than 16 hours, whereas > > in Oracle it only takes 15 minutes. Where is the problem? > > I use mclient as follows :? > > mclient -u user1 -d demo -ims -s " COPY 300000009 RECORDS INTO > > LINEORDER FROM STDIN USING DELIMITERS '|','\n'" - < D:\SSB\ > > LINEORDER.tbl > > > > ?for information I use : > > > > MonetDB5 > > Windows > > Memory : 16 Go > > There are two constraints : primary key and foreign key on the table > > prior to loading data? > > > > 2nd question : > > how inner joins are made in MongoDB? > typo ? > > Niels > > > > cordialy. > > > _______________________________________________ > > developers-list mailing list > > developers-list(a)monetdb.org > > http://mail.monetdb.org/mailman/listinfo/developers-list > > > -- > Niels Nes, Centrum Wiskunde & Informatica (CWI) > Science Park 123, 1098 XG Amsterdam, The Netherlands > room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl > url: http://www.cwi.nl/~niels e-mail: Niels.Nes(a)cwi.nl >

1 0

Re: How would I add a new directory to /monetdb5/extras/
by Stefan Manegold 28 Mar '13

28 Mar '13

It's a shared library that will only be loaded once required at run time. Just say yes when gab asks you if the breakpoint should only be set once the library/code is loaded. -- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | ----- Reply message ----- From: "Chi-Young Ku" <chi(a)querymetrica.com> To: "Communication channel for developers of the MonetDB suite." <developers-list(a)monetdb.org> Subject: How would I add a new directory to /monetdb5/extras/ Date: Wed, Mar 27, 2013 19:08 Hi Babis, Thanks a lot for your help! I am able to get the foo directory compiled and built lib_foo.la. But, when I attatch GDB to the mserver5 process and try to set a breakpoint in foo.test(), I got an error saying foo.test() is not loaded. Have I missed anything? Chi ________________________________ From: Charalampos Nikolaou <charnik(a)di.uoa.gr> To: Communication channel for developers of the MonetDB suite. <developers-list(a)monetdb.org> Sent: Thursday, March 21, 2013 3:04 PM Subject: Re: How would I add a new directory to /monetdb5/extras/ Hi, you have to edit monetdb5/extras/Makefile.ag appending to variable SUBDIRS the name of the directory you want to add. For example, if you want to add directory "foo", given that the value of SUBDIRS was HAVE_RAPTOR?rdf HAVE_SPHINXCLIENT?sphinx HAVE_JAQL?jaql mal_optimizer_template the new value for SUBDIRS should be HAVE_RAPTOR?rdf HAVE_SPHINXCLIENT?sphinx HAVE_JAQL?jaql mal_optimizer_template foo Of course, this way you should run de-bootstrap and bootstrap again. Notice, that you have to specify also another Makefile.ag in monetdb5/extras/foo for taking care of the compilation of your code. However, I don't see any connection of your question to the message you replied to. Babis On Thu, Mar 21, 2013 at 7:35 PM, Chi-Young Ku <chi(a)querymetrica.com> wrote: > Hi, > > I would like to add a new sub-directory to /monetdb5/extras/ so that: > > 1. the configure process generates Makefiles for it and > > 2. it gets built when "make" is invoke in the top source directory. > > Thanks in advance. > > Chi > > > ________________________________ > From: Stephen P. Morgan <stephen_p_morgan(a)sbcglobal.net> > To: developers-list(a)monetdb.org > Sent: Thursday, March 21, 2013 12:06 PM > Subject: Question in re remote.exec() > > I have a question about remote.exec(). Let's say I have a user function, > s1_1 that takes a BAT as a parameter and returns a BAT. Its signature might > be: > > function user.s1_1(in:bat[:oid,:int]):bat[:oid,:int]; > > How can I call s1_1 using remote.exec to pass in a BAT and to retrieve the > result? I want to do something like > > X_2 := remote.exec(conn, "user", "s1_1", X_1); > > where X_1 and X_2 are both :bat[:oid,:int]. But that doesn't seem to work. > > Thanks, > > Steve Morgan > > _______________________________________________ > developers-list mailing list > developers-list(a)monetdb.org > http://mail.monetdb.org/mailman/listinfo/developers-list > > > > _______________________________________________ > developers-list mailing list > developers-list(a)monetdb.org > http://mail.monetdb.org/mailman/listinfo/developers-list > _______________________________________________ developers-list mailing list developers-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list

2 1

Re: Question about : LOAD DATA
by Stefan Manegold 27 Mar '13

27 Mar '13

Please see my answer I sent to your identical question yesterday. Stefan -- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | ----- Reply message ----- From: "Bouslah Ahmed" <a.bouslah(a)yahoo.fr> To: "developers-list(a)monetdb.org" <developers-list(a)monetdb.org> Subject: Question about : LOAD DATA Date: Wed, Mar 27, 2013 19:44 Good afternoon, I have a csv file with 300000000 million lines. when I load it in a MonetDB table, it takes more than 16 hours, whereas in Oracle it only takes 15 minutes. Where is the problem? I use mclient as follows :? mclient -u user1 -d demo -ims -s " COPY 300000009 RECORDS INTO LINEORDER FROM STDIN USING DELIMITERS '|','\n'" - < D:\SSB\LINEORDER.tbl for information I use : MonetDB5 Windows Memory : 16 Go There are two constraints : primary key and foreign key on the table prior to loading data? cordialy.

1 0

Question about : LOAD DATA
by Bouslah Ahmed 27 Mar '13

27 Mar '13

Good afternoon, I have a csv file with 300000000 million lines. when I load it in a MonetDB table, it takes more than 16 hours, whereas in Oracle it only takes 15 minutes. Where is the problem? I use mclient as follows :? mclient -u user1 -d demo -ims -s " COPY 300000009 RECORDS INTO LINEORDER FROM STDIN USING DELIMITERS '|','\n'" - < D:\SSB\LINEORDER.tbl for information I use : MonetDB5 Windows Memory : 16 Go There are two constraints : primary key and foreign key on the table prior to loading data? cordialy.

1 0

Question in re remote.exec()
by Stephen P. Morgan 27 Mar '13

27 Mar '13

I have a question about remote.exec(). Let's say I have a user function, s1_1 that takes a BAT as a parameter and returns a BAT. Its signature might be: function user.s1_1(in:bat[:oid,:int]):bat[:oid,:int]; How can I call s1_1 using remote.exec to pass in a BAT and to retrieve the result? I want to do something like X_2 := remote.exec(conn, "user", "s1_1", X_1); where X_1 and X_2 are both :bat[:oid,:int]. But that doesn't seem to work. Thanks, Steve Morgan

3 3

Question
by Bouslah Ahmed 26 Mar '13

26 Mar '13

I have a csv file with 300000000 million lines. when I load it in a MonetDB table, it takes more than 16 hours, whereas in Oracle it only takes 15 minutes. Where is the problem? I use mclient as follows : mclient -u user1 -d demo -ims -s " COPY 300000009 RECORDS INTO LINEORDER FROM STDIN USING DELIMITERS '|','\n'" - < D:\SSB\LINEORDER.tbl cordially.

2 1

reply soon
by Meenesh sharma 24 Mar '13

24 Mar '13

sir, please tell can i add coding for variant stochastic cracking ....so, that i can analysis it with work done previously . . ... do help me -- " HAVE A NICE DAY"

1 0

do reply
by Meenesh sharma 22 Mar '13

22 Mar '13

i am doing my dissertation work on variant stochastic cracking .....so, i want to know which tool should i use to implement and then analysis it for various workload . do reply sir . . . i will very very thank ful to you .. . .please guide me ............. -- " HAVE A NICE DAY"

2 1

Re: MonetDB: default - approved output
by Sjoerd Mullender 20 Mar '13

20 Mar '13

Shouldn't this go to the Feb2013 branch? On 2013-03-20 15:55, Niels Nes wrote: > Changeset: 59ae06013de6 for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=59ae06013de6 > Modified Files: > sql/backends/monet5/rel_bin.c > sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out > Branch: default > Log Message: > > approved output > fixed bug view-view, bug 3245 > > > diffs (281 lines): > > diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/rel_bin.c > --- a/sql/backends/monet5/rel_bin.c > +++ b/sql/backends/monet5/rel_bin.c > @@ -2340,14 +2340,21 @@ rel2bin_select( mvc *sql, sql_rel *rel, > if (!sub) > return NULL; > sub = row2cols(sql, sub); > - } else { > + } > + if (!sub && !predicate) > predicate = rel2bin_predicate(sql); > - } > + else if (!predicate) > + predicate = stmt_const(sql->sa, bin_first_column(sql->sa, sub), stmt_bool(sql->sa, 1)); > if (!rel->exps->h) { > if (sub) > return sub; > return predicate; > } > + if (!sub && predicate) { > + list *l = sa_list(sql->sa); > + append(l, predicate); > + sub = stmt_list(sql->sa, l); > + } > /* handle possible index lookups */ > /* expressions are in index order ! */ > if (sub && (en = rel->exps->h) != NULL) { > @@ -2368,10 +2375,8 @@ rel2bin_select( mvc *sql, sql_rel *rel, > assert(0); > return NULL; > } > - if (s->nrcols == 0){ > - if (!predicate) > - predicate = rel2bin_predicate(sql); > - predicate = stmt_uselect(sql->sa, predicate, s, cmp_equal, NULL); > + if (s->nrcols == 0){ > + sel = stmt_uselect(sql->sa, predicate, s, cmp_equal, sel); > } else if (e->type != e_cmp) { > sel = stmt_uselect(sql->sa, s, stmt_bool(sql->sa, 1), cmp_equal, NULL); > } else { > @@ -2379,14 +2384,6 @@ rel2bin_select( mvc *sql, sql_rel *rel, > } > } > > - if (predicate && sel) { > - sel = stmt_reverse(sql->sa, sel); > - sel = stmt_join(sql->sa, sel, predicate, cmp_all); > - sel = stmt_result(sql->sa, sel, 0); > - predicate = NULL; > - if (!sub) > - predicate = sel; > - } > /* construct relation */ > l = sa_list(sql->sa); > if (sub && sel) { > @@ -2399,22 +2396,6 @@ rel2bin_select( mvc *sql, sql_rel *rel, > col = stmt_project(sql->sa, sel, col); > list_append(l, col); > } > - } else if (sub && predicate) { > - stmt *h = NULL; > - n = sub->op4.lval->h; > - h = stmt_join(sql->sa, column(sql->sa, n->data), predicate, cmp_all); > - h = stmt_result(sql->sa, h, 0); > - for( n = sub->op4.lval->h; n; n = n->next ) { > - stmt *col = n->data; > - > - if (col->nrcols == 0) /* constant */ > - col = stmt_const(sql->sa, h, col); > - else > - col = stmt_project(sql->sa, h, col); > - list_append(l, col); > - } > - } else if (predicate) { > - list_append(l, predicate); > } > return stmt_list(sql->sa, l); > } > diff --git a/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out b/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out > --- a/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out > +++ b/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out > @@ -29,17 +29,17 @@ Ready. > % .explain # table_name > % mal # name > % clob # type > -% 117 # length > +% 111 # length > function user.s0_1(A0:str):void; > X_2 := sql.mvc(); > X_6 := sql.bind(X_2,"sys","functions","name",0); > X_3:bat[:oid,:oid] := sql.tid(X_2,"sys","functions"); > - X_49 := algebra.likesubselect(X_6,X_3,A0,"",false); > + X_48 := algebra.likesubselect(X_6,X_3,A0,"",false); > (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2); > - X_50 := algebra.likesubselect(r1_9,A0,"",false); > + X_49 := algebra.likesubselect(r1_9,A0,"",false); > X_12 := sql.bind(X_2,"sys","functions","name",1); > - X_51 := algebra.likesubselect(X_12,X_3,A0,"",false); > - X_15 := sql.subdelta(X_49,X_9,X_50,X_51); > + X_50 := algebra.likesubselect(X_12,X_3,A0,"",false); > + X_15 := sql.subdelta(X_48,X_9,X_49,X_50); > X_17 := sql.projectdelta(X_15,X_6,X_9,r1_9,X_12); > X_18 := sql.bind(X_2,"sys","functions","func",0); > (X_20,r1_28) := sql.bind(X_2,"sys","functions","func",2); > @@ -55,17 +55,17 @@ end s0_1; > % .explain # table_name > % mal # name > % clob # type > -% 121 # length > +% 115 # length > function user.s1_1(A0:str):void; > X_2 := sql.mvc(); > X_6 := sql.bind(X_2,"sys","functions","name",0); > X_3:bat[:oid,:oid] := sql.tid(X_2,"sys","functions"); > - X_49 := algebra.likesubselect(X_6,X_3,A0,"",true); > + X_48 := algebra.likesubselect(X_6,X_3,A0,"",true); > (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2); > - X_50 := algebra.likesubselect(r1_9,A0,"",true); > + X_49 := algebra.likesubselect(r1_9,A0,"",true); > X_12 := sql.bind(X_2,"sys","functions","name",1); > - X_51 := algebra.likesubselect(X_12,X_3,A0,"",true); > - X_15 := sql.subdelta(X_49,X_9,X_50,X_51); > + X_50 := algebra.likesubselect(X_12,X_3,A0,"",true); > + X_15 := sql.subdelta(X_48,X_9,X_49,X_50); > X_17 := sql.projectdelta(X_15,X_6,X_9,r1_9,X_12); > X_18 := sql.bind(X_2,"sys","functions","func",0); > (X_20,r1_28) := sql.bind(X_2,"sys","functions","func",2); > @@ -81,17 +81,17 @@ end s1_1; > % .explain # table_name > % mal # name > % clob # type > -% 118 # length > +% 112 # length > function user.s2_1(A0:str):void; > X_2 := sql.mvc(); > X_6 := sql.bind(X_2,"sys","functions","name",0); > X_3:bat[:oid,:oid] := sql.tid(X_2,"sys","functions"); > - X_49 := algebra.ilikesubselect(X_6,X_3,A0,"",false); > + X_48 := algebra.ilikesubselect(X_6,X_3,A0,"",false); > (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2); > - X_50 := algebra.ilikesubselect(r1_9,A0,"",false); > + X_49 := algebra.ilikesubselect(r1_9,A0,"",false); > X_12 := sql.bind(X_2,"sys","functions","name",1); > - X_51 := algebra.ilikesubselect(X_12,X_3,A0,"",false); > - X_15 := sql.subdelta(X_49,X_9,X_50,X_51); > + X_50 := algebra.ilikesubselect(X_12,X_3,A0,"",false); > + X_15 := sql.subdelta(X_48,X_9,X_49,X_50); > X_17 := sql.projectdelta(X_15,X_6,X_9,r1_9,X_12); > X_18 := sql.bind(X_2,"sys","functions","func",0); > (X_20,r1_28) := sql.bind(X_2,"sys","functions","func",2); > @@ -107,17 +107,17 @@ end s2_1; > % .explain # table_name > % mal # name > % clob # type > -% 122 # length > +% 116 # length > function user.s3_1(A0:str):void; > X_2 := sql.mvc(); > X_6 := sql.bind(X_2,"sys","functions","name",0); > X_3:bat[:oid,:oid] := sql.tid(X_2,"sys","functions"); > - X_49 := algebra.ilikesubselect(X_6,X_3,A0,"",true); > + X_48 := algebra.ilikesubselect(X_6,X_3,A0,"",true); > (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2); > - X_50 := algebra.ilikesubselect(r1_9,A0,"",true); > + X_49 := algebra.ilikesubselect(r1_9,A0,"",true); > X_12 := sql.bind(X_2,"sys","functions","name",1); > - X_51 := algebra.ilikesubselect(X_12,X_3,A0,"",true); > - X_15 := sql.subdelta(X_49,X_9,X_50,X_51); > + X_50 := algebra.ilikesubselect(X_12,X_3,A0,"",true); > + X_15 := sql.subdelta(X_48,X_9,X_49,X_50); > X_17 := sql.projectdelta(X_15,X_6,X_9,r1_9,X_12); > X_18 := sql.bind(X_2,"sys","functions","func",0); > (X_20,r1_28) := sql.bind(X_2,"sys","functions","func",2); > @@ -153,19 +153,19 @@ end s3_1; > % .explain # table_name > % mal # name > % clob # type > -% 121 # length > +% 115 # length > function user.s4_1(A0:str):void; > X_2 := sql.mvc(); > X_6 := sql.bind(X_2,"sys","functions","name",0); > X_3:bat[:oid,:oid] := sql.tid(X_2,"sys","functions"); > - X_52 := calc.+("%",A0); > - X_53 := calc.+(X_52,"%"); > - X_56 := algebra.likesubselect(X_6,X_3,X_53,"",false,false); > + X_51 := calc.+("%",A0); > + X_52 := calc.+(X_51,"%"); > + X_55 := algebra.likesubselect(X_6,X_3,X_52,"",false,false); > (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2); > - X_57 := algebra.likesubselect(r1_9,X_53,"",false,false); > + X_56 := algebra.likesubselect(r1_9,X_52,"",false,false); > X_12 := sql.bind(X_2,"sys","functions","name",1); > - X_58 := algebra.likesubselect(X_12,X_3,X_53,"",false,false); > - X_14 := sql.subdelta(X_56,X_9,X_57,X_58); > + X_57 := algebra.likesubselect(X_12,X_3,X_52,"",false,false); > + X_14 := sql.subdelta(X_55,X_9,X_56,X_57); > X_15 := sql.projectdelta(X_14,X_6,X_9,r1_9,X_12); > X_16 := sql.bind(X_2,"sys","functions","func",0); > (X_18,r1_35) := sql.bind(X_2,"sys","functions","func",2); > @@ -181,19 +181,19 @@ end s4_1; > % .explain # table_name > % mal # name > % clob # type > -% 125 # length > +% 119 # length > function user.s5_1(A0:str):void; > X_2 := sql.mvc(); > X_6 := sql.bind(X_2,"sys","functions","name",0); > X_3:bat[:oid,:oid] := sql.tid(X_2,"sys","functions"); > - X_52 := calc.+("%",A0); > - X_53 := calc.+(X_52,"%"); > - X_57 := algebra.likesubselect(X_6,X_3,X_53,"",false,true); > + X_51 := calc.+("%",A0); > + X_52 := calc.+(X_51,"%"); > + X_56 := algebra.likesubselect(X_6,X_3,X_52,"",false,true); > (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2); > - X_58 := algebra.likesubselect(r1_9,X_53,"",false,true); > + X_57 := algebra.likesubselect(r1_9,X_52,"",false,true); > X_12 := sql.bind(X_2,"sys","functions","name",1); > - X_59 := algebra.likesubselect(X_12,X_3,X_53,"",false,true); > - X_14 := sql.subdelta(X_57,X_9,X_58,X_59); > + X_58 := algebra.likesubselect(X_12,X_3,X_52,"",false,true); > + X_14 := sql.subdelta(X_56,X_9,X_57,X_58); > X_15 := sql.projectdelta(X_14,X_6,X_9,r1_9,X_12); > X_16 := sql.bind(X_2,"sys","functions","func",0); > (X_18,r1_35) := sql.bind(X_2,"sys","functions","func",2); > @@ -209,19 +209,19 @@ end s5_1; > % .explain # table_name > % mal # name > % clob # type > -% 122 # length > +% 116 # length > function user.s6_1(A0:str):void; > X_2 := sql.mvc(); > X_6 := sql.bind(X_2,"sys","functions","name",0); > X_3:bat[:oid,:oid] := sql.tid(X_2,"sys","functions"); > - X_52 := calc.+("%",A0); > - X_53 := calc.+(X_52,"%"); > - X_57 := algebra.likesubselect(X_6,X_3,X_53,"",true,false); > + X_51 := calc.+("%",A0); > + X_52 := calc.+(X_51,"%"); > + X_56 := algebra.likesubselect(X_6,X_3,X_52,"",true,false); > (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2); > - X_58 := algebra.likesubselect(r1_9,X_53,"",true,false); > + X_57 := algebra.likesubselect(r1_9,X_52,"",true,false); > X_12 := sql.bind(X_2,"sys","functions","name",1); > - X_59 := algebra.likesubselect(X_12,X_3,X_53,"",true,false); > - X_14 := sql.subdelta(X_57,X_9,X_58,X_59); > + X_58 := algebra.likesubselect(X_12,X_3,X_52,"",true,false); > + X_14 := sql.subdelta(X_56,X_9,X_57,X_58); > X_15 := sql.projectdelta(X_14,X_6,X_9,r1_9,X_12); > X_16 := sql.bind(X_2,"sys","functions","func",0); > (X_18,r1_35) := sql.bind(X_2,"sys","functions","func",2); > @@ -237,19 +237,19 @@ end s6_1; > % .explain # table_name > % mal # name > % clob # type > -% 126 # length > +% 120 # length > function user.s7_1(A0:str):void; > X_2 := sql.mvc(); > X_6 := sql.bind(X_2,"sys","functions","name",0); > X_3:bat[:oid,:oid] := sql.tid(X_2,"sys","functions"); > - X_52 := calc.+("%",A0); > - X_53 := calc.+(X_52,"%"); > - X_56 := algebra.likesubselect(X_6,X_3,X_53,"",true,true); > + X_51 := calc.+("%",A0); > + X_52 := calc.+(X_51,"%"); > + X_55 := algebra.likesubselect(X_6,X_3,X_52,"",true,true); > (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2); > - X_57 := algebra.likesubselect(r1_9,X_53,"",true,true); > + X_56 := algebra.likesubselect(r1_9,X_52,"",true,true); > X_12 := sql.bind(X_2,"sys","functions","name",1); > - X_58 := algebra.likesubselect(X_12,X_3,X_53,"",true,true); > - X_14 := sql.subdelta(X_56,X_9,X_57,X_58); > + X_57 := algebra.likesubselect(X_12,X_3,X_52,"",true,true); > + X_14 := sql.subdelta(X_55,X_9,X_56,X_57); > X_15 := sql.projectdelta(X_14,X_6,X_9,r1_9,X_12); > X_16 := sql.bind(X_2,"sys","functions","func",0); > (X_18,r1_35) := sql.bind(X_2,"sys","functions","func",2); > _______________________________________________ > checkin-list mailing list > checkin-list(a)monetdb.org > http://mail.monetdb.org/mailman/listinfo/checkin-list > -- Sjoerd Mullender

1 0