Hi Martin, Thanks for the fix. However, TPCH MAL plans still show the same errors: Installed: changeset 53316:192a529eaa4a http://dev.monetdb.org/hg/MonetDB/rev/192a529eaa4a Running MAL plan: sql/benchmarks/tpch/Tests/02-explain.stable.out I get the following exception: !TypeException:user.s2_1[25]:'algebra.join' undefined in: (X_41:any, r1_46:any) := algebra.join(X_31:bat[:oid,:oid], X_40:bat[:oid,:any]) !TypeException:user.main[1]:'user.s2_1' undefined in: _1:any := user.s2_1() Even if I regenerate the query plan myself, I get same exception. Thanks for the help. Regards, -----Original Message----- From: users-list [mailto:users-list-bounces+ahmad.hassan=sap.com@monetdb.org] On Behalf Of Martin Kersten Sent: 09 October 2014 18:43 To: users-list@monetdb.org Subject: Re: MAL script error Hi, The problem has been fixed in the upcoming Oct2014 release branch. changeset: 53316:192a529eaa4a | | | branch: Oct2014 | | | parent: 53312:8b94f3b29d5d | | | user: Martin Kersten | | | date: Sat Oct 04 09:18:22 2014 +0200 | | | summary: Fix type admin of sql.binds --- a/sql/backends/monet5/sql_gencode.c Fri Oct 03 19:56:04 2014 +0200 +++ b/sql/backends/monet5/sql_gencode.c Thu Oct 09 19:42:25 2014 +0200 @@ -899,8 +899,10 @@ return -1; if (s->flag == RD_UPD_ID) { q = pushReturn(mb, q, newTmpVariable(mb, newBatType(ht, tt))); - } else + } else { setVarType(mb, getArg(q, 0), newBatType(ht, tt)); + setVarUDFtype(mb, getArg(q, 0)); + } q = pushArgument(mb, q, sql->mvc_var); q = pushSchema(mb, q, t); q = pushStr(mb, q, t->base.name); regards, Martin On 09/10/14 18:05, Qing Guo wrote:

Hi Martin,

I had the same issue. Could you give a clue how to fix the problem in other MAL plans? Thanks!

Regards, -Qing

On Oct 4, 2014, at 1:49 AM, Martin Kersten wrote:

...

Hi

I found the culprit. The types of some of the sql.bind() calls are not retained in the listing, which should have been.

X_10 := sql.bind(X_6,"sys","nation","n_regionkey",0); X_16 := sql.bind(X_6,"sys","region","r_name",0); X_21 := sql.bind(X_6,"sys","region","r_regionkey",0); X_29 := sql.bind(X_6,"sys","nation","n_nationkey",0); X_35 := sql.bind(X_6,"sys","supplier","s_nationkey",0); X_41 := sql.bind(X_6,"sys","supplier","s_suppkey",0); X_49 := sql.bind(X_6,"sys","partsupp","ps_suppkey",0); X_54 := sql.bind(X_6,"sys","partsupp","ps_partkey",0); X_60 := sql.bind(X_6,"sys","part","p_type",0); X_64 := sql.bind(X_6,"sys","part","p_size",0); X_70 := sql.bind(X_6,"sys","part","p_partkey",0); X_86 := sql.bind(X_6,"sys","nation","n_regionkey",0); X_93 := sql.bind(X_6,"sys","region","r_name",0); X_99 := sql.bind(X_6,"sys","region","r_regionkey",0); X_115 := sql.bind(X_6,"sys","partsupp","ps_supplycost",0); X_273:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_name",0); X_274:bat[:oid,:str] := sql.bind(X_6,"sys","nation","n_name",0); X_275:bat[:oid,:lng] := sql.bind(X_6,"sys","supplier","s_acctbal",0); X_174 := sql.bind(X_6,"sys","part","p_mfgr",0); X_276:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_address",0); X_277:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_phone",0); X_278:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_comment",0);

A bug report has been filed.

On 03/10/14 18:27, Hassan, Ahmad wrote:

...

Hi Marten,

I didn't modify the query plan. I retrieved the query plan using 'explain <sql query>' for tpch query #02. However, I checked the latest MonetDB version 11.17.21, it also gives the errors.

Further, upon running the MAL function for TPCH query #02 located in: MonetDB-11.17.21/sql/benchmarks/tpch/Tests/02-explain.stable.out

I also get:

