Tickets :: Comment on [#15172] mysql V 8.0.36: SQL QUERY FAILED: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'other

* Your Email Address
* Spam protection	Enter the letters below: . .. ..__ .__ .___. \ /\|_/ [__)[__) _/ \/ \| \\| \[__)./__.
Comment	>> 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@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
Attachment
Watch this ticket