add unittest for foreign key parser problem

rp- · rp- · commit a95d33e5eec0 · 2013-05-03T21:12:56.000+02:00
diff --git a/src/tests/testsqlobjects.cpp b/src/tests/testsqlobjects.cpp
@@ -15,6 +15,7 @@ private slots:
     void parseSQL();
     void parseSQLdefaultexpr();
     void parseSQLMultiPk();
+    void parseSQLForeignKey();
 };
 
 void TestTable::sqlOutput()
@@ -148,5 +149,17 @@ void TestTable::parseSQLMultiPk()
     QVERIFY(tab.primarykey().contains(tab.fields().at(1)));
 }
 
+void TestTable::parseSQLForeignKey()
+{
+    QString sSQL = "CREATE TABLE grammar_test(id, test, FOREIGN KEY(test) REFERENCES other_table);";
+
+    Table tab = Table::parseSQL(sSQL);
+
+    QVERIFY(tab.name() == "grammar_test");
+    QVERIFY(tab.fields().at(0)->name() == "id");
+    QVERIFY(tab.fields().at(1)->name() == "test");
+
+}
+
 QTEST_MAIN(TestTable)
 #include "testsqlobjects.moc"
