Anomie added a comment.
The annoying bit is that the join condition for `pagecontent` will look something like `old_id = substring( content_address from '^tt:(8[0-9]+)$' )::int`, which hard-codes the "tt:". Thankfully PG has that regexp-based substring and casting NULL to `int` works right or it'd be even worse. In T198341#5046541 <https://phabricator.wikimedia.org/T198341#5046541>, @daniel wrote: > And let's look into fixing postgres later. And by "later" I mean "when there is nothing more urgent or more important to be done". That sounds like code for "never". :( TASK DETAIL https://phabricator.wikimedia.org/T198341 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: BPirkle, Anomie Cc: tstarling, gerritbot, Tgr, Jdforrester-WMF, Anomie, Addshore, aude, Aklapper, daniel, alaa_wmde, EvanProdromou, CucyNoiD, Nandana, NebulousIris, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Ramsey-WMF, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, JJMC89, Maathavan, _jensen, rosalieper, Agabi10, Wikidata-bugs, Mbch331, Ltrlg
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
