Matthias Mullie has uploaded a new change for review.
https://gerrit.wikimedia.org/r/259234
Change subject: Make patch-reference_wiki*.sql work with prefixed tables
......................................................................
Make patch-reference_wiki*.sql work with prefixed tables
Bug: T121486
Change-Id: I88a73e2a77b6a3feece45222ef85de045938126c
---
M db_patches/patch-reference_wiki-phase3.sql
M db_patches/patch-reference_wiki.sql
2 files changed, 12 insertions(+), 12 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/Flow
refs/changes/34/259234/1
diff --git a/db_patches/patch-reference_wiki-phase3.sql
b/db_patches/patch-reference_wiki-phase3.sql
index b511721..eb8b1aa 100644
--- a/db_patches/patch-reference_wiki-phase3.sql
+++ b/db_patches/patch-reference_wiki-phase3.sql
@@ -10,12 +10,12 @@
SELECT ref_src_workflow_id, workflow_wiki
FROM /*_*/flow_wiki_ref, /*_*/flow_workflow
WHERE
- flow_wiki_ref.ref_src_workflow_id =
flow_workflow.workflow_id AND
- ( flow_wiki_ref.ref_src_wiki = '' OR
flow_wiki_ref.ref_src_wiki IS NULL )
+ ref_src_workflow_id = workflow_id AND
+ ( ref_src_wiki = '' OR ref_src_wiki IS NULL )
LIMIT 1000
) tmp
- SET flow_wiki_ref.ref_src_wiki = tmp.workflow_wiki
- WHERE flow_wiki_ref.ref_src_workflow_id = tmp.ref_src_workflow_id;
+ SET /*_*/flow_wiki_ref.ref_src_wiki = tmp.workflow_wiki
+ WHERE /*_*/flow_wiki_ref.ref_src_workflow_id = tmp.ref_src_workflow_id;
-- Populate external references with the appropriate wiki.
@@ -24,9 +24,9 @@
SELECT ref_src_workflow_id, workflow_wiki
FROM /*_*/flow_ext_ref, /*_*/flow_workflow
WHERE
- flow_ext_ref.ref_src_workflow_id =
flow_workflow.workflow_id AND
- ( flow_ext_ref.ref_src_wiki = '' OR
flow_ext_ref.ref_src_wiki IS NULL )
+ ref_src_workflow_id = workflow_id AND
+ ( ref_src_wiki = '' OR ref_src_wiki IS NULL )
LIMIT 1000
) tmp
- SET flow_ext_ref.ref_src_wiki = tmp.workflow_wiki
- WHERE flow_ext_ref.ref_src_workflow_id = tmp.ref_src_workflow_id;
+ SET /*_*/flow_ext_ref.ref_src_wiki = tmp.workflow_wiki
+ WHERE /*_*/flow_ext_ref.ref_src_workflow_id = tmp.ref_src_workflow_id;
diff --git a/db_patches/patch-reference_wiki.sql
b/db_patches/patch-reference_wiki.sql
index 63b7778..27f36ad 100644
--- a/db_patches/patch-reference_wiki.sql
+++ b/db_patches/patch-reference_wiki.sql
@@ -10,9 +10,9 @@
-- Populate wiki references with the appropriate wiki
UPDATE /*_*/flow_wiki_ref, /*_*/flow_workflow
- SET flow_wiki_ref.ref_src_wiki = flow_workflow.workflow_wiki
+ SET ref_src_wiki = workflow_wiki
WHERE
- flow_wiki_ref.ref_src_workflow_id = flow_workflow.workflow_id;
+ ref_src_workflow_id = workflow_id;
-- Recreate new indexes
CREATE INDEX /*i*/flow_wiki_ref_idx_v2 ON /*_*/flow_wiki_ref
@@ -30,9 +30,9 @@
-- Populate external references with the appropriate wiki
UPDATE /*_*/flow_ext_ref, /*_*/flow_workflow
- SET flow_ext_ref.ref_src_wiki = flow_workflow.workflow_wiki
+ SET ref_src_wiki = workflow_wiki
WHERE
- flow_ext_ref.ref_src_workflow_id = flow_workflow.workflow_id;
+ ref_src_workflow_id = workflow_id;
-- Recreate new indexes
CREATE INDEX /*i*/flow_ext_ref_idx_v2 ON /*_*/flow_ext_ref
--
To view, visit https://gerrit.wikimedia.org/r/259234
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I88a73e2a77b6a3feece45222ef85de045938126c
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/Flow
Gerrit-Branch: master
Gerrit-Owner: Matthias Mullie <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
