mysql-test/main/ssl_and_innodb.test


1
2
3
4
5
6
7
8
9
10
11

-- source include/have_innodb.inc
-- source include/have_des.inc

CREATE TABLE t1(a int) engine=innodb;
INSERT INTO t1 VALUES (1);

SELECT DISTINCT
convert((SELECT des_decrypt(2,1) AS a FROM t1 WHERE @a:=1), signed) as d
FROM t1 ;

DROP TABLE t1;