Trailing garbage after a valid JSON value is accepted by JSON_LENGTH, JSON_QUERY, JSON_KEYS, JSON_VALUE, JSON_SEARCH and JSON_EXISTS

SELECT JSON_VALID('1 x');                     -- 0

SELECT JSON_LENGTH('1 x'),                    -- 1

       JSON_QUERY('[1] x', '$'),              -- [1]

       JSON_KEYS('{"a":1} x'),                -- ["a"]

       JSON_VALUE('{"a":1} x', '$.a');        -- 1

SELECT JSON_SEARCH('["1"] x', 'one', '1'),    -- "$[0]"

       JSON_SEARCH('["1"] x', 'all', '1');    -- NULL (differs from 'one')

SELECT JSON_EXISTS('[1] x', '$[0]'),                 -- 1

       JSON_CONTAINS_PATH('[1] x', 'one', '$[0]');   -- NULL (differs from JSON_EXISTS)