Kbase P145093: When will the _mprosrv process recache the schema for a database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/04/2009 |
|
Status: Unverified
GOAL:
When will the _mprosrv process recache the schema for a database?
GOAL:
When does the _mprosrv process recache schema associated with online schema changes?
GOAL:
How does the _mprosrv handle online schema changes?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
FIX:
The _mprosrv will notice online schema changes as soon as a new query on the given changed table is executed after the online schema change. A query running while the online schema change was made will not see the change. Just a new query will cause it to re-cache the schema for that table. Only tables involved in the online schema change are re-cached by the server.The ABL client running rcode will not recache the schema even for a table that had an online schema change made. Compiling new code will cause the client to recache and see the changes to the schema.