ignite-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From voze...@apache.org
Subject ignite git commit: IGNITE-6468: ODBC: More tests for SQLGetInfo. This closes #2733.
Date Wed, 27 Sep 2017 06:44:16 GMT
Repository: ignite
Updated Branches:
  refs/heads/master 641dd6707 -> cccf11327


IGNITE-6468: ODBC: More tests for SQLGetInfo. This closes #2733.


Project: http://git-wip-us.apache.org/repos/asf/ignite/repo
Commit: http://git-wip-us.apache.org/repos/asf/ignite/commit/cccf1132
Tree: http://git-wip-us.apache.org/repos/asf/ignite/tree/cccf1132
Diff: http://git-wip-us.apache.org/repos/asf/ignite/diff/cccf1132

Branch: refs/heads/master
Commit: cccf1132731382244736673dc490039d84624eed
Parents: 641dd67
Author: Igor Sapego <igorsapg@gmail.com>
Authored: Wed Sep 27 09:43:58 2017 +0300
Committer: devozerov <vozerov@gridgain.com>
Committed: Wed Sep 27 09:43:58 2017 +0300

----------------------------------------------------------------------
 modules/platforms/cpp/odbc-test/Makefile.am     |   1 +
 .../cpp/odbc-test/include/test_utils.h          |   7 +
 .../cpp/odbc-test/project/vs/odbc-test.vcxproj  |   1 +
 .../project/vs/odbc-test.vcxproj.filters        |   5 +-
 .../cpp/odbc-test/src/sql_get_info_test.cpp     | 485 +++++++++++++++++++
 .../include/ignite/odbc/config/configuration.h  |   4 +-
 .../cpp/odbc/src/config/connection_info.cpp     |   6 +-
 7 files changed, 503 insertions(+), 6 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/ignite/blob/cccf1132/modules/platforms/cpp/odbc-test/Makefile.am
----------------------------------------------------------------------
diff --git a/modules/platforms/cpp/odbc-test/Makefile.am b/modules/platforms/cpp/odbc-test/Makefile.am
index 5c335cf..7cccf4c 100644
--- a/modules/platforms/cpp/odbc-test/Makefile.am
+++ b/modules/platforms/cpp/odbc-test/Makefile.am
@@ -77,6 +77,7 @@ ignite_odbc_tests_SOURCES = \
     src/sql_types_test.cpp \
     src/sql_date_time_functions_test.cpp \
     src/sql_outer_join_test.cpp \
+    src/sql_get_info_test.cpp \
     src/api_robustness_test.cpp \
     src/attributes_test.cpp \
     src/errors_test.cpp \

http://git-wip-us.apache.org/repos/asf/ignite/blob/cccf1132/modules/platforms/cpp/odbc-test/include/test_utils.h
----------------------------------------------------------------------
diff --git a/modules/platforms/cpp/odbc-test/include/test_utils.h b/modules/platforms/cpp/odbc-test/include/test_utils.h
index 5dc6d6e..e65e187 100644
--- a/modules/platforms/cpp/odbc-test/include/test_utils.h
+++ b/modules/platforms/cpp/odbc-test/include/test_utils.h
@@ -36,6 +36,13 @@
         BOOST_FAIL(ignite_test::GetOdbcErrorMessage(type, handle)); \
     }
 
