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
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Q Analyzer - Auto-Completion |
| Version | 13.0 |
Version: 13.0-dev-19
Build #: 30206
Build Date: 2012-Nov-16 02:00:40 PM
Query Window autocompletion displays table and view names instead of table columns
To reproduce
Connect to Postgres Server 8.2
Connect to the ivan database
Enter the below query and hit autocomplete at the position marked with ^
^ when you hit autocomplete inside the select clause, the list of columns should be visible and not tabled and views
select
distinct substring(firstname from 1 for 3) from customer C
where substring(firstname from 1 for 3) not in (select ^ from customer)
See attached pic
|
|
67 KB
The cause of bug is that the parser is treating the "from" in substring function call as start of the SQL FROM clause.
This fix should be applied to the following 3 functions. See issue #8657
overlay(string placing string from int [for int])
substring(string [from int] [for int])
trim([leading | trailing | both] [characters] from string)
This fix should be applied to the following 3 functions. See issue #8657
overlay(string placing string from int [for int])
substring(string [from int] [for int])
trim([leading | trailing | both] [characters] from string)
Issue #7958 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build 13.0-alpha-16 |
| No time estimate |
The cause of bug is that the parser is treating the "from" in substring function call as start of the SQL FROM clause.