Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Auto-completion uses Table icon for Materialized Views on Oracle connection.
It should use Materialized View icon as used in Schema Tree.
Auto-completion was retrieving both tables and materialized views together and we couldn't distinguish materialized views from tables.
I've updated auto-completion to retrieve tables and materialized views using separate queries and UNION the results together. This allows us to be able to distinguish materialized views from tables and use a different icon for materialized views in the auto-completion list.
Dev Notes:
1. The queries used for auto-completion are the same queries used for the schema browser.
2. In v18, I need to backport AFMatView changes from v19 so that AFMatView is derived from AFTable.
QA Notes:
1. The metadata query changes affect Oracle only.
2. Go to Server Properties -> Advanced tab -> Use DBA Views. Verify this issue with "Use DBA Views" checked and unchecked.
3. The areas that are impacted by the metadata query changes are:
- auto-completion table list
- "describe" action with "<TABLENAME>" as table name or any table name in SELECT query
- "list tables" and "list views" commands in FluidShell
4. Do regression testing to verify that tables, materialized views, and views are listed correctly in schema browser, Schema Script Generator, Schema Compare, etc.
Verified all the scenarios in 18.0.9-2. All regression in Jennys notes are taken care of in testing
Verified all the scenarios in 18.0.9-2. All regression in Jennys notes are taken care of in testing
Issue #15162 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 18.0.9-1, 19.0.0-dev-22 |
| No time estimate |
Auto-completion was retrieving both tables and materialized views together and we couldn't distinguish materialized views from tables.
I've updated auto-completion to retrieve tables and materialized views using separate queries and UNION the results together. This allows us to be able to distinguish materialized views from tables and use a different icon for materialized views in the auto-completion list.
Dev Notes:
1. The queries used for auto-completion are the same queries used for the schema browser.
2. In v18, I need to backport AFMatView changes from v19 so that AFMatView is derived from AFTable.
QA Notes:
1. The metadata query changes affect Oracle only.
2. Go to Server Properties -> Advanced tab -> Use DBA Views. Verify this issue with "Use DBA Views" checked and unchecked.
3. The areas that are impacted by the metadata query changes are:
- auto-completion table list
- "describe" action with "<TABLENAME>" as table name or any table name in SELECT query
- "list tables" and "list views" commands in FluidShell
4. Do regression testing to verify that tables, materialized views, and views are listed correctly in schema browser, Schema Script Generator, Schema Compare, etc.