May be a jsonb type bug

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

Responses

Browse pgsql-bugs by date

  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