Revision 7388
Added by ben leinfelder almost 12 years ago
| src/upgrade-db-to-2.0.0-oracle.sql | ||
|---|---|---|
| 142 | 142 |
CREATE INDEX xml_access_guid_index on xml_access (guid); |
| 143 | 143 |
|
| 144 | 144 |
UPDATE xml_access xa |
| 145 |
SET accessfileid = maxid.guid |
|
| 146 |
FROM max_identifier maxid |
|
| 147 |
WHERE xa.accessfileid = maxid.docid |
|
| 148 |
AND xa.guid IS NOT null;
|
|
| 145 |
SET accessfileid = (SELECT maxid.guid
|
|
| 146 |
FROM max_identifier maxid
|
|
| 147 |
WHERE xa.accessfileid = maxid.docid
|
|
| 148 |
AND xa.guid IS NOT null);
|
|
| 149 | 149 |
--UPDATE 310427 |
| 150 | 150 |
|
| 151 | 151 |
DROP INDEX maxid_docid_index; |
Also available in: Unified diff
use alternative syntax for xml_access table update since oracle does not use joins in a update statement that same way as postgres. http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5717