Hi, Thomas. No, I did not try the most recent version. But I have some new info.
When I migrated to the previous version (1.3 stable release) I found new error description message while running the above query. Right now I can not find it but *it was strongly linked with DateTime range conversion*. Something like that: 'Can not convert Datetime value to the array' I'll post the exact message ASAP. After that I tried to remove *DISTINCT* instruction from the query - and suddenly *it worked*. then I excluded *date range comparison* *and ordering* from WHERE clause and again* it was successful*. These results were taken from DBeaver and Squirrel clients - not from my application. Seems like a bug in H2? May be this will be helpful to development team. Thanks in advance. -- Dmitry четверг, 23 февраля 2017 г., 19:30:41 UTC+3 пользователь Thomas Mueller Graf написал: > > Hi, > > Did you try with the latest version? > > Regards, > Thomas > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
