[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           | Unconfirmed
+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 10:36) 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.