+#define ODBC_FAIL_ON_ERROR1(ret, type, handle, msg)                                    \
+    if (!SQL_SUCCEEDED(ret))                                                           \
+    {                                                                                  \
+        Ignition::StopAll(true);                                                       \
+        BOOST_FAIL(ignite_test::GetOdbcErrorMessage(type, handle) + ", msg = " + msg); \
+    }
+
 
 namespace ignite_test
 {

http://git-wip-us.apache.org/repos/asf/ignite/blob/cccf1132/modules/platforms/cpp/odbc-test/project/vs/odbc-test.vcxproj
----------------------------------------------------------------------
diff --git a/modules/platforms/cpp/odbc-test/project/vs/odbc-test.vcxproj b/modules/platforms/cpp/odbc-test/project/vs/odbc-test.vcxproj
index 6ee999e..e11a3ba 100644
--- a/modules/platforms/cpp/odbc-test/project/vs/odbc-test.vcxproj
+++ b/modules/platforms/cpp/odbc-test/project/vs/odbc-test.vcxproj
@@ -175,6 +175,7 @@
     <ClCompile Include="..\..\src\parser_test.cpp" />
     <ClCompile Include="..\..\src\row_test.cpp" />
     <ClCompile Include="..\..\src\sql_aggregate_functions_test.cpp" />
+    <ClCompile Include="..\..\src\sql_get_info_test.cpp" />
     <ClCompile Include="..\..\src\sql_outer_join_test.cpp" />
     <ClCompile Include="..\..\src\sql_date_time_functions_test.cpp" />
     <ClCompile Include="..\..\src\sql_test_suite_fixture.cpp" />

http://git-wip-us.apache.org/repos/asf/ignite/blob/cccf1132/modules/platforms/cpp/odbc-test/project/vs/odbc-test.vcxproj.filters
----------------------------------------------------------------------
diff --git a/modules/platforms/cpp/odbc-test/project/vs/odbc-test.vcxproj.filters b/modules/platforms/cpp/odbc-test/project/vs/odbc-test.vcxproj.filters
index abfe303..ebdf7d3 100644
--- a/modules/platforms/cpp/odbc-test/project/vs/odbc-test.vcxproj.filters
+++ b/modules/platforms/cpp/odbc-test/project/vs/odbc-test.vcxproj.filters
@@ -130,6 +130,9 @@
     <ClCompile Include="..\..\src\errors_test.cpp">
       <Filter>Code</Filter>
     </ClCompile>
+    <ClCompile Include="..\..\src\sql_get_info_test.cpp">
+      <Filter>Code</Filter>
+    </ClCompile>
   </ItemGroup>
   <ItemGroup>
     <ClInclude Include="..\..\include\test_type.h">
@@ -168,4 +171,4 @@
       <Filter>Configs</Filter>
     </None>
   </ItemGroup>
-</Project>
\ No newline at end of file
+</Project>

http://git-wip-us.apache.org/repos/asf/ignite/blob/cccf1132/modules/platforms/cpp/odbc-test/src/sql_get_info_test.cpp
----------------------------------------------------------------------
diff --git a/modules/platforms/cpp/odbc-test/src/sql_get_info_test.cpp b/modules/platforms/cpp/odbc-test/src/sql_get_info_test.cpp
new file mode 100644
index 0000000..e628fb6
--- /dev/null
+++ b/modules/platforms/cpp/odbc-test/src/sql_get_info_test.cpp
@@ -0,0 +1,485 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+#ifdef _WIN32
+#   include <windows.h>
+#endif
+
+#include <sql.h>
+#include <sqlext.h>
+
+#include <vector>
+#include <string>
+
+#ifndef _MSC_VER
+#   define BOOST_TEST_DYN_LINK
+#endif
+
+#include <boost/test/unit_test.hpp>
+
+#include "ignite/ignition.h"
+#include "ignite/impl/binary/binary_utils.h"
+#include "ignite/odbc/config/connection_info.h"
+
+#include "test_type.h"
+#include "test_utils.h"
+
+using namespace ignite;
+using namespace ignite_test;
+
+using namespace boost::unit_test;
+
+using ignite::impl::binary::BinaryUtils;
+
+/**
+ * Test setup fixture.
+ */
+struct SqlGetInfoTestSuiteFixture
+{
+    /**
+     * Establish connection to node.
+     *
+     * @param connectStr Connection string.
+     */
+    void Connect(const std::string& connectStr)
+    {
+        // Allocate an environment handle
+        SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env);
+
+        BOOST_REQUIRE(env != NULL);
+
+        // We want ODBC 3 support
+        SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION, reinterpret_cast<void*>(SQL_OV_ODBC3),
0);
+
+        // Allocate a connection handle
+        SQLAllocHandle(SQL_HANDLE_DBC, env, &dbc);
+
+        BOOST_REQUIRE(dbc != NULL);
+
+        // Connect string
+        std::vector<SQLCHAR> connectStr0;
+
+        connectStr0.reserve(connectStr.size() + 1);
+        std::copy(connectStr.begin(), connectStr.end(), std::back_inserter(connectStr0));
+
+        SQLCHAR outstr[ODBC_BUFFER_SIZE];
+        SQLSMALLINT outstrlen;
+
+        // Connecting to ODBC server.
+        SQLRETURN ret = SQLDriverConnect(dbc, NULL, &connectStr0[0], static_cast<SQLSMALLINT>(connectStr0.size()),
+            outstr, sizeof(outstr), &outstrlen, SQL_DRIVER_COMPLETE);
+
+        ODBC_FAIL_ON_ERROR(ret, SQL_HANDLE_DBC, dbc);
+
+        // Allocate a statement handle
+        SQLAllocHandle(SQL_HANDLE_STMT, dbc, &stmt);
+
+        BOOST_REQUIRE(stmt != NULL);
+    }
+
+    void Disconnect()
+    {
+        // Releasing statement handle.
+        SQLFreeHandle(SQL_HANDLE_STMT, stmt);
+
+        // Disconneting from the server.
+        SQLDisconnect(dbc);
+
+        // Releasing allocated handles.
+        SQLFreeHandle(SQL_HANDLE_DBC, dbc);
+        SQLFreeHandle(SQL_HANDLE_ENV, env);
+    }
+
+    void CheckStrInfo(SQLSMALLINT type, const std::string& expectedValue)
+    {
+        SQLCHAR val[ODBC_BUFFER_SIZE];
+        SQLSMALLINT valLen = 0;
+
+        SQLRETURN ret = SQLGetInfo(dbc, type, &val, sizeof(val), &valLen);
+
+        std::string typeStr = odbc::config::ConnectionInfo::InfoTypeToString(type);
+        ODBC_FAIL_ON_ERROR1(ret, SQL_HANDLE_DBC, dbc, typeStr);
+        BOOST_CHECK_EQUAL(std::string(reinterpret_cast<const char*>(val), valLen),
expectedValue);
+    }
+
+    void CheckIntInfo(SQLSMALLINT type, SQLUINTEGER expectedValue)
+    {
+        SQLUINTEGER val;
+        SQLRETURN ret = SQLGetInfo(dbc, type, &val, 0, 0);
+
+        std::string typeStr = odbc::config::ConnectionInfo::InfoTypeToString(type);
+        ODBC_FAIL_ON_ERROR1(ret, SQL_HANDLE_DBC, dbc, typeStr);
+        BOOST_CHECK_EQUAL(val, expectedValue);
+    }
+
+    void CheckShortInfo(SQLSMALLINT type, SQLUSMALLINT expectedValue)
+    {
+        SQLUSMALLINT val;
+        SQLRETURN ret = SQLGetInfo(dbc, type, &val, 0, 0);
+
+        std::string typeStr = odbc::config::ConnectionInfo::InfoTypeToString(type);
+        ODBC_FAIL_ON_ERROR1(ret, SQL_HANDLE_DBC, dbc, typeStr);
+        BOOST_CHECK_EQUAL(val, expectedValue);
+    }
+
+    /**
+     * Constructor.
+     */
+    SqlGetInfoTestSuiteFixture() :
+        env(NULL),
+        dbc(NULL),
+        stmt(NULL)
+    {
+#ifdef IGNITE_TESTS_32
+        const char* config = "queries-test-32.xml";
+#else
+        const char* config = "queries-test.xml";
+#endif
+
+        grid = StartNode(config, "NodeMain");
+    }
+
+    /**
+     * Destructor.
+     */
+    ~SqlGetInfoTestSuiteFixture()
+    {
+        Disconnect();
+
+        Ignition::StopAll(true);
+    }
+
+    /** Node started during the test. */
+    Ignite grid;
+
+    /** ODBC Environment. */
+    SQLHENV env;
+
+    /** ODBC Connect. */
+    SQLHDBC dbc;
+
+    /** ODBC Statement. */
+    SQLHSTMT stmt;
+};
+
+BOOST_FIXTURE_TEST_SUITE(SqlGetInfoTestSuite, SqlGetInfoTestSuiteFixture)
+
+BOOST_AUTO_TEST_CASE(TestValues)
+{
+    Connect("DRIVER={Apache Ignite};address=127.0.0.1:11110;schema=cache");
+
+    CheckStrInfo(SQL_DRIVER_NAME, "Apache Ignite");
+    CheckStrInfo(SQL_DBMS_NAME, "Apache Ignite");
+    CheckStrInfo(SQL_DRIVER_ODBC_VER, "03.00");
+    CheckStrInfo(SQL_DRIVER_VER, "02.03.0000");
+    CheckStrInfo(SQL_DBMS_VER, "02.03.0000");
+    CheckStrInfo(SQL_COLUMN_ALIAS, "Y");
+    CheckStrInfo(SQL_IDENTIFIER_QUOTE_CHAR, "");
+    CheckStrInfo(SQL_CATALOG_NAME_SEPARATOR, ".");
+    CheckStrInfo(SQL_SPECIAL_CHARACTERS, "");
+    CheckStrInfo(SQL_CATALOG_TERM, "");
+    CheckStrInfo(SQL_QUALIFIER_TERM, "");
+    CheckStrInfo(SQL_TABLE_TERM, "table");
+    CheckStrInfo(SQL_SCHEMA_TERM, "schema");
+    CheckStrInfo(SQL_NEED_LONG_DATA_LEN, "Y");
+    CheckStrInfo(SQL_ACCESSIBLE_PROCEDURES, "Y");
+    CheckStrInfo(SQL_ACCESSIBLE_TABLES, "Y");
+    CheckStrInfo(SQL_CATALOG_NAME, "N");
+    CheckStrInfo(SQL_COLLATION_SEQ, "UTF-8");
+    CheckStrInfo(SQL_DATA_SOURCE_NAME, "");
+    CheckStrInfo(SQL_DATA_SOURCE_READ_ONLY, "N");
+    CheckStrInfo(SQL_DATABASE_NAME, "");
+    CheckStrInfo(SQL_DESCRIBE_PARAMETER, "N");
+    CheckStrInfo(SQL_EXPRESSIONS_IN_ORDERBY, "Y");
+    CheckStrInfo(SQL_INTEGRITY, "N");
+    CheckStrInfo(SQL_KEYWORDS, "LIMIT,MINUS,OFFSET,ROWNUM,SYSDATE,SYSTIME,SYSTIMESTAMP,TODAY");
+    CheckStrInfo(SQL_LIKE_ESCAPE_CLAUSE, "N");
+    CheckStrInfo(SQL_MAX_ROW_SIZE_INCLUDES_LONG, "Y");
+    CheckStrInfo(SQL_MULT_RESULT_SETS, "N");
+    CheckStrInfo(SQL_MULTIPLE_ACTIVE_TXN, "N");
+    CheckStrInfo(SQL_ORDER_BY_COLUMNS_IN_SELECT, "N");
+    CheckStrInfo(SQL_PROCEDURE_TERM, "stored procedure");
+    CheckStrInfo(SQL_PROCEDURES, "N");
+    CheckStrInfo(SQL_ROW_UPDATES, "N");
+    CheckStrInfo(SQL_SEARCH_PATTERN_ESCAPE, "\\");
+    CheckStrInfo(SQL_SERVER_NAME, "Apache Ignite");
+    CheckStrInfo(SQL_USER_NAME, "apache_ignite_user");
+
+    CheckIntInfo(SQL_ASYNC_MODE, SQL_AM_NONE);
+    CheckIntInfo(SQL_BATCH_ROW_COUNT, SQL_BRC_ROLLED_UP | SQL_BRC_EXPLICIT);
+    CheckIntInfo(SQL_BATCH_SUPPORT, SQL_BS_ROW_COUNT_EXPLICIT);
+    CheckIntInfo(SQL_BOOKMARK_PERSISTENCE, 0);
+    CheckIntInfo(SQL_CATALOG_LOCATION, 0);
+    CheckIntInfo(SQL_QUALIFIER_LOCATION, 0);
+    CheckIntInfo(SQL_GETDATA_EXTENSIONS, SQL_GD_ANY_COLUMN | SQL_GD_ANY_ORDER | SQL_GD_BOUND);
+    CheckIntInfo(SQL_ODBC_INTERFACE_CONFORMANCE, SQL_OIC_CORE);
+    CheckIntInfo(SQL_SQL_CONFORMANCE, SQL_SC_SQL92_ENTRY);
+    CheckIntInfo(SQL_CATALOG_USAGE, 0);
+    CheckIntInfo(SQL_QUALIFIER_USAGE, 0);
+    CheckIntInfo(SQL_TIMEDATE_ADD_INTERVALS, 0);
+    CheckIntInfo(SQL_TIMEDATE_DIFF_INTERVALS, 0);
+    CheckIntInfo(SQL_DATETIME_LITERALS, SQL_DL_SQL92_DATE | SQL_DL_SQL92_TIME | SQL_DL_SQL92_TIMESTAMP);
+    CheckIntInfo(SQL_SYSTEM_FUNCTIONS, SQL_FN_SYS_USERNAME | SQL_FN_SYS_DBNAME | SQL_FN_SYS_IFNULL);
+    CheckIntInfo(SQL_CONVERT_FUNCTIONS, SQL_FN_CVT_CONVERT | SQL_FN_CVT_CAST);
+    CheckIntInfo(SQL_OJ_CAPABILITIES, SQL_OJ_LEFT | SQL_OJ_NOT_ORDERED | SQL_OJ_ALL_COMPARISON_OPS);
+    CheckIntInfo(SQL_POS_OPERATIONS, 0);
+    CheckIntInfo(SQL_SQL92_DATETIME_FUNCTIONS, SQL_SDF_CURRENT_DATE | SQL_SDF_CURRENT_TIMESTAMP);
+    CheckIntInfo(SQL_SQL92_VALUE_EXPRESSIONS, SQL_SVE_CASE | SQL_SVE_CAST | SQL_SVE_COALESCE
| SQL_SVE_NULLIF);
+    CheckIntInfo(SQL_STATIC_CURSOR_ATTRIBUTES1, SQL_CA1_NEXT);
+    CheckIntInfo(SQL_STATIC_CURSOR_ATTRIBUTES2, 0);
+    CheckIntInfo(SQL_PARAM_ARRAY_ROW_COUNTS, SQL_PARC_NO_BATCH);
+    CheckIntInfo(SQL_PARAM_ARRAY_SELECTS, SQL_PAS_NO_SELECT);
+    CheckIntInfo(SQL_SCROLL_OPTIONS, SQL_SO_FORWARD_ONLY | SQL_SO_STATIC);
+    CheckIntInfo(SQL_ALTER_DOMAIN, 0);
+    CheckIntInfo(SQL_ALTER_TABLE, SQL_AT_ADD_COLUMN_SINGLE);
+    CheckIntInfo(SQL_CREATE_ASSERTION, 0);
+    CheckIntInfo(SQL_CREATE_CHARACTER_SET, 0);
+    CheckIntInfo(SQL_CREATE_COLLATION, 0);
+    CheckIntInfo(SQL_CREATE_DOMAIN, 0);
+    CheckIntInfo(SQL_CREATE_SCHEMA, 0);
+    CheckIntInfo(SQL_CREATE_TABLE, SQL_CT_CREATE_TABLE | SQL_CT_COLUMN_CONSTRAINT);
+    CheckIntInfo(SQL_CREATE_TRANSLATION, 0);
+    CheckIntInfo(SQL_CREATE_VIEW, 0);
+    CheckIntInfo(SQL_CURSOR_SENSITIVITY, SQL_INSENSITIVE);
+    CheckIntInfo(SQL_DDL_INDEX, SQL_DI_CREATE_INDEX | SQL_DI_DROP_INDEX);
+    CheckIntInfo(SQL_DEFAULT_TXN_ISOLATION, 0);
+    CheckIntInfo(SQL_DROP_ASSERTION, 0);
+    CheckIntInfo(SQL_DROP_CHARACTER_SET, 0);
+    CheckIntInfo(SQL_DROP_COLLATION, 0);
+    CheckIntInfo(SQL_DROP_DOMAIN, 0);
+    CheckIntInfo(SQL_DROP_SCHEMA, 0);
+    CheckIntInfo(SQL_DROP_TABLE, SQL_DT_DROP_TABLE);
+    CheckIntInfo(SQL_DROP_TRANSLATION, 0);
+    CheckIntInfo(SQL_DROP_VIEW, 0);
+    CheckIntInfo(SQL_DYNAMIC_CURSOR_ATTRIBUTES1, SQL_CA1_NEXT);
+    CheckIntInfo(SQL_DYNAMIC_CURSOR_ATTRIBUTES2, SQL_CA2_READ_ONLY_CONCURRENCY);
+    CheckIntInfo(SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1, SQL_CA1_NEXT);
+    CheckIntInfo(SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2, SQL_CA2_READ_ONLY_CONCURRENCY);
+    CheckIntInfo(SQL_INDEX_KEYWORDS, SQL_IK_ALL);
+    CheckIntInfo(SQL_INFO_SCHEMA_VIEWS, 0);
+    CheckIntInfo(SQL_INSERT_STATEMENT, SQL_IS_INSERT_LITERALS | SQL_IS_INSERT_SEARCHED);
+    CheckIntInfo(SQL_KEYSET_CURSOR_ATTRIBUTES1, SQL_CA1_NEXT);
+    CheckIntInfo(SQL_KEYSET_CURSOR_ATTRIBUTES2, 0);
+    CheckIntInfo(SQL_MAX_ASYNC_CONCURRENT_STATEMENTS, 0);
+    CheckIntInfo(SQL_MAX_BINARY_LITERAL_LEN, 0);
+    CheckIntInfo(SQL_MAX_CATALOG_NAME_LEN, 0);
+    CheckIntInfo(SQL_MAX_CHAR_LITERAL_LEN, 0);
+    CheckIntInfo(SQL_MAX_INDEX_SIZE, 0);
+    CheckIntInfo(SQL_MAX_ROW_SIZE, 0);
+    CheckIntInfo(SQL_MAX_STATEMENT_LEN, 0);
+    CheckIntInfo(SQL_SQL92_FOREIGN_KEY_DELETE_RULE, 0);
+    CheckIntInfo(SQL_SQL92_FOREIGN_KEY_UPDATE_RULE, 0);
+    CheckIntInfo(SQL_SQL92_GRANT, 0);
+    CheckIntInfo(SQL_SQL92_REVOKE, 0);
+    CheckIntInfo(SQL_STANDARD_CLI_CONFORMANCE, 0);
+    CheckIntInfo(SQL_TXN_ISOLATION_OPTION, 0);
+    CheckIntInfo(SQL_UNION, SQL_U_UNION | SQL_U_UNION_ALL);
+
+    CheckIntInfo(SQL_SCHEMA_USAGE, SQL_SU_DML_STATEMENTS | SQL_SU_TABLE_DEFINITION | SQL_SU_PRIVILEGE_DEFINITION
|
+        SQL_SU_INDEX_DEFINITION);
+
+    CheckIntInfo(SQL_AGGREGATE_FUNCTIONS, SQL_AF_AVG | SQL_AF_COUNT | SQL_AF_MAX | SQL_AF_MIN
| SQL_AF_SUM |
+        SQL_AF_DISTINCT);
+
+    CheckIntInfo(SQL_NUMERIC_FUNCTIONS, SQL_FN_NUM_ABS | SQL_FN_NUM_ACOS | SQL_FN_NUM_ASIN
| SQL_FN_NUM_EXP |
+        SQL_FN_NUM_ATAN | SQL_FN_NUM_ATAN2 | SQL_FN_NUM_CEILING | SQL_FN_NUM_COS | SQL_FN_NUM_TRUNCATE
|
+        SQL_FN_NUM_FLOOR | SQL_FN_NUM_DEGREES | SQL_FN_NUM_POWER | SQL_FN_NUM_RADIANS | SQL_FN_NUM_SIGN
|
+        SQL_FN_NUM_SIN | SQL_FN_NUM_LOG | SQL_FN_NUM_TAN | SQL_FN_NUM_PI | SQL_FN_NUM_MOD
| SQL_FN_NUM_COT |
+        SQL_FN_NUM_LOG10 | SQL_FN_NUM_ROUND | SQL_FN_NUM_SQRT | SQL_FN_NUM_RAND);
+
+    CheckIntInfo(SQL_STRING_FUNCTIONS, SQL_FN_STR_ASCII | SQL_FN_STR_BIT_LENGTH | SQL_FN_STR_CHAR_LENGTH
|
+        SQL_FN_STR_CHAR | SQL_FN_STR_CONCAT | SQL_FN_STR_DIFFERENCE | SQL_FN_STR_INSERT |
SQL_FN_STR_LEFT |
+        SQL_FN_STR_LENGTH | SQL_FN_STR_CHARACTER_LENGTH | SQL_FN_STR_LTRIM | SQL_FN_STR_OCTET_LENGTH
|
+        SQL_FN_STR_POSITION | SQL_FN_STR_REPEAT | SQL_FN_STR_REPLACE | SQL_FN_STR_RIGHT |
SQL_FN_STR_RTRIM |
+        SQL_FN_STR_SOUNDEX | SQL_FN_STR_SPACE | SQL_FN_STR_SUBSTRING | SQL_FN_STR_LCASE |
SQL_FN_STR_UCASE |
+        SQL_FN_STR_LOCATE_2 | SQL_FN_STR_LOCATE);
+
+    CheckIntInfo(SQL_TIMEDATE_FUNCTIONS, SQL_FN_TD_CURRENT_DATE | SQL_FN_TD_CURRENT_TIME
| SQL_FN_TD_WEEK |
+        SQL_FN_TD_QUARTER | SQL_FN_TD_SECOND | SQL_FN_TD_CURDATE | SQL_FN_TD_CURTIME | SQL_FN_TD_DAYNAME
|
+        SQL_FN_TD_MINUTE | SQL_FN_TD_DAYOFWEEK | SQL_FN_TD_DAYOFYEAR | SQL_FN_TD_EXTRACT
| SQL_FN_TD_HOUR |
+        SQL_FN_TD_DAYOFMONTH | SQL_FN_TD_MONTH | SQL_FN_TD_MONTHNAME | SQL_FN_TD_NOW | SQL_FN_TD_YEAR
|
+        SQL_FN_TD_CURRENT_TIMESTAMP);
+
+    CheckIntInfo(SQL_SQL92_NUMERIC_VALUE_FUNCTIONS, SQL_SNVF_BIT_LENGTH | SQL_SNVF_CHARACTER_LENGTH
| SQL_SNVF_EXTRACT |
+        SQL_SNVF_OCTET_LENGTH | SQL_SNVF_POSITION);
+
+    CheckIntInfo(SQL_SQL92_STRING_FUNCTIONS, SQL_SSF_LOWER | SQL_SSF_UPPER | SQL_SSF_TRIM_TRAILING
| SQL_SSF_SUBSTRING |
+        SQL_SSF_TRIM_BOTH | SQL_SSF_TRIM_LEADING);
+
+    CheckIntInfo(SQL_SQL92_PREDICATES, SQL_SP_BETWEEN | SQL_SP_COMPARISON | SQL_SP_EXISTS
| SQL_SP_IN |
+        SQL_SP_ISNOTNULL | SQL_SP_ISNULL | SQL_SP_LIKE | SQL_SP_MATCH_FULL | SQL_SP_MATCH_PARTIAL
|
+        SQL_SP_MATCH_UNIQUE_FULL | SQL_SP_MATCH_UNIQUE_PARTIAL | SQL_SP_OVERLAPS | SQL_SP_UNIQUE
|
+        SQL_SP_QUANTIFIED_COMPARISON);
+
+    CheckIntInfo(SQL_SQL92_RELATIONAL_JOIN_OPERATORS, SQL_SRJO_CORRESPONDING_CLAUSE | SQL_SRJO_CROSS_JOIN
|
+        SQL_SRJO_EXCEPT_JOIN | SQL_SRJO_INNER_JOIN | SQL_SRJO_LEFT_OUTER_JOIN | SQL_SRJO_RIGHT_OUTER_JOIN
|
+        SQL_SRJO_NATURAL_JOIN | SQL_SRJO_INTERSECT_JOIN | SQL_SRJO_UNION_JOIN);
+
+    CheckIntInfo(SQL_CONVERT_BIGINT, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR
| SQL_CVT_WCHAR |
+        SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_TIMESTAMP | SQL_CVT_TINYINT
|
+        SQL_CVT_SMALLINT | SQL_CVT_INTEGER | SQL_CVT_BIGINT | SQL_CVT_BIT);
+
+    CheckIntInfo(SQL_CONVERT_BINARY, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR
| SQL_CVT_BIT |
+        SQL_CVT_WCHAR | SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_LONGVARBINARY
|
+        SQL_CVT_FLOAT | SQL_CVT_SMALLINT | SQL_CVT_INTEGER | SQL_CVT_BIGINT | SQL_CVT_REAL
| SQL_CVT_DATE |
+        SQL_CVT_TINYINT | SQL_CVT_DOUBLE | SQL_CVT_BINARY | SQL_CVT_DECIMAL | SQL_CVT_TIME
| SQL_CVT_GUID |
+        SQL_CVT_TIMESTAMP | SQL_CVT_VARBINARY);
+
+    CheckIntInfo(SQL_CONVERT_BIT, SQL_CVT_BIGINT | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR
| SQL_CVT_WVARCHAR |
+        SQL_CVT_NUMERIC | SQL_CVT_BIT | SQL_CVT_CHAR | SQL_CVT_SMALLINT | SQL_CVT_INTEGER
| SQL_CVT_TINYINT);
+
+    CheckIntInfo(SQL_CONVERT_CHAR, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR |
SQL_CVT_VARBINARY |
+        SQL_CVT_WCHAR | SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_DECIMAL
|
+        SQL_CVT_BIT | SQL_CVT_TINYINT | SQL_CVT_SMALLINT | SQL_CVT_INTEGER | SQL_CVT_BIGINT
| SQL_CVT_REAL |
+        SQL_CVT_FLOAT | SQL_CVT_DOUBLE | SQL_CVT_BINARY | SQL_CVT_TIMESTAMP | SQL_CVT_DATE
| SQL_CVT_TIME |
+        SQL_CVT_LONGVARBINARY | SQL_CVT_GUID);
+
+    CheckIntInfo(SQL_CONVERT_VARCHAR, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR
| SQL_CVT_WCHAR |
+        SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_DECIMAL | SQL_CVT_TINYINT
|
+        SQL_CVT_SMALLINT | SQL_CVT_INTEGER | SQL_CVT_BIGINT | SQL_CVT_REAL | SQL_CVT_FLOAT
| SQL_CVT_BIT |
+        SQL_CVT_DOUBLE | SQL_CVT_BINARY | SQL_CVT_VARBINARY | SQL_CVT_GUID | SQL_CVT_DATE
| SQL_CVT_TIME |
+        SQL_CVT_LONGVARBINARY | SQL_CVT_TIMESTAMP);
+
+    CheckIntInfo(SQL_CONVERT_LONGVARCHAR, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_DATE |
SQL_CVT_TIME |
+        SQL_CVT_LONGVARCHAR | SQL_CVT_WCHAR | SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC
|
+        SQL_CVT_DECIMAL | SQL_CVT_BIT | SQL_CVT_REAL | SQL_CVT_SMALLINT | SQL_CVT_INTEGER
| SQL_CVT_GUID |
+        SQL_CVT_BIGINT | SQL_CVT_LONGVARBINARY | SQL_CVT_DOUBLE | SQL_CVT_BINARY | SQL_CVT_VARBINARY
|
+        SQL_CVT_TINYINT | SQL_CVT_FLOAT | SQL_CVT_TIMESTAMP);
+
+    CheckIntInfo(SQL_CONVERT_WCHAR, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR
| SQL_CVT_WCHAR |
+        SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_DECIMAL | SQL_CVT_VARBINARY
|
+        SQL_CVT_BIT | SQL_CVT_TINYINT | SQL_CVT_SMALLINT | SQL_CVT_INTEGER | SQL_CVT_BIGINT
| SQL_CVT_REAL |
+        SQL_CVT_FLOAT | SQL_CVT_DOUBLE | SQL_CVT_BINARY | SQL_CVT_LONGVARBINARY | SQL_CVT_TIMESTAMP
|
+        SQL_CVT_DATE | SQL_CVT_TIME | SQL_CVT_GUID);
+
+    CheckIntInfo(SQL_CONVERT_WVARCHAR, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR
| SQL_CVT_REAL |
+        SQL_CVT_WCHAR | SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_LONGVARBINARY
|
+        SQL_CVT_DECIMAL | SQL_CVT_BIT | SQL_CVT_TINYINT | SQL_CVT_SMALLINT | SQL_CVT_DATE
| SQL_CVT_TIME |
+        SQL_CVT_INTEGER | SQL_CVT_BIGINT | SQL_CVT_FLOAT | SQL_CVT_DOUBLE | SQL_CVT_BINARY
| SQL_CVT_GUID |
+        SQL_CVT_VARBINARY | SQL_CVT_TIMESTAMP);
+
+    CheckIntInfo(SQL_CONVERT_WLONGVARCHAR, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_BIGINT
| SQL_CVT_REAL |
+        SQL_CVT_LONGVARCHAR | SQL_CVT_WCHAR | SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_VARBINARY
|
+        SQL_CVT_NUMERIC | SQL_CVT_DECIMAL | SQL_CVT_BIT | SQL_CVT_TINYINT | SQL_CVT_DATE
| SQL_CVT_FLOAT |
+        SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_DOUBLE | SQL_CVT_BINARY | SQL_CVT_LONGVARBINARY
|
+        SQL_CVT_TIME | SQL_CVT_TIMESTAMP | SQL_CVT_GUID);
+
+    CheckIntInfo(SQL_CONVERT_GUID, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR |
SQL_CVT_WVARCHAR |
+        SQL_CVT_WCHAR | SQL_CVT_WLONGVARCHAR | SQL_CVT_BINARY | SQL_CVT_VARBINARY | SQL_CVT_LONGVARBINARY
|
+        SQL_CVT_GUID);
+
+    CheckIntInfo(SQL_CONVERT_DATE, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR |
SQL_CVT_WCHAR |
+        SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_INTEGER | SQL_CVT_BIGINT
|
+        SQL_CVT_BINARY | SQL_CVT_VARBINARY | SQL_CVT_LONGVARBINARY | SQL_CVT_DATE | SQL_CVT_TIMESTAMP);
+
+    CheckIntInfo(SQL_CONVERT_DECIMAL, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR
| SQL_CVT_WCHAR |
+        SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_DECIMAL | SQL_CVT_TIMESTAMP
|
+        SQL_CVT_BIT | SQL_CVT_TINYINT | SQL_CVT_SMALLINT | SQL_CVT_INTEGER | SQL_CVT_BIGINT
| SQL_CVT_REAL |
+        SQL_CVT_FLOAT | SQL_CVT_DOUBLE | SQL_CVT_BINARY | SQL_CVT_VARBINARY | SQL_CVT_LONGVARBINARY);
+
+    CheckIntInfo(SQL_CONVERT_DOUBLE, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR
| SQL_CVT_WCHAR |
+        SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_DECIMAL | SQL_CVT_TIMESTAMP
|
+        SQL_CVT_TINYINT | SQL_CVT_BIGINT | SQL_CVT_INTEGER | SQL_CVT_FLOAT | SQL_CVT_REAL
| SQL_CVT_DOUBLE |
+        SQL_CVT_BINARY | SQL_CVT_VARBINARY | SQL_CVT_SMALLINT | SQL_CVT_LONGVARBINARY);
+
+    CheckIntInfo(SQL_CONVERT_FLOAT, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR
| SQL_CVT_WVARCHAR |
+        SQL_CVT_WLONGVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_DECIMAL | SQL_CVT_TINYINT | SQL_CVT_SMALLINT
|
+        SQL_CVT_INTEGER | SQL_CVT_BIGINT | SQL_CVT_REAL | SQL_CVT_FLOAT | SQL_CVT_DOUBLE
| SQL_CVT_BINARY |
+        SQL_CVT_VARBINARY | SQL_CVT_WCHAR | SQL_CVT_LONGVARBINARY | SQL_CVT_TIMESTAMP | SQL_CVT_BIT);
+
+    CheckIntInfo(SQL_CONVERT_REAL, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR |
SQL_CVT_WVARCHAR |
+        SQL_CVT_NUMERIC | SQL_CVT_DECIMAL | SQL_CVT_BIT | SQL_CVT_FLOAT | SQL_CVT_SMALLINT
| SQL_CVT_REAL |
+        SQL_CVT_INTEGER | SQL_CVT_BIGINT | SQL_CVT_DOUBLE | SQL_CVT_TINYINT | SQL_CVT_WLONGVARCHAR
|
+        SQL_CVT_BINARY | SQL_CVT_VARBINARY | SQL_CVT_LONGVARBINARY | SQL_CVT_TIMESTAMP |
SQL_CVT_WCHAR);
+
+    CheckIntInfo(SQL_CONVERT_INTEGER, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR
| SQL_CVT_WCHAR |
+        SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_DECIMAL | SQL_CVT_TINYINT
|
+        SQL_CVT_SMALLINT | SQL_CVT_BIT | SQL_CVT_INTEGER | SQL_CVT_BIGINT | SQL_CVT_REAL
| SQL_CVT_FLOAT |
+        SQL_CVT_DOUBLE | SQL_CVT_BINARY | SQL_CVT_VARBINARY | SQL_CVT_LONGVARBINARY | SQL_CVT_TIMESTAMP);
+
+    CheckIntInfo(SQL_CONVERT_NUMERIC, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR
| SQL_CVT_WCHAR |
+        SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_DECIMAL | SQL_CVT_SMALLINT
|
+        SQL_CVT_INTEGER | SQL_CVT_BIGINT | SQL_CVT_REAL | SQL_CVT_BIT | SQL_CVT_TINYINT |
SQL_CVT_FLOAT |
+        SQL_CVT_DOUBLE | SQL_CVT_BINARY | SQL_CVT_VARBINARY | SQL_CVT_LONGVARBINARY | SQL_CVT_TIMESTAMP);
+
+    CheckIntInfo(SQL_CONVERT_SMALLINT, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR
| SQL_CVT_WCHAR |
+        SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_DECIMAL | SQL_CVT_VARBINARY
|
+        SQL_CVT_BIT | SQL_CVT_TINYINT | SQL_CVT_SMALLINT | SQL_CVT_INTEGER | SQL_CVT_BIGINT
| SQL_CVT_REAL |
+        SQL_CVT_FLOAT | SQL_CVT_DOUBLE | SQL_CVT_BINARY | SQL_CVT_LONGVARBINARY | SQL_CVT_TIMESTAMP);
+
+    CheckIntInfo(SQL_CONVERT_TINYINT, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR
| SQL_CVT_WCHAR |
+        SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_DECIMAL | SQL_CVT_TINYINT
|
+        SQL_CVT_SMALLINT | SQL_CVT_BIT | SQL_CVT_INTEGER | SQL_CVT_BIGINT | SQL_CVT_REAL
| SQL_CVT_FLOAT |
+        SQL_CVT_DOUBLE | SQL_CVT_BINARY | SQL_CVT_VARBINARY | SQL_CVT_LONGVARBINARY | SQL_CVT_TIMESTAMP);
+
+    CheckIntInfo(SQL_CONVERT_TIME, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR |
SQL_CVT_WVARCHAR |
+        SQL_CVT_WCHAR | SQL_CVT_WLONGVARCHAR | SQL_CVT_BINARY | SQL_CVT_VARBINARY | SQL_CVT_LONGVARBINARY
|
+        SQL_CVT_TIME | SQL_CVT_TIMESTAMP);
+
+    CheckIntInfo(SQL_CONVERT_TIMESTAMP, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR
| SQL_CVT_DATE |
+        SQL_CVT_WCHAR | SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_LONGVARBINARY
|
+        SQL_CVT_DECIMAL | SQL_CVT_INTEGER | SQL_CVT_BINARY | SQL_CVT_VARBINARY | SQL_CVT_TIMESTAMP
| SQL_CVT_BIGINT |
+        SQL_CVT_TIME);
+
+    CheckIntInfo(SQL_CONVERT_VARBINARY, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_LONGVARCHAR
| SQL_CVT_BIT |
+        SQL_CVT_WCHAR | SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_NUMERIC | SQL_CVT_DECIMAL
|
+        SQL_CVT_TINYINT | SQL_CVT_SMALLINT | SQL_CVT_DATE | SQL_CVT_BIGINT | SQL_CVT_REAL
| SQL_CVT_FLOAT |
+        SQL_CVT_DOUBLE | SQL_CVT_INTEGER | SQL_CVT_BINARY | SQL_CVT_VARBINARY | SQL_CVT_LONGVARBINARY
|
+        SQL_CVT_TIME | SQL_CVT_TIMESTAMP | SQL_CVT_GUID);
+
+    CheckIntInfo(SQL_CONVERT_LONGVARBINARY, SQL_CVT_CHAR | SQL_CVT_VARCHAR | SQL_CVT_BIT
| SQL_CVT_TINYINT |
+        SQL_CVT_WCHAR | SQL_CVT_WLONGVARCHAR | SQL_CVT_WVARCHAR | SQL_CVT_LONGVARCHAR | SQL_CVT_NUMERIC
|
+        SQL_CVT_DECIMAL | SQL_CVT_FLOAT | SQL_CVT_INTEGER | SQL_CVT_BIGINT | SQL_CVT_REAL
| SQL_CVT_DATE |
+        SQL_CVT_DOUBLE | SQL_CVT_BINARY | SQL_CVT_VARBINARY | SQL_CVT_LONGVARBINARY | SQL_CVT_TIMESTAMP
|
+        SQL_CVT_SMALLINT | SQL_CVT_TIME | SQL_CVT_GUID);
+
+    CheckIntInfo(SQL_SQL92_ROW_VALUE_CONSTRUCTOR, SQL_SRVC_VALUE_EXPRESSION | SQL_SRVC_DEFAULT
| SQL_SRVC_NULL |
+        SQL_SRVC_ROW_SUBQUERY);
+
+    CheckIntInfo(SQL_SUBQUERIES, SQL_SQ_CORRELATED_SUBQUERIES | SQL_SQ_COMPARISON | SQL_SQ_EXISTS
| SQL_SQ_IN |
+        SQL_SQ_QUANTIFIED);
+
+    CheckShortInfo(SQL_MAX_CONCURRENT_ACTIVITIES, 32);
+    CheckShortInfo(SQL_CURSOR_COMMIT_BEHAVIOR, SQL_CB_PRESERVE);
+    CheckShortInfo(SQL_CURSOR_ROLLBACK_BEHAVIOR, SQL_CB_PRESERVE);
+    CheckShortInfo(SQL_TXN_CAPABLE, SQL_TC_NONE);
+    CheckShortInfo(SQL_QUOTED_IDENTIFIER_CASE, SQL_IC_SENSITIVE);
+    CheckShortInfo(SQL_ACTIVE_ENVIRONMENTS, 0);
+    CheckShortInfo(SQL_CONCAT_NULL_BEHAVIOR, SQL_CB_NULL);
+    CheckShortInfo(SQL_CORRELATION_NAME, SQL_CN_ANY);
+    CheckShortInfo(SQL_FILE_USAGE, SQL_FILE_NOT_SUPPORTED);
+    CheckShortInfo(SQL_GROUP_BY, SQL_GB_GROUP_BY_EQUALS_SELECT);
+    CheckShortInfo(SQL_IDENTIFIER_CASE, SQL_IC_UPPER);
+    CheckShortInfo(SQL_MAX_COLUMN_NAME_LEN, 0);
+    CheckShortInfo(SQL_MAX_COLUMNS_IN_GROUP_BY, 0);
+    CheckShortInfo(SQL_MAX_COLUMNS_IN_INDEX, 0);
+    CheckShortInfo(SQL_MAX_COLUMNS_IN_ORDER_BY, 0);
+    CheckShortInfo(SQL_MAX_COLUMNS_IN_SELECT, 0);
+    CheckShortInfo(SQL_MAX_COLUMNS_IN_TABLE, 0);
+    CheckShortInfo(SQL_MAX_CURSOR_NAME_LEN, 0);
+    CheckShortInfo(SQL_MAX_DRIVER_CONNECTIONS, 0);
+    CheckShortInfo(SQL_MAX_IDENTIFIER_LEN, 128);
+    CheckShortInfo(SQL_MAX_PROCEDURE_NAME_LEN, 0);
+    CheckShortInfo(SQL_MAX_SCHEMA_NAME_LEN, 0);
+    CheckShortInfo(SQL_MAX_TABLE_NAME_LEN, 0);
+    CheckShortInfo(SQL_MAX_TABLES_IN_SELECT, 0);
+    CheckShortInfo(SQL_MAX_USER_NAME_LEN, 0);
+    CheckShortInfo(SQL_NON_NULLABLE_COLUMNS, SQL_NNC_NULL);
+    CheckShortInfo(SQL_NULL_COLLATION, SQL_NC_END);
+}
+
+BOOST_AUTO_TEST_SUITE_END()

