179 |
179 |
180 QVERIFY_SQL( q, exec("create table " + test2 + "(id int, title varchar(20))")); |
180 QVERIFY_SQL( q, exec("create table " + test2 + "(id int, title varchar(20))")); |
181 |
181 |
182 QVERIFY_SQL( q, exec("create table " + test3 + "(id int, random varchar(20), randomtwo varchar(20))")); |
182 QVERIFY_SQL( q, exec("create table " + test3 + "(id int, random varchar(20), randomtwo varchar(20))")); |
183 |
183 |
184 QVERIFY_SQL( q, exec("create table " + qTableName("test4", __FILE__) + "(column1 varchar(50), column2 varchar(50), column3 varchar(50))")); |
184 if(!tst_Databases::isSqlServer(db)) |
|
185 QVERIFY_SQL( q, exec("create table " + qTableName("test4", __FILE__) + "(column1 varchar(50), column2 varchar(50), column3 varchar(50))")); |
|
186 else |
|
187 QVERIFY_SQL( q, exec("create table " + qTableName("test4", __FILE__) + "(column1 varchar(50), column2 varchar(50) NULL, column3 varchar(50))")); |
|
188 |
185 |
189 |
186 QVERIFY_SQL( q, exec("create table " + qTableName("emptytable", __FILE__) + "(id int)")); |
190 QVERIFY_SQL( q, exec("create table " + qTableName("emptytable", __FILE__) + "(id int)")); |
187 |
191 |
188 if (testWhiteSpaceNames(db.driverName())) { |
192 if (testWhiteSpaceNames(db.driverName())) { |
189 QString qry = "create table " + qTableName("qtestw hitespace", db.driver()) + " ("+ db.driver()->escapeIdentifier("a field", QSqlDriver::FieldName) + " int)"; |
193 QString qry = "create table " + qTableName("qtestw hitespace", db.driver()) + " ("+ db.driver()->escapeIdentifier("a field", QSqlDriver::FieldName) + " int)"; |