Issue:- JSON data type column accepting 'integer' value
Priority:-Minor
Below is the table definition and insert statement, which is working in Postgres however it doesn't work in oracle with check constraint(jj is JSON strict).
postgres=# \d kp Table "public.kp" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+-------------------------------- id | integer | | not null | nextval('kp_id_seq'::regclass) jj | json | | |
postgres=# insert into kp(jj) values('98'); INSERT 0 1
But while we checking the same thing in Oracle it doesn't accept this. Is it an issue with Postgres data type?
