From e7e313f46f02c9a075f458502f0e4d6ac42880a6 Mon Sep 17 00:00:00 2001 From: Daniel Black Date: Tue, 15 Mar 2016 18:03:20 +1100 Subject: test case for CRC32() SQL function --- mysql-test/r/func_math.result | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'mysql-test/r/func_math.result') diff --git a/mysql-test/r/func_math.result b/mysql-test/r/func_math.result index f7ca1aa3d03..703d9816f8b 100644 --- a/mysql-test/r/func_math.result +++ b/mysql-test/r/func_math.result @@ -805,3 +805,9 @@ STDDEV_POP(ROUND(0,@A:=2009)) select 0=0, 0=-0, 0.0= -0.0, 0.0 = -(0.0), 0.0E1=-0.0E1, 0.0E1=-(0.0E1); 0=0 0=-0 0.0= -0.0 0.0 = -(0.0) 0.0E1=-0.0E1 0.0E1=-(0.0E1) 1 1 1 1 1 1 +# +# 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 -- cgit v1.2.1