db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Casal <emico...@yahoo.com>
Subject [SOURCE] Issue #TRQS159 - Invalid syntaxes for Hypersonic when using indexes.
Date Wed, 21 May 2003 21:12:04 GMT
You can view the issue detail at the following URL:
<http://scarab.werken.com/scarab/issues/id/TRQS159>

Type :        Defect
Issue Id :    TRQS159
Reported by: Paul Casal
             goldrimtang - (emiconde@yahoo.com)

Details:

Summary: Invalid syntaxes for Hypersonic when using indexes.
Description: This bug happens when running the 'sql' target and there is at least one index
defined.

Symptom:
 The last column of the generated CRAETE TABLE statement will have an extra ',' at the end
of the column definition. When this is submited, it generates a syntaxes error.

Example:

    <table name="payment_invoice_map" 
  		description="maps the many-to-many relationship between payments and invoices">
  	<column name="payment_id" required="false" type="INTEGER"/>
  	<column name="invoice_id" required="false" type="INTEGER"/>
  	
    <index name="ix_uq_payment_invoice_map_pa_in">
    	<index-column name="payment_id"/>
    	<index-column name="invoice_id"/>
    </index>
  </table>

By the way, it'd be good to have Hypersonic to the list of databases for reporting bugs.
Status: New
Operating system: Windows
Priority: Undecided


Mime
View raw message