B4BY.588
Home
Terminal
Upload
information
Create File
Create Folder
About
Tools
:
/
usr
/
share
/
mysql-test
/
r
/
Filename :
func_des_encrypt.result
back
Copy
select des_encrypt('hello'); des_encrypt('hello') ��2nV��} # # Bug #11643: des_encrypt() causes server to die # CREATE TABLE t1 (des VARBINARY(200) NOT NULL DEFAULT '') ENGINE=MyISAM; INSERT INTO t1 VALUES ('1234'), ('12345'), ('123456'), ('1234567'); UPDATE t1 SET des=DES_ENCRYPT('1234'); SELECT LENGTH(des) FROM t1; LENGTH(des) 9 9 9 9 SELECT DES_DECRYPT(des) FROM t1; DES_DECRYPT(des) 1234 1234 1234 1234 SELECT LENGTH(DES_ENCRYPT('1234')), LENGTH(DES_ENCRYPT('12345')), LENGTH(DES_ENCRYPT('123456')), LENGTH(DES_ENCRYPT('1234567')); LENGTH(DES_ENCRYPT('1234')) LENGTH(DES_ENCRYPT('12345')) LENGTH(DES_ENCRYPT('123456')) LENGTH(DES_ENCRYPT('1234567')) 9 9 9 9 SELECT DES_DECRYPT(DES_ENCRYPT('1234')), DES_DECRYPT(DES_ENCRYPT('12345')), DES_DECRYPT(DES_ENCRYPT('123456')), DES_DECRYPT(DES_ENCRYPT('1234567')); DES_DECRYPT(DES_ENCRYPT('1234')) DES_DECRYPT(DES_ENCRYPT('12345')) DES_DECRYPT(DES_ENCRYPT('123456')) DES_DECRYPT(DES_ENCRYPT('1234567')) 1234 12345 123456 1234567 DROP TABLE t1; End of 5.0 tests