Kbase P92395: Select statement is on SQL-92 schema table (_systabauth) which has nouser visible columns. (9981)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/23/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
FACT(s) (Environment):
OpenEdge 10.x
SYMPTOM(s):
Select statement is on SQL-92 schema table (_systabauth) which has no
user visible columns. (9981)
CAUSE:
Most SQL-92 schema tables (such as _sysdbauth) have all their columns with the attribute _Field._sys-field set to True. Such fields can only be seen by specifically using the column's name in the select list. Usually this error arises on a statement like "select * from _sysdbauth".
FIX:
Solution is to avoid "select *" on such tables or to explicitly select needed columns.