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:	Enablement	Assignee:	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

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

2011-09-21 09:35:45 EDT

Brian, can you have some of the IBM Informix folks look into this one?