Hi Niels, Here's the output from \d negs: CREATE TABLE "sys"."negs" ( "id" VARCHAR(50) NOT NULL, "xdate" DATE NOT NULL, "market" INTEGER, "product" INTEGER, "notional" DOUBLE, "client" INTEGER, "tier" INTEGER, "status" INTEGER, "dayno" INTEGER, CONSTRAINT "negs_id_xdate_pkey" PRIMARY KEY ("id", "xdate") ); CREATE INDEX "idx_negs_client" ON "sys"."negs" ("client"); CREATE INDEX "idx_negs_market" ON "sys"."negs" ("market"); CREATE INDEX "idx_negs_product" ON "sys"."negs" ("product"); CREATE INDEX "idx_negs_status" ON "sys"."negs" ("status"); CREATE INDEX "idx_negs_tier" ON "sys"."negs" ("tier"); CREATE INDEX "idx_negs_xdate" ON "sys"."negs" ("xdate"); (I have added a few more columns since my original E-mail, but still seeing the same crashing behaviour.) Cheers, Nick -----Original Message----- From: users-list [mailto:users-list-bounces+nickc=digiterre.com@monetdb.org] On Behalf Of Niels Nes Sent: 16 September 2014 19:48 To: Communication channel for MonetDB users Subject: Re: Crashing when querying on date column On Tue, Sep 16, 2014 at 01:31:34PM +0000, Nick Chadwick wrote:
Hi.
I’m currently evaluating MonetDB for an upcoming project, and am having some problems when using date criteria in the where clause.
I have a very simple table:
Create table negs (id varchar(50) not null, xdate date not null, market int, product int, notional double)
Id and xdate form a composite primary key, and I have indices on xdate, market and product. Date itself isn't that special (ie used in very many of our tests), I expecte the composite key or indices cause the problem. Could you send the full ddl (or simply using mclients \d negs ).
Niels
If I run the following query:
Select * from negs where xdate = current_date
the client crashes. Similarly if I run the same query over a JDBC connection from java, the connection is lost.
Looking in the log file, it says that the database was killed due to a SIGSEGV.
Am I doing something wrong?
I am running on Ubuntu 14.04, and built MonetDB from the latest source tarball, 11.17.21.
Thanks,
Nick
www.digiterre.com _________________
Privileged or confidential information may be contained in this message. If you are not the addressee of this message please notify the sender by return and thereafter delete the message, and you may not use, copy, disclose or rely on the information contained in it. Internet e-mail may be susceptible to data corruption, interception and unauthorised amendment for which Digiterre does not accept liability. Whilst we have taken reasonable precautions to ensure that this e-mail and any attachments have been swept for viruses, Digiterre does not accept liability for any damage sustained as a result of viruses. Statements in this message that do not relate to the business of Digiterre are neither given nor endorsed by the company or its directors.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl www.digiterre.com _________________ Privileged or confidential information may be contained in this message. If you are not the addressee of this message please notify the sender by return and thereafter delete the message, and you may not use, copy, disclose or rely on the information contained in it. Internet e-mail may be susceptible to data corruption, interception and unauthorised amendment for which Digiterre does not accept liability. Whilst we have taken reasonable precautions to ensure that this e-mail and any attachments have been swept for viruses, Digiterre does not accept liability for any damage sustained as a result of viruses. Statements in this message that do not relate to the business of Digiterre are neither given nor endorsed by the company or its directors.