1select des_encrypt("test", 'akeystr');
2des_encrypt("test", 'akeystr')
3NULL
4Warnings:
5Warning	1289	The 'des_encrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
6select des_encrypt("test", 1);
7des_encrypt("test", 1)
8NULL
9Warnings:
10Warning	1289	The 'des_encrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
11select des_encrypt("test", 9);
12des_encrypt("test", 9)
13NULL
14Warnings:
15Warning	1289	The 'des_encrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
16select des_encrypt("test", 100);
17des_encrypt("test", 100)
18NULL
19Warnings:
20Warning	1289	The 'des_encrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
21select des_encrypt("test", NULL);
22des_encrypt("test", NULL)
23NULL
24Warnings:
25Warning	1289	The 'des_encrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
26select des_encrypt(NULL, NULL);
27des_encrypt(NULL, NULL)
28NULL
29Warnings:
30Warning	1289	The 'des_encrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
31select des_decrypt("test", 'anotherkeystr');
32des_decrypt("test", 'anotherkeystr')
33NULL
34Warnings:
35Warning	1289	The 'des_decrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
36select des_decrypt(1, 1);
37des_decrypt(1, 1)
38NULL
39Warnings:
40Warning	1289	The 'des_decrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
41select des_decrypt(des_encrypt("test", 'thekey'));
42des_decrypt(des_encrypt("test", 'thekey'))
43NULL
44Warnings:
45Warning	1289	The 'des_decrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
46select hex(des_encrypt("hello")),des_decrypt(des_encrypt("hello"));
47hex(des_encrypt("hello"))	des_decrypt(des_encrypt("hello"))
48NULL	NULL
49Warnings:
50Warning	1289	The 'des_encrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
51Warning	1289	The 'des_decrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
52select des_decrypt(des_encrypt("hello",4));
53des_decrypt(des_encrypt("hello",4))
54NULL
55Warnings:
56Warning	1289	The 'des_decrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
57select des_decrypt(des_encrypt("hello",'test'),'test');
58des_decrypt(des_encrypt("hello",'test'),'test')
59NULL
60Warnings:
61Warning	1289	The 'des_decrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
62select hex(des_encrypt("hello")),hex(des_encrypt("hello",5)),hex(des_encrypt("hello",'default_password'));
63hex(des_encrypt("hello"))	hex(des_encrypt("hello",5))	hex(des_encrypt("hello",'default_password'))
64NULL	NULL	NULL
65Warnings:
66Warning	1289	The 'des_encrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
67Warning	1289	The 'des_encrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
68Warning	1289	The 'des_encrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
69select des_decrypt(des_encrypt("hello"),'default_password');
70des_decrypt(des_encrypt("hello"),'default_password')
71NULL
72Warnings:
73Warning	1289	The 'des_decrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
74select des_decrypt(des_encrypt("hello",4),'password4');
75des_decrypt(des_encrypt("hello",4),'password4')
76NULL
77Warnings:
78Warning	1289	The 'des_decrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
79SET @a=des_decrypt(des_encrypt("hello"));
80Warnings:
81Warning	1289	The 'des_decrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
82flush des_key_file;
83select @a = des_decrypt(des_encrypt("hello"));
84@a = des_decrypt(des_encrypt("hello"))
85NULL
86select hex("hello");
87hex("hello")
8868656C6C6F
89select hex(des_decrypt(des_encrypt("hello",4),'password2'));
90hex(des_decrypt(des_encrypt("hello",4),'password2'))
91NULL
92Warnings:
93Warning	1289	The 'des_decrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
94select hex(des_decrypt(des_encrypt("hello","hidden")));
95hex(des_decrypt(des_encrypt("hello","hidden")))
96NULL
97Warnings:
98Warning	1289	The 'des_decrypt' feature is disabled; you need MariaDB built with '--with-ssl' to have it working
99