Edouard Vanbelle
d88b3a313f
note: issue may have been on my side during test implementation, in any case the protection is required
11 lines
536 B
SQL
11 lines
536 B
SQL
-- Remove rows from auth.user_recent_files and auth.user_favorites whose
|
|
-- item_id is not a valid UUID (e.g. composite "uuid1_uuid2" values written
|
|
-- by a previous code path that joined owner_id and resource_id with '_').
|
|
-- These rows would cause a cast failure on `item_id::UUID` in list queries.
|
|
|
|
DELETE FROM auth.user_recent_files
|
|
WHERE item_id !~ '^[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}$';
|
|
|
|
DELETE FROM auth.user_favorites
|
|
WHERE item_id !~ '^[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}$';
|