Page MenuHomePhabricator

[keyserver] Avoid JSON cast when using MariaDB
ClosedPublic

Authored by ashoat on Jul 13 2022, 10:49 AM.
Tags
None
Referenced Files
Unknown Object (File)
Sat, Nov 2, 6:32 PM
Unknown Object (File)
Sat, Nov 2, 6:32 PM
Unknown Object (File)
Sat, Nov 2, 6:31 PM
Unknown Object (File)
Sat, Nov 2, 6:21 PM
Unknown Object (File)
Tue, Oct 29, 6:07 AM
Unknown Object (File)
Sun, Oct 20, 11:44 PM
Unknown Object (File)
Mon, Oct 7, 12:29 AM
Unknown Object (File)
Mon, Oct 7, 12:29 AM

Details

Summary

One difference between MySQL and MariaDB is that MySQL has a JSON column type and MariaDB doesn't.

MySQL requires that the second parameter to JSON_CONTAINS is a JSON type. MariaDB doesn't have JSON types, so it doesn't have this requirement.

We need to make sure we do the cast for MySQL, but not for MariaDB.

Depends on D4521

Test Plan

I ran the web application and clicked around a bunch. Full test plan will come later

Diff Detail

Repository
rCOMM Comm
Lint
Lint Not Applicable
Unit
Tests Not Applicable

Event Timeline

keyserver/src/fetchers/message-fetchers.js
113 ↗(On Diff #14441)

Should probably make a follow-up task to the mysql migration to remove the branching logic (which you may already have).

keyserver/src/fetchers/message-fetchers.js
113 ↗(On Diff #14441)
This revision is now accepted and ready to land.Jul 17 2022, 12:53 PM