Hi I can not reconstruct the error on the Jan 2014 Fedora 20 Jan2014> mclient -d demoJan2014 Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased) Database: MonetDB v11.20.0 (unreleased), 'mapi:monetdb://vienna.ins.cwi.nl:50000/demoJan2014' Type \q to quit, \? for a list of available commands auto commit mode: on sql>Create table negs (id varchar(50) not null, xdate date not null, market int, product int, notional double); operation successful (23.827ms) sql>Select * from negs where xdate = current_date; +----+-------+--------+---------+----------+ | id | xdate | market | product | notional | +====+=======+========+=========+==========+ +----+-------+--------+---------+----------+ 0 tuples (2.028ms) sql> Could it be that your table 'negs' is not empty? More information is needed to track the problem. regards, Martin On 16/09/14 15:31, 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.
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