diff options
| author | Daniel Black <daniel@linux.ibm.com> | 2018-05-07 17:04:18 +1000 |
|---|---|---|
| committer | Daniel Black <daniel@linux.ibm.com> | 2018-05-07 17:04:18 +1000 |
| commit | 97486599812f3d5a83dd6d13aac20b7e564f96f6 (patch) | |
| tree | 0b31e71d0a15ce54f3efc727514ad9b3ed044165 /mysql-test | |
| parent | c28be510d1316cc972c308f6f675fd753e718867 (diff) | |
| download | mariadb-git-97486599812f3d5a83dd6d13aac20b7e564f96f6.tar.gz | |
mtr: extend func_math (CRC32)
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/main/func_math.result | 6 | ||||
| -rw-r--r-- | mysql-test/main/func_math.test | 2 |
2 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/main/func_math.result b/mysql-test/main/func_math.result index 0f856fde255..832ca69d3ea 100644 --- a/mysql-test/main/func_math.result +++ b/mysql-test/main/func_math.result @@ -835,9 +835,9 @@ select 0=0, 0=-0, 0.0= -0.0, 0.0 = -(0.0), 0.0E1=-0.0E1, 0.0E1=-(0.0E1); # # CRC32 tests # -select CRC32(NULL), CRC32(''), CRC32('MySQL'), CRC32('mysql'), CRC32('01234567'), CRC32('012345678'), CRC32(REPEAT('0123456789', 200)); -CRC32(NULL) CRC32('') CRC32('MySQL') CRC32('mysql') CRC32('01234567') CRC32('012345678') CRC32(REPEAT('0123456789', 200)) -NULL 0 3259397556 2501908538 763378421 939184570 1428305034 +select CRC32(NULL), CRC32(''), CRC32('MySQL'), CRC32('mysql'), CRC32('01234567'), CRC32('012345678'), CRC32(REPEAT('ABCDEfghij', 20)), CRC32(REPEAT('0123456789', 200)); +CRC32(NULL) CRC32('') CRC32('MySQL') CRC32('mysql') CRC32('01234567') CRC32('012345678') CRC32(REPEAT('ABCDEfghij', 20)) CRC32(REPEAT('0123456789', 200)) +NULL 0 3259397556 2501908538 763378421 939184570 3823776386 1428305034 explain extended select (3-2)+1, (3/2)*1, 3-(2+1), 3/(2*1); id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used diff --git a/mysql-test/main/func_math.test b/mysql-test/main/func_math.test index 5de86dd5198..a2c54b58a67 100644 --- a/mysql-test/main/func_math.test +++ b/mysql-test/main/func_math.test @@ -607,7 +607,7 @@ select 0=0, 0=-0, 0.0= -0.0, 0.0 = -(0.0), 0.0E1=-0.0E1, 0.0E1=-(0.0E1); --echo # CRC32 tests --echo # -select CRC32(NULL), CRC32(''), CRC32('MySQL'), CRC32('mysql'), CRC32('01234567'), CRC32('012345678'), CRC32(REPEAT('0123456789', 200)); +select CRC32(NULL), CRC32(''), CRC32('MySQL'), CRC32('mysql'), CRC32('01234567'), CRC32('012345678'), CRC32(REPEAT('ABCDEfghij', 20)), CRC32(REPEAT('0123456789', 200)); # # MDEV-13673 Bad result in view |