!TypeException:user.s2_1[23]:'algebra.join' undefined in: (X_41:any, r1_46:any) := algebra.join(X_31:bat[:oid,:oid], X_40:bat[:oid,:any])

!TypeException:user.main[1]:'user.s2_1' undefined in: _1:any := user.s2_1()

Regards,

*From:*users-list [mailto:users-list-bounces+ahmad.hassan=sap.com@monetdb.org] *On Behalf Of * Martin Kersten *Sent:* 03 October 2014 17:20 *To:* Communication channel for MonetDB users *Subject:* Re: MAL script error

this is insufficient to identify. Most likely you attempted to use a modified plan, where the type of z-150 and r1-280 can not be statically determined.

regards, martin

On 3 okt. 2014, at 16:52, "Hassan, Ahmad" mailto:ahmad.hassan@sap.com> wrote:

Hi,

One executing the MAL script http://pastebin.com/VUPbhD8V , I get the following errors:

!TypeException:user.s0_11[87]:'algebra.join' undefined in: (X_150:any, r1_280:any) := algebra.join(X_137:bat[:oid,:oid], X_149:bat[:oid,:any])

!TypeException:user.s0_11[88]:'algebra.leftfetchjoin' undefined in: X_152:any := algebra.leftfetchjoin(r1_280:any, X_138:bat[:oid,:oid])

!TypeException:user.s0_11[94]:'algebra.join' undefined in: (X_161:any, r1_304:any) := algebra.join(X_152:any, X_160:bat[:oid,:any])

!TypeException:user.s0_11[95]:'algebra.leftfetchjoin' undefined in: X_404:any := algebra.leftfetchjoin(X_150:any, X_135:bat[:oid,:oid])

!TypeException:user.s0_11[100]:'algebra.leftfetchjoinPath' undefined in: X_174:bat[:oid,:int] := algebra.leftfetchjoinPath(X_161:any, X_404:any, X_173:bat[:oid,:any])

!TypeException:user.s0_11[106]:'algebra.leftfetchjoin' undefined in: X_183:any := algebra.leftfetchjoin(r1_304:any, X_182:bat[:oid,:any])

!TypeException:user.s0_11[107]:'algebra.join' undefined in: (X_184:any, r1_343:any) := algebra.join(X_183:any, X_107:bat[:oid,:int])

!TypeException:user.s0_11[109]:'algebra.leftfetchjoin' undefined in: X_187:any := algebra.leftfetchjoin(X_186:bat[:oid,:oid], X_183:any)

!TypeException:user.s0_11[110]:'group.subgroupdone' undefined in: (X_188:any, r1_349:any, r2_349:any) := group.subgroupdone(X_187:any)

!TypeException:user.s0_11[111]:'algebra.leftfetchjoin' undefined in: X_191:any := algebra.leftfetchjoin(r1_349:any, X_187:any)

!TypeException:user.s0_11[113]:'algebra.leftfetchjoinPath' undefined in: X_195:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_186:bat[:oid,:oid], r1_304:any, X_194:bat[:oid,:any])

!TypeException:user.s0_11[114]:'aggr.submin' undefined in: X_196:bat[:oid,:lng] := aggr.submin(X_195:bat[:oid,:lng], X_188:any, r1_349:any, _201:bit)

!TypeException:user.s0_11[119]:'algebra.leftfetchjoin' undefined in: X_202:any := algebra.leftfetchjoin(r1_389:bat[:oid,:oid], X_191:any)

!TypeException:user.main[2]:'user.s0_11' undefined in: _4:any := user.s0_11()

The equivalent SQL query works fine but I am interested in running MAL script via mserver5. How can I resolve the above exceptions please?

Thanks.

_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

