GBase 8c SQL 参考手册 南大通用数据技术股份有限公司 382 参数类型:byteawithoutorderwithequalcol, byteawithoutorderwithequalcol 返回值类型:bool byteawithoutorderwithequalcolnebyteal(bytea, byteawithoutorderwithequalcol) 描述:比较bytea 和byteawithoutorderwithequalcol 数据是否相同,相同则返回true,否 则返回false。 参数类型:bytea,byteawithoutorderwithequalcol 返回值类型:bool byteawithoutorderwithequalcolnebytear(byteawithoutorderwithequalcol, bytea) 描述:比较byteawithoutorderwithequalcol 和bytea 数据是否不相同,相同则返回true, 否则返回false。 参数类型:byteawithoutorderwithequalcol, bytea 返回值类型:bool hll_hash_byteawithoutorderwithequalcol(byteawithoutorderwithequalcol) 描述:返回byteawithoutorderwithequalcol 的hll 哈希值。 参数类型:byteawithoutorderwithequalcol 返回值类型:hll_hashval 由于byteawithoutorderwithequalcolin 的实现会对cek 进行查找,并且判断是否为正常加 密后的数据类型。 因此如果用户输入数据的格式不为加密后的数据格式, 并且在本地不存在 对应cek 的情况下,会返回错误。 gbase=# SELECT * FROM byteawithoutorderwithequalcolsend('\x907219912381298461289346129'::byteawith outorderwithequalcol); ERROR: cek with OID 596711794 not found LINE 1: SELECT * FROM byteawithoutorderwithequalcolsend('\x907219912... ^
GBase 8c SQL 参考手册 南大通用数据技术股份有限公司 383 gbase=# SELECT * FROM byteawithoutordercolout('\x90721901999999999999912381298461289346129'); ERROR: cek with OID 2566986098 not found LINE 1: SELECT * FROM byteawithoutordercolout('\x9072190199999999999... ^ gbase=# SELECT * FROM byteawithoutorderwithequalcolrecv('\x907219019999999999999123812984612893461 29'::byteawithoutorderwithequalcol); ERROR: cek with OID 2566986098 not found LINE 1: SELECT * FROM byteawithoutorderwithequalcolrecv('\x907219019... ^ gbase=# SELECT * FROM byteawithoutorderwithequalcolsend('\x907219019999999999999123812984612893461 29'::byteawithoutorderwithequalcol); ERROR: cek with OID 2566986098 not found LINE 1: SELECT * FROM byteawithoutorderwithequalcolsend('\x907219019... ^