This is related to the query parser in some way - when using bound parameters it works perfectly,
https://github.com/codemix/oriento/blob/gregorian-dates/test/bugs/xxx-gregorian-dates.js Charles On Friday, December 19, 2014 3:06:39 PM UTC, Charles Pick wrote: > > The properties do get created with types, but I can replicate the issue > via the REST api, just not via binary. Try sending in the format > "1582-10-04T00:00:00.000Z" and see if that makes a difference? > > Charles > > On Friday, December 19, 2014 1:20:59 PM UTC, GoorMoon wrote: >> >> I look in to your test case you didn't create properties with types. >> Look in this scenario >> >> CREATE CLASS TestClass >> CREATE PROPERTY TestCLass.someDate date >> CREATE PROPERTY TestCLass.someDateTime datetime >> >> INSERT INTO TestClass SET someDate = "1582-10-04 09:00:00", someDateTime >> = "1582-10-14 09:00:00" >> >> >> On Friday, December 19, 2014 12:09:32 PM UTC+2, Charles Pick wrote: >>> >>> Could not replicate this with Oriento, see this test case - >>> https://github.com/codemix/oriento/blob/gregorian-dates/test/bugs/xxx-gregorian-dates.js >>> >>> Charles >>> >>> On Thursday, December 18, 2014 9:05:47 PM UTC, GoorMoon wrote: >>>> >>>> Hello everyone, >>>> >>>> I check the driver fault in OrientDB-Net.binary with dates and I >>>> noticed that the dates in between 1582-10-04 and 1582-10-15 can not be >>>> inserted into the database. >>>> I understand that this happens because the Gregorian calendar that JAVA >>>> using. >>>> But I think the database must support all range of a dates at least >>>> from 0001-01-01 to 9999-12-31. >>>> WDYT? >>>> >>>> ============================================ >>>> >>>> orientdb {db=Temp}> info class testvertex >>>> >>>> Class................: TestVertex >>>> Default cluster......: testvertex (id=12) >>>> Supported cluster ids: [12] >>>> Cluster selection....: round-robin >>>> >>>> PROPERTIES >>>> >>>> -------------------------------+---------------------+----------------------------------------------+----------------------+-------------------+----------------+-------------+--------------+----------------+ >>>> NAME | TYPE | LINKED TYPE/CLASS >>>> | MANDATORY | READONLY | NOT NULL | MIN | MAX | COLLATE >>>> | >>>> >>>> -------------------------------+---------------------+----------------------------------------------+----------------------+-------------------+----------------+-------------+--------------+----------------+ >>>> _dt | DATETIME | null >>>> | false | false | false >>>> | | | default | >>>> >>>> -------------------------------+---------------------+----------------------------------------------+----------------------+-------------------+----------------+-------------+--------------+----------------+ >>>> >>>> orientdb {db=Temp}> select from testvertex >>>> >>>> ----+---------+----------------+------------------------------ >>>> # |@RID |@CLASS |_dt >>>> ----+---------+----------------+------------------------------ >>>> 0 |#12:0 |TestVertex |0001-01-01 00:00:00 >>>> ----+---------+----------------+------------------------------ >>>> >>>> 1 item(s) found. Query executed in 0.003 sec(s). >>>> orientdb {db=Temp}> insert into TestVertex set _dt='1582-10-14 00:00:00' >>>> >>>> Error: >>>> com.orientechnologies.orient.core.exception.OQueryParsingException: Error >>>> on conversion of date '1582-10-14 00:00:00' using the format: yyyy-MM-dd >>>> HH:mm:ss >>>> >>>> orientdb {db=Temp}> >>>> >>>> -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
