You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by su...@apache.org on 2016/08/05 22:10:31 UTC
[1/6] incubator-trafodion git commit: [TRAFODION-2079]Catalog API
support get indexes
Repository: incubator-trafodion
Updated Branches:
refs/heads/master 37901fb53 -> ea11b0520
[TRAFODION-2079]Catalog API support get indexes
After this comment, both JDBC type4 and ODBC Catalog API will support
get the information about index.
[TRAFODION-2079]([3rd party tool-Squirrel] indexes won't show up on
objects panel, sql command line works fine) which related to Catalog
API of JDBC type, it is fixed also.
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/7ba2118c
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/7ba2118c
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/7ba2118c
Branch: refs/heads/master
Commit: 7ba2118cb426888aaab8745c485274b8aa49c132
Parents: c75214e
Author: Weiqing Xu <we...@esgyn.cn>
Authored: Fri Jul 15 10:29:36 2016 +0000
Committer: Weiqing Xu <we...@esgyn.cn>
Committed: Fri Jul 15 10:38:03 2016 +0000
----------------------------------------------------------------------
.../odbc/src/odbc/nsksrvrcore/srvrothers.cpp | 34 ++++++++++++++++++--
1 file changed, 32 insertions(+), 2 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/7ba2118c/core/conn/odbc/src/odbc/nsksrvrcore/srvrothers.cpp
----------------------------------------------------------------------
diff --git a/core/conn/odbc/src/odbc/nsksrvrcore/srvrothers.cpp b/core/conn/odbc/src/odbc/nsksrvrcore/srvrothers.cpp
index 3458251..7ee9e56 100644
--- a/core/conn/odbc/src/odbc/nsksrvrcore/srvrothers.cpp
+++ b/core/conn/odbc/src/odbc/nsksrvrcore/srvrothers.cpp
@@ -4934,7 +4934,7 @@ odbc_SQLSvc_GetSQLCatalogs_sme_(
convertWildcard(metadataId, TRUE, schemaNm, expSchemaNm);
convertWildcardNoEsc(metadataId, TRUE, schemaNm, schemaNmNoEsc);
convertWildcard(metadataId, TRUE, tableNm, expTableNm);
- convertWildcardNoEsc(metadataId, TRUE, tableNmNoEsc, tableNmNoEsc);
+ convertWildcardNoEsc(metadataId, TRUE, tableNm, tableNmNoEsc);
inputParam[0] = schemaNmNoEsc;
inputParam[1] = expSchemaNm;
inputParam[2] = tableNmNoEsc;
@@ -4967,10 +4967,40 @@ odbc_SQLSvc_GetSQLCatalogs_sme_(
"and (ob.SCHEMA_NAME = '%s' or trim(ob.SCHEMA_NAME) LIKE '%s' ESCAPE '\\') "
"and (ob.OBJECT_NAME = '%s' or trim(ob.OBJECT_NAME) LIKE '%s' ESCAPE '\\') "
"and (ob.OBJECT_TYPE in ('BT', 'VI')) "
- "and (trim(co.COLUMN_CLASS) not in('S', 'M'));",
+ "and (trim(co.COLUMN_CLASS) not in('S', 'M')) "
+ "union "
+ "select "
+ "cast('%s' as varchar(128)) TABLE_CAT, "
+ "cast(trim(ob.SCHEMA_NAME) as varchar(128)) TABLE_SCHEM, "
+ "cast(trim(ob.OBJECT_NAME) as varchar(128)) TABLE_NAME, "
+ "cast(idx.is_unique as smallint) NON_UNIQUE, "
+ "cast('' as varchar(128)) INDEX_QUALIFIER, "
+ "cast(trim(ob_table.OBJECT_NAME) as varchar(128)) INDEX_NAME, "
+ "cast(3 as smallint) TYPE, "
+ "cast(0 as smallint) ORDINAL_POSITION, "
+ "cast('' as varchar(128)) COLUMN_NAME, "
+ "cast('' as char(1)) ASC_OR_DES, "
+ "cast(0 as integer) CARDINALITY, "
+ "cast(0 as integer) PAGES, "
+ "cast('' as varchar(128)) FILTER_CONDITION "
+ "from "
+ "TRAFODION.\"_MD_\".OBJECTS ob, "
+ "TRAFODION.\"_MD_\".INDEXES idx, "
+ "TRAFODION.\"_MD_\".OBJECTS ob_table, "
+ "TRAFODION.\"_MD_\".TABLES tb "
+ "where "
+ "idx.BASE_TABLE_UID=tb.TABLE_UID "
+ "and idx.INDEX_UID=ob.OBJECT_UID "
+ "and idx.BASE_TABLE_UID=ob_table.OBJECT_UID "
+ "and (ob_table.SCHEMA_NAME = '%s' or trim(ob_table.SCHEMA_NAME) LIKE '%s' ESCAPE '\\') "
+ "and (ob_table.OBJECT_NAME = '%s' or trim(ob_table.OBJECT_NAME) LIKE '%s' ESCAPE '\\') "
+ "and (ob_table.OBJECT_TYPE in ('BT', 'VI'));",
tableParam[0],
inputParam[0],
inputParam[0], inputParam[1],
+ inputParam[2], inputParam[3],
+ tableParam[0],
+ inputParam[0], inputParam[1],
inputParam[2], inputParam[3]
);
[5/6] incubator-trafodion git commit: add test to check if the
getIndexOf return real null
Posted by su...@apache.org.
add test to check if the getIndexOf return real null
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/fa3cf706
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/fa3cf706
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/fa3cf706
Branch: refs/heads/master
Commit: fa3cf706cc6f502733cb33857a8911e83b636d8f
Parents: e0af177
Author: Weiqing Xu <we...@esgyn.cn>
Authored: Fri Aug 5 01:55:14 2016 +0000
Committer: Weiqing Xu <we...@esgyn.cn>
Committed: Fri Aug 5 02:00:15 2016 +0000
----------------------------------------------------------------------
.../org/trafodion/jdbc_test/TestGetIndexInfo.java | 16 ++++++++++++++++
1 file changed, 16 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/fa3cf706/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java
----------------------------------------------------------------------
diff --git a/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java b/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java
index f0cfa12..1cab0b0 100644
--- a/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java
+++ b/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java
@@ -163,14 +163,30 @@ public class TestGetIndexInfo {
assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbTableName ", indexInfo.dbTableName, rs.getString("TABLE_NAME"));
assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbNoneUnique ", indexInfo.dbNoneUnique, rs.getBoolean("NON_UNIQUE"));
+ // By the Document, dbNoneUnique will return null if the type is SQL_TABLE_STAT
+ System.out.println(rs.wasNull());
+ if (indexInfo.dbType == DatabaseMetaData.tableIndexStatistic)
+ assertTrue(rs.wasNull());
+
assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbIndexQualifier ", indexInfo.dbIndexQualifier, rs.getString("INDEX_QUALIFIER"));
assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbIndexName ", indexInfo.dbIndexName, rs.getString("INDEX_NAME"));
assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbType ", indexInfo.dbType, rs.getShort("TYPE"));
assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbOridinalPosition ", indexInfo.dbOrdinalPosition, rs.getShort("ORDINAL_POSITION"));
+ // By the Document, it return NULL when the type is SQL_TABLE_STAT
+ if (indexInfo.dbType == DatabaseMetaData.tableIndexStatistic)
+ assertTrue(rs.wasNull());
+
assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbColumnName ", indexInfo.dbColumnName, rs.getString("COLUMN_NAME"));
assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbAscOrDesc ", indexInfo.dbAscOrDesc, rs.getString("ASC_OR_DESC"));
assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbCardinality ", indexInfo.dbCardinality, rs.getInt("CARDINALITY"));
+ // When the type is not SQL_TABLE_STAT, dbCardinality will be NULL
+ if (indexInfo.dbType != DatabaseMetaData.tableIndexStatistic)
+ assertTrue(rs.wasNull());
assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbPages ", indexInfo.dbPages, rs.getInt("PAGES"));
+ // Since dbPages is not supported now, it always return NULL
+ // here check if it is real NULL
+ assertTrue(rs.wasNull());
+
assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbFilterCondition ", indexInfo.dbFilterCondition, rs.getString("FILTER_CONDITION"));
} catch (Exception e) {
System.out.println(e.getMessage());
[2/6] incubator-trafodion git commit: add JDBC test for getIndexInfo
Posted by su...@apache.org.
add JDBC test for getIndexInfo
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/3032a0c9
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/3032a0c9
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/3032a0c9
Branch: refs/heads/master
Commit: 3032a0c9718c529d4086dea775f9cdaa0d2a4b41
Parents: 7ba2118
Author: Weiqing Xu <we...@esgyn.cn>
Authored: Mon Aug 1 05:14:49 2016 +0000
Committer: Weiqing Xu <we...@esgyn.cn>
Committed: Mon Aug 1 05:14:49 2016 +0000
----------------------------------------------------------------------
.../odbc/src/odbc/nsksrvrcore/srvrothers.cpp | 46 +++---
.../trafodion/jdbc_test/TestGetIndexInfo.java | 161 +++++++++++++++++++
2 files changed, 186 insertions(+), 21 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/3032a0c9/core/conn/odbc/src/odbc/nsksrvrcore/srvrothers.cpp
----------------------------------------------------------------------
diff --git a/core/conn/odbc/src/odbc/nsksrvrcore/srvrothers.cpp b/core/conn/odbc/src/odbc/nsksrvrcore/srvrothers.cpp
index 7ee9e56..3481d4b 100644
--- a/core/conn/odbc/src/odbc/nsksrvrcore/srvrothers.cpp
+++ b/core/conn/odbc/src/odbc/nsksrvrcore/srvrothers.cpp
@@ -4945,16 +4945,16 @@ odbc_SQLSvc_GetSQLCatalogs_sme_(
"cast('%s' as varchar(128)) TABLE_CAT, "
"cast(trim(ob.SCHEMA_NAME) as varchar(128)) TABLE_SCHEM, "
"cast(trim(ob.OBJECT_NAME) as varchar(128)) TABLE_NAME, "
- "cast(0 as smallint) NON_UNIQUE, " // not support
- "cast('' as varchar(128)) INDEX_QUALIFIER, " // not support
- "cast('' as varchar(128)) INDEX_NAME, "
- "cast(0 as smallint) TYPE, " // not support
- "cast(co.column_number as smallint) ORDINAL_POSITION, "
+ "cast(NULL as smallint) NON_UNIQUE, " // return NULL if TYPE is SQL_TABLE_STAT
+ "cast(NULL as varchar(128)) INDEX_QUALIFIER, " // return NULL if TYPE is SQL_TABLE_STAT
+ "cast(NULL as varchar(128)) INDEX_NAME, " // return NULL if TYPE is SQL_TABLE_STAT
+ "cast(0 as smallint) TYPE, " // TYPE is SQL_TABLE_STAT
+ "cast(NULL as smallint) ORDINAL_POSITION, " // return NULL if TYPE is SQL_TABLE_STAT
"cast(trim(co.COLUMN_NAME) as varchar(128)) COLUMN_NAME, "
- "cast('' as char(1)) ASC_OR_DES, "
- "cast(sb.rowcount as integer) CARDINALITY, "
- "cast(0 as integer) PAGES, " // not support
- "cast('' as varchar(128)) FILTER_CONDITION " // not support
+ "cast(NULL as char(1)) ASC_OR_DESC, " // return NULL if TYPE is SQL_TABLE_STAT
+ "cast(sb.rowcount as integer) CARDINALITY, " // number of rows
+ "cast(NULL as integer) PAGES, " // not support
+ "cast(NULL as varchar(128)) FILTER_CONDITION " // not support
"from "
"TRAFODION.\"_MD_\".OBJECTS ob, "
"TRAFODION.\"_MD_\".COLUMNS co, "
@@ -4971,18 +4971,18 @@ odbc_SQLSvc_GetSQLCatalogs_sme_(
"union "
"select "
"cast('%s' as varchar(128)) TABLE_CAT, "
- "cast(trim(ob.SCHEMA_NAME) as varchar(128)) TABLE_SCHEM, "
- "cast(trim(ob.OBJECT_NAME) as varchar(128)) TABLE_NAME, "
+ "cast(trim(ob_table.SCHEMA_NAME) as varchar(128)) TABLE_SCHEM, "
+ "cast(trim(ob_table.OBJECT_NAME) as varchar(128)) TABLE_NAME, "
"cast(idx.is_unique as smallint) NON_UNIQUE, "
- "cast('' as varchar(128)) INDEX_QUALIFIER, "
- "cast(trim(ob_table.OBJECT_NAME) as varchar(128)) INDEX_NAME, "
- "cast(3 as smallint) TYPE, "
+ "cast(NULL as varchar(128)) INDEX_QUALIFIER, " // not support
+ "cast(trim(ob.OBJECT_NAME) as varchar(128)) INDEX_NAME, "
+ "cast(3 as smallint) TYPE, " // SQL_INDEX_OTHER
"cast(0 as smallint) ORDINAL_POSITION, "
- "cast('' as varchar(128)) COLUMN_NAME, "
- "cast('' as char(1)) ASC_OR_DES, "
- "cast(0 as integer) CARDINALITY, "
- "cast(0 as integer) PAGES, "
- "cast('' as varchar(128)) FILTER_CONDITION "
+ "cast('' as varchar(128)) COLUMN_NAME, " // return an empty string if the expression cannot be determined.
+ "cast(NULL as char(1)) ASC_OR_DESC, " // not subsequent
+ "cast(NULL as integer) CARDINALITY, "
+ "cast(NULL as integer) PAGES, "
+ "cast(NULL as varchar(128)) FILTER_CONDITION "
"from "
"TRAFODION.\"_MD_\".OBJECTS ob, "
"TRAFODION.\"_MD_\".INDEXES idx, "
@@ -4994,14 +4994,17 @@ odbc_SQLSvc_GetSQLCatalogs_sme_(
"and idx.BASE_TABLE_UID=ob_table.OBJECT_UID "
"and (ob_table.SCHEMA_NAME = '%s' or trim(ob_table.SCHEMA_NAME) LIKE '%s' ESCAPE '\\') "
"and (ob_table.OBJECT_NAME = '%s' or trim(ob_table.OBJECT_NAME) LIKE '%s' ESCAPE '\\') "
- "and (ob_table.OBJECT_TYPE in ('BT', 'VI'));",
+ "and (ob_table.OBJECT_TYPE in ('BT', 'VI')) "
+ "%s "
+ "ORDER BY 1, 2, 3, 7, 9, 6 ;",
tableParam[0],
inputParam[0],
inputParam[0], inputParam[1],
inputParam[2], inputParam[3],
tableParam[0],
inputParam[0], inputParam[1],
- inputParam[2], inputParam[3]
+ inputParam[2], inputParam[3],
+ uniqueness == 1 ? "" : "and idx.is_unique=1"
);
break;
@@ -5031,6 +5034,7 @@ odbc_SQLSvc_GetSQLCatalogs_sme_(
// Temporary solution - bypass checks on metadata tables
unsigned int savedParserFlags = 0;
+
SQL_EXEC_GetParserFlagsForExSqlComp_Internal(savedParserFlags);
try
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/3032a0c9/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java
----------------------------------------------------------------------
diff --git a/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java b/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java
new file mode 100644
index 0000000..6605328
--- /dev/null
+++ b/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java
@@ -0,0 +1,161 @@
+package src.test.java.org.trafodion.jdbc_test;
+
+import java.sql.Connection;
+import java.sql.DatabaseMetaData;
+import java.sql.DriverManager;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.Statement;
+
+import org.junit.AfterClass;
+import org.junit.BeforeClass;
+import org.junit.Test;
+import static org.junit.Assert.*;
+
+public class TestGetIndexInfo {
+
+ private static final String INDEX_INFO_TEST_TABLE = "INDEX_INFO_TEST_TABLE";
+
+ private static final String strCreateTableQuery = "CREATE TABLE " + INDEX_INFO_TEST_TABLE + "(C1 INT, C2 INT)";
+ private static final String strInsertQuery = "INSERT INTO " + INDEX_INFO_TEST_TABLE + " (C1, C2) VALUES (?, ?)";
+ private static final String strUpdateStatisticsQuery = "UPDATE STATISTICS FOR TABLE " + INDEX_INFO_TEST_TABLE + " ON (C1, C2)";
+ private static final String strDropTableQuery = "DROP TABLE " + INDEX_INFO_TEST_TABLE;
+ private static final String INDEX_C1_NAME = INDEX_INFO_TEST_TABLE + "_INDEX";
+
+ private static final String strCreateIndexQuery = "CREATE INDEX " + INDEX_C1_NAME +" on " + INDEX_INFO_TEST_TABLE + "(C1)";
+
+ private static Connection _conn = null;
+
+ @BeforeClass
+ public static void doTestSuiteSetup() throws Exception {
+ try {
+ _conn = DriverManager.getConnection(Utils.url, Utils.usr, Utils.pwd);
+ Statement stmt = _conn.createStatement();
+ stmt.execute(strCreateTableQuery);
+
+ PreparedStatement pstmt = _conn.prepareStatement(strInsertQuery);
+ int[][] testValues = {
+ {1, 2},
+ {10, 3},
+ {2, 2}
+ };
+ System.out.println(testValues.length);
+ for (int i = 0; i < testValues.length; i++) {
+ pstmt.setInt(1, testValues[i][0]);
+ pstmt.setInt(2, testValues[i][1]);
+ pstmt.addBatch();
+ }
+ pstmt.executeBatch();
+ pstmt.close();
+
+ // create index
+ stmt.execute(strCreateIndexQuery);
+
+ // update statistics on the table
+ stmt.execute(strUpdateStatisticsQuery);
+
+ stmt.close();
+ }
+ catch (Exception e) {
+ System.out.println(e.getMessage());
+ e.printStackTrace();
+ } finally {
+ }
+ }
+
+ @Test
+ public void testGetNoneUniqueIndexInfo() {
+ IndexInfo[] expIndexInfo = {
+ new IndexInfo("TRAFODION", "SEABASE", INDEX_INFO_TEST_TABLE, false, (String)null, (String)null, (short)0, (short)0, "C1", 0, 3, (short)0, (String)null),
+ new IndexInfo("TRAFODION", "SEABASE", INDEX_INFO_TEST_TABLE, false, (String)null, (String)null, (short)0, (short)0, "C2", 0, 3, (short)0, (String)null),
+ new IndexInfo("TRAFODION", "SEABASE", INDEX_INFO_TEST_TABLE, false, (String)null, INDEX_C1_NAME, (short)3, (short)0, "", 0, 0, (short)0, (String)null)
+ };
+
+ try {
+ DatabaseMetaData meta = _conn.getMetaData();
+ ResultSet indexInformation = meta.getIndexInfo(_conn.getCatalog(), null, INDEX_INFO_TEST_TABLE, false, false);
+
+ int rowNum = 0;
+ while(indexInformation.next()) {
+ compareInfoWithExp("testGetUniqueIndexInfo", rowNum + 1, indexInformation, expIndexInfo[rowNum]);
+ rowNum += 1;
+ }
+ assertEquals(rowNum, 3);
+ } catch(Exception e) {
+ System.out.println(e.getMessage());
+ e.printStackTrace();
+ }
+ }
+
+ @AfterClass
+ public static void cleanTable() {
+ try ( Statement stmt = _conn.createStatement() ) {
+ stmt.execute(strDropTableQuery);
+ } catch(Exception e) {
+ // do nothing
+ }
+
+ try {
+ _conn.close();
+ } catch(Exception e) {
+
+ }
+ }
+
+ private class IndexInfo {
+ public String dbCatalog = "TRAFODION";
+ public String dbSchema = "SEABASE";
+ public String dbTableName;
+ public boolean dbNoneUnique = false;
+ public String dbIndexQualifier;
+ public String dbIndexName;
+ public short dbType;
+ public short dbOrdinalPosition;
+ public String dbColumnName;
+ public String dbAscOrDesc;
+ public int dbCardinality;
+ public int dbPages;
+ public String dbFilterCondition;
+
+ public IndexInfo(String dbCatalog, String dbSchema, String dbTableName, boolean dbNoneUnique, String dbIndexQualifier, String dbIndexName,
+ short dbType, short dbOrdinalPosition, String dbColumnName, int dbAscOrdesc, int dbCardinality, int dbPages, String dbFilterCondition) {
+ this.dbCatalog = dbCatalog;
+ this.dbSchema = dbSchema;
+ this.dbTableName = dbTableName;
+ this.dbNoneUnique = dbNoneUnique;
+ this.dbIndexQualifier = dbIndexQualifier;
+ this.dbIndexName = dbIndexName;
+ this.dbType = dbType;
+ this.dbOrdinalPosition = dbOrdinalPosition;
+ this.dbColumnName = dbColumnName;
+ this.dbCardinality = dbCardinality;
+ this.dbPages = dbPages;
+ this.dbFilterCondition = dbFilterCondition;
+ }
+ }
+
+ private void compareInfoWithExp(String methondName, int rowNum, ResultSet rs, IndexInfo indexInfo) {
+ try {
+ assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbCatalog ", indexInfo.dbCatalog, rs.getString("TABLE_CAT"));
+ String currentSchema = _conn.getSchema();
+
+ // Since we may run the test in different Schema, so compare the result to the current schema of the connection here.
+ assertEquals(methondName + " rowNUm " + Integer.toString(rowNum) + " dbSchem ", currentSchema, rs.getString("TABLE_SCHEM"));
+
+ assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbTableName ", indexInfo.dbTableName, rs.getString("TABLE_NAME"));
+ assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbNoneUnique ", indexInfo.dbNoneUnique, rs.getBoolean("NON_UNIQUE"));
+ assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbIndexQualifier ", indexInfo.dbIndexQualifier, rs.getString("INDEX_QUALIFIER"));
+ assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbIndexName ", indexInfo.dbIndexName, rs.getString("INDEX_NAME"));
+ assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbType ", indexInfo.dbType, rs.getShort("TYPE"));
+ assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbOridinalPosition ", indexInfo.dbOrdinalPosition, rs.getShort("ORDINAL_POSITION"));
+ assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbColumnName ", indexInfo.dbColumnName, rs.getString("COLUMN_NAME"));
+ assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbAscOrDesc ", indexInfo.dbAscOrDesc, rs.getString("ASC_OR_DESC"));
+ assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbCardinality ", indexInfo.dbCardinality, rs.getInt("CARDINALITY"));
+ assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbPages ", indexInfo.dbPages, rs.getInt("PAGES"));
+ assertEquals(methondName + " rowNum " + Integer.toString(rowNum) + " dbFilterCondition ", indexInfo.dbFilterCondition, rs.getString("FILTER_CONDITION"));
+ } catch (Exception e) {
+ System.out.println(e.getMessage());
+ e.printStackTrace();
+ }
+ }
+}
\ No newline at end of file
[4/6] incubator-trafodion git commit: fix a compilation failure of
TestGetIndexInfo
Posted by su...@apache.org.
fix a compilation failure of TestGetIndexInfo
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/e0af1778
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/e0af1778
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/e0af1778
Branch: refs/heads/master
Commit: e0af1778ac832592e122cdcc1999d226559e0aea
Parents: f7ed9fe
Author: Weiqing Xu <we...@esgyn.cn>
Authored: Tue Aug 2 05:39:18 2016 +0000
Committer: Weiqing Xu <we...@esgyn.cn>
Committed: Tue Aug 2 05:39:18 2016 +0000
----------------------------------------------------------------------
.../src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java | 2 --
1 file changed, 2 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e0af1778/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java
----------------------------------------------------------------------
diff --git a/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java b/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java
index 71a28d7..f0cfa12 100644
--- a/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java
+++ b/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java
@@ -19,8 +19,6 @@
//
// @@@ END COPYRIGHT @@@
-package src.test.java.org.trafodion.jdbc_test;
-
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
[6/6] incubator-trafodion git commit: Merge [TRAFODION-2079] PR-594
Catalog API support get indexes
Posted by su...@apache.org.
Merge [TRAFODION-2079] PR-594 Catalog API support get indexes
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/ea11b052
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/ea11b052
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/ea11b052
Branch: refs/heads/master
Commit: ea11b052015c2d6a9b4306f5732e48746af91e8c
Parents: 37901fb fa3cf70
Author: Suresh Subbiah <su...@apache.org>
Authored: Fri Aug 5 22:09:49 2016 +0000
Committer: Suresh Subbiah <su...@apache.org>
Committed: Fri Aug 5 22:09:49 2016 +0000
----------------------------------------------------------------------
.../odbc/src/odbc/nsksrvrcore/srvrothers.cpp | 58 ++++--
.../trafodion/jdbc_test/TestGetIndexInfo.java | 196 +++++++++++++++++++
2 files changed, 242 insertions(+), 12 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/ea11b052/core/conn/odbc/src/odbc/nsksrvrcore/srvrothers.cpp
----------------------------------------------------------------------
[3/6] incubator-trafodion git commit: add apache license for
TestGetIndexInfo.java
Posted by su...@apache.org.
add apache license for TestGetIndexInfo.java
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/f7ed9fef
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/f7ed9fef
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/f7ed9fef
Branch: refs/heads/master
Commit: f7ed9fef1bb9f3d410148424928b1b4a40bb49d9
Parents: 3032a0c
Author: Weiqing Xu <we...@esgyn.cn>
Authored: Mon Aug 1 11:13:24 2016 +0000
Committer: Weiqing Xu <we...@esgyn.cn>
Committed: Mon Aug 1 11:13:24 2016 +0000
----------------------------------------------------------------------
.../trafodion/jdbc_test/TestGetIndexInfo.java | 25 ++++++++++++++++++--
1 file changed, 23 insertions(+), 2 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/f7ed9fef/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java
----------------------------------------------------------------------
diff --git a/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java b/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java
index 6605328..71a28d7 100644
--- a/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java
+++ b/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestGetIndexInfo.java
@@ -1,3 +1,24 @@
+// @@@ START COPYRIGHT @@@
+//
+// 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.
+//
+// @@@ END COPYRIGHT @@@
+
package src.test.java.org.trafodion.jdbc_test;
import java.sql.Connection;
@@ -39,7 +60,7 @@ public class TestGetIndexInfo {
{10, 3},
{2, 2}
};
- System.out.println(testValues.length);
+
for (int i = 0; i < testValues.length; i++) {
pstmt.setInt(1, testValues[i][0]);
pstmt.setInt(2, testValues[i][1]);
@@ -158,4 +179,4 @@ public class TestGetIndexInfo {
e.printStackTrace();
}
}
-}
\ No newline at end of file
+}