hedgedoc/lib
David Mehren 380587b7fd Ensure case-sensitive DB queries on MySQL/MariaDB
MySQLs string comparisons are case-insensitive by default.
This allows to hide notes by creating a new note with an alias that
equals the lower-cased alias of another note.
The new note is returned first by MySQL, so the original one is not
accessible anymore.

This fixes the problem by using an explicit binary comparison in the
affected queries.

See https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html

Signed-off-by: David Mehren <git@herrmehren.de>
2024-09-01 13:54:18 +02:00
..
config feat: option to disable note creation 2024-07-21 11:03:35 +02:00
migrations refactor(migrations): move cleanup code into migration 2022-11-06 22:24:48 +01:00
models Ensure case-sensitive DB queries on MySQL/MariaDB 2024-09-01 13:54:18 +02:00
ot Fix logging in ot module 2018-11-13 23:30:13 +01:00
web feat: option to disable note creation 2024-07-21 11:03:35 +02:00
workers Adapt code for eslint-config-standard 17 2022-05-01 21:19:44 +02:00
csp.js Fix GitLab snippet export 2022-04-10 21:24:30 +02:00
errors.js Fix express deprecation warning 2022-10-30 22:15:16 +01:00
history.js Adapt code for eslint-config-standard 17 2022-05-01 21:19:44 +02:00
letter-avatars.js Use identicons as fallback for libravatar 2022-01-07 14:03:26 +01:00
logger.js Fix eslint warnings 2019-05-31 00:30:29 +02:00
prometheus.js Add custom prometheus metrics 2021-04-25 20:06:56 +02:00
realtime.js Fix premature note cleanup on error 2023-05-28 16:10:51 +02:00
response.js Adapt code for eslint-config-standard 17 2022-05-01 21:19:44 +02:00
utils.js Ensure case-sensitive DB queries on MySQL/MariaDB 2024-09-01 13:54:18 +02:00