jenkins-bot has submitted this change and it was merged.
Change subject: Drop and re-create the index
......................................................................
Drop and re-create the index
MySQL will give an error if you just change to a blob
Error: 1170 BLOB/TEXT column 'ref_target' used in key specification without
a key length
Bug: T110446
Change-Id: Icfc080768005a314970498e94861a1ab9c068549
---
M db_patches/patch-ref_target_not_null.sql
1 file changed, 3 insertions(+), 0 deletions(-)
Approvals:
Catrope: Looks good to me, approved
jenkins-bot: Verified
diff --git a/db_patches/patch-ref_target_not_null.sql
b/db_patches/patch-ref_target_not_null.sql
index da88d32..eb84e5f 100644
--- a/db_patches/patch-ref_target_not_null.sql
+++ b/db_patches/patch-ref_target_not_null.sql
@@ -1 +1,4 @@
+ALTER TABLE /*_*/flow_ext_ref DROP KEY flow_ext_ref_idx_v2;
ALTER TABLE /*_*/flow_ext_ref CHANGE ref_target ref_target BLOB NOT NULL;
+CREATE INDEX /*i*/flow_ext_ref_idx_v2 ON /*_*/flow_ext_ref
+ (ref_src_wiki, ref_src_namespace, ref_src_title, ref_type,
ref_target(255), ref_src_object_type, ref_src_object_id);
--
To view, visit https://gerrit.wikimedia.org/r/308912
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Icfc080768005a314970498e94861a1ab9c068549
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/Flow
Gerrit-Branch: master
Gerrit-Owner: MarkAHershberger <m...@nichework.com>
Gerrit-Reviewer: Catrope <roan.katt...@gmail.com>
Gerrit-Reviewer: Springle <sprin...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
