DROP USER IF EXISTS test CASCADE;
CREATE USER test WITH CREATEDB PASSWORD "Gauss@123";
SET ROLE test PASSWORD 'Gauss@123';
\! gs_ktool -d all
\! gs_ktool -g

\! @abs_bindir@/../jre/bin/java -cp $CLASSPATH:@abs_builddir@/jdbc_client_lib/gsjdbc4.jar:@abs_builddir@/jdbc_ce_test/ce_ddl_pbe/. ClientEncryptionTriggerTest @portstring@ > /dev/null 2>&1

SELECT global_key_name, key_namespace, key_owner FROM gs_client_global_keys;

SELECT column_key_name,  key_namespace, key_owner FROM gs_column_keys;

SELECT column_name, encryption_type, data_type_original_oid FROM gs_encrypted_columns;

--支持
select count(*) from test_trigger_src_tbl;
select count(*) from test_trigger_des_tbl;

DROP TABLE IF EXISTS test_trigger_src_tbl;
DROP TABLE IF EXISTS test_trigger_des_tbl;

DROP CLIENT MASTER KEY triggerCMK CASCADE;

select  count(*), 'count' FROM gs_client_global_keys;
select  count(*), 'count' FROM gs_column_keys;
SELECT  count(*), 'count' FROM gs_encrypted_columns;
\! gs_ktool -d all

RESET ROLE;
DROP USER IF EXISTS test CASCADE;