sql: missing backport to 20.2 related to "char"

[knz]

In 20.2:

[email protected]:58180/defaultdb> select '"char"'::regtype;
   regtype
-------------
  character
(1 row)

On master and psql:

[email protected]:26257/defaultdb> select '"char"'::regtype;
  regtype
-----------
  "char"
(1 row)

There was a PR that fixed that but it's not backported yet. Found while working on #57558.

[blathers-crl]

Hi @knz, please add a C-ategory label to your issue. Check out the label system docs.

While you're here, please consider adding an A- label to help keep our repository tidy.

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

[rafiss]

Thanks for finding this. I haven't looked at the code yet, but pretty sure it's this: #55607. also, #56298 happened recently and might be related but is a bigger change. @otan i think #55607 can be backported but not sure about #56298 -- what do you think?

[otan]

Yeah they need some backports which I wasn't looking to do in 20.2 since they're mildly risky...
Seems like behavior for a long time as well.

[otan]

i'm closing this because this is a longstanding bug, which i don't think is urgent enough to backport to 20.2.