Re: query with group.subgroupdone' undefined in

Hello Jose, We had some problems with bugzilla recently, and we were forced to disable user creation. I will file your bug tomorrow and add your email address in the CC list, if it is alright with you. Best regards, Panos. José Cavieres @ 2016-10-21 18:08 GMT:

Environment: - MonetDB v11.23.7 (Jun2016-SP1) from release package - Centos and Ubuntu

How to reproduce:

sql>create table testquery (N6_end timestamp null,trStart timestamp null); operation successful (31.437ms) sql>select (CAST(now()-'1970-01-01 00:00:00' as BIGINT)) as minuto,avg(CAST(N6_end - trStart as BIGINT)) as testquery from z_autoactivacionsim_com_zweicom_0_3_9 where trStart>'2016-10-06 00:00:00.000000' GROUP BY minuto; +---------------+--------------------------+ | minuto | testquery | +===============+==========================+ | 1477073192000 | null | +---------------+--------------------------+ 1 tuple (3.680ms) sql>select 2*(CAST(now()-'1970-01-01 00:00:00' as BIGINT)) as minuto,avg(CAST(N6_end - trStart as BIGINT)) as testquery from z_autoactivacionsim_com_zweicom_0_3_9 where trStart>'2016-10-06 00:00:00.000000' GROUP BY minuto; TypeException:user.s8_1[10]:'group.subgroupdone' undefined in: (X_15:any,r1_15:any,r2_15:any) := group.subgroupdone(X_14:hge); program contains errors

Regards JCS

On Fri, Oct 21, 2016 at 11:04 AM, José Cavieres wrote:

...

Thanks for answering. I'd love to file a bug report, but it's been impossible for me to create a new user or login in https://www.monetdb.org/bugzilla/

I can't find the "create a new user" button and the reset password doesn't work either (I guess because my user doesn't exist).

JCS

On Fri, Oct 21, 2016 at 10:24 AM, Ying Zhang wrote:

...

Hello,

This looks like a bug to me. Can you please fire a bug report with the schema of “testquery”, so that we can try to reproduce it? Does it matter if there are data in “testquery”? If yes, please give us the necessary data. Thanks!

Regards, Jennie

...

On 07 Oct 2016, at 16:33, José Cavieres wrote:

Hello,

Can anyone explain why adding "2*" in the following query results in an error:

Original Query: sql>select (CAST(now()-'1970-01-01 00:00:00' as BIGINT)) as minuto,avg(CAST(N6_end - trStart as BIGINT)) as promedio from testquery where trStart>'2016-10-06 00:00:00.000000' GROUP BY minuto; +---------------+--------------------------+ | minuto | promedio | +===============+==========================+ | 1475770734000 | null | +---------------+--------------------------+

Query with "2*": sql>select 2*CAST(now()-'1970-01-01 00:00:00' as BIGINT) as minuto,avg(CAST(N6_end - trStart as BIGINT)) as promedio from testquery where trStart>'2016-10-06 00:00:00.000000' GROUP BY minuto; TypeException:user.s20_1[10]:'group.subgroupdone' undefined in: (X_15:any,r1_15:any,r2_15:any) := group.subgroupdone(X_14:hge); program contains errors

Explain: ------------------------------------------------------------

---

---------------------+

...

| mal | +=========================================================== ============================================================ ======================+ | function user.s22_1(A0:bte,A1:str,A2:str):void; | sql.mvc();

...

| X_5:timestamp := mtime.current_timestamp(); | | A1; | | calc.timestamp(X_6,7,1); | | X_10:lng := mtime.diff(X_5,X_7); | | calc.lng(X_10); | | calc.hge(X_11); | | A0; | | X_14:hge := calc.*(X_12,X_13); | | (X_15,r1_15,r2_15) := group.subgroupdone(X_14); | | algebra.projection(r1_15,X_14); | | bat.setKey(X_18,true); | | X_21:bat[:oid] := sql.tid(X_4,"sys","testquery"); | | X_24:bat[:timestamp] := sql.bind(X_4,"sys","testquery","trstart",0); | | (X_27,r1_27) := sql.bind(X_4,"sys","testquery","trstart",2); | | X_30:bat[:timestamp] := sql.bind(X_4,"sys","testquery","trstart",1); | | sql.delta(X_24,X_27,r1_27,X_30); | | algebra.projection(X_21,X_31); | | X_33:bat[:timestamp] := mal.multiplex("calc","timestamp",X_32,7); | | A2; | | calc.timestamp(X_36,7); | | algebra.thetasubselect(X_33,X_37,">"); | | X_40:bat[:timestamp] := sql.bind(X_4,"sys","testquery","n6_end",0); | | (X_42,r1_42) := sql.bind(X_4,"sys","testquery","n6_end",2); | | X_44:bat[:timestamp] := sql.bind(X_4,"sys","testquery","n6_end",1); | | sql.delta(X_40,X_42,r1_42,X_44); | | algebra.projection(X_21,X_45); | | algebra.projection(X_38,X_46); | | algebra.projection(X_38,X_32); | | X_49:bat[:lng] := mal.multiplex("mtime","diff",X_47,X_48); | | batcalc.lng(X_49); | | batcalc.dbl(X_52); | | X_54:bat[:dbl] := aggr.subavg(X_53,X_15,r1_15,true,true); | | bat.new(nil:oid,nil:str); | | bat.new(nil:oid,nil:str); | | bat.new(nil:oid,nil:str); | | bat.new(nil:oid,nil:int); | | bat.new(nil:oid,nil:int); | | bat.append(X_58,".L1"); | | bat.append(X_61,"minuto"); | | bat.append(X_62,"hugeint"); | | bat.append(X_63,72); | | bat.append(X_65,0); | | bat.append(X_66,"sys.L3"); | | bat.append(X_68,"promedio"); | | bat.append(X_70,"double"); | | bat.append(X_72,53); | | bat.append(X_74,0); | | sql.resultSet(X_76,X_78,X_80,X_82,X_84,X_19,X_54); | | end user.s22_1; | | # querylog.define("explain select 2*cast(now()-\\'1970-01-01 00:00:00\\' as bigint) as minuto,avg(cast(n6_end - trstart as bigint)) as

...

: edio from testquery where trstart>\\'2016-10-06 00:00:00.000000\\' group by minuto;","default_pipe") :

Environment: - MonetDB v11.23.7 (Jun2016-SP1) from release package - Centos and Ubuntu - Create table attached - The type of the columns in the query is timestamp - A previous versions of this email was rejected because the "create

| prom | table" statement is too big for the 40Kbytes limit of this list.

...

Thanks Jose Cavieres

_______________________________________________ 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