package net.sourceforge.mayfly.acceptance;

public class IndexTest extends SqlTestCase {
    
    public void testMysqlSyntax() throws Exception {
        String sql = "create table foo(a integer, index(a))";
        if (dialect.createTableCanContainIndex()) {
            execute(sql);
            execute("create table bar(b integer, index named_index(b))");
        }
        else {
            expectExecuteFailure(sql, "expected data type but got '('");
        }
    }
    
    // TODO: Also consider Hypersonic/Derby syntax: CREATE INDEX, etc

}

@@ -469,24 +469,136 @@
 %0A    %7D%0A    %0A
+    /* TODO: Might want to insist that the index be on a NOT NULL%0A       column the way that MySQL 5.1 does */%0A%0A
     // TODO:
@@ -655,11 +655,15 @@
 EX, etc%0A
+    
 %0A%7D%0A

Add TODO comment for one more case we might test.