返回首页

gbase数据、南大通用产品文档:GBase8c内部类型处理函数

更新日期:2024年09月11日

abstimerecv
euc_jis_2
004_to_ut
f8
int2recv
line_rec
v
oidvectorrecv_
extend
tidrecv
utf8_to_k
oi8u
anyarray_recv
euc_jp_to
_mic
int2vecto
rrecv
lseg_rec
v
path_recv
time_recv
utf8_to_s
hift_jis_2
004
array_recv
euc_jp_to
_sjis
int4recv
macaddr
_recv
pg_node_tree_
recv
time_transf
orm
utf8_to_sj
is
ascii_to_mic
euc_jp_to
_utf8
int8recv
mic_to_
ascii
point_recv
timestamp_
recv
utf8_to_u
hc
ascii_to_utf8
euc_kr_to
_mic
internal_
out
mic_to_
big5
poly_recv
timestamp_
transform
utf8_to_w
in
big5_to_euc_tw
euc_kr_to
_utf8
interval_r
ecv
mic_to_
euc_cn
pound_nexttok
en
timestampt
z_recv
uuid_recv
big5_to_mic
euc_tw_t
o_big5
interval_t
ransform
mic_to_
euc_jp
prsd_nexttoke
n
timetz_rec
v
varbit_rec
v
big5_to_utf8
euc_tw_t
o_mic
iso_to_ko
i8r
mic_to_
euc_kr
range_recv
tintervalrec
v
varbit_tra
nsform
bit_recv
euc_tw_t
o_utf8
iso_to_mi
c
mic_to_
euc_tw
rawrecv
tsqueryrecv
varchar_tr
ansform
boolrecv
float4recv
iso_to_wi
n1251
mic_to_i
so
record_recv
tsvectorrec
v
varcharrec
v
box_recv
float8recv
iso_to_wi
n866
mic_to_
koi8r
regclassrecv
txid_snaps
hot_recv
void_recv
bpcharrecv
gb18030_
to_utf8
iso8859_
1_to_utf8
mic_to_l
atin1
regconfigrecv
uhc_to_utf
8
win_to_ut
f8
btoidsortsupport
gbk_to_ut
f8
iso8859_t
o_utf8
mic_to_l
atin2
regdictionaryr
ecv
unknownre
cv
win1250_
to_latin2

GBase 8c SQL 参考手册
南大通用数据技术股份有限公司
586
bytearecv
gin_extra
ct_tsvecto
r
johab_to_
utf8
mic_to_l
atin3
regoperatorrec
v
utf8_to_asc
ii
win1250_
to_mic
byteawithoutord
erwithequalcolr
ecv
gtsvector
_compres
s
json_recv
mic_to_l
atin4
regoperrecv
utf8_to_big
5
win1251_
to_iso
cash_recv
gtsvector
_consiste
nt
koi8r_to_
iso
mic_to_
sjis
regprocedurer
ecv
utf8_to_eu
c_cn
win1251_
to_koi8r
charrecv
gtsvector
_decompr
ess
koi8r_to_
mic
mic_to_
win1250
regprocrecv
utf8_to_eu
c_jis_2004
win1251_
to_mic
cidr_recv
gtsvector
_penalty
koi8r_to_
utf8
mic_to_
win1251
regtyperecv
utf8_to_eu
c_jp
win1251_
to_win86
6
cidrecv
gtsvector
_picksplit
koi8r_to_
win1251
mic_to_
win866
reltimerecv
utf8_to_eu
c_kr
win866_t
o_iso
circle_recv
gtsvector
_same
koi8r_to_
win866
namerec
v
shift_jis_2004
_to_euc_jis_2
004
utf8_to_eu
c_tw
win866_t
o_koi8r
cstring_recv
gtsvector
_union
koi8u_to
_utf8
ngram_n
exttoken
shift_jis_2004
_to_utf8
utf8_to_gb
18030
win866_t
o_mic
date_recv
hll_recv
latin1_to
_mic
numeric
_recv
sjis_to_euc_jp
utf8_to_gb
k
win866_t
o_win125
1
domain_recv
hll_trans_
recv
latin2_to
_mic
numeric
_transfo
rm
sjis_to_mic
utf8_to_iso
8859
xidrecv
euc_cn_to_mic
hstore_re
cv
latin2_to
_win1250
nvarchar
2recv
sjis_to_utf8
utf8_to_iso
8859_1
xidrecv4
euc_cn_to_utf8
inet_recv
latin3_to
_mic
oidrecv
smalldatetime
_recv
utf8_to_joh
ab
xml_recv