Hi Martin, After applying this fix, MAL plans are still not working, but now giving errors on other functions like projectdelta, delta etc TPCH q02 !TypeException:user.s1_1[6]:'sql.projectdelta' undefined in: X_18:any := sql.projectdelta(X_7:bat[:oid,:oid], X_10:bat[:oid,:oid], X_13:bat[:oid,:oid], r1_13:bat[:oid,:any], X_16:bat[:oid,:oid]) !TypeException:user.main[1]:'user.s1_1' undefined in: _1:any := user.s1_1() TPCH q13 !TypeException:user.s1_1[8]:'sql.delta' undefined in: X_20:any := sql.delta(X_12:bat[:oid,:oid], X_15:bat[:oid,:oid], r1_15:bat[:oid,:any], X_18:bat[:oid,:oid]) !TypeException:user.main[1]:'user.s1_1' undefined in: _1:any := user.s1_1() Regards, -----Original Message----- From: users-list [mailto:users-list-bounces+ahmad.hassan=sap.com@monetdb.org] On Behalf Of Martin Kersten Sent: 13 October 2014 21:01 To: Communication channel for MonetDB users Subject: Re: MAL script error Hi I see, in sql_gencode.c the same patch should be applied on line 921: case st_idxbat:{ ... if (s->flag == RD_UPD_ID) { q = pushReturn(mb, q, newTmpVariable(mb, newBatType(ht, tt))); } else{ setVarType(mb, getArg(q, 0), newBatType(ht, tt)); setVarUDFtype(mb, getArg(q, 0)); } On 13/10/14 17:11, Hassan, Ahmad wrote:

Hi Martin,

Thanks for the fix. However, TPCH MAL plans still show the same errors:

Installed: changeset 53316:192a529eaa4a http://dev.monetdb.org/hg/MonetDB/rev/192a529eaa4a

Running MAL plan: sql/benchmarks/tpch/Tests/02-explain.stable.out

I get the following exception: !TypeException:user.s2_1[25]:'algebra.join' undefined in: (X_41:any, r1_46:any) := algebra.join(X_31:bat[:oid,:oid], X_40:bat[:oid,:any]) !TypeException:user.main[1]:'user.s2_1' undefined in: _1:any := user.s2_1()

Even if I regenerate the query plan myself, I get same exception.

Thanks for the help.

Regards,

-----Original Message----- From: users-list [mailto:users-list-bounces+ahmad.hassan=sap.com@monetdb.org] On Behalf Of Martin Kersten Sent: 09 October 2014 18:43 To: users-list@monetdb.org Subject: Re: MAL script error

Hi,

The problem has been fixed in the upcoming Oct2014 release branch.

changeset: 53316:192a529eaa4a | | | branch: Oct2014 | | | parent: 53312:8b94f3b29d5d | | | user: Martin Kersten | | | date: Sat Oct 04 09:18:22 2014 +0200 | | | summary: Fix type admin of sql.binds

--- a/sql/backends/monet5/sql_gencode.c Fri Oct 03 19:56:04 2014 +0200 +++ b/sql/backends/monet5/sql_gencode.c Thu Oct 09 19:42:25 2014 +0200 @@ -899,8 +899,10 @@ return -1; if (s->flag == RD_UPD_ID) { q = pushReturn(mb, q, newTmpVariable(mb, newBatType(ht, tt))); - } else + } else { setVarType(mb, getArg(q, 0), newBatType(ht, tt)); + setVarUDFtype(mb, getArg(q, 0)); + } q = pushArgument(mb, q, sql->mvc_var); q = pushSchema(mb, q, t); q = pushStr(mb, q, t->base.name);

regards, Martin

On 09/10/14 18:05, Qing Guo wrote:

...

Hi Martin,

I had the same issue. Could you give a clue how to fix the problem in other MAL plans? Thanks!

Regards, -Qing

On Oct 4, 2014, at 1:49 AM, Martin Kersten wrote:

...

Hi

I found the culprit. The types of some of the sql.bind() calls are not retained in the listing, which should have been.

X_10 := sql.bind(X_6,"sys","nation","n_regionkey",0); X_16 := sql.bind(X_6,"sys","region","r_name",0); X_21 := sql.bind(X_6,"sys","region","r_regionkey",0); X_29 := sql.bind(X_6,"sys","nation","n_nationkey",0); X_35 := sql.bind(X_6,"sys","supplier","s_nationkey",0); X_41 := sql.bind(X_6,"sys","supplier","s_suppkey",0); X_49 := sql.bind(X_6,"sys","partsupp","ps_suppkey",0); X_54 := sql.bind(X_6,"sys","partsupp","ps_partkey",0); X_60 := sql.bind(X_6,"sys","part","p_type",0); X_64 := sql.bind(X_6,"sys","part","p_size",0); X_70 := sql.bind(X_6,"sys","part","p_partkey",0); X_86 := sql.bind(X_6,"sys","nation","n_regionkey",0); X_93 := sql.bind(X_6,"sys","region","r_name",0); X_99 := sql.bind(X_6,"sys","region","r_regionkey",0); X_115 := sql.bind(X_6,"sys","partsupp","ps_supplycost",0); X_273:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_name",0); X_274:bat[:oid,:str] := sql.bind(X_6,"sys","nation","n_name",0); X_275:bat[:oid,:lng] := sql.bind(X_6,"sys","supplier","s_acctbal",0); X_174 := sql.bind(X_6,"sys","part","p_mfgr",0); X_276:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_address",0); X_277:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_phone",0); X_278:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_comment",0);

