[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]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: https://spencer.horde.org/hordenext/horde/../whups/ticket/15172
------------------------------------------------------------------------------
  Ticket           | 15172
  Aktualisiert Von | Ralf Lang <ralf.lang at ralf-lang.de>
  Zusammenfassung  | 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
  Warteschlange    | Kronolith
  Version          | FRAMEWORK_6_0
  Typ              | Bug
  Status           | Assigned
  Priorität        | 2. Medium
  Milestone        |
  Patch            |
-Zuständige       |
+Zuständige       | Horde Developers, Ralf Lang
------------------------------------------------------------------------------


Ralf Lang <ralf.lang at ralf-lang.de> (2025-05-29 11:10) hat geschrieben:

> Confirmed.
> I don't have this in mariadb.
> There's a workaround in mysql 8.0.13 and later by using an  
> expression rather than a literal as default for text and blob field.  
> We will build a patch based on this.

Preliminary patch at library level

commit c2d525d02cb0a7c2f087e0c86f9728caf3e44816 (HEAD ->  
FRAMEWORK_6_0, origin/HEAD, origin/FRAMEWORK_6_0)
Author: Ralf Lang <ralf.lang at ralf-lang.de>
Date:   Thu May 29 11:08:19 2025 +0200

     fix: #15172 Add a filter to support column defaults on mysql >=  
8.0.13 for TEXT, BLOB and JSON format

Will test if this is sufficient for nag and kronolith on this version of mysql