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 jcavieres@gmail.com 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 Y.Zhang@cwi.nl 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 jcavieres@gmail.com 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 prom |
: 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
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