forked from StarRocks/starrocks
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtest_encryption
More file actions
82 lines (82 loc) · 8.7 KB
/
Copy pathtest_encryption
File metadata and controls
82 lines (82 loc) · 8.7 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
-- name: test_encryption_aes_encrypt_decrypt
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3'));
select AES_DECRYPT(from_base64('uv/Lhzm74syo8JlfWarwKA=='),'F3229A0B371ED2D9441B830D21A390C3');
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', NULL, "AES_128_ECB", "test"));
select AES_DECRYPT(from_base64('uv/Lhzm74syo8JlfWarwKA=='),'F3229A0B371ED2D9441B830D21A390C3', NULL, "AES_128_ECB", "test");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', NULL, "AES_128_ECB"));
select AES_DECRYPT(from_base64('uv/Lhzm74syo8JlfWarwKA=='),'F3229A0B371ED2D9441B830D21A390C3', NULL, "AES_128_ECB");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_ECB"));
select AES_DECRYPT(from_base64('uv/Lhzm74syo8JlfWarwKA=='),'F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_ECB");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "", "AES_192_ECB"));
select AES_DECRYPT(from_base64('xaf+kW/d5YPRSYFGnFkOfQ=='),'F3229A0B371ED2D9441B830D21A390C3', "", "AES_192_ECB");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "", "AES_256_ECB"));
select AES_DECRYPT(from_base64('o8B7eV7n6BqEuO7N453Y4A=='),'F3229A0B371ED2D9441B830D21A390C3', "", "AES_256_ECB");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_CBC"));
select AES_DECRYPT(from_base64('ne2YHEKECQSni3/kRI/nBg=='),'F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_CBC");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', NULL, "AES_128_CBC"));
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_128_CBC"));
select AES_DECRYPT(from_base64('taXlwIvir9yff94F5Uv/KA=='),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_128_CBC");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_192_CBC"));
select AES_DECRYPT(from_base64('QK83BHrWHqCWD1mA1u7WGQ=='),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_192_CBC");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_256_CBC"));
select AES_DECRYPT(from_base64('4w0ceQx2FqG8GGTivC0QPg=='),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_256_CBC");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_CFB"));
select AES_DECRYPT(from_base64('3wGmUeFO4/Ex'),'F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_CFB");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', NULL, "AES_128_CFB"));
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_128_CFB"));
select AES_DECRYPT(from_base64('POcBNCCAYPCc'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_128_CFB");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_192_CFB"));
select AES_DECRYPT(from_base64('Ma7ozVBB4lGP'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_192_CFB");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_256_CFB"));
select AES_DECRYPT(from_base64('p6+axkiBSNf2'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_256_CFB");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_CFB1"));
select AES_DECRYPT(from_base64('2NB6ZTf15qlj'),'F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_CFB1");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', NULL, "AES_128_CFB1"));
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_128_CFB1"));
select AES_DECRYPT(from_base64('JrWt4rBZ2JRl'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_128_CFB1");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_192_CFB1"));
select AES_DECRYPT(from_base64('MltCAryodTud'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_192_CFB1");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_256_CFB1"));
select AES_DECRYPT(from_base64('h5rRJ9HmkeqM'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_256_CFB1");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_CFB8"));
select AES_DECRYPT(from_base64('3yAMoqwMEKHp'),'F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_CFB8");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', NULL, "AES_128_CFB8"));
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_128_CFB8"));
select AES_DECRYPT(from_base64('PLbtNmFObZU6'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_128_CFB8");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_192_CFB8"));
select AES_DECRYPT(from_base64('MS8Gi0HaPkf8'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_192_CFB8");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_256_CFB8"));
select AES_DECRYPT(from_base64('p8NH5PX2mufr'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_256_CFB8");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_CFB128"));
select AES_DECRYPT(from_base64('3wGmUeFO4/Ex'),'F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_CFB128");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', NULL, "AES_128_CFB128"));
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_128_CFB128"));
select AES_DECRYPT(from_base64('POcBNCCAYPCc'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_128_CFB128");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_192_CFB128"));
select AES_DECRYPT(from_base64('Ma7ozVBB4lGP'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_192_CFB128");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_256_CFB128"));
select AES_DECRYPT(from_base64('p6+axkiBSNf2'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_256_CFB128");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_OFB"));
select AES_DECRYPT(from_base64('3wGmUeFO4/Ex'),'F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_OFB");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', NULL, "AES_128_OFB"));
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_128_OFB"));
select AES_DECRYPT(from_base64('POcBNCCAYPCc'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_128_OFB");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_192_OFB"));
select AES_DECRYPT(from_base64('Ma7ozVBB4lGP'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_192_OFB");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_256_OFB"));
select AES_DECRYPT(from_base64('p6+axkiBSNf2'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_256_OFB");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_CTR"));
select AES_DECRYPT(from_base64('3wGmUeFO4/Ex'),'F3229A0B371ED2D9441B830D21A390C3', "", "AES_128_CTR");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', NULL, "AES_128_CTR"));
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_128_CTR"));
select AES_DECRYPT(from_base64('POcBNCCAYPCc'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_128_CTR");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_192_CTR"));
select AES_DECRYPT(from_base64('Ma7ozVBB4lGP'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_192_CTR");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_256_CTR"));
select AES_DECRYPT(from_base64('p6+axkiBSNf2'),'F3229A0B371ED2D9441B830D21A390C3', "abcdefg", "AES_256_CTR");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefghijklmnop", "AES_128_GCM", "abcdefg"));
select AES_DECRYPT(from_base64('YWJjZGVmZ2hpamtsdpJC2rnrGmvqKQv/WcoO6NuOCXvUnC8pCw=='),'F3229A0B371ED2D9441B830D21A390C3', "abcdefghijklmnop", "AES_128_GCM", "abcdefg");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefghijklmnop", "AES_192_GCM", "abcdefg"));
select AES_DECRYPT(from_base64('YWJjZGVmZ2hpamtsIpxL5blh0/zHNXw5nG/tL68lc1BJZ/fCPA=='),'F3229A0B371ED2D9441B830D21A390C3', "abcdefghijklmnop", "AES_192_GCM", "abcdefg");
select to_base64(AES_ENCRYPT('starrocks','F3229A0B371ED2D9441B830D21A390C3', "abcdefghijklmnop", "AES_256_GCM", "abcdefg"));
select AES_DECRYPT(from_base64('YWJjZGVmZ2hpamts2bRovmWbg/Y5qmz8Lt1L2oebY6lOV92Ozw=='),'F3229A0B371ED2D9441B830D21A390C3', "abcdefghijklmnop", "AES_256_GCM", "abcdefg");