Extra quotes in plan when using unlist function

[sim1984]

Here's what a normal plan output looks like when using tables:

select count(*)
from
  horse h

PLAN ("H" NATURAL)

Explain:

Select Expression
    -> Aggregate
        -> Table "PUBLIC"."HORSE" as "H" Full Scan

Now let's try to get a plan if the query uses UNLIST

select count(*)
from
  unlist('1,2,3') as l(n)

PLAN ("""L""" NATURAL)

Explain:

Select Expression
    -> Aggregate
        -> Functions Unlist as """L""" Scan

There are obviously a lot of extra quotation marks here.

[dyemanov]

I will fix it, if Adriano doesn't mind. It needs a few other related adjustments.

[dyemanov]

Now the expected output is:

SQL> set plan;
SQL> select count(*)
CON> from
CON>   unlist('1,2,3') as l(n);

PLAN ("L" NATURAL)

                COUNT 
===================== 
                    3 

SQL> set explain;
SQL> select count(*)
CON> from
CON>   unlist('1,2,3') as l(n)
CON> ;

Select Expression
    -> Aggregate
        -> Function "UNLIST" as "L" Scan

                COUNT 
===================== 
                    3