Re: [Firebird-devel] Jira

2012-06-28 Thread Alex Peshkoff
On 06/27/12 21:04, marius adrian popa wrote: On Wed, Jun 27, 2012 at 7:35 PM, Leyne, Sean s...@broadviewsoftware.comwrote: Actually, I just opened the TIMESTAMP Keyword case with Atlassian IMHO, you did a little mistake in this ticket - you mentioned Firebird. If you simply had

Re: [Firebird-devel] Jira

2012-06-28 Thread Mark Rotteveel
On 27-6-2012 18:28, Dimitry Sibiryakov wrote: 27.06.2012 17:30, Leyne, Sean wrote: Actually, I just opened the TIMESTAMP Keyword case with Atlassian IMHO, you did a little mistake in this ticket - you mentioned Firebird. If you simply had written what kind of idiot must be DB developer

Re: [Firebird-devel] Jira

2012-06-27 Thread Mark Rotteveel
On Wed, 27 Jun 2012 10:47:14 -0400, Leyne, Sean s...@broadviewsoftware.com wrote: -Original Message- From: Leyne, Sean [mailto:s...@broadviewsoftware.com] Sent: Viernes, 22 de Junio de 2012 17:18 They have a column named TIMESTAMP which is a reserved word in Firebird, and

Re: [Firebird-devel] Jira

2012-06-27 Thread Mark Rotteveel
On Wed, 27 Jun 2012 17:19:34 +0200, Mark Rotteveel m...@lawinegevaar.nl wrote: It would be interesting to see what other JDBC drivers report for the the DatabaseMetaData.getSQLKeywords() method. Jaybird explicitly does not include TIMESTAMP as that should already be a SQL-92 (and/or SQL:2003)

Re: [Firebird-devel] Jira

2012-06-27 Thread Dimitry Sibiryakov
27.06.2012 17:30, Leyne, Sean wrote: Actually, I just opened the TIMESTAMP Keyword case with Atlassian IMHO, you did a little mistake in this ticket - you mentioned Firebird. If you simply had written what kind of idiot must be DB developer to choose reserved word as a field's name, they

Re: [Firebird-devel] Jira

2012-06-27 Thread Leyne, Sean
Actually, I just opened the TIMESTAMP Keyword case with Atlassian IMHO, you did a little mistake in this ticket - you mentioned Firebird. If you simply had written what kind of idiot must be DB developer to choose reserved word as a field's name, they wouldn't have had chance to

Re: [Firebird-devel] Jira

2012-06-27 Thread marius adrian popa
On Wed, Jun 27, 2012 at 7:35 PM, Leyne, Sean s...@broadviewsoftware.comwrote: Actually, I just opened the TIMESTAMP Keyword case with Atlassian IMHO, you did a little mistake in this ticket - you mentioned Firebird. If you simply had written what kind of idiot must be DB developer

Re: [Firebird-devel] Jira - Email found in subject

2012-06-27 Thread Leyne, Sean
Actually, I just opened the TIMESTAMP Keyword case with Atlassian    IMHO, you did a little mistake in this ticket - you mentioned Firebird. If you simply had written what kind of idiot must be DB developer to choose reserved word as a field's name, they wouldn't have had chance to

Re: [Firebird-devel] Jira

2012-06-22 Thread Dmitry Yemanov
22.06.2012 20:04, Philippe Makowski wrote: Error occurred during export before upgrade: Erreur d'exportation de données : org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, VOTES, TIMESTAMP FROM votehistory (GDS Exception.

Re: [Firebird-devel] Jira

2012-06-22 Thread Leyne, Sean
They have a column named TIMESTAMP which is a reserved word in Firebird, and supposedly in many other RDBMS too (and in the SQL standard as well). What the hell they are doing? I have logged a case on the Jira tracker regarding this issue. https://jira.atlassian.com/browse/JRA-28657 Sean