To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106234 Issue #|106234 Summary|[cws hsqldb19] Time macros are not recognized Component|Database access Version|DEV300m61 Platform|Unknown URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen
------- Additional comments from atjen...@openoffice.org Fri Oct 23 21:45:24 +0000 2009 ------- Test env. OOO300m_61 CWSHSQLdb19 (10-20-09), Win 7 To reproduce. Open Base Go to queries Create New query in SQL view Click on the SQL tool button 1) test one date passes Enter command: CALL CURRENT_DATE Run query - result is the current date 2) test time macro Enter command: CALL CURRENT_TIME Run query - --------------------------- Debug Output --------------------------- Error: ORowSetValue::fill: unsupported type! >From File d:/src/cws/hsqldb19/ooo/connectivity/source/commontools/FValue.cxx at Line 1910 Same is true for CURRENT_TIMESTAMP NOTE - selecting IGNORE from that error dialog sometimes the returns an empty result set, and sometimes OO.o just crashes...can't tell you how to make it do one or the other - but it appears that running a successful query first raises the chances that the application will actually crash --------------------------------------------------------------------- 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
