*** ./expected/3des.out Sun Mar 20 22:24:51 2005 --- ./results/3des.out Tue Jul 5 08:20:26 2005 *************** *** 17,23 **** select encode( encrypt('', 'foo', '3des'), 'hex'); encode ------------------ ! 9b641a6936249eb4 (1 row) -- 10 bytes key --- 17,23 ---- select encode( encrypt('', 'foo', '3des'), 'hex'); encode ------------------ ! 4d91b5c9cc64e1c9 (1 row) -- 10 bytes key *************** *** 24,30 **** select encode( encrypt('foo', '0123456789', '3des'), 'hex'); encode ------------------ ! 6f02b7076a366504 (1 row) -- 22 bytes key --- 24,30 ---- select encode( encrypt('foo', '0123456789', '3des'), 'hex'); encode ------------------ ! d2fb8baa1717cb02 (1 row) -- 22 bytes key *************** *** 37,44 **** -- decrypt select decrypt(encrypt('foo', '0123456', '3des'), '0123456', '3des'); decrypt ! --------- ! foo (1 row) -- iv --- 37,44 ---- -- decrypt select decrypt(encrypt('foo', '0123456', '3des'), '0123456', '3des'); decrypt ! ---------------------------- ! \327\007C\202\334|\232\310 (1 row) -- iv *************** *** 45,56 **** select encode(encrypt_iv('foo', '0123456', 'abcd', '3des'), 'hex'); encode ------------------ ! df27c264fb24ed7a (1 row) select decrypt_iv(decode('df27c264fb24ed7a', 'hex'), '0123456', 'abcd', '3des'); decrypt_iv ! ------------ ! foo (1 row) --- 45,56 ---- select encode(encrypt_iv('foo', '0123456', 'abcd', '3des'), 'hex'); encode ------------------ ! a1917305c1df08f8 (1 row) select decrypt_iv(decode('df27c264fb24ed7a', 'hex'), '0123456', 'abcd', '3des'); decrypt_iv ! ------------------------- ! \325c\311\365\223\312E_ (1 row) ======================================================================