sql: `ltree2text` produces incorrect result

[mgartner]

In Postgres:

SELECT ltree2text('foo.bar.baz'::LTREE);
--  ltree2text
-- -------------
--  foo.bar.baz
-- (1 row)

SELECT ltree2text('foo.bar.baz'::LTREE) = 'foo.bar.baz'::TEXT;
--  ?column?
-- ----------
--  t
-- (1 row)

In CockroachDB, the result is incorrectly wrapped in single quotes:

SELECT ltree2text('foo.bar.baz'::LTREE);
--    ltree2text
-- -----------------
--   'foo.bar.baz'
-- (1 row)

SELECT ltree2text('foo.bar.baz'::LTREE) = 'foo.bar.baz'::TEXT;
--   ?column?
-- ------------
--      f
-- (1 row)

SELECT ltree2text('foo.bar.baz'::LTREE) = $$'foo.bar.baz'$$::TEXT;
--   ?column?
-- ------------
--      t
-- (1 row)

Jira issue: CRDB-56033

[blathers-crl]

Hi @mgartner, please add a branch-* label to identify the earliest affected branch for this C-bug

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}