<\/span><\/h2>\n\n\n\nMASKED WITH(FUNCTION = \u2018TYPE(\u53c2\u6570)\u2019)
TYPE\u6709\u56db\u79cd\u8131\u654f\u7c7b\u578bDEFAULT\u3001RANDOM\u3001PARTIAL\u3001SHA\u3001keymask<\/p>\n\n\n\n| \u7c7b\u578b<\/td> | \u652f\u6301\u7684\u7c7b\u578b<\/td> | \u8bed\u6cd5\u6837\u4f8b<\/td><\/tr> |
| default<\/td> | \u6240\u6709<\/td> | MASKED WITH(FUNCTION = \u2018DEFAULT()\u2019)<\/td><\/tr> |
| random<\/td> | \u6570\u5b57\u7c7b\u578b<\/td> | MASKED WITH(FUNCTION = \u2018RANDOM(1,100)\u2019)<\/td><\/tr> |
| partial<\/td> | \u5b57\u7b26\u7c7b\u578b<\/td> | masked with(function='Partial(1,\"$\",1)')<\/td><\/tr> |
| sha<\/td> | \u5b57\u7b26\u7c7b\u578b<\/td> | masked with(function='sha()')<\/td><\/tr> |
| keymask<\/td> | \u5b57\u7b26\u7c7b\u578b<\/td> | masked with(function='keymask(\"con\",\"#\",0)')<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<\/span>DEFAULT \u7c7b\u578b<\/span><\/h3>\n\n\n\n\u6ca1\u6709\u53c2\u6570\uff0c\u662f\u9488\u5bf9\u57fa\u672c\u7c7b\u578b\u7684\u6570\u636e\u5217\u8fdb\u884c\u8131\u654f\u7684\uff0c\u4e3a\u9ed8\u8ba4\u8131\u654f\u51fd\u6570\u3002
\u8bbe\u7f6e\u65b9\u5f0f\uff1aMASKED WITH(FUNCTION = \u2018DEFAULT()\u2019)
\u5728\u8be5\u79cd\u6a21\u5f0f\u4e0b\uff1a<\/p>\n\n\n\n - \u82e5\u6570\u636e\u7c7b\u578b\u5305\u542b date\u3001datetime \u548c time\uff1a
\uf0d8 date \u4f1a\u4ee5\u201c1900-01-01\u201d\u663e\u793a\uff1b
\uf0d8 datetime \u4f1a\u4ee5\u201c1900-01-01 00:00:00\u201d\u663e\u793a\uff1b
\uf0d8 time \u4f1a\u4ee5\u201c00:00:00\u201d\u663e\u793a\u3002<\/li> - \u82e5\u6570\u636e\u7c7b\u578b\u662f\u6574\u578b\u3001\u6d6e\u70b9\u578b\u548c decimal\uff1a
\uf0d8 \u6574\u578b\u548c\u6d6e\u70b9\u578b\u4f1a\u663e\u793a 0\uff1b
\uf0d8 decimal \u4f1a\u663e\u793a\u4e3a 0.000\u2026, \u5e26\u6709\u7ed3\u679c\u5c0f\u6570\u4f4d\uff08\u5b9a\u4e49\u7684\u7c7b\u578b\u6216\u8005\u8bc4\u4f30
\u7684\u7c7b\u578b\uff09\u4e2a\u6570 0\u3002<\/li> - \u82e5\u6570\u636e\u7c7b\u578b\u662f\u5b57\u7b26\u4e32\u7c7b\u578b\u7684\uff1a
\u5c06\u4f1a\u66ff\u6362\u4e3a\u56fa\u5b9a4\u4e2aX\u5b57\u7b26\u201cXXXX\u201d\u3002<\/li> - NULL \u503c\uff1a
\u4e0d\u505a\u8131\u654f\u5904\u7406\uff0c\u663e\u793a\u4e3aNULL\u3002<\/li> - Sql \u51fd\u6570\uff1a
\u5982\u679c\u4efb\u4e00\u53c2\u6570\u542b\u6709\u8131\u654f\u5c5e\u6027\uff0c\u5219\u6309\u7167\u7ed3\u679c\u7c7b\u578b\uff0c\u6267\u884c\u9ed8\u8ba4\u8131\u654f<\/span>\u3002\u5982\u679c\u53ea\u53c2\u4e0e\u6761\u4ef6\u90e8\u5206\uff0c\u7ed3\u679c\u90e8\u5206\u4e0d\u5305\u542b\u8131\u654f\u5217\uff0c\u5219\u4e0d\u8131\u654f\uff0c\u6bd4\u5982case when \u7684\u6761\u4ef6\u90e8\u5206\u3002<\/li><\/ol>\n\n\n\n<\/span>default\u6570\u636e\u7c7b\u578b\u8303\u56f4<\/span><\/h4>\n\n\n\n\u6240\u6709\u7c7b\u578b\u3002<\/p>\n\n\n\n <\/span>default\u6837\u4f8b<\/span><\/h4>\n\n\n\n\u5982\u4e0b\u662f\u9ed8\u8ba4\u8131\u654f\u7684\u8f93\u51fa\u4f8b\u5b50\u3002\u5176\u4e2d\u51fd\u6570\u90e8\u5206\uff0c\u662f\u5148\u6309\u7167\u539f\u59cb\u6570\u636e\u5904\u7406\u51fd\u6570\uff0c\u53ea\u662f\u5728\u6700\u540e\u8fd4\u56de\u7ed3\u679c\u65f6\uff0c\u6309\u7167\u51fd\u6570\u8fd4\u56de\u7c7b\u578b\uff0c\u6839\u636e\u8131\u654f\u89c4\u5219\u8fdb\u884c\u3002\u5173\u4e8e\u8131\u654f\u7528\u6237\u6743\u9650\u8bbe\u7f6e\uff0c\u8bf7\u770b\u540e\u9762\u7ae0\u8282\u3002<\/p>\n\n\n\n create table testMask(\n id int masked with(function='default()'), \n name varchar(100) masked with(function='default()'), \n birth date masked with(function='default()'),\n salary decimal(16,3) masked with(function='default()'),\n luckynumber bigint masked with(function='default()')\n);\n\ninsert into testmask values\n (1,'First','2001-01-01',1111.111,111111111111),\n (2,'Second','2002-02-02',2222.222,222222222222),\n (3,'\u5f20\u4e09','2003-03-03',3333.333,333333333333),\n (4,'\u674e\u56db','2004-04-04',4444.444,444444444444),\n (5,'\u5927\u5200\u738b\u4e94','2005-05-05',5555.555,555555555555);\n\n\n\ngbase> create table testMask(\n -> id int masked with(function='default()'),\n -> name varchar(100) masked with(function='default()'),\n -> birth date masked with(function='default()'),\n -> salary decimal(16,3) masked with(function='default()'),\n -> luckynumber bigint masked with(function='default()')\n -> );\nQuery OK, 0 rows affected (Elapsed: 00:00:00.63)\n\ngbase> insert into testmask values\n -> (1,'First','2001-01-01',1111.111,111111111111),\n -> (2,'Second','2002-02-02',2222.222,222222222222),\n -> (3,'\u5f20\u4e09','2003-03-03',3333.333,333333333333),\n -> (4,'\u674e\u56db','2004-04-04',4444.444,444444444444),\n -> (5,'\u5927\u5200\u738b\u4e94','2005-05-05',5555.555,555555555555);\nQuery OK, 5 rows affected (Elapsed: 00:00:00.49)\nRecords: 5 Duplicates: 0 Warnings: 0\ngbase> select * from testmask;\n+------+--------------+------------+----------+--------------+\n| id | name | birth | salary | luckynumber |\n+------+--------------+------------+----------+--------------+\n| 1 | First | 2001-01-01 | 1111.111 | 111111111111 |\n| 2 | Second | 2002-02-02 | 2222.222 | 222222222222 |\n| 3 | \u5f20\u4e09 | 2003-03-03 | 3333.333 | 333333333333 |\n| 4 | \u674e\u56db | 2004-04-04 | 4444.444 | 444444444444 |\n| 5 | \u5927\u5200\u738b\u4e94 | 2005-05-05 | 5555.555 | 555555555555 |\n+------+--------------+------------+----------+--------------+\n5 rows in set (Elapsed: 00:00:00.01)\n\ngbase>\n\n[gbase@rh6-1 ~]$ gccli -umasked -pmasked -e\"select * from testdb.testmask\"\n+------+------+------------+--------+-------------+\n| id | name | birth | salary | luckynumber |\n+------+------+------------+--------+-------------+\n| 0 | xxxx | 1900-01-01 | 0.000 | 0 |\n| 0 | xxxx | 1900-01-01 | 0.000 | 0 |\n| 0 | xxxx | 1900-01-01 | 0.000 | 0 |\n| 0 | xxxx | 1900-01-01 | 0.000 | 0 |\n| 0 | xxxx | 1900-01-01 | 0.000 | 0 |\n+------+------+------------+--------+-------------+\n[gbase@rh6-1 ~]$\n\n[gbase@rh6-1 ~]$ gccli -umasked -pmasked -e\"select substr(name,0,2) from testdb.testmask\"\n+------------------+\n| substr(name,0,2) |\n+------------------+\n| xx |\n| xx |\n| xx |\n| xx |\n| xx |\n+------------------+\n[gbase@rh6-1 ~]$ gccli -umasked -pmasked -e\"select substr(name,0,2) from testdb.testmask where substr(name,0,2)='Fi'\"\n+------------------+\n| substr(name,0,2) |\n+------------------+\n| xx |\n+------------------+<\/code><\/pre>\n\n\n\n<\/span>RANDOM \u7c7b\u578b<\/span><\/h3>\n\n\n\nRANDOM(min,max)\u6709\u4e24\u4e2a\u53c2\u6570\u6807\u5b9a\u968f\u673a\u8303\u56f4\uff0c\u6700\u5c0f\u503c\u548c\u6700\u5927\u503c\u968f\u673a\u8131\u654f\u51fd\u6570\u53ea\u5bf9\u6570\u5b57\u7c7b\u578b\u8d77\u4f5c\u7528\uff0c\u5b83\u5c06\u4f1a\u968f\u673a\u663e\u793a\u67d0\u4e00\u4e2a\u8303\u56f4\u5185\u7684\u503c\uff0c\u5e76\u591a\u6b21\u6267\u884c\uff0c\u4f46\u540c\u4e00\u884c\u7684\u968f\u673a\u503c\u4f1a\u4e0d\u540c\u3002<\/p>\n\n\n\n \uf06c \u5bf9 NULL \u503c\u4e0d\u505a\u5904\u7406\uff0c\u4f9d\u7136\u663e\u793a\u4e3a NULL\u3002
\uf06c min \u6570\u503c\u5fc5\u987b\u5c0f\u4e8e max<\/p>\n\n\n\n \u8bbe\u7f6e\u65b9\u5f0f\uff1aMASKED WITH(FUNCTION = \u2018RANDOM(XXX,YYYYYY)\u2019)<\/p>\n\n\n\n <\/span>random\u6570\u636e\u7c7b\u578b\u8303\u56f4<\/span><\/h4>\n\n\n\nRandom\u53ea\u5bf9\u6570\u5b57\u7c7b\u578b(int\u7cfb\u5217,decimal\uff09\u6709\u6548\uff0c\u5bf9\u5b57\u7b26\u4e32\uff0c\u65e5\u671f\u7b49\u4f1a\u62a5\u9519\u3002<\/p>\n\n\n\n gbase> create table testMaskRandom(\n -> id int masked with(function='random(1,10)'),\n -> name varchar(100) masked with(function='random(20,30)'),\n -> birth date masked with(function='random(40,50)'),\n -> salary decimal(16,3) masked with(function='random(60,70)'),\n -> luckynumber bigint masked with(function='random(80,90)')\n -> );\nERROR 1210 (HY000): Incorrect arguments to The data type of column 'name' does not support data masking function 'random'.\ngbase><\/code><\/pre>\n\n\n\n<\/span>random\u6837\u4f8b<\/span><\/h4>\n\n\n\nrandom\u6bcf\u6b21\u6267\u884c\u7ed3\u679c\u90fd\u4e0d\u4e00\u6837\u3002 <\/p>\n\n\n\n \u4e0d\u5f71\u54cd\u67e5\u8be2\u6761\u4ef6\u548c\u51fd\u6570\u8ba1\u7b97\u7b49\uff0c\u8131\u654f\u53ea\u5bf9\u6700\u7ec8\u8fd4\u56de\u7684\u7ed3\u679c\u6709\u6548\u3002<\/p>\n\n\n\n \ngbase> create table testMaskRandom(\n -> id int masked with(function='random(1,10)'),\n -> name varchar(100) ,\n -> birth date ,\n -> salary decimal(16,3) masked with(function='random(60,70)'),\n -> luckynumber bigint masked with(function='random(80,90)')\n -> );\nQuery OK, 0 rows affected (Elapsed: 00:00:00.60)\n\ngbase> insert into testMaskRandom values\n -> (1,'First','2001-01-01',1111.111,111111111111),\n -> (2,'Second','2002-02-02',2222.222,222222222222),\n -> (3,'\u5f20\u4e09','2003-03-03',3333.333,333333333333),\n -> (4,'\u674e\u56db','2004-04-04',4444.444,444444444444),\n -> (5,'\u5927\u5200\u738b\u4e94','2005-05-05',5555.555,555555555555);\nQuery OK, 5 rows affected (Elapsed: 00:00:00.58)\nRecords: 5 Duplicates: 0 Warnings: 0\n[gbase@rh6-1 ~]$ gccli -umasked -pmasked -e\"select * from testdb.testmaskrandom\"\n+------+--------------+------------+--------+-------------+\n| id | name | birth | salary | luckynumber |\n+------+--------------+------------+--------+-------------+\n| 6 | First | 2001-01-01 | 66.254 | 84 |\n| 4 | Second | 2002-02-02 | 63.583 | 88 |\n| 8 | \u5f20\u4e09 | 2003-03-03 | 67.809 | 84 |\n| 8 | \u674e\u56db | 2004-04-04 | 67.991 | 85 |\n| 4 | \u5927\u5200\u738b\u4e94 | 2005-05-05 | 68.429 | 83 |\n+------+--------------+------------+--------+-------------+\n[gbase@rh6-1 ~]$ gccli -umasked -pmasked -e\"select * from testdb.testmaskrandom\"\n+------+--------------+------------+--------+-------------+\n| id | name | birth | salary | luckynumber |\n+------+--------------+------------+--------+-------------+\n| 5 | First | 2001-01-01 | 68.080 | 88 |\n| 6 | Second | 2002-02-02 | 61.481 | 82 |\n| 8 | \u5f20\u4e09 | 2003-03-03 | 60.335 | 89 |\n| 5 | \u674e\u56db | 2004-04-04 | 66.832 | 90 |\n| 8 | \u5927\u5200\u738b\u4e94 | 2005-05-05 | 67.511 | 86 |\n+------+--------------+------------+--------+-------------+\n[gbase@rh6-1 ~]$ gccli -umasked -pmasked -e\"select * from testdb.testmaskrandom where salary=1111.111\"\n+------+-------+------------+--------+-------------+\n| id | name | birth | salary | luckynumber |\n+------+-------+------------+--------+-------------+\n| 1 | First | 2001-01-01 | 60.464 | 81 |\n+------+-------+------------+--------+-------------+\n<\/code><\/pre>\n\n\n\n<\/span>PARTIAL \u81ea\u5b9a\u4e49\u7c7b\u578b<\/span><\/h3>\n\n\n\nPARTIAL(prefix,padding,suffix)\uff0c\u6709\u4e09\u4e2a\u53c2\u6570\uff1a<\/p>\n\n\n\n prefix \u8868\u793a\u524d\u7f00\u4fdd\u7559\u663e\u793a\u5b57\u7b26\u6570\u91cf\uff1b
padding \u8868\u793a\u8131\u654f\u663e\u793a\u5b57\u7b26\uff1b
suffix \u8868\u793a\u7ed3\u5c3e\u4fdd\u7559\u663e\u793a\u5b57\u7b26\u6570\u91cf\u3002<\/p>\n\n\n\n \u5982\u679c\u5b9e\u9645\u5185\u5bb9\u957f\u5ea6\u5c0f\u4e8e\u7b49\u4e8eprefix+suffix+length(padding)\u957f\u5ea6\uff0c\u5219\u76f4\u63a5\u663e\u793a padding \u7684\u5b57\u7b26\u5185\u5bb9\u3002<\/p>\n\n\n\n \uf06c \u5bf9 NULL \u4e0d\u505a\u8131\u654f\u5904\u7406\uff0c\u663e\u793a\u4e3a NULL\uff1b
\uf06c prefix \u548c suffix \u4e3a\u5927\u4e8e\u7b49\u4e8e 0 \u7684\u6574\u6570<\/p>\n\n\n\n \u8bbe\u7f6e\u65b9\u5f0f\uff1aMASKED WITH(FUNCTION = \u2018PARTIAL(1,\u201dXXXX\u201d,1)\u2019)<\/p>\n\n\n\n <\/span>partial\u6570\u636e\u7c7b\u578b\u8303\u56f4<\/span><\/h4>\n\n\n\n\u652f\u6301\u5b57\u7b26\u4e32\uff0c\u5bf9\u6570\u5b57\u3001\u65e5\u671f\u7c7b\u578b\uff0c\u4e0d\u652f\u6301\u3002<\/p>\n\n\n\n gbase> create table testMaskPartial(\n -> id int masked with(function='Partial(1,\"#\",1)'),\n -> name varchar(100) masked with(function='Partial(1,\"$\",1)'),\n -> birth date masked with(function='Partial(1,\"%\",1)'),\n -> salary decimal(16,3) masked with(function='Partial(1,\"&\",1)'),\n -> luckynumber bigint masked with(function='Partial(1,\"*\",1)'),\n -> );\nERROR 1210 (HY000): Incorrect arguments to The data type of column 'id' does not support data masking function 'partial'.\ngbase> create table testMaskPartial(\n -> id int ,\n -> name varchar(100) masked with(function='Partial(1,\"$\",1)'),\n -> birth date masked with(function='Partial(1,\"%\",1)'),\n -> salary decimal(16,3) ,\n -> luckynumber bigint\n -> );\nERROR 1210 (HY000): Incorrect arguments to The data type of column 'birth' does not support data masking function 'partial'.\ngbase>\n<\/code><\/pre>\n\n\n\n<\/span>partial\u6837\u4f8b<\/span><\/h4>\n\n\n\ngbase> create table testMaskPartial(\n -> id int ,\n -> name varchar(100) masked with(function='Partial(1,\"$\",1)'),\n -> birth date ,\n -> salary decimal(16,3) ,\n -> luckynumber bigint\n -> );\nQuery OK, 0 rows affected (Elapsed: 00:00:00.80)\n\ngbase> insert into testMaskPartial values\n -> (1,'First','2001-01-01',1111.111,111111111111),\n -> (2,'Second','2002-02-02',2222.222,222222222222),\n -> (3,'\u5f20\u4e09','2003-03-03',3333.333,333333333333),\n -> (4,'\u674e\u56db','2004-04-04',4444.444,444444444444),\n -> (5,'\u5927\u5200\u738b\u4e94','2005-05-05',5555.555,555555555555);\nQuery OK, 5 rows affected (Elapsed: 00:00:00.40)\nRecords: 5 Duplicates: 0 Warnings: 0\n\ngbase> select * from testMaskPartial;\n+------+--------------+------------+----------+--------------+\n| id | name | birth | salary | luckynumber |\n+------+--------------+------------+----------+--------------+\n| 1 | First | 2001-01-01 | 1111.111 | 111111111111 |\n| 2 | Second | 2002-02-02 | 2222.222 | 222222222222 |\n| 3 | \u5f20\u4e09 | 2003-03-03 | 3333.333 | 333333333333 |\n| 4 | \u674e\u56db | 2004-04-04 | 4444.444 | 444444444444 |\n| 5 | \u5927\u5200\u738b\u4e94 | 2005-05-05 | 5555.555 | 555555555555 |\n+------+--------------+------------+----------+--------------+\n5 rows in set (Elapsed: 00:00:00.01)\n\ngbase>\n[gbase@rh6-1 ~]$ gccli -umasked -pmasked -e\"select * from testdb.testmaskpartial\"\n+------+---------+------------+----------+--------------+\n| id | name | birth | salary | luckynumber |\n+------+---------+------------+----------+--------------+\n| 1 | F$t | 2001-01-01 | 1111.111 | 111111111111 |\n| 2 | S$d | 2002-02-02 | 2222.222 | 222222222222 |\n| 3 | $ | 2003-03-03 | 3333.333 | 333333333333 |\n| 4 | $ | 2004-04-04 | 4444.444 | 444444444444 |\n| 5 | \u5927$\u4e94 | 2005-05-05 | 5555.555 | 555555555555 |\n+------+---------+------------+----------+--------------+\n[gbase@rh6-1 ~]$ gccli -umasked -pmasked -e\"select * from testdb.testmaskpartial where name='First'\"\n+------+------+------------+----------+--------------+\n| id | name | birth | salary | luckynumber |\n+------+------+------------+----------+--------------+\n| 1 | F$t | 2001-01-01 | 1111.111 | 111111111111 |\n+------+------+------------+----------+--------------+\n<\/code><\/pre>\n\n\n\n<\/span>SHA \u7c7b\u578b<\/span><\/h3>\n\n\n\n\u505aSHA\u52a0\u5bc6\u8ba1\u7b97\u3002<\/p>\n\n\n\n \u5bf9 NULL \u4e0d\u505a\u5904\u7406\uff0c\u663e\u793a\u4e3a NULL\u3002<\/p>\n\n\n\n \u8bbe\u7f6e\u65b9\u5f0f<\/p>\n\n\n\n MASKED WITH(FUNCTION = \u2018SHA()\u2019)<\/p>\n\n\n\n <\/span>sha\u6570\u636e\u7c7b\u578b\u8303\u56f4<\/span><\/h4>\n\n\n\n\u5b57\u7b26\u4e32\u7c7b\u578b\u3002\u5176\u5b83\u7c7b\u578b\u62a5\u9519\u3002<\/p>\n\n\n\n gbase> create table testMaskSHA(\n -> id int masked with(function='sha()'),\n -> name varchar(100) masked with(function='sha()'),\n -> birth date masked with(function='sha()'),\n -> salary decimal(16,3) masked with(function='sha()'),\n -> luckynumber bigint masked with(function='sha()')\n -> );\nERROR 1210 (HY000): Incorrect arguments to The data type of column 'id' does not support data masking function 'sha'.\ngbase> create table testMaskSHA(\n -> id int ,\n -> name varchar(100) masked with(function='sha()'),\n -> birth date masked with(function='sha()'),\n -> salary decimal(16,3) masked with(function='sha()'),\n -> luckynumber bigint masked with(function='sha()')\n -> );\nERROR 1210 (HY000): Incorrect arguments to The data type of column 'birth' does not support data masking function 'sha'.\ngbase>\n<\/code><\/pre>\n\n\n\n<\/span>sha\u6837\u4f8b<\/span><\/h4>\n\n\n\ngbase> create table testMaskSHA(\n -> id int ,\n -> name varchar(100) masked with(function='sha()'),\n -> birth date ,\n -> salary decimal(16,3) ,\n -> luckynumber bigint\n -> );\nQuery OK, 0 rows affected (Elapsed: 00:00:01.00)\n\ngbase> insert into testMaskSHA values\n -> (1,'First','2001-01-01',1111.111,111111111111),\n -> (2,'Second','2002-02-02',2222.222,222222222222),\n -> (3,'\u5f20\u4e09','2003-03-03',3333.333,333333333333),\n -> (4,'\u674e\u56db','2004-04-04',4444.444,444444444444),\n -> (5,'\u5927\u5200\u738b\u4e94','2005-05-05',5555.555,555555555555);\nQuery OK, 5 rows affected (Elapsed: 00:00:00.35)\nRecords: 5 Duplicates: 0 Warnings: 0\n\ngbase> select * from testMaskSHA;\n+------+--------------+------------+----------+--------------+\n| id | name | birth | salary | luckynumber |\n+------+--------------+------------+----------+--------------+\n| 1 | First | 2001-01-01 | 1111.111 | 111111111111 |\n| 2 | Second | 2002-02-02 | 2222.222 | 222222222222 |\n| 3 | \u5f20\u4e09 | 2003-03-03 | 3333.333 | 333333333333 |\n| 4 | \u674e\u56db | 2004-04-04 | 4444.444 | 444444444444 |\n| 5 | \u5927\u5200\u738b\u4e94 | 2005-05-05 | 5555.555 | 555555555555 |\n+------+--------------+------------+----------+--------------+\n5 rows in set (Elapsed: 00:00:00.02)\n\ngbase> ^CAborted\n[gbase@rh6-1 ~]$ gccli -umasked -pmasked -e\"select * from testdb.testmasksha\"\n+------+------------------------------------------+------------+----------+--------------+\n| id | name | birth | salary | luckynumber |\n+------+------------------------------------------+------------+----------+--------------+\n| 1 | 916a78d701ded328cd66da58a97ef8cd28a99e84 | 2001-01-01 | 1111.111 | 111111111111 |\n| 2 | 2a4bcae654f264daf22579fb462bf0bae302a057 | 2002-02-02 | 2222.222 | 222222222222 |\n| 3 | ced07fb42b05a2ed9efa330250e2bb9175f962ce | 2003-03-03 | 3333.333 | 333333333333 |\n| 4 | b7b286678338a2092572733e23236485d166c0df | 2004-04-04 | 4444.444 | 444444444444 |\n| 5 | 393b73dba6e95c7487be4e175dc1d37ace4a5480 | 2005-05-05 | 5555.555 | 555555555555 |\n+------+------------------------------------------+------------+----------+--------------+\n[gbase@rh6-1 ~]$ gccli -umasked -pmasked -e\"select * from testdb.testmasksha where name='First'\"\n+------+------------------------------------------+------------+----------+--------------+\n| id | name | birth | salary | luckynumber |\n+------+------------------------------------------+------------+----------+--------------+\n| 1 | 916a78d701ded328cd66da58a97ef8cd28a99e84 | 2001-01-01 | 1111.111 | 111111111111 |\n+------+------------------------------------------+------------+----------+--------------+\n[gbase@rh6-1 ~]$\n<\/code><\/pre>\n\n\n\n<\/span>\u81ea\u5b9a\u4e49\u8131\u654f\u51fd\u6570<\/span><\/h3>\n\n\n\nkeymask(substr,padding,pos)<\/p>\n\n\n\n \u529f\u80fd\uff1a\u6307\u5b9a\u5b57\u7b26\u4e3a\u521d\u59cb\u8ba1\u6570\u4f4d\u7f6e\uff0c\u6307\u5b9a\u4f4d\u6570\u5185\u8131\u654f\u529f\u80fd\u3002<\/p>\n\n\n\n <\/span>keymask\u6570\u636e\u7c7b\u578b\u8303\u56f4<\/span><\/h4>\n\n\n\nkeymask\u8131\u654f\u51fd\u6570\u53ea\u7528\u4e8evarchar\/char\u5217\u8fdb\u884c\u8131\u654f\uff0c\u5176\u4ed6\u7c7b\u578b\u5217\u4f7f\u7528\u8be5\u51fd\u6570\u5c06\u62a5\u9519\u8fd4\u56de\u3002<\/p>\n\n\n\n substr\uff1a\u8981\u627e\u5230\u7684\u5b57\u7b26\u4e32
padding\uff1a\u66ff\u6362\u6210\u7684\u5b57\u7b26
pos: 0\/1 \u8986\u76d6\u65b9\u5411\uff0c0\u8868\u793a\u5411\u524d\u8986\u76d6\uff0c1\u8868\u793a\u5411\u540e\u8986\u76d6<\/p>\n\n\n\n <\/span>kekeymask\u6837\u4f8b<\/span><\/h4>\n\n\n\n\u5982\u4e0b\u4f8b\u5b50\u4e2d\uff0cSecond\u5b57\u7b26\u91cc\uff0c\u5148\u627e\u5230con\u7684\u4f4d\u7f6e\uff0c\u7136\u540e\u6309\u7167pos=0\u5411\u524d\u66ff\u6362\u6240\u6709\u5b57\u7b26\u4e3apadding\u7684\u5b57\u7b26#,\u7ed3\u679c\u5c31\u662f#cond<\/p>\n\n\n\n \ngbase> create table testMaskKeymask(\n -> id int ,\n -> name varchar(100) masked with(function='keymask(\"con\",\"#\",0)'),\n -> birth date ,\n -> salary decimal(16,3) ,\n -> luckynumber bigint\n -> );\nQuery OK, 0 rows affected (Elapsed: 00:00:00.87)\n\ngbase> insert into testMaskKeymask values\n -> (1,'First','2001-01-01',1111.111,111111111111),\n -> (2,'Second','2002-02-02',2222.222,222222222222),\n -> (3,'\u5f20\u4e09','2003-03-03',3333.333,333333333333),\n -> (4,'\u674e\u56db','2004-04-04',4444.444,444444444444),\n -> (5,'\u5927\u5200\u738b\u4e94','2005-05-05',5555.555,555555555555);\nQuery OK, 5 rows affected (Elapsed: 00:00:00.37)\nRecords: 5 Duplicates: 0 Warnings: 0\n\ngbase> select * from testMaskKeymask;\n+------+--------------+------------+----------+--------------+\n| id | name | birth | salary | luckynumber |\n+------+--------------+------------+----------+--------------+\n| 1 | First | 2001-01-01 | 1111.111 | 111111111111 |\n| 2 | Second | 2002-02-02 | 2222.222 | 222222222222 |\n| 3 | \u5f20\u4e09 | 2003-03-03 | 3333.333 | 333333333333 |\n| 4 | \u674e\u56db | 2004-04-04 | 4444.444 | 444444444444 |\n| 5 | \u5927\u5200\u738b\u4e94 | 2005-05-05 | 5555.555 | 555555555555 |\n+------+--------------+------------+----------+--------------+\n5 rows in set (Elapsed: 00:00:00.00)\n\ngbase> ^CAborted\n[gbase@rh6-1 ~]$ gccli -umasked -pmasked -e\"select * from testdb.testmaskkeymask where name='Second'\"\n+------+-------+------------+----------+--------------+\n| id | name | birth | salary | luckynumber |\n+------+-------+------------+----------+--------------+\n| 2 | #cond | 2002-02-02 | 2222.222 | 222222222222 |\n+------+-------+------------+----------+--------------+\n[gbase@rh6-1 ~]$ gccli -umasked -pmasked -e\"select * from testdb.testmaskkeymask\"\n+------+--------------+------------+----------+--------------+\n| id | name | birth | salary | luckynumber |\n+------+--------------+------------+----------+--------------+\n| 1 | First | 2001-01-01 | 1111.111 | 111111111111 |\n| 2 | #cond | 2002-02-02 | 2222.222 | 222222222222 |\n| 3 | \u5f20\u4e09 | 2003-03-03 | 3333.333 | 333333333333 |\n| 4 | \u674e\u56db | 2004-04-04 | 4444.444 | 444444444444 |\n| 5 | \u5927\u5200\u738b\u4e94 | 2005-05-05 | 5555.555 | 555555555555 |\n+------+--------------+------------+----------+--------------+\n[gbase@rh6-1 ~]$\n<\/code><\/pre>\n\n\n\n<\/span>\u4fee\u6539\u8131\u654f\u5c5e\u6027<\/span><\/h2>\n\n\n\n\u652f\u6301\u521b\u5efa\u8868\u65f6\u76f4\u63a5\u6307\u5b9a\u8131\u654f\u5217\uff0c\u4e5f\u53ef\u4ee5\u540e\u671f\u968f\u65f6\u4fee\u6539\u8131\u654f\u7b97\u6cd5\u3002\u5982\u679c\u4ee5\u524d\u6ca1\u6709\uff0c\u5219\u65f6\u589e\u52a0\u4e86\u8131\u654f\u5c5e\u6027\u3002<\/p>\n\n\n\n alter table TABLENAME alter \u5217\u540d masked with \u65b0\u7684\u5c5e\u6027\u3002<\/p>\n\n\n\n gbase> alter table testdb.testmasksha alter salary masked with(function='default()');\nQuery OK, 0 rows affected (Elapsed: 00:00:00.57)\n\ngbase> select * from testMaskSHA;\n+------+--------------+------------+----------+--------------+\n| id | name | birth | salary | luckynumber |\n+------+--------------+------------+----------+--------------+\n| 1 | First | 2001-01-01 | 1111.111 | 111111111111 |\n| 2 | Second | 2002-02-02 | 2222.222 | 222222222222 |\n| 3 | \u5f20\u4e09 | 2003-03-03 | 3333.333 | 333333333333 |\n| 4 | \u674e\u56db | 2004-04-04 | 4444.444 | 444444444444 |\n| 5 | \u5927\u5200\u738b\u4e94 | 2005-05-05 | 5555.555 | 555555555555 |\n+------+--------------+------------+----------+--------------+\n5 rows in set (Elapsed: 00:00:00.02)\n\ngbase> ^CAborted\n[gbase@rh6-1 ~]$ gccli -umasked -pmasked -e\"select * from testdb.testmasksha where name='First'\"\n+------+------------------------------------------+------------+--------+--------------+\n| id | name | birth | salary | luckynumber |\n+------+------------------------------------------+------------+--------+--------------+\n| 1 | 916a78d701ded328cd66da58a97ef8cd28a99e84 | 2001-01-01 | 0.000 | 111111111111 |\n+------+------------------------------------------+------------+--------+--------------+\n[gbase@rh6-1 ~]$\n<\/code><\/pre>\n\n\n\n<\/span>\u5220\u9664\u8131\u654f\u5c5e\u6027<\/span><\/h2>\n\n\n\n\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n\n\n\n alter table TABLENAME alter \u5217\u540d drop masked<\/p>\n\n\n\n [gbase@rh6-1 ~]$ gccli testdb\n\nGBase client 8.6.2.43-R28.122445. Copyright (c) 2004-2020, GBase. All Rights Reserved.\n\ngbase> alter table testMaskSHA alter salary drop masked;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.58)\n\ngbase> ^CAborted\n[gbase@rh6-1 ~]$ gccli -umasked -pmasked -e\"select * from testdb.testmaskSHA\"\n+------+------------------------------------------+------------+----------+--------------+\n| id | name | birth | salary | luckynumber |\n+------+------------------------------------------+------------+----------+--------------+\n| 1 | 916a78d701ded328cd66da58a97ef8cd28a99e84 | 2001-01-01 | 1111.111 | 111111111111 |\n| 2 | 2a4bcae654f264daf22579fb462bf0bae302a057 | 2002-02-02 | 2222.222 | 222222222222 |\n| 3 | ced07fb42b05a2ed9efa330250e2bb9175f962ce | 2003-03-03 | 3333.333 | 333333333333 |\n| 4 | b7b286678338a2092572733e23236485d166c0df | 2004-04-04 | 4444.444 | 444444444444 |\n| 5 | 393b73dba6e95c7487be4e175dc1d37ace4a5480 | 2005-05-05 | 5555.555 | 555555555555 |\n+------+------------------------------------------+------------+----------+--------------+\n[gbase@rh6-1 ~]$ gccli testdb\n\nGBase client 8.6.2.43-R28.122445. Copyright (c) 2004-2020, GBase. All Rights Reserved.\n\ngbase> alter table testMaskSHA alter name drop masked;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.30)\n\ngbase> ^CAborted\n[gbase@rh6-1 ~]$ gccli -umasked -pmasked -e\"select * from testdb.testmaskSHA\"\n+------+--------------+------------+----------+--------------+\n| id | name | birth | salary | luckynumber |\n+------+--------------+------------+----------+--------------+\n| 1 | First | 2001-01-01 | 1111.111 | 111111111111 |\n| 2 | Second | 2002-02-02 | 2222.222 | 222222222222 |\n| 3 | \u5f20\u4e09 | 2003-03-03 | 3333.333 | 333333333333 |\n| 4 | \u674e\u56db | 2004-04-04 | 4444.444 | 444444444444 |\n| 5 | \u5927\u5200\u738b\u4e94 | 2005-05-05 | 5555.555 | 555555555555 |\n+------+--------------+------------+----------+--------------+\n[gbase@rh6-1 ~]$\n<\/code><\/pre>\n\n\n\n<\/span>\u51fd\u6570\u6216\u8ba1\u7b97\u8868\u8fbe\u5f0f<\/span><\/h3>\n\n\n\n\u53ea\u8981\u51fd\u6570\u6216\u8868\u8fbe\u5f0f\u4e2d\uff0c\u6709\u8131\u654f\u5217\uff0c\u90a3\u4e48\u5c06\u6309\u7167default\u89c4\u5219\u8fdb\u884c\uff0c\u6570\u5b57\u53d8\u62101\uff0c\u5b57\u7b26\u4e32\u53d8\u6210XXXX,\u65e5\u671f\u53d8\u62101970-01-01<\/p>\n\n\n\n CREATE TABLE \"testmaskrandom\" (\n \"id\" int(11) DEFAULT NULL MASKED WITH(FUNCTION='RANDOM(1,10)'),\n \"name\" varchar(100) DEFAULT NULL,\n \"birth\" date DEFAULT NULL MASKED WITH(FUNCTION='DEFAULT()'),\n \"salary\" decimal(16,3) DEFAULT NULL MASKED WITH(FUNCTION='RANDOM(60,70)'),\n \"luckynumber\" bigint(20) DEFAULT NULL MASKED WITH(FUNCTION='RANDOM(80,90)')\n) \n\n\u6570\u636e\u548c\u524d\u9762\u7684\u5217\u5b50\u4e00\u6837\u3002\n\ngbase> select id,id+1,sin(id),concat(id,'ABC'),birth,date_add(birth,interval 1 day) birth from testmaskrandom;\n+------+------+---------+------------------+------------+------------+\n| id | id+1 | sin(id) | concat(id,'ABC') | birth | birth |\n+------+------+---------+------------------+------------+------------+\n| 4 | 0 | 0 | xxxx | 1900-01-01 | 1900-01-01 |\n| 2 | 0 | 0 | xxxx | 1900-01-01 | 1900-01-01 |\n| 5 | 0 | 0 | xxxx | 1900-01-01 | 1900-01-01 |\n| 8 | 0 | 0 | xxxx | 1900-01-01 | 1900-01-01 |\n| 5 | 0 | 0 | xxxx | 1900-01-01 | 1900-01-01 |\n+------+------+---------+------------------+------------+------------+\n5 rows in set (Elapsed: 00:00:00.02)\n<\/code><\/pre>\n\n\n\n\u8131\u654f\u5217\u51fa\u73b0\u5728\u8868\u8fbe\u5f0f\u6761\u4ef6\u90e8\u5206\uff0c\u4e0d\u4f1a\u5bfc\u81f4\u8131\u654f\u3002<\/p>\n\n\n\n gbase> select id,case when id>=3 then date_add(now(),interval 10 day) else now() end birth from testmaskrandom;\n+------+---------------------+\n| id | birth |\n+------+---------------------+\n| 9 | 2020-12-08 09:08:21 |\n| 10 | 2020-12-08 09:08:21 |\n| 3 | 2020-12-18 09:08:21 |\n| 3 | 2020-12-18 09:08:21 |\n| 7 | 2020-12-18 09:08:21 |\n+------+---------------------+\n5 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<\/span>\u5d4c\u5957\u67e5\u8be2<\/span><\/h2>\n\n\n\n\u5982\u679c\u5d4c\u5957\u5185\u7684\u8868\u8fbe\u5f0f\uff0c\u53ea\u8981\u7ed3\u679c\u91cc\u9762\u5305\u542b\u4e86\u8131\u654f\u7c7b\uff0c\u65e0\u8bba\u6761\u4ef6\u662f\u5426\u547d\u4e2d\uff0c\u90a3\u4e48\u8fd4\u56de\u7ed3\u679c\u7684\u5bf9\u5e94\u5217\uff0c\u5c31\u4f1a\u88ab\u8131\u654f\uff0c\u6309\u7167\u9ed8\u8ba4\u89c4\u5219\u3002 <\/p>\n\n\n\n gbase> select id,id+1,sin(id),concat(id,'ABC'),birth from (select id,case when id>=3 then birth else now() end birth from testmaskrandom)t;\n+------+------+---------+------------------+---------------------+\n| id | id+1 | sin(id) | concat(id,'ABC') | birth |\n+------+------+---------+------------------+---------------------+\n| 2 | 0 | 0 | xxxx | 1900-01-01 00:00:00 |\n| 3 | 0 | 0 | xxxx | 1900-01-01 00:00:00 |\n| 9 | 0 | 0 | xxxx | 1900-01-01 00:00:00 |\n| 9 | 0 | 0 | xxxx | 1900-01-01 00:00:00 |\n| 5 | 0 | 0 | xxxx | 1900-01-01 00:00:00 |\n+------+------+---------+------------------+---------------------+\n5 rows in set (Elapsed: 00:00:00.00)\n\n\u5982\u4e0b\u4f8b\u5b50\u5c06id>3000,\u4e0d\u53ef\u80fd\u547d\u4e2d\uff0c\u4f46\u4f9d\u7136\u88ab\u8131\u654f\uff0c\u56e0\u4e3acase when\u7684\u7ed3\u679c\u90e8\u5206\u6709birth\u3002\n\ngbase> select id,id+1,sin(id),concat(id,'ABC'),birth from (select id,case when id>=3000 then birth else now() end birth from testmaskrandom)t;\n+------+------+---------+------------------+---------------------+\n| id | id+1 | sin(id) | concat(id,'ABC') | birth |\n+------+------+---------+------------------+---------------------+\n| 9 | 0 | 0 | xxxx | 1900-01-01 00:00:00 |\n| 2 | 0 | 0 | xxxx | 1900-01-01 00:00:00 |\n| 7 | 0 | 0 | xxxx | 1900-01-01 00:00:00 |\n| 4 | 0 | 0 | xxxx | 1900-01-01 00:00:00 |\n| 4 | 0 | 0 | xxxx | 1900-01-01 00:00:00 |\n+------+------+---------+------------------+---------------------+\n5 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n\u5982\u679c\u53ea\u51fa\u73b0\u5728\u5d4c\u5957\u67e5\u8be2\u7684\u6761\u4ef6\u90e8\u5206\uff0c\u5219\u4e0d\u5f71\u54cd\u3002\u5982\u4e0bid\u53ea\u51fa\u73b0\u5728case when\u7684\u6761\u4ef6\u90e8\u5206\uff0c\u800c\u7ed3\u679c\u90e8\u5206\u6ca1\u6709\u8131\u654f\u5b57\u6bb5\uff0c\u7ed3\u679c\u5219\u662f\u3010\u4e0d\u8131\u654f\u3011\u7684\u3002<\/p>\n\n\n\n gbase> select id,id+1,sin(id),concat(id,'ABC'),birth from (select id,case when id>=3 then date_add(now(),interval 10 day) else now() end birth from testmaskrandom)t;\n+------+------+---------+------------------+---------------------+\n| id | id+1 | sin(id) | concat(id,'ABC') | birth |\n+------+------+---------+------------------+---------------------+\n| 7 | 0 | 0 | xxxx | 2020-12-08 09:06:58 |\n| 7 | 0 | 0 | xxxx | 2020-12-08 09:06:58 |\n| 1 | 0 | 0 | xxxx | 2020-12-18 09:06:58 |\n| 3 | 0 | 0 | xxxx | 2020-12-18 09:06:58 |\n| 2 | 0 | 0 | xxxx | 2020-12-18 09:06:58 |\n+------+------+---------+------------------+---------------------+\n5 rows in set (Elapsed: 00:00:00.02)<\/code><\/pre>\n\n\n\n
|