GBase 8c SQL 参考手册
南大通用数据技术股份有限公司
587
euc_jis_2004_to
_shift_jis_2004
int1recv
latin4_to
_mic
oidvecto
rrecv
textrecv
utf8_to_koi
8r
cstore_tid
_out
i16toi1
int16
int16_bo
ol
int16eq
int16div
int16ge
int16gt
int16in
int16le
int16lt
int16mi
int16mul
int16ne
int16out
int16pl
int16recv
int16send
numeric
_bool
int2vectorin_e
xtend
int2vectoro
ut_extend
int2vector
recv_exte
nd
int2vectorsend_
extend
jsonb_in
jsonb_out
jsonb_re
cv
jsonb_send
complex_a
rray_in
bool_int1
bool_int2
bool_int8
bpchar_fl
oat4
bpchar_f
loat8
bpchar_int4
bpchar_int
8
bpchar_nu
meric
bpchar_timesta
mp
f4toi1
f8toi1
float4_b
pchar
float4_text
float4_varc
har
float8_bp
char
float8_text
float8_var
char
i1tof4
i1tof8
i1toi2
i1toi4
i1toi8
i2toi1
i4toi1
i8toi1
int1_avg
_accum
int1_bool
int1_bpcha
r
int1_num
eric
int1_nvarchar2
int1_text
int1_varc
har
int1abs
int1and
int1cmp
int1div
int1eq
int1ge
int1gt
int1in
int1inc
int1larger
int1le
int1lt
int1mi
int1mod
int1mul
int1ne
int1not
int1or
int1out
int1pl
int1shl
int1shr
int1smaller
int1um
int1up
int1xor
int2_bool
int2_bpch
ar
int2_text
int2_varchar
int4_bpcha
r
int4_text
int4_varchar
int8_bool
int8_bpch
ar
int8_text
int8_varchar
job_submit
numeric_
bpchar
numeric_int1
numeric_t
ext
numeric_
varchar
nvarchar
2in
nvarchar2out
nvarchar2s
end
oidvectori
n_extend

GBase 8c SQL 参考手册
南大通用数据技术股份有限公司
588
oidvectorout_ex
tend
oidvector
send_exte
nd
rawcmp
raweq
rawge
rawgt
rawin
rawle
rawlike
rawlt
rawne
rawnlike
rawout
rawsend
text_float4
text_float
8
text_int1
text_int2
text_int4
text_int8
text_nume
ric
timestamp_text
timestam
p_varchar
varchar_f
loat4
varchar_
float8
varchar_int4
varchar_int
8
varchar_n
umeric
xidout4
xidsend4
calculate
_quantile
_of
calculate
_value_
at
large_seq_roll
back_ntree
large_seq_
upgrade_nt
ree
-

GBA-02BR-0046
错误码
错误标识
错误信息
GBA-02BR-0046

Execute sql error
错误出现原因
执行SQL 失败
分析与建议
1、检查数据库状态
2、检查所执行SQL 的正确性

本节主要介绍的是配置目标数据库,
也就是执行dblink 语句的集群的配置
文件。用户可以通过gcadmin 命令查看集群的部署状态,然后完善配置文件。
该配置文件的作用是,网关需要操作目标库时,需要获取目标库的相关信息。
下面举例说明,目标数据库的信息配置,目标数据库的集群信息如下:
===============================================================
|
GBASE COORDINATOR CLUSTER INFORMATION
|
===============================================================
|
NodeName
|
IpAddress
|gcware |gcluster |DataState |
---------------------------------------------------------------
| coordinator1 | 192.168.103.142 | OPEN
|
OPEN
|
0
|
---------------------------------------------------------------
===========================================================
|
GBASE DATA CLUSTER INFORMATION
|
===========================================================
|NodeName |
IpAddress
|gnode |syncserver |DataState |
-----------------------------------------------------------
|
node1
| 192.168.103.142 | OPEN |
OPEN
|
0
|
-----------------------------------------------------------
|
node2
| 192.168.103.143 | OPEN |
OPEN
|
0
|
-----------------------------------------------------------
配置网关目标数据库,目前配置存在版本区别:
1)网关为GBase8a_MPP_Cluster_Gateway_8.5.1.2_build4.7 以及以下的
版本
在[安装目录]/conf/gcluster/192.168.103.142_gbase.properties
gcluster.pwd=gbase20110531
gcluster.encode=utf-8

GBase 8a MPP Cluster 透明网关手册
- 6 -
南大通用数据技术股份有限公司
在[安装目录]/conf/gcluster/192.168.103.143_gbase.properties
gcluster.pwd=gbase20110531
gcluster.encode=utf-8
2)网关为GBase8a_MPP_Cluster_Gateway_8.5.1.2_build4.8 及以上版本
在[安装目录]/conf/gcluster/gbase8a_gcluster.properties 中配置
[gc142]
gcluster_IP=192.168.103.142
gcluster_port=5258
gcluster_user=gbase
gcluster_pwd=gbase20110531
gcluster_encode=utf-8
[gn142]
gcluster_IP=192.168.103.146
gcluster_port=5050
gcluster_user=gbase
gcluster_pwd=gbase20110531
gcluster_encode=utf-8
[gn143]
gcluster_IP=192.168.103.142
gcluster_port=5050
gcluster_user=gbase
gcluster_pwd=gbase20110531
gcluster_encode=utf-8
注:
如果集群存在内网和外网IP 地址,
网关目标数据库中配置这两种IP 地址。