tests: Add test to check escaping quotes by using two of them

MKleusberg · MKleusberg · commit b841025bae8c · 2014-10-15T12:57:37.000+02:00
diff --git a/src/tests/testsqlobjects.cpp b/src/tests/testsqlobjects.cpp
@@ -213,6 +213,17 @@ void TestTable::parseNonASCIIChars()
     QVERIFY(tab.fields().at(0)->name() == "Fieldöäüß");
 }
 
+void TestTable::parseSQLEscapedQuotes()
+{
+    QString sSql = "CREATE TABLE double_quotes(a text default 'a''a');";
+
+    Table tab = Table::parseSQL(sSql).first;
+
+    QCOMPARE(tab.name(), QString("double_quotes"));
+    QCOMPARE(tab.fields().at(0)->name(), QString("a"));
+    QCOMPARE(tab.fields().at(0)->defaultValue(), QString("a''a"));
+}
+
 void TestTable::createTableWithIn()
 {
     QString sSQL = "CREATE TABLE not_working("
diff --git a/src/tests/testsqlobjects.h b/src/tests/testsqlobjects.h
@@ -20,6 +20,7 @@ private slots:
     void parseSQLKeywordInIdentifier();
     void parseSQLWithoutRowid();
     void parseNonASCIIChars();
+    void parseSQLEscapedQuotes();
     void createTableWithIn();
     void createTableWithNotLikeConstraint();
 };
