[
https://issues.apache.org/jira/browse/TRAFODION-2079?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15379547#comment-15379547
]
ASF GitHub Bot commented on TRAFODION-2079:
-------------------------------------------
Github user selvaganesang commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/594#discussion_r70990583
--- Diff: core/conn/odbc/src/odbc/nsksrvrcore/srvrothers.cpp ---
@@ -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, "
--- End diff --
Spec says NULL should be returned when the value is not available. Can you
please change it to NULL. Attaching a formatted output of this query when the
table has index would be helpful to validate the results of the query by the
reviewers. Consider creating a use case with two tables one with update
statistics performed and another without.
> [3rd party tool-Squirrel] indexes won't show up on objects panel, sql command
> line works fine
> ---------------------------------------------------------------------------------------------
>
> Key: TRAFODION-2079
> URL: https://issues.apache.org/jira/browse/TRAFODION-2079
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-jdbc-t4
> Affects Versions: 2.1-incubating
> Environment: Squirrel 3.7
> server info -- esgynDBadv R2.1, centos 6.7, hbase1.0 cdh5.4.8
> Reporter: Gao, Rui-Xian
> Assignee: Weiqing Xu
> Priority: Minor
>
> click table name from objects panel, indexes won't show up.
> But checking from sql command line, indexes will be returned.
> >>get indexes on table BTSEL04;
> Indexes on Table RACHEL_SCH.BTSEL04
> ===================================
> BTSEL04A
> BTSEL04B
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
