[Tickets #15172] Re: mysql V 8.0.36: SQL QUERY FAILED: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'other_attributes' can't have a default value

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: https://bugs.horde.org/ticket/15172
------------------------------------------------------------------------------
  Ticket             | 15172
  Updated By         | Git Commit <commits at lists.horde.org>
  Summary            | mysql V 8.0.36: SQL QUERY FAILED: SQLSTATE[42000]:
                     | Syntax error or access violation:
                     | 1101 BLOB, TEXT, GEOMETRY or JSON
                     | column 'other_attributes' can't
                     | have a default value
  Queue              | Kronolith
  Version            | FRAMEWORK_6_0
  Type               | Bug
  State              | Assigned
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             | Horde Developers, Ralf Lang
------------------------------------------------------------------------------


Git Commit <commits at lists.horde.org> (2025-05-29 10:49) wrote:

Changes have been made in Git (FRAMEWORK_6_0):

commit 9b12019057d6b5dd3b9a488598256e554e77a136
Author: Ralf Lang <ralf.lang at ralf-lang.de>
Date:   Thu, 29 May 2025 12:49:21 +0200

Release 3.0.0-alpha6  (API Version: 3.0.0-alpha1)

fix: Also apply defaults filter when changing an existing column's type
fix: Special case default field values must not be quoted if they are  
expressions
feat: Optionally supply sqlType to addColumnOptions
fix: #15172 Add a filter to support column defaults on mysql >= 8.0.13  
for TEXT, BLOB and JSON format

  M .horde.yml
  M composer.json
  M doc/changelog.yml

https://github.com/horde/Db/commit/9b12019057d6b5dd3b9a488598256e554e77a136