Hi.

I wrote a patch for improving 'create Index' compatibility.

DB2, Oracle and Derby checks that columns are already indexed when
execute create Index statement.

Oracle checks that columns already indexed and indexing ascending or decending.
DB2 checks only that columns already indexed because DB2 has 'allow
reverse scans' option.

PostgreSQL, MySQL and H2 checks index name already exists only.


-- 
-----------
litailang

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Attachment: createIndex.patch
Description: Binary data

Reply via email to