From: | yunlong(dot)gao <yunlong(dot)gao(at)qunar(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | May be a jsonb type bug |
Date: | 2017-12-22 12:43:19 |
Message-ID: | ae4325cd-4e99-b9d0-34f7-55ebe8f1a028@qunar.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi all:
When i exec function jsonb_array_length(jsonb),The database throw a
error: |cannot get array length of a scalar
That's because have a 'null' value in the jsonb type column|
|So i have a test and think null is a bug for jsonb:
|
mydb=# \d test
Table "public.test"
Column | Type | Collation | Nullable
| Default
----------+-----------------------------+-----------+----------+----------------------------------
id | integer | | not null |
nextval('test_id_seq'::regclass)
info | text | | |
crt_time | timestamp without time zone | | |
col_n | jsonb | | |
Indexes:
"test_pkey" PRIMARY KEY, btree (id)
mydb=# update test set col_n='test' where id=1;
ERROR: invalid input syntax for type json
LINE 1: update test set col_n='test' where id=1;
^
DETAIL: Token "test" is invalid.
CONTEXT: JSON data, line 1: test
mydb=# update test set col_n='null' where id=1;
UPDATE 1
mydb=#
mydb=#
mydb=# select * from test where id=1;
id | info | crt_time | col_n
----+------+----------------------------+-------
1 | test | 2017-12-13 15:14:16.347681 | null
(1 row)
--
*PostgreSQL DBA yunlong.gao *
pg开发指南 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=58058230
pg发布流程 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=56215301
pg值班列表 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=50508626
pg机器列表 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=36438672
pgbouncer http://wiki.corp.qunar.com/display/searchdev/pgbouncer+server
From | Date | Subject | |
---|---|---|---|
Next Message | Sergei Kornilov | 2017-12-22 13:04:34 | Re: May be a jsonb type bug |
Previous Message | Masahiko Sawada | 2017-12-22 05:07:10 | Re: BUG #14941: Vacuum crashes |