Kbase P12741: get-init.p fails if SQL-92 view exists.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/28/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
In Version 9, all references to the metaschema should include the _Owner in the where clause. The adm code should add "AND _Owner = "PUB" or _Owner = "_Foreign". This eliminates all SQL92 files/views/etc from the 4GL client view.
The procedure get-init.p gets confused when a SQL-92 view has the same name as a table known to the 4GL.
A sql92 view can have the same name as a table. The code in get-init.p will a times get the view instead of the table because it searches based only on filename.
CHANGE:
Migration from 9.1C to 9.1D
CAUSE:
Bug # 20010905-012
CAUSE:
Changed get-init.p to check that _tbl-type indicates that it is a Progress
table (ie. EQ 'T') to avoid unique find related error.
FIX:
Fixed in 9.1E.
Work around:
As of V9, when searching _File, all code for 4GL should only look at rows
where _Tbl-Type = "T" or "S" . This will skip sql92 views, which have table
type "V" or "C".
Thus, add the following line in get-init.p:
... and _file._tbl-type = "T" or _file._tbl-type ="S" NO-LOCK.