← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/md5/t/md5.test

  • Committer: Brian Aker
  • Date: 2009-05-15 21:09:49 UTC
  • mfrom: (1008.4.2 working)
  • mto: This revision was merged to the branch mainline in revision 1025.
  • Revision ID: brian@gaz-20090515210949-wake45iau00m9t7o
Merge Jay

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/md5/t/md5.test
 
1
# 
 
2
# Verify that MD5() function returns a deterministic result
 
3
# when successively supplied with the same constant.
 
4
#
 
5
 
 
6
SELECT MD5("I love testing");
 
7
SELECT MD5("I love testing");
 
8
 
 
9
# 
 
10
# Check that the hash of a constant is identical to the hash
 
11
# of the same constant stored in a table column.
 
12
#
 
13
 
 
14
--disable_warnings
 
15
DROP TABLE IF EXISTS t1;
 
16
--enable_warnings
 
17
CREATE TABLE t1
 
18
(
 
19
  some_text VARCHAR(100) NOT NULL
 
20
);
 
21
INSERT INTO t1 VALUES ("I love testing");
 
22
SELECT MD5("I love testing") = MD5(some_text) FROM t1;
 
23
DROP TABLE t1;