[CR #272941] When you upgrade to Adaptive Server 12.5.0.1 or later, check constraints created with the following criteria. They may not have been upgraded correctly.
The check constraint was created as a named check constraint.
Quoted identifiers were set to on while the constraint was created.
Quote identifiers were used around the entire constraint name.
The constraint name was also a key word, or not a legal identifier.
You see parser syntax errors after you have upgraded to Adaptive Server 12.5.0.1 and later, and when you first add data to the constrained column, or when you run dbcc upgrade_object.
To determine whether this problem occurs on your upgraded databases, run this command to check for syntax errors on your constraints and rules:
dbcc upgrade_object (dbname, rule)
Workaround: There are two workarounds to this problem:
Issue alter table drop constraint_name to drop a constraint that was not upgraded successfully. Then issue alter table add constraint_name, and re-create the constraint.
As System Administrator, manually update syscomments.text to add quoted identifiers to the constraints that were not successfully upgraded.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