http://git-wip-us.apache.org/repos/asf/ignite/blob/cccf1132/modules/platforms/cpp/odbc/include/ignite/odbc/config/configuration.h
----------------------------------------------------------------------
diff --git a/modules/platforms/cpp/odbc/include/ignite/odbc/config/configuration.h b/modules/platforms/cpp/odbc/include/ignite/odbc/config/configuration.h
index b334141..2b1ec52 100644
--- a/modules/platforms/cpp/odbc/include/ignite/odbc/config/configuration.h
+++ b/modules/platforms/cpp/odbc/include/ignite/odbc/config/configuration.h
@@ -204,9 +204,9 @@ namespace ignite
                  *
                  * @return Data Source Name.
                  */
-                const std::string& GetDsn() const
+                const std::string& GetDsn(const std::string& dflt = DefaultValue::dsn)
const
                 {
-                    return GetStringValue(Key::dsn, DefaultValue::dsn);
+                    return GetStringValue(Key::dsn, dflt);
                 }
 
                 /**

http://git-wip-us.apache.org/repos/asf/ignite/blob/cccf1132/modules/platforms/cpp/odbc/src/config/connection_info.cpp
----------------------------------------------------------------------
diff --git a/modules/platforms/cpp/odbc/src/config/connection_info.cpp b/modules/platforms/cpp/odbc/src/config/connection_info.cpp
index 362d46b..9567d0c 100644
--- a/modules/platforms/cpp/odbc/src/config/connection_info.cpp
+++ b/modules/platforms/cpp/odbc/src/config/connection_info.cpp
@@ -673,7 +673,7 @@ namespace ignite
                 // called SQLDriverConnect or SQLBrowseConnect, this is the value of the
DSN keyword in the connection
                 // string passed to the driver. If the connection string did not contain
the DSN keyword (such as when
                 // it contains the DRIVER keyword), this is an empty string.
-                strParams[SQL_DATA_SOURCE_NAME] = config.GetDsn();
+                strParams[SQL_DATA_SOURCE_NAME] = config.GetDsn("");
 #endif // SQL_DATA_SOURCE_NAME
 
 #ifdef SQL_DATA_SOURCE_READ_ONLY
@@ -760,7 +760,7 @@ namespace ignite
 #ifdef SQL_PROCEDURE_TERM
                 // A character string: "Y" if the data source supports procedures and the
driver supports the ODBC
                 // procedure invocation syntax; "N" otherwise.
-                strParams[SQL_PROCEDURE_TERM] = "N";
+                strParams[SQL_PROCEDURES] = "N";
 #endif // SQL_PROCEDURE_TERM
 
 #ifdef SQL_ROW_UPDATES
@@ -2211,7 +2211,7 @@ namespace ignite
                 //     represent.
                 // SQL_CN_ANY = Correlation names are supported and can be any valid user
- defined name.
                 // An SQL - 92 Entry level-conformant driver will always return SQL_CN_ANY.
-                shortParams[SQL_CORRELATION_NAME] = SQL_CB_NULL;
+                shortParams[SQL_CORRELATION_NAME] = SQL_CN_ANY;
 #endif // SQL_CORRELATION_NAME
 
 #ifdef SQL_FILE_USAGE


Mime
View raw message