Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-3806

'parameter' is a reserved word in Firebird

XMLWordPrintable

      As summary – we need to deprecate/fix this, although it is not the only issue affecting Firebird

            [JRASERVER-3806] 'parameter' is a reserved word in Firebird

            Dylan Etkin [Atlassian] added a comment -

            This is no longer an issue with JIRA 3.7. We have renamed the offending colums and we have an upgrade task that will fix all the other databases. For Firebird users they will need to do an export and an import when upgrading to JIRA 3.7.

            Dylan Etkin [Atlassian] added a comment - This is no longer an issue with JIRA 3.7. We have renamed the offending colums and we have an upgrade task that will fix all the other databases. For Firebird users they will need to do an export and an import when upgrading to JIRA 3.7.

            Jeff Turner added a comment -

            Carsten,

            That is the result of an internal firebird limit on key sizes. See http://jira.atlassian.com/browse/JRA-5841

            –
            ATLASSIAN - http://www.atlassian.com
            Expert J2EE Software, Services and Support
            -------------------------------------------------------------
            JIRA Docs: http://www.atlassian.com/software/jira/docs/latest

            Jeff Turner added a comment - Carsten, That is the result of an internal firebird limit on key sizes. See http://jira.atlassian.com/browse/JRA-5841 – ATLASSIAN - http://www.atlassian.com Expert J2EE Software, Services and Support ------------------------------------------------------------- JIRA Docs: http://www.atlassian.com/software/jira/docs/latest

            Carsten Schäfer added a comment -

            I want to Install 3.1.1 Standalone with Firebird Database 1.5.2.
            I got the following error:
            CREATE TABLE notification (ID NUMERIC(18,0) NOT NULL, SCHEME NUMERIC(18,0), EVENT VARCHAR(60), TYPE_ VARCHAR(60), PARAMETER VARCHAR(60), CONSTRAINT PK_notification PRIMARY KEY (ID))
            Error was: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
            SQL error code = -104
            Token unknown - line 1, char 115
            PARAMETER

            Carsten Schäfer added a comment - I want to Install 3.1.1 Standalone with Firebird Database 1.5.2. I got the following error: CREATE TABLE notification (ID NUMERIC(18,0) NOT NULL, SCHEME NUMERIC(18,0), EVENT VARCHAR(60), TYPE_ VARCHAR(60), PARAMETER VARCHAR(60), CONSTRAINT PK_notification PRIMARY KEY (ID)) Error was: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 115 PARAMETER

            Owen Fellows added a comment -

            What does this effect?
            Where is the us of the word parameter reserved?

            Owen Fellows added a comment - What does this effect? Where is the us of the word parameter reserved?

              dylan@atlassian.com Dylan Etkin [Atlassian]
              7ee5c68a815f Jeff Turner
              Affected customers:
              0 This affects my team
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: