diff options
| author | Daniel Black <grooverdan@users.sourceforge.net> | 2018-04-21 15:44:55 +1000 |
|---|---|---|
| committer | Sergey Vojtovich <svoj@mariadb.org> | 2018-04-26 16:33:09 +0400 |
| commit | 7f89d9c9e3b5ee87f5d3555a425ecf495bf04745 (patch) | |
| tree | cf9920089310b0055ec296ec785e238fdf1de257 /mysql-test/main/func_math.test | |
| parent | 1a011e5b5a7557175c6bb1d2ca61c48d37a63ad8 (diff) | |
| download | mariadb-git-7f89d9c9e3b5ee87f5d3555a425ecf495bf04745.tar.gz | |
tests: func_math, correct crc32 for mariadb
Differences:
MariaDB doesn't support a JSON type therefore the crc32 on those values
are different.
JSON extract syntax is different.
loaddata_utf8 has 3 duplicate lines removed compared to MySQL version.
Diffstat (limited to 'mysql-test/main/func_math.test')
| -rw-r--r-- | mysql-test/main/func_math.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/func_math.test b/mysql-test/main/func_math.test index f93509121b7..adea228207a 100644 --- a/mysql-test/main/func_math.test +++ b/mysql-test/main/func_math.test @@ -836,8 +836,8 @@ DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a JSON); INSERT INTO t1 VALUES ('{"name" : "goodyear"}'), ('{"name" : "verygood-year"}'); -SELECT a->>'$.name', CRC32(a) FROM t1; -SELECT CRC32(a->>'$.name') FROM t1 WHERE a->>'$.name' = 'goodyear'; +SELECT a, CRC32(a) FROM t1; +SELECT CRC32(json_query(a, '$.name')) FROM t1 WHERE json_query(a, '$.name') = 'goodyear'; SELECT CRC32(REPLACE(JSON_EXTRACT(a, "$.name"),'\"','')) FROM t1 WHERE JSON_EXTRACT(a, "$.name") = 'goodyear'; DROP TABLE t1; |