Code assist does not work for Informix cross-db queries
started a topic
about 9 years ago
[This topic is migrated from our old forums. The original author name has been removed]
This is more a feature request than a bug, but it would be very useful to have.
To recreate, you need an instance of Informix with two databases, e.g. db1 and db2.
Create a table in the first database (db1), e.g.:
CREATE TABLE test (id_col INTEGER);
In SQL commander, select the second database (db2), and it is possible to query the above table by writing:
SELECT * FROM db1:test;
In this query, code assist (ctrl+space) does not offer a list of columns when the cursor is positioned just before "*" , as it does with tables within the same database.
Also, code assist should show a list of tables in db1 database when positioned just after the ":" in the statement.
Both these features work in MySQL, which uses a dot to separate database and table name in the query (e.g. SELECT * FROM db1.test) instead of the colon which is used in the Informix query.