Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-1833

SQL keyword 'VALUE' used as table's attribute name in test case

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Trivial
    • Resolution: Fixed
    • None
    • None
    • Database integration
    • None
    • Debian 7.0, OpenJDK Runtime Environment (IcedTea6 1.12.5) (6b27-1.12.5-1), Firebird-2.5 super

    Description

      Test case tries to create table CLOB_TEST_RELATION with command
      "CREATE TABLE CLOB_TEST_RELATION (ID INTEGER NOT NULL, ID_CLOB INTEGER NOT NULL, VALUE INTEGER, PRIMARY KEY (ID))"

      Third attribute's name 'VALUE' is SQL language keyword. FirebirdSQL can't create table, where attribute's name is keyword.

      Attachments

        1. keyword_sql_fb.patch
          1 kB
          Miłosz Pigłas

        Activity

          People

            Unassigned Unassigned
            kurhan Miłosz Pigłas
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: