[SOURCE] Issue #TRQS77 - Incosistent generation errors

[Will Holcomb]

You can view the issue detail at the following URL:
<http://nagoya.apache.org/scarab/servlet/scarab/id/TRQS77>

Type :        Defect
Issue Id :    TRQS77
Reported by: Will Holcomb
             wholcomb - ([EMAIL PROTECTED])

Details:

Summary: Incosistent generation errors
Description: The following will generate sql that works on postgresql:

  <!-- The captures multiple numbers for a single course -->
  <table name="course_number" description="Number for a course">
    <column name="course_id" required="true" type="INTEGER"/>
    <column name="number" required="true" type="INTEGER"/>

    <foreign-key foreignTable="course"
     onDelete="cascade" onUpdate="cascade">
      <reference local="course_id" foreign="id"/>
    </foreign-key>
  </table>

If the order of the columns is switched it leaves a trailing column and the comment 
saying what the foreign key references is left unclosed:

  <table name="course_number" description="Number for a course">
    <column name="number" required="true" type="INTEGER"/>
    <column name="course_id" required="true" type="INTEGER"/>

    <foreign-key foreignTable="course"
     onDelete="cascade" onUpdate="cascade">
      <reference local="course_id" foreign="id"/>
    </foreign-key>
  </table>

Status: New
Database: Postgresql
Operating system: Linux
Priority: Medium


--
To unsubscribe, e-mail:   <mailto:turbine-torque-dev-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:turbine-torque-dev-help@;jakarta.apache.org>