[OS-JIRA] Created: (CAY-358) ant test fails under MySQL

From: jira-norepl..bjectstyle.org
Date: Mon Aug 29 2005 - 16:06:35 EDT

  • Next message: Andrus Adamchik: "Re: Why don't we use version-based optimistic locking?"

    Message:

      A new issue has been created in JIRA.

    ---------------------------------------------------------------------
    View the issue:

      http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-358

    Here is an overview of the issue:
    ---------------------------------------------------------------------
            Key: CAY-358
        Summary: ant test fails under MySQL
           Type: Bug

         Status: Assigned
       Priority: Major

        Project: Cayenne
     Components:
                 Cayenne Core Library
       Versions:
                 1.2 [DEV]

       Assignee: Andrus Adamchik
       Reporter: Gili Tzabari

        Created: Mon, 29 Aug 2005 4:05 PM
        Updated: Mon, 29 Aug 2005 4:05 PM
    Environment: MySQL 4.1.12-nt

    Description:
    CREATE TABLE GENERATED_COLUMN_COMP_KEY (AUTO_PK INT NOT NULL, GENERATED_COLUMN INT NOT NULL AUTO_INCREMENT, NAME VARCHAR(100) NULL, PROPAGATED_PK INT NOT NULL, PRIMARY KEY (AUTO_PK, GENERATED_COLUMN, PROPAGATED_PK))

    if InnoDB are the default DB type, this SQL statement will fail with:

    ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key

    ---------------------------------------------------------------------
    JIRA INFORMATION:
    This message is automatically generated by JIRA.

    If you think it was sent incorrectly contact one of the administrators:
       http://objectstyle.org/jira/secure/Administrators.jspa

    If you want more information on JIRA, or have a bug to report see:
       http://www.atlassian.com/software/jira



    This archive was generated by hypermail 2.0.0 : Mon Aug 29 2005 - 16:06:36 EDT