1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
SELECT CRC32("I love testing");
CRC32("I love testing")
34910190
SELECT CRC32("I love testing");
CRC32("I love testing")
34910190
DROP TABLE IF EXISTS t1;
CREATE TABLE t1
(
some_text VARCHAR(100) NOT NULL
);
INSERT INTO t1 VALUES ("I love testing");
SELECT CRC32("I love testing") = CRC32(some_text) FROM t1;
CRC32("I love testing") = CRC32(some_text)
1
SELECT CRC32();
ERROR 42000: Incorrect parameter count in the call to native function 'crc32'
SELECT CRC32('foo','bar','zoo');
ERROR 42000: Incorrect parameter count in the call to native function 'crc32'
SELECT CRC32('');
CRC32('')
0
SELECT CRC32(100);
CRC32(100)
595022058
SELECT CRC32(4294967295);
CRC32(4294967295)
1540081739
SELECT CRC32('a');
CRC32('a')
3904355907
SELECT CRC32('taohuoahusoahusoa haneo uhnteoahu ntoahu saonhu aoeuoa hun');
CRC32('taohuoahusoahusoa haneo uhnteoahu ntoahu saonhu aoeuoa hun')
734998015
DROP TABLE t1;
|