Hi User-list!

I am experiencing segfault monetdb crash, platform:

  CentOS Linux release 7.1.1503 (Core) 

  3.10.0-229.1.2.el7.x86_64 #1 SMP Fri Mar 27 03:04:26 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

Table:

CREATE TABLE "marketdata"."quotes" (

"id"     INTEGER       NOT NULL DEFAULT next value for "marketdata"."seq_6391",

"qtime"  TIMESTAMP WITH TIME ZONE NOT NULL,

"sdate"  TIMESTAMP WITH TIME ZONE,

"sym"    VARCHAR(10)   NOT NULL,

"cur"    VARCHAR(10)   NOT NULL,

"open"   DOUBLE        NOT NULL,

"high"   DOUBLE        NOT NULL,

"low"    DOUBLE        NOT NULL,

"close"  DOUBLE        NOT NULL,

"volume" DOUBLE,

CONSTRAINT "quotes_id_pkey" PRIMARY KEY ("id")

);

SQL: 

WITH cte(qtime, open, close, sdate, id, rnk) as (

  select qtime, sdate, id, row_number() over (partition by sdate order by qtime asc) as rnk

  from marketdata.quotes where sym='SPY'

) select * from cte where rnk=1;

~2M records loaded from csv.

Always segfault crashes monetdb daemon and DB became not repairable.

Reproducible on MonetDB-11.19.9 installed from yum repository, as well as compiled from sources, with-optimization and without.
Also it crashed on latest development source branch MonetDB-11c0c6cf614f with optimization and without.
From mclient and JDBC client.


Any help is very appreciated!! I am available to debug / provide additional information if needed.


Thanks,
John