You need to run this exact statement:
select bson_get(data,id)::json from tabname
Tabname needs to have been created as a collection table.
Example output from dbschema:
create collection table t2
(
id char(128) not null ,
data "informix".bson,
modcount bigint,
flags integer,
primary key (id)
)
The correct syntax for bson_get() is to have the 2nd parameter
in quotes. So the correct query if you were looking for the
field named "id" in the bson document would be:
select bson_get(data, "id")::json from t2
However, if the table is a collection table and you try to look
for the "id" field without the quotes, it causes the server to
SEGV and assert fail with the following stack:
afstack
mt_ex_throw_sig
afsig_handler
geval
geval
bson_get
geval
ev_geval
new_eval
evalcols
getrow
fetchrow
exfetch
sql_nfetch
sq_nfetch
sqmain
spawn_thread
th_init_initgls
startup
If you change "id" in the statement to some other field name
like this for example:
select bson_get(data, fname)::json from t2;
The select statement will fail with a -217 error.
If the table is not a collection table, but just a regular table
with a single bson column and you also use bson_get() and forget
the quotes around "id", in this case it will also just fail with
a -217 error. Example:
create table t1 (c1 bson);
select bson_get(c1, id)::json from t1; |
