maria-developers team mailing list archive

[Sergey Petrunia <sergey@xxxxxxxxxxx>]

I've also found this:

CREATE FUNCTION FN_COUNT_ROWS(X JSON)
RETURNS INT DETERMINISTIC
RETURN (
  SELECT COUNT(*) FROM JSON_TABLE( X, '$[*]' COLUMNS( I INT PATH '$')) der
);
SELECT FN_COUNT_ROWS('[1, 2]') CNT;

This produces 
+------+
| CNT  |
+------+
|    0 |
+------+

while it should produce 2. 
Please investigate and fix this.

BR
 Sergei
-- 
Sergei Petrunia, Software Developer
MariaDB Corporation | Skype: sergefp | Blog: http://petrunia.net