Change Details

T90025 revealed some pretty large external links, like:
* https://bits.wikimedia.org/www.mediawiki.org/load.php?debug=false&lang=id&modules=jquery,mediawiki&only=scripts&skin=vector&version=20150107T194503Z:156:502
* https://bits.wikimedia.org/www.mediawiki.org/load.php?debug=false&lang=id&modules=jquery,mediawiki&only=scripts&skin=vector&version=20150107T194503Z:161:743
The unique index flow_ext_ref_pk constraint results in this post not being inserted, even though the links are different.
The index is too short to hold the entire value, and the differences are near the end of the very long links.

T90025 revealed some pretty large external links, like:
* https://bits.wikimedia.org/www.mediawiki.org/load.php?debug=false&lang=id&modules=jquery,mediawiki&only=scripts&skin=vector&version=20150107T194503Z:156:502
* https://bits.wikimedia.org/www.mediawiki.org/load.php?debug=false&lang=id&modules=jquery,mediawiki&only=scripts&skin=vector&version=20150107T194503Z:161:743
The unique index flow_ext_ref_pk constraint results in this post not being inserted, even though the links are different.
The index is too short to hold the entire value, and the differences are near the end of the very long links.
Apart from the index, we may also want to think about the size of that column (currently `varbinary(255)`)

T90025 revealed some pretty large external links, like:
* https://bits.wikimedia.org/www.mediawiki.org/load.php?debug=false&lang=id&modules=jquery,mediawiki&only=scripts&skin=vector&version=20150107T194503Z:156:502
* https://bits.wikimedia.org/www.mediawiki.org/load.php?debug=false&lang=id&modules=jquery,mediawiki&only=scripts&skin=vector&version=20150107T194503Z:161:743
The unique index flow_ext_ref_pk constraint results in this post not being inserted, even though the links are different.
The index is too short to hold the entire value, and the differences are near the end of the very long links.
Apart from the index, we may also want to think about the size of that column (currently `varbinary(255)`)