Re: BUG #13884: array_to_json() works incorrectly for non-0-based arrays

Hi

2016-01-24 11:47 GMT+01:00 <xtracoder@gmail.com>:

> The following bug has been logged on the website:
>
> Bug reference:      13884
> Logged by:          xtracoder
> Email address:      xtracoder@gmail.com
> PostgreSQL version: 9.5.0
> Operating system:   Windows
> Description:
>
> When postgres array has no elements at the beginning, array_to_json()
> generates json array starting at the first initialized value
>
> Steps to reproduce
> - - - - - - - - - - - - - - - - - - - - - - - -
> DO $$
> DECLARE
>   arr real[];
>   jsarr jsonb;
>   arr2 real[];
> BEGIN
>   arr[3] = 1.1;
>   arr[4] = 1.1;
>   raise notice 'arr = %', arr;
>
>   jsarr = array_to_json(arr);
>   raise notice 'arr = %', jsarr;
>
>   arr[0] = 1.1;
>   raise notice 'arr = %', arr;
>
>   jsarr = array_to_json(arr);
>   raise notice 'arr = %', jsarr;
> END $$
>
> Actual result
> - - - - - - - - - - - - - - - - - - - - - - - -
> 1. NOTICE:  arr = [3:4]={1.1,1.1}
> 2. NOTICE:  arr = [1.1, 1.1]
> 3. NOTICE:  arr = [0:4]={1.1,NULL,NULL,1.1,1.1}
> 4. NOTICE:  arr = [1.1, null, null, 1.1, 1.1]
>
>
> Expected result
> - - - - - - - - - - - - - - - - - - - - - - - -
> 2. NOTICE:  arr = [null, null, null, 1.1, 1.1]
>
>
It doesn't looks like bug - It hard to say, when is a start of PostgreSQL
array and how PostgreSQL arrays should be serialized to JSON. First field
in pg array is a first field in JSON array.

Pavel


>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>