Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 358409 - The view only shows system tables on 'informix' schema, others are empty
Summary: The view only shows system tables on 'informix' schema, others are empty
Status: NEW
Alias: None
Product: Data Tools
Classification: Tools
Component: Enablement (show other bugs)
Version: 1.9   Edit
Hardware: PC Windows 7
: P3 major (vote)
Target Milestone: ---   Edit
Assignee: Brian Payton CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-21 08:43 EDT by Enrico Daga CLA
Modified: 2011-09-21 09:36 EDT (History)
0 users

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Enrico Daga CLA 2011-09-21 08:43:27 EDT 
Build Identifier: I20110613-1736

The Tables folder in the view is empty under all schemas in the Catalog except the schema 'informix'. In the informix schema, the Tables folder lists only sys* tables.
I can normally query the database using an SQL query, there are lot of tables under different schemas, but they do not appear in the tree view.

I tried with different Informix JDBC drivers (versions 3.50 and 3.70), but the behavior is the same.

I tried connecting with the 'informix' user and with another user, in both cases the behavior is the same.

This did not happen with the version released with Galileo.

Reproducible: Always

Steps to Reproduce:
1. Create a new connection of type Informix
2. Connect and expand the tree of the catalog you have connected too
3. Expand 'Schemas'->'informix'->'Tables' : only sys* tables are in the list
4. Expand 'Schemas'->'<another>'->'Tables' :  the list is empty
Comment 1 Brian Fitzpatrick CLA 2011-09-21 09:35:45 EDT 
Brian, can you have some of the IBM Informix folks look into this one?