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