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