To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110625 Issue #|110625 Summary|(invalid?) SQL Statement no longer work after JAVA Run |time Update Component|Database access Version|OOo 3.2 Platform|Unknown URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P5 Subcomponent|MySQL Connector/OOo Assigned to|dbaneedsconfirm Reported by|stefanoo
------- Additional comments from [email protected] Mon Apr 5 15:39:33 +0000 2010 ------- Not sure if this is a bug need to be considered! Using SQL Querry with Date Formats in a *ods file, that connecting to a HSQLDB (Base) Database was working since 2 years. After upgrading to Java Runtime environment (JRE) 1.6.0_19 these query result in eror messages. (Using an older JRE and it works again). Example for a query is: UPDATE ""Table"" SET ""Datecolumn"" = '"&Year(Date)&"-" &month(Date)& "-"& day(Date) This will give the date in a format like 'YYYY-M-D'. Before the JRE update this was possible, now in any case 'YYYY-MM-DD' is required. The behaviour can be reproduced with any Date format 'YYYY-M-D'. Even if the 'YYYY-M-D' format might be wrong in the statement it was working before. Priority in my eyes is low (I will change the SQL) but at least there is some influence of the JRE on the behaviour of the SQL Statement. --------------------------------------------------------------------- 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: [email protected] For additional commands, e-mail: [email protected]
