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 | Tools - Object Search |
| Version | 13.0 |
Version: 13.0-alpha-15
Build #: 30688
Build Date: 2012-Dec-20 10:14:56 AM
Greenplum --> Tools -->Object Search for Constraint Columns seems to be repetitive
Search as attached in the Greenplum database and you can see that the contraint search results seems to be repetitive
Can you please check if this is correct
attached screenshot
|
|
86 KB
The query is incorrect because the objects returned from the current implementation are not only duplicated but also include objects belong to non-selected schemas. The current implementation is the same as PostgreSQL's implementation, and of course, PostgreSQL's result is incorrect either. I need to study PostgreSQL system catalog in order to resolve this issue.
Added more criteria to the query's WHERE clause for both Greenplum and PostgreSQL on Constraint Columns search. Only tested Greenplum and PostgreSQL 8.2, though.
Added more criteria to the query's WHERE clause for both Greenplum and PostgreSQL on Constraint Columns search. Only tested Greenplum and PostgreSQL 8.2, though.
Issue #8108 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build trunk/30702 |
| No time estimate |
The query is incorrect because the objects returned from the current implementation are not only duplicated but also include objects belong to non-selected schemas. The current implementation is the same as PostgreSQL's implementation, and of course, PostgreSQL's result is incorrect either. I need to study PostgreSQL system catalog in order to resolve this issue.