[teiid-issues] [JBoss JIRA] Commented: (TEIID-1359) DatabaseMetaData.getTables() not returning values when supplied with types.

[Steven Hawkins (JIRA)]

    [ https://jira.jboss.org/browse/TEIID-1359?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12563463#comment-12563463 ] 

Steven Hawkins commented on TEIID-1359:
---------------------------------------

The top query is correct given that we are asking about two specific table types (it would be more cleanly written as an IN predicate, but that's a different story).  We also have a test case for this scenario that seems to have been running fine.  Are you sure you have an issue?

> DatabaseMetaData.getTables() not returning values when supplied with types.
> ---------------------------------------------------------------------------
>
>                 Key: TEIID-1359
>                 URL: https://jira.jboss.org/browse/TEIID-1359
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Driver
>    Affects Versions: 7.1.1
>         Environment: SOA 5.1 ER3 w/ EDS, JBDS Beta 1
>            Reporter: John Doyle
>            Assignee: Steven Hawkins
>
> I have a VDB deployed into EDS.  When I connect with a Hibernate config I don't get any tables back.  If I connect with the DTP tooling I do. The difference seems to be that Hibernate is passing "TABLE" and "VIEW" as table types, otherwise the params to the call are the same.
> Here is the SQL created in the call that returns no tables:
> SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION, IsPhysical AS ISPHYSICAL FROM SYS.Tables g  WHERE UCASE(VDBName) LIKE ? ESCAPE '\'  AND UCASE(SchemaName) LIKE ? ESCAPE '\'  AND UCASE(Name) LIKE ? ESCAPE '\'  AND (CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\'  OR CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' ) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME
> And the SQL from the call that returns the correct tables.
> SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION, IsPhysical AS ISPHYSICAL FROM SYS.Tables g  WHERE UCASE(VDBName) LIKE ? ESCAPE '\'  AND UCASE(SchemaName) LIKE ? ESCAPE '\'  AND UCASE(Name) LIKE ? ESCAPE '\'  ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira