Encrypted Functions and Operators
byteawithoutorderwithequalcolin(cstring)
Description: Converts input data to the internal byteawithoutorderwithequalcol format.
Parameter type: cstring
Return type: byteawithoutorderwithequalcol
byteawithoutorderwithequalcolout(byteawithoutorderwithequalcol)
Description: Converts the internal byteawithoutorderwithequalcol type into the cstring type.
Parameter type: byteawithoutorderwithequalcol
Return type: cstring
byteawithoutorderwithequalcolsend(byteawithoutorderwithequalcol)
Description: Converts the byteawithoutorderwithequalcol type into the bytea type.
Parameter type: byteawithoutorderwithequalcol
Return type: bytea
byteawithoutorderwithequalcolrecv(internal)
Description: Converts the internal type into the byteawithoutorderwithequalcol type.
Parameter type: internal
Return type: byteawithoutorderwithequalcol
byteawithoutorderwithequalcoltypmodin(cstring[])
Description: Converts the cstring[] type into the byteawithoutorderwithequalcol type.
Parameter type: cstring[]
Return type: int4
byteawithoutorderwithequalcoltypmodout(int4)
Description: Converts the int4 type into the cstring type.
Parameter type: int4
Return type: cstring
byteawithoutordercolin(cstring)
Description: Converts the input data into the internal byteawithoutordercolin type.
Parameter type: cstring
Return type: byteawithoutordercol
byteawithoutordercolout(byteawithoutordercol)
Description: Converts the internal byteawithoutordercol type into the cstring type.
Parameter type: byteawithoutordercol
Return type: cstring
byteawithoutordercolsend(byteawithoutordercol)
Description: Converts the byteawithoutordercol type into the bytea type.
Parameter type: byteawithoutordercol
Return type: bytea
byteawithoutordercolrecv(internal)
Description: Converts the internal type into the byteawithoutordercol type.
Parameter type: internal
Return type: byteawithoutordercol
byteawithoutorderwithequalcolcmp(byteawithoutorderwithequalcol, byteawithoutorderwithequalcol)
Description: Compares two byteawithoutorderwithequalcol parameters. If the first parameter is less than the second, the function will return -1. If the first parameter is greater, the function will return 1. If the parameters are equal, the function will return 0.
Parameter type: byteawithoutorderwithequalcol, byteawithoutorderwithequalcol
Return type: int4
byteawithoutorderwithequalcolcmpbytear(byteawithoutorderwithequalcol, bytea)
Description: Compares a byteawithoutorderwithequalcol parameter with a bytea parameter. If the first parameter is less than the second, the function will return -1. If the first parameter is greater, the function will return 1. If the parameters are equal, the function will return 0.
Parameter type: byteawithoutorderwithequalcol, bytea
Return type: int4
byteawithoutorderwithequalcolcmpbyteal(bytea, byteawithoutorderwithequalcol)
Description: Compares a bytea parameter with a byteawithoutorderwithequalcol parameter. If the first parameter is less than the second, the function will return -1. If the first parameter is greater, the function will return 1. If the parameters are equal, the function will return 0.
Parameter type: bytea, byteawithoutorderwithequalcol
Return type: int4
byteawithoutorderwithequalcoleq(byteawithoutorderwithequalcol, byteawithoutorderwithequalcol)
Description: Checks whether two byteawithoutorderwithequalcol parameters are the same. If so, the function will return true. If not, the function will return false.
Parameter type: byteawithoutorderwithequalcol, byteawithoutorderwithequalcol
Return type: Boolean
byteawithoutorderwithequalcoleqbyteal(bytea, byteawithoutorderwithequalcol)
Description: Checks whether a bytea parameter is the same as a byteawithoutorderwithequalcol parameter. If so, the function will return true. If not, the function will return false.
Parameter type: bytea, byteawithoutorderwithequalcol
Return type: Boolean
byteawithoutorderwithequalcoleqbytear(byteawithoutorderwithequalcol, bytea)
Description: Checks whether a byteawithoutorderwithequalcol parameter is the same as a bytea parameter. If so, the function will return true. If not, the function will return false.
Parameter type: byteawithoutorderwithequalcol, bytea
Return type: Boolean
byteawithoutorderwithequalcolne(byteawithoutorderwithequalcol, byteawithoutorderwithequalcol)
Description: Checks whether two byteawithoutorderwithequalcol parameters are different. If so, the function will return true. If not, the function will return false.
Parameter type: byteawithoutorderwithequalcol, byteawithoutorderwithequalcol
Return type: Boolean
byteawithoutorderwithequalcolnebyteal(bytea, byteawithoutorderwithequalcol)
Description: Checks whether a bytea parameter is the same as a byteawithoutorderwithequalcol parameter. If so, the function will return true. If not, the function will return false.
Parameter type: bytea, byteawithoutorderwithequalcol
Return type: Boolean
byteawithoutorderwithequalcolnebytear(byteawithoutorderwithequalcol, bytea)
Description: Checks whether a byteawithoutorderwithequalcol parameter is the same as a bytea parameter. If so, the function will return true. If not, the function will return false.
Parameter type: byteawithoutorderwithequalcol, bytea
Return type: Boolean
hll_hash_byteawithoutorderwithequalcol(byteawithoutorderwithequalcol)
Description: Returns the hll hash value of byteawithoutorderwithequalcol.
Parameter type: byteawithoutorderwithequalcol
Return type: hll_hashval
tee_lt(byteawithoutorderwithequalcol, byteawithoutorderwithequalcol)
Description: Checks whether a byteawithoutorderwithequalcol parameter is less than another byteawithoutorderwithequalcol parameter. If so, the function will return true. If not, the function will return false. This function is not supported in distributed mode.
Parameter type: byteawithoutorderwithequalcol, byteawithoutorderwithequalcol
Return type: Boolean
tee_gt(byteawithoutorderwithequalcol, byteawithoutorderwithequalcol)
Description: Checks whether a byteawithoutorderwithequalcol parameter is greater than another byteawithoutorderwithequalcol parameter. If so, the function will return true. If not, the function will return false. This function is not supported in distributed mode.
Parameter type: byteawithoutorderwithequalcol, byteawithoutorderwithequalcol
Return type: Boolean
tee_le(byteawithoutorderwithequalcol, byteawithoutorderwithequalcol)
Description: Checks whether a byteawithoutorderwithequalcol parameter is less than or equal to another byteawithoutorderwithequalcol parameter. If so, the function will return true. If not, the function will return false. This function is not supported in distributed mode.
Parameter type: byteawithoutorderwithequalcol, byteawithoutorderwithequalcol
Return type: Boolean
tee_ge(byteawithoutorderwithequalcol, byteawithoutorderwithequalcol)
Description: Checks whether a byteawithoutorderwithequalcol parameter is greater than or equal to another byteawithoutorderwithequalcol parameter. If so, the function will return true. If not, the function will return false. This function is not supported in distributed mode.
Parameter type: byteawithoutorderwithequalcol, byteawithoutorderwithequalcol
Return type: Boolean
tee_like(byteawithoutorderwithequalcol, byteawithoutorderwithequalcol)
Description: Checks whether byteawithoutorderwithequalcol parameters can be fuzzily matched. If so, the function will return true. If not, the function will return false. This function is not supported in distributed mode.
Parameter type: byteawithoutorderwithequalcol, byteawithoutorderwithequalcol
Return type: Boolean
tee_nlike(byteawithoutorderwithequalcol, byteawithoutorderwithequalcol)
Description: Checks whether byteawithoutorderwithequalcol parameters cannot be fuzzily matched. If so, the function will return true. If not, the function will return false. This function is not supported in distributed mode.
Parameter type: byteawithoutorderwithequalcol, byteawithoutorderwithequalcol
Return type: Boolean
tee_calculation(byteawithoutorderwithequalcol, byteawithoutorderwithequalcol)
Description: General function for mathematical operations between byteawithoutorderwithequalcol types. This function is not supported in distributed mode.
Parameter type: byteawithoutorderwithequalcol, byteawithoutorderwithequalcol
Return type: byteawithoutorderwithequalcol
tee_sortsupport(internal)
Description: Function used to support sorting, which is internally called during sorting and is not supported in the current version.
Parameter type: internal
Return type: void
teegtsel(internal, oid, internal, integer)
Description: Selectivity of ciphertext greater than and greater than or equal to. The default value 0.3333333333333333 is returned. This function cannot be called by common users.
Parameter type: internal, oid, internal, integer
Return type: double precision
teeltsel(internal, oid, internal, integer)
Description: Selectivity of ciphertext less than and less than or equal to. The default value 0.3333333333333333 is returned. This function cannot be called by common users.
Parameter type: internal, oid, internal, integer
Return type: double precision
teelikesel(internal, oid, internal, integer)
Description: Selectivity of ciphertext fuzzy match. The default value 0.005 is returned. This function cannot be called by common users.
Parameter type: internal, oid, internal, integer
Return type: double precision
teenlikesel(internal, oid, internal, integer)
Description: Selectivity of ciphertext non-fuzzy-match. The default value 0.005 is returned. This function cannot be called by common users.
Parameter type: internal, oid, internal, integer
Return type: double precision
sum(byteawithoutorderwithequalcol)
Description: Aggregates the ciphertext sum. It is not supported in the current version.
Parameter type: byteawithoutorderwithequalcol
Return type: byteawithoutorderwithequalcol
avg(byteawithoutorderwithequalcol)
Description: Aggregates the ciphertext average value. It is not supported in the current version.
Parameter type: byteawithoutorderwithequalcol
Return type: byteawithoutorderwithequalcol
min(byteawithoutorderwithequalcol)
Description: Aggregates the ciphertext minimum value. It is not supported in the current version.
Parameter type: byteawithoutorderwithequalcol
Return type: byteawithoutorderwithequalcol
max(byteawithoutorderwithequalcol)
Description: Aggregates the ciphertext maximum value. It is not supported in the current version.
Parameter type: byteawithoutorderwithequalcol
Return type: byteawithoutorderwithequalcol
stddev_samp(byteawithoutorderwithequalcol)
Description: Aggregates the standard deviation of ciphertext samples. It is not supported in the current version.
Parameter type: byteawithoutorderwithequalcol
Return type: byteawithoutorderwithequalcol
stddev_pop(byteawithoutorderwithequalcol)
Description: Aggregates the total standard deviation of ciphertext. It is not supported in the current version.
Parameter type: byteawithoutorderwithequalcol
Return type: byteawithoutorderwithequalcol
var_samp(byteawithoutorderwithequalcol)
Description: Aggregates the variance of ciphertext samples. It is not supported in the current version.
Parameter type: byteawithoutorderwithequalcol
Return type: byteawithoutorderwithequalcol
var_pop(byteawithoutorderwithequalcol)
Description: Aggregates the total variance of ciphertext. It is not supported in the current version.
Parameter type: byteawithoutorderwithequalcol
Return type: byteawithoutorderwithequalcol
tee_trans(byteawithoutorderwithequalcol, byteawithoutorderwithequalcol)
Description: Aggregates the internal processing function for ciphertext. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol, byteawithoutorderwithequalcol
Return type: byteawithoutorderwithequalcol
tee_collect(byteawithoutorderwithequalcol, byteawithoutorderwithequalcol)
Description: Aggregates the internal processing function for ciphertext. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol, byteawithoutorderwithequalcol
Return type: byteawithoutorderwithequalcol
tee_final(byteawithoutorderwithequalcol)
Description: Aggregates the internal processing function for ciphertext. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol
Return type: byteawithoutorderwithequalcol
security_tee_process()
Description: Manages the computational state in a secret trusted domain. It is not supported in the current version.
Parameter type: int
Return type: Boolean
ce_encrypt_deterministic(text, oid)
Description: Encrypts the plaintext of the TEXT type to the encrypted equivalent structure. The key OID is the value of column_key_distributed_id in the gs_column_keys system catalog. This function is not supported in the current version.
Parameter type: text, oid
Return type: byteawithoutorderwithequalcol
ce_encrypt_deterministic(int1, oid)
Description: Encrypts the plaintext of the int1 type to the encrypted equivalent structure. The key OID is the value of column_key_distributed_id in the gs_column_keys system catalog. This function is not supported in the current version.
Parameter type: int1, oid
Return type: byteawithoutorderwithequalcol
ce_encrypt_deterministic(int2, oid)
Description: Encrypts the plaintext of the int2 type to the encrypted equivalent structure. The key OID is the value of column_key_distributed_id in the gs_column_keys system catalog. This function is not supported in the current version.
Parameter type: int2, oid
Return type: byteawithoutorderwithequalcol
ce_encrypt_deterministic(int4, oid)
Description: Encrypts the plaintext of the int4 type to the encrypted equivalent structure. The key OID is the value of column_key_distributed_id in the gs_column_keys system catalog. This function is not supported in the current version.
Parameter type: int4, oid
Return type: byteawithoutorderwithequalcol
ce_encrypt_deterministic(int8, oid)
Description: Encrypts the plaintext of the int8 type to the encrypted equivalent structure. The key OID is the value of column_key_distributed_id in the gs_column_keys system catalog. This function is not supported in the current version.
Parameter type: int8, oid
Return type: byteawithoutorderwithequalcol
ce_encrypt_deterministic(float4, oid)
Description: Encrypts the plaintext of the float4 type to the encrypted equivalent structure. The key OID is the value of column_key_distributed_id in the gs_column_keys system catalog. This function is not supported in the current version.
Parameter type: float4, oid
Return type: byteawithoutorderwithequalcol
ce_encrypt_deterministic(float8, oid)
Description: Encrypts the plaintext of the float8 type to the encrypted equivalent structure. The key OID is the value of column_key_distributed_id in the gs_column_keys system catalog. This function is not supported in the current version.
Parameter type: float8, oid
Return type: byteawithoutorderwithequalcol
ce_encrypt_deterministic(numeric, oid)
Description: Encrypts the plaintext of the numeric type to the encrypted equivalent structure. The key OID is the value of column_key_distributed_id in the gs_column_keys system catalog. This function is not supported in the current version.
Parameter type: numeric, oid
Return type: byteawithoutorderwithequalcol
ce_encrypt_deterministic(clob, oid)
Description: Encrypts the plaintext of the CLOB type to the encrypted equivalent structure. The key OID is the value of column_key_distributed_id in the gs_column_keys system catalog. This function is not supported in the current version.
Parameter type: clob, oid
Return type: byteawithoutorderwithequalcol
ce_encrypt_deterministic(varchar, oid)
Description: Encrypts the plaintext of the varchar type to the encrypted equivalent structure. The key OID is the value of column_key_distributed_id in the gs_column_keys system catalog. This function is not supported in the current version.
Parameter type: varchar, oid
Return type: byteawithoutorderwithequalcol
ce_encrypt_deterministic(nvarchar2, oid)
Description: Encrypts the plaintext of the nvarchar2 type to the encrypted equivalent structure. The key OID is the value of column_key_distributed_id in the gs_column_keys system catalog. This function is not supported in the current version.
Parameter type: nvarchar2, oid
Return type: byteawithoutorderwithequalcol
ce_encrypt_deterministic(bpchar, oid)
Description: Encrypts the plaintext of the bpchar type to the encrypted equivalent structure. The key OID is the value of column_key_distributed_id in the gs_column_keys system catalog. This function is not supported in the current version.
Parameter type: bpchar, oid
Return type: byteawithoutorderwithequalcol
ce_encrypt_deterministic(bytea, oid)
Description: Encrypts the plaintext of the bytea type to the encrypted equivalent structure. The key OID is the value of column_key_distributed_id in the gs_column_keys system catalog. This function is not supported in the current version.
Parameter type: bytea, oid
Return type: byteawithoutorderwithequalcol
ce_decrypt_deterministic(byteawithoutorderwithequalcol, oid)
Description: Decrypts the ciphertext of the encrypted equivalent structure to the plaintext data of the text type. The key OID is the value of column_key_distributed_id in the gs_column_keys system catalog. This function is not supported in the current version.
Parameter type: byteawithoutorderwithequalcol, oid
Return type: text
The following functions starting with ce_encrypt/ce_decrypt exist in the pg_catalog namespace.
ce_encrypt_text(text, int4, boolean, int4, internal)
Description: Encryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: text, int4, Boolean, int4, internal
Return type: byteawithoutorderwithequalcol
ce_encrypt_varchar(varchar, int4, boolean, int4, internal)
Description: Encryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: varchar, int4, Boolean, int4, internal
Return type: byteawithoutorderwithequalcol
ce_encrypt_nvarchar2(nvarchar2, int4, boolean, int4, internal)
Description: Encryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: nvarchar2, int4, Boolean, int4, internal
Return type: byteawithoutorderwithequalcol
ce_encrypt_bpchar(bpchar, int4, boolean, int4, internal)
Description: Encryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: bpchar, int4, Boolean, int4, internal
Return type: byteawithoutorderwithequalcol
ce_encrypt_int1(int1, int4, boolean, int4, internal)
Description: Encryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: int1, int4, Boolean, int4, internal
Return type: byteawithoutorderwithequalcol
ce_encrypt_int2(int2, int4, boolean, int4, internal)
Description: Encryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: int2, int4, Boolean, int4, internal
Return type: byteawithoutorderwithequalcol
ce_encrypt_int4(int4, int4, boolean, int4, internal)
Description: Encryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: int4, int4, Boolean, int4, internal
Return type: byteawithoutorderwithequalcol
ce_encrypt_int8(int8, int4, boolean, int4, internal)
Description: Encryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: int8, int4, Boolean, int4, internal
Return type: byteawithoutorderwithequalcol
ce_encrypt_float4(float4, int4, boolean, int4, internal)
Description: Encryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: float4, int4, Boolean, int4, internal
Return type: byteawithoutorderwithequalcol
ce_encrypt_float8(float8, int4, boolean, int4, internal)
Description: Encryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: float8, int4, Boolean, int4, internal
Return type: byteawithoutorderwithequalcol
ce_encrypt_numeric(numeric, int4, boolean, int4, internal)
Description: Encryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: numeric, int4, Boolean, int4, internal
Return type: byteawithoutorderwithequalcol
ce_encrypt_bytea(bytea, int4, boolean, int4, internal)
Description: Encryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: bytea, int4, Boolean, int4, internal
Return type: byteawithoutorderwithequalcol
ce_encrypt_clob(clob, int4, boolean, int4, internal)
Description: Encryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: clob, int4, Boolean, int4, internal
Return type: byteawithoutorderwithequalcol
ce_decrypt_text(byteawithoutorderwithequalcol, int4, boolean, int4, internal)
Description: Decryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol, int4, Boolean, int4, internal
Return type: text
ce_decrypt_varchar(byteawithoutorderwithequalcol, int4, boolean, int4, internal)
Description: Decryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol, int4, Boolean, int4, internal
Return type: varchar
ce_decrypt_nvarchar2(byteawithoutorderwithequalcol, int4, boolean, int4, internal)
Description: Decryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol, int4, Boolean, int4, internal
Return type: nvarchar2
ce_decrypt_bpchar(byteawithoutorderwithequalcol, int4, boolean, int4, internal)
Description: Decryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol, int4, Boolean, int4, internal
Return type: bpchar
ce_decrypt_int1(byteawithoutorderwithequalcol, int4, boolean, int4, internal)
Description: Decryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol, int4, Boolean, int4, internal
Return type: int1
ce_decrypt_int2(byteawithoutorderwithequalcol, int4, boolean, int4, internal)
Description: Decryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol, int4, Boolean, int4, internal
Return type: int2
ce_decrypt_int4(byteawithoutorderwithequalcol, int4, boolean, int4, internal)
Description: Decryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol, int4, Boolean, int4, internal
Return type: int4
ce_decrypt_int8(byteawithoutorderwithequalcol, int4, boolean, int4, internal)
Description: Decryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol, int4, Boolean, int4, internal
Return type: int8
ce_decrypt_float4(byteawithoutorderwithequalcol, int4, boolean, int4, internal)
Description: Decryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol, int4, Boolean, int4, internal
Return type: float4
ce_decrypt_float8(byteawithoutorderwithequalcol, int4, boolean, int4, internal)
Description: Decryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol, int4, Boolean, int4, internal
Return type: float8
ce_decrypt_numeric(byteawithoutorderwithequalcol, int4, boolean, int4, internal)
Description: Decryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol, int4, Boolean, int4, internal
Return type: numeric
ce_decrypt_bytea(byteawithoutorderwithequalcol, int4, boolean, int4, internal)
Description: Decryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol, int4, Boolean, int4, internal
Return type: bytea
ce_decrypt_clob(byteawithoutorderwithequalcol, int4, boolean, int4, internal)
Description: Decryption function for fully-encrypted type conversion. This function cannot be called by common users.
Parameter type: byteawithoutorderwithequalcol, int4, Boolean, int4, internal
Return type: CLOB
Example
Encrypted equality functions such as byteawithoutorderwithequalcolin and byteawithoutorderwithequalcolout are read/write format conversion functions such as in, out, send, and recv specified by the data type byteawithoutorderwithequalcol in the database kernel. For details, see the byteain and byteaout functions of the bytea type. However, the local CEK is verified, and the function can be successfully executed only when the encrypted column contains a cekoid that exists on the localhost.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
-- For example, if the int_type encrypted table exists, int_col2 is the encrypted column. -- Use a non-encrypted client to connect to the database and query the ciphertext of the encrypted column. gaussdb=# SELECT int_col2 FROM int_type; int_col2 ------------------------------------------------------------------------------------------------------------------------------------------------------ \x01c35301bf421c8edf38c34704bcc82838742917778ccb402a1b7452ad4a6ac7371acc0ac33100000035fe3424919854c86194f1aa5bb4e1ca656e8fc6d05324a1419b69f488bdc3c6 (1 row) -- The ciphertext of the encrypted column is used as the input parameter of byteawithoutorderwithequalcolin. The format is converted from cstring to byteawithoutorderwithequalcol. gaussdb=# SELECT byteawithoutorderwithequalcolin('\x01c35301bf421c8edf38c34704bcc82838742917778ccb402a1b7452ad4a6ac7371acc0ac33100000035fe3424919854c86194f1aa5bb4e1ca656e8fc6d05324a1419b69f488bdc3c6'); byteawithoutorderwithequalcolin ------------------------------------------------------------------------------------------------------------------------------------------------------ \x01c35301bf421c8edf38c34704bcc82838742917778ccb402a1b7452ad4a6ac7371acc0ac33100000035fe3424919854c86194f1aa5bb4e1ca656e8fc6d05324a1419b69f488bdc3c6 (1 row) |
Implementations such as byteawithoutorderwithequalcolin search for CEK and determine whether it is a normal encrypted data type.
Therefore, if the input data is not in an encrypted format and the CEK does not exist on the localhost, an error will be reported.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
gaussdb=# SELECT * FROM byteawithoutorderwithequalcolsend('\x907219912381298461289346129'::byteawithoutorderwithequalcol); ERROR: cek with OID 596711794 not found LINE 1: SELECT * FROM byteawithoutorderwithequalcolsend('\x907219912... ^ gaussdb=# SELECT * FROM byteawithoutordercolout('\x90721901999999999999912381298461289346129'); ERROR: cek with OID 2566986098 not found LINE 1: SELECT * FROM byteawithoutordercolout('\x9072190199999999999... gaussdb=# SELECT * FROM byteawithoutorderwithequalcolrecv('\x90721901999999999999912381298461289346129'::byteawithoutorderwithequalcol); ERROR: cek with OID 2566986098 not found ^ gaussdb=# SELECT * FROM byteawithoutorderwithequalcolsend('\x90721901999999999999912381298461289346129'::byteawithoutorderwithequalcol); ERROR: cek with OID 2566986098 not found LINE 1: SELECT * FROM byteawithoutorderwithequalcolsend('\x907219019... ^ |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
