|
1008.4.2
by Jay Pipes
Adds a md5 test case suite for the md5 UDF plugin. This should serve |
1 |
SELECT MD5("I love testing");
|
2 |
MD5("I love testing")
|
|
3 |
dc30ccbf874c4faa408ffdc500c2e29a
|
|
4 |
SELECT MD5("I love testing");
|
|
5 |
MD5("I love testing")
|
|
6 |
dc30ccbf874c4faa408ffdc500c2e29a
|
|
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 MD5("I love testing") = MD5(some_text) FROM t1;
|
|
14 |
MD5("I love testing") = MD5(some_text)
|
|
15 |
1
|
|
16 |
DROP TABLE t1;
|