Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 358409

Summary: The view only shows system tables on 'informix' schema, others are empty
Product: [Tools] Data Tools Reporter: Enrico Daga <enricodaga>
Component: EnablementAssignee: Brian Payton <bpayton>
Status: NEW --- QA Contact:
Severity: major    
Priority: P3    
Version: 1.9   
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
Whiteboard:

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?