[NXP-2652] SQL storage fails on "system properties" - Nuxeo Issue Tracker

XML

Word

Printable

Impact type:

Content model Change
Upgrade notes:

Hide

For PostgreSQL:
ALTER TABLE misc ADD COLUMN wfinprogress BOOLEAN;
ALTER TABLE misc ADD COLUMN wfincoption TEXT;
For Derby:
ALTER TABLE misc ADD COLUMN wfinprogress SMALLINT;
ALTER TABLE misc ADD COLUMN wfincoption CLOB;
Adapt for other databases depending on their boolean/text types.

Show
For PostgreSQL: ALTER TABLE misc ADD COLUMN wfinprogress BOOLEAN; ALTER TABLE misc ADD COLUMN wfincoption TEXT; For Derby: ALTER TABLE misc ADD COLUMN wfinprogress SMALLINT; ALTER TABLE misc ADD COLUMN wfincoption CLOB; Adapt for other databases depending on their boolean/text types.

SQLDocument.getSystemProp and SQLDocument.setSystemProp are missing.