From 78f8c54bb046a6643bd511d77017594e79850f11 Mon Sep 17 00:00:00 2001 From: Daniel Black Date: Thu, 20 Jul 2017 15:20:52 +1000 Subject: [PATCH] Expand test suite to include CRC32 tests --- mysql-test/r/func_math.result | 6 ++++++ mysql-test/t/func_math.test | 7 +++++++ 2 files changed, 13 insertions(+) diff --git a/mysql-test/r/func_math.result b/mysql-test/r/func_math.result index 5de4711c38b..20857e2a2ba 100644 --- a/mysql-test/r/func_math.result +++ b/mysql-test/r/func_math.result @@ -953,3 +953,9 @@ number Round(number, num_digits) > 0 Round(number, 3) > 0 1 1 1 0 0 0 DROP PROCEDURE test_round_fn; +# +# CRC32 tests +# +select CRC32(NULL), CRC32(''), CRC32('MySQL'), CRC32('mysql'), CRC32('01234567'), CRC32('012345678'); +CRC32(NULL) CRC32('') CRC32('MySQL') CRC32('mysql') CRC32('01234567') CRC32('012345678') +NULL 0 3259397556 2501908538 763378421 939184570 diff --git a/mysql-test/t/func_math.test b/mysql-test/t/func_math.test index fc45241e2b3..fe1e4f699ae 100644 --- a/mysql-test/t/func_math.test +++ b/mysql-test/t/func_math.test @@ -683,3 +683,10 @@ DELIMITER ;| CALL test_round_fn(); DROP PROCEDURE test_round_fn; + + +--echo # +--echo # CRC32 tests +--echo # + +select CRC32(NULL), CRC32(''), CRC32('MySQL'), CRC32('mysql'), CRC32('01234567'), CRC32('012345678');