A bug report has been filed.

On 03/10/14 18:27, Hassan, Ahmad wrote:

...

Hi Marten,

I didn't modify the query plan. I retrieved the query plan using 'explain <sql query>' for tpch query #02. However, I checked the latest MonetDB version 11.17.21, it also gives the errors.

Further, upon running the MAL function for TPCH query #02 located in: MonetDB-11.17.21/sql/benchmarks/tpch/Tests/02-explain.stable.out

I also get:

!TypeException:user.s2_1[23]:'algebra.join' undefined in: (X_41:any, r1_46:any) := algebra.join(X_31:bat[:oid,:oid], X_40:bat[:oid,:any])

!TypeException:user.main[1]:'user.s2_1' undefined in: _1:any := user.s2_1()

Regards,

*From:*users-list [mailto:users-list-bounces+ahmad.hassan=sap.com@monetdb.org] *On Behalf Of * Martin Kersten *Sent:* 03 October 2014 17:20 *To:* Communication channel for MonetDB users *Subject:* Re: MAL script error

this is insufficient to identify. Most likely you attempted to use a modified plan, where the type of z-150 and r1-280 can not be statically determined.

regards, martin

On 3 okt. 2014, at 16:52, "Hassan, Ahmad" mailto:ahmad.hassan@sap.com> wrote:

Hi,

One executing the MAL script http://pastebin.com/VUPbhD8V , I get the following errors:

!TypeException:user.s0_11[87]:'algebra.join' undefined in: (X_150:any, r1_280:any) := algebra.join(X_137:bat[:oid,:oid], X_149:bat[:oid,:any])

!TypeException:user.s0_11[88]:'algebra.leftfetchjoin' undefined in: X_152:any := algebra.leftfetchjoin(r1_280:any, X_138:bat[:oid,:oid])

!TypeException:user.s0_11[94]:'algebra.join' undefined in: (X_161:any, r1_304:any) := algebra.join(X_152:any, X_160:bat[:oid,:any])

!TypeException:user.s0_11[95]:'algebra.leftfetchjoin' undefined in: X_404:any := algebra.leftfetchjoin(X_150:any, X_135:bat[:oid,:oid])

!TypeException:user.s0_11[100]:'algebra.leftfetchjoinPath' undefined in: X_174:bat[:oid,:int] := algebra.leftfetchjoinPath(X_161:any, X_404:any, X_173:bat[:oid,:any])

!TypeException:user.s0_11[106]:'algebra.leftfetchjoin' undefined in: X_183:any := algebra.leftfetchjoin(r1_304:any, X_182:bat[:oid,:any])

!TypeException:user.s0_11[107]:'algebra.join' undefined in: (X_184:any, r1_343:any) := algebra.join(X_183:any, X_107:bat[:oid,:int])

!TypeException:user.s0_11[109]:'algebra.leftfetchjoin' undefined in: X_187:any := algebra.leftfetchjoin(X_186:bat[:oid,:oid], X_183:any)

!TypeException:user.s0_11[110]:'group.subgroupdone' undefined in: (X_188:any, r1_349:any, r2_349:any) := group.subgroupdone(X_187:any)

!TypeException:user.s0_11[111]:'algebra.leftfetchjoin' undefined in: X_191:any := algebra.leftfetchjoin(r1_349:any, X_187:any)

!TypeException:user.s0_11[113]:'algebra.leftfetchjoinPath' undefined in: X_195:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_186:bat[:oid,:oid], r1_304:any, X_194:bat[:oid,:any])

!TypeException:user.s0_11[114]:'aggr.submin' undefined in: X_196:bat[:oid,:lng] := aggr.submin(X_195:bat[:oid,:lng], X_188:any, r1_349:any, _201:bit)

!TypeException:user.s0_11[119]:'algebra.leftfetchjoin' undefined in: X_202:any := algebra.leftfetchjoin(r1_389:bat[:oid,:oid], X_191:any)

!TypeException:user.main[2]:'user.s0_11' undefined in: _4:any := user.s0_11()

The equivalent SQL query works fine but I am interested in running MAL script via mserver5. How can I resolve the above exceptions please?

Thanks.

_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list