moodle/.upgradenotes/MDL-46739-2024091010555321.yml
Tim Hunt 8f9b57d5d3
MDL-46739 user preferences: change value column to TEXT.
Other similar columns config.value and config_plugins.value are TEXT, so
it is surprising that this column is different, and that has lead to
bugs in the past, so we should make it consistent.
2024-11-11 11:33:52 +00:00

11 lines
426 B
YAML

issueNumber: MDL-46739
notes:
core:
- message: >-
The {user_preferences}.value database field is now TEXT instead of CHAR.
This means that any queries with a condition on this field in a WHERE or
JOIN statement will need updating to use `$DB->sql_compare_text()`. See
the `$newusers` query in
`\core\task\send_new_users_password_task::execute` for an example.
type: changed