Kbase P98588: SQL-92: SELECT * FROM sysprogress.sysvarcharstat returns no records;
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/12/2004 |
|
Status: Unverified
GOAL:
Why does the SQL-92 statement:
SQL-92: SELECT * FROM sysprogress.sysvarcharstat;
returns no records while the statement:
SELECT coltype, COUNT(*) FROM sysprogress.syscolstat GROUP BY coltype;
lists many VARCHAR columns.
FIX:
The statistics for VARCHAR columns go in the schema table "_sysnvarcharstat" with view "sysnvarcharstat". This name stands for "internationalized VARCHAR statistics". "sysvarcharstat" is a legacy schema table which is not currently used, because all database character data is internationalized.