To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106197 Issue #|106197 Summary|[cws hsqldb19] Queries works differently with new date |/interval data types Component|Database access Version|DEV300m61 Platform|Unknown URL| OS/Version|Windows XP Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|r4zoli
------- Additional comments from r4z...@openoffice.org Thu Oct 22 14:12:36 +0000 2009 ------- Open database containing date, timestamp fields. Open query in SQL View. Activate Run SQL command directly. Run queries, they run without problem: SELECT "Date_1" + 21 DAY FROM "Table1" SELECT "Date_1" + 21 MONTH FROM "Table1" SELECT (CURRENT_DATE - 2 DAY) FROM "Table1" SELECT (CURRENT_TIMESTAMP + '20:00') SECONDS FROM "Table1" SELECT TIMESTAMP '2008-08-08 20:08:08' From "Table1" Run queries below, they run with assertion error: unsupported type If I run them in Tools>SQL command window, successfully executed: SELECT (CURRENT_DATE - DATE '2000-01-01') DAY FROM "Table1" SELECT (CURRENT_DATE - "Date_1") DAY FROM "Table1" SELECT (CURRENT_DATE - DATE '2000-01-01') YEAR TO MONTH FROM "Table1" SELECT ("Timestamp_1" - TIMESTAMP '2009-01-01 00:00:00') YEAR TO MONTH FROM "Table1" --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org