projectwonder/wonder — Issue #88: WONDER-713 Derby plugin creates wrong sql
Author: pascalrobert
Created: 2011-12-27 02:29:13+00:00
State: open

Reported by Greg Brown

When Entity modeler creates sql for an index, the statement is like: create index indname >>> FOR<<<< tablename(col). But Derby says:

CREATE [UNIQUE] INDEX index-Name >>>ON<<< table-Name ( Simple-column-Name [ ASC | DESC ]
[ , Simple-column-Name [ ASC | DESC ]] * )

For vs On, one works one doesn't