[ 
https://issues.apache.org/jira/browse/TORQUE-110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Thomas Fox closed TORQUE-110.
-----------------------------

    
> unique name not parsed when generating mysql (sql/base/mysql/unique.vm)
> -----------------------------------------------------------------------
>
>                 Key: TORQUE-110
>                 URL: https://issues.apache.org/jira/browse/TORQUE-110
>             Project: Torque
>          Issue Type: Bug
>          Components: Generator
>    Affects Versions: 3.3-RC3
>         Environment: debian etch linux
>            Reporter: Peter Frühberger
>            Assignee: Thomas Fox
>            Priority: Minor
>             Fix For: 4.0-beta1
>
>
> The following snippet of code:
> <unique name="NAME_IDX">
> <unique-column name="NAME"/>    
> </unique>
> Schema:
> <!ELEMENT index (option*,index-column+)>
> <!ATTLIST index
>   name CDATA #IMPLIED
> generates the following mysql code (the name is totally ignored), but the 
> schema allows it.
> Create ...
>         ...
>     UNIQUE (NAME)
> );
> The unique index name (NAME_IDX) is missing, it should correctly be:
> Create ...
>         UNIQUE NAME_IDX (NAME);
> );
> changing the unique.vm in sql/base/mysql/unique.vm from
> #foreach ($unique in $table.Unices) 
> UNIQUE($unique.ColumnList), 
> #end
> to
> #foreach ($unique in $table.Unices) 
> UNIQUE $unique.Name ($unique.ColumnList), 
> #end
> I think we have to change unique.vm to do the following semantics:
> if ("unique name" is specified) {
>  unique $uniq.name ('column')
> }
> else {
> unique ('column')
> }
> We could also set the name whenever creating an sql unique column For 
> example, if you have to maintain two different databases (i.e. oracle and 
> mysql), both generated from the same xml file, you have probably written a 
> tool which compares both databases. Oracle always uses an unique index name 
> (afaik), mysql can do without, but comparisson from your tool failes.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscr...@db.apache.org
For additional commands, e-mail: torque-dev-h...@db.apache.org

Reply via email to