Product: Aqua Data Studio
Version: 18.0.0-devi-239
Build #: 51197
Build Date: 2016-Sep-19 12:48:23 PM
Operating Environment: Windows 7 (6.1, x86) / Cp1252 / en / IN / Oracle Corporation 1.8.0_101-b13
Memory: Max=766,312,448; Total=159,465,472; Free=71,619,768; CPUs=8
Connect to DB Sybase Anywhere 17
Steps:
1. in DB Sybase Anywhere 17, go to Databases-> demo-> choose any schema, I chose pariksiht_test
2. Make Right Click on selected schema and select "Query Builder".
3. "Query Builder" window opened.
4. In "Query Builder", select schema "parikshit_test", so tables and views created in that schema will appear in below "Table" and "View" windows respectively.
5. If I try to expand any table or view among them, it gives an error.
Actual Result:
Error message displays: SQL Anywhere Error -143: Column 'foreign_table_id' not found
Columns and Indexes are not expanding properly of respective Tables and Views in "Query Builder".
Expected Result:
Column and Index names should get fetch from Tree node to "Query Builder".
Hence when we expand selected table or view, we should see Column and Index names regarding them.
Observation:
For Sybase Anywhere 16, In QB window, Column and Index node are expanded correctly and reflects column name related to it properly.
But in version 17 of Sybase Anywhere, if I try to expand the same, we get above-mentioned error.
ADS is failing to extract columns of tables and views to the "Query Builder".
Build Information:
I checked V14, v15, v16 and v17. The same issue is reproducing.
