|
V6-QUERY-D444
POSSIBLE AMBIGUOUS COLUMN error message generated with the Query Window
|
An ambiguous column reference error message may be produced in the QueryWindow when no columns have been selected from a table used in the
current query. For example, if we select TABLE1, TABLE2 and TABLE3 as
TEST and then select COUNT(*) and <all columns> from TABLE1 and TABLE2,
WHERE TABLE1.column=TEST.column, the query will will be incorrectly
built with an automatic alias instead of the assigned alias of TEST.
This has been corrected at 6.12 TSLEVEL 040 and above.
| Products: | BASE |
| Component: | QUERY |
| Priority: | MED |
| Status: | Outstanding Problem |
| Date: | Thu, 3 Apr 1997 |
| System | Release Reported | Release Fixed |
| VM/ESA (CMS) | 6.08 TS404 | |
| OS/390 (MVS) | 6.08 TS404 | |
| IBM OS/2 | 6.08 TS404 | 6.12 TS045 |
| OpenVMS VAX | 6.08 TS404 | |
| VSE/ESA (VSE) | 6.08 TS404 | |
| Windows 3.11 | 6.08 TS404 | 6.12 TS045 |
| VM/ESA (CMS) | 6.09 TS450 | |
| OS/390 (MVS) | 6.09 TS450 | |
| OpenVMS VAX | 6.09 TS450 | |
| Intel ABI | 6.10 TS018 | |
| Silicon Graphics Unix | 6.10 TS018 | |
| Macintosh | 6.10 TS037 | 6.12 TS040 |
| Compaq Tru64 Unix | 6.10 TS018 | 6.12 TS040 |
| IBM OS/2 | 6.10 TS019 | 6.12 TS045 |
| Windows 3.11 | 6.10 TS019 | 6.12 TS045 |
| AIX/6000 | 6.11 TS020 | 6.12 TS045 |
| HP-UX Operating Systems | 6.11 TS020 | 6.12 TS045 |
| IBM OS/2 | 6.11 TS020 | 6.12 TS045 |
| Solaris | 6.11 TS020 | 6.12 TS045 |
| Windows 3.11 | 6.11 TS020 | 6.12 TS045 |
| Intel ABI | 6.11 TS040 | |
| Silicon Graphics Unix | 6.11 TS040 | |
| Compaq Tru64 Unix | 6.11 TS040 | 6.12 TS040 |
| Windows NT | 6.11 TS040 | 6.12 TS045 |
| Windows 95 | 6.11 TS040 | 6.12 TS045 |
| AIX/6000 | 6.12 TS020 | 6.12 TS045 |
| HP-UX Operating Systems | 6.12 TS020 | 6.12 TS045 |
| IBM OS/2 | 6.12 TS020 | 6.12 TS045 |
| Solaris | 6.12 TS020 | 6.12 TS045 |
| OpenVMS Alpha | 6.12 TS020 | 6.12 TS045 |
| Windows 3.11 | 6.12 TS020 | 6.12 TS045 |
| Windows NT | 6.12 TS020 | 6.12 TS045 |
| Windows 95 | 6.12 TS020 | 6.12 TS045 |
No Fixes Available