recent mariadb and json: what about Memcached_DataObject.php

[Gijs Hillenius]

Hi

Is it possible that recent versions of MariaDB come with JSON support
which causes Memcached_DataObject.php to fail?

The error message displayed on the site following a (seemingly
succesful) installation;

Notice] DB_DataObject error []: MDB2 Error: syntax error

Trying to investigate this further, I added /this/ to my config.php:

$config['db']['debug'] = 1;

which gives me lots of debug output on the database. It seems to be in
Memcached_DataObject.php.



Notice: Query Error: [mdb2_error: message="MDB2 Error: syntax error"
code=-2 mode=return level=notice prefix="" info="_doQuery: [Error
message: Could not execute statement]

[Last executed query: SELECT `notice`.*
FROM `notice`

INNER JOIN (
WITH t1 (id, id_pos) AS (VALUES (NULL,0) LIMIT 0)
SELECT * FROM t1
) AS `notice_vals` USING (id)
WHERE ( `notice`.id IS NOT NULL )


ORDER BY `notice_vals`.id_pos
]
[Native code: 1064]

[Native message: You have an error in your SQL syntax; check the manual
that corresponds to your MariaDB server version for the right syntax to
use near 't1 (id, id_pos) AS (VALUES (NULL,0) LIMIT 0)

SELECT * FROM t1
) AS `notice_val' at line 5]
"]

Notice: 1: Clearing Cache for notice
User: 1: Clearing Cache for user