ODBC C-tests commit: r38 - trunk/testsuites/t_jbalint

[jbalint]

Modified:
   trunk/testsuites/t_jbalint/catalog.c
   trunk/testsuites/t_jbalint/t_jbalint.h
   trunk/testsuites/t_jbalint/t_jbalint_suite.c
Log:
added test for SQLSpecialColumns() and no available rowid

Modified: trunk/testsuites/t_jbalint/catalog.c
===================================================================
--- trunk/testsuites/t_jbalint/catalog.c	2007-03-07 11:07:18 UTC (rev 37)
+++ trunk/testsuites/t_jbalint/catalog.c	2007-03-07 16:13:59 UTC (rev 38)
@@ -312,6 +312,20 @@
     free_statement(stmt);
 }
 
+/* seems the I_S has no keys for views,
+ * test that we have an empty result (for completeness ;) */
+OT_TEST_METHOD(specialcolumns_view_no_rowid)
+{
+    SQLHANDLE stmt = get_statement();
+
+    CHECK_SQL_S(SQLSpecialColumns(stmt, SQL_BEST_ROWID, NULL, SQL_NTS,
+        NULL, SQL_NTS, "v_simple1", SQL_NTS,
+        SQL_SCOPE_SESSION, SQL_NULLABLE), stmt);
+    CHECK_SQL_RC(SQLFetch(stmt), stmt, SQL_HANDLE_STMT, SQL_NO_DATA);
+
+    free_statement(stmt);
+}
+
 /*
  * Test basic use of SQLPrimaryKeys.
  *

Modified: trunk/testsuites/t_jbalint/t_jbalint.h
===================================================================
--- trunk/testsuites/t_jbalint/t_jbalint.h	2007-03-07 11:07:18 UTC (rev 37)
+++ trunk/testsuites/t_jbalint/t_jbalint.h	2007-03-07 16:13:59 UTC (rev 38)
@@ -30,6 +30,7 @@
 OT_TEST_METHOD(specialcolumns_pk_as_rowid);
 OT_TEST_METHOD(specialcolumns_uidx_as_rowid);
 OT_TEST_METHOD(specialcolumns_multicol_uidx_as_rowid);
+OT_TEST_METHOD(specialcolumns_view_no_rowid);
 OT_TEST_METHOD(primarykeys);
 OT_TEST_METHOD(statistics);
 OT_TEST_METHOD(columns);

Modified: trunk/testsuites/t_jbalint/t_jbalint_suite.c
===================================================================
--- trunk/testsuites/t_jbalint/t_jbalint_suite.c	2007-03-07 11:07:18 UTC (rev 37)
+++ trunk/testsuites/t_jbalint/t_jbalint_suite.c	2007-03-07 16:13:59 UTC (rev 38)
@@ -31,6 +31,7 @@
     OT_SUITE_ADD_TEST(specialcolumns_pk_as_rowid, NULL, NULL);
     OT_SUITE_ADD_TEST(specialcolumns_uidx_as_rowid, NULL, NULL);
     OT_SUITE_ADD_TEST(specialcolumns_multicol_uidx_as_rowid, NULL, NULL);
+    OT_SUITE_ADD_TEST(specialcolumns_view_no_rowid, NULL, NULL);
     OT_SUITE_ADD_TEST(primarykeys, NULL, NULL);
     OT_SUITE_ADD_TEST(statistics, NULL, NULL);
     OT_SUITE_ADD_TEST(columns, NULL, NULL);