add a test with create table with IN

rp- · rp- · commit 55d8c9f9d881 · 2014-06-11T22:48:51.000+02:00
diff --git a/src/tests/testsqlobjects.cpp b/src/tests/testsqlobjects.cpp
@@ -208,5 +208,18 @@ void TestTable::parseNonASCIIChars()
     QVERIFY(tab.fields().at(0)->name() == "Fieldöäüß");
 }
 
+void TestTable::createTableWithIn()
+{
+    QString sSQL = "CREATE TABLE not_working("
+            "_id PRIMARY KEY NOT NULL,"
+            "value NVARCHAR(5) CHECK (value IN ('a', 'b', 'c'))"
+            ");";
+
+    Table tab = Table::parseSQL(sSQL);
+    QVERIFY(tab.name() == "not_working");
+
+    QVERIFY(tab.fields().at(1)->check() == "value IN ('a', 'b', 'c')");
+}
+
 QTEST_MAIN(TestTable)
 //#include "testsqlobjects.moc"
diff --git a/src/tests/testsqlobjects.h b/src/tests/testsqlobjects.h
@@ -17,5 +17,6 @@ private slots:
     void parseSQLKeywordInIdentifier();
     void parseSQLWithoutRowid();
     void parseNonASCIIChars();
+    void createTableWithIn();
 };
 
