Skip to content

Commit 9214cfb

Browse files
committed
add a unittest for the keyword in column name issue
1 parent 331455c commit 9214cfb

File tree

2 files changed

+12
-0
lines changed

2 files changed

+12
-0
lines changed

src/tests/testsqlobjects.cpp

Lines changed: 11 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -159,5 +159,16 @@ void TestTable::parseSQLSingleQuotes()
159159
QVERIFY(tab.fields().at(1)->name() == "test");
160160
}
161161

162+
void TestTable::parseSQLKeywordInIdentifier()
163+
{
164+
QString sSQL = "CREATE TABLE deffered(key integer primary key, if text);";
165+
166+
Table tab = Table::parseSQL(sSQL);
167+
168+
QVERIFY(tab.name() == "deffered");
169+
QVERIFY(tab.fields().at(0)->name() == "key");
170+
QVERIFY(tab.fields().at(1)->name() == "if");
171+
}
172+
162173
QTEST_MAIN(TestTable)
163174
//#include "testsqlobjects.moc"

src/tests/testsqlobjects.h

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -13,5 +13,6 @@ private slots:
1313
void parseSQLMultiPk();
1414
void parseSQLForeignKey();
1515
void parseSQLSingleQuotes();
16+
void parseSQLKeywordInIdentifier();
1617
};
1718

0 commit comments

Comments
 (0)