The bugtracker is open for new accounts again. I figured that the spammers have gone on to bother other sites after they weren't able to bother us for a while. On 10/22/2016 02:09 PM, Panagiotis Koutsourakis wrote:
The bug has been reported:
https://www.monetdb.org/bugzilla/show_bug.cgi?id=6082
Unfortunately I could not add you to the CC list, it seems that your email address has to be known to bugzilla in order to do that.
Panos.
José Cavieres @ 2016-10-21 18:37 GMT:
That would be great.
Thanks JCS
On Fri, Oct 21, 2016 at 3:14 PM, Panagiotis Koutsourakis < kutsurak@monetdbsolutions.com> wrote:
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
_______________________________________________ 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
-- Sjoerd Mullender