TTL Job Description does not quote Key Column

[elizah18]

Describe the problem

The schema uses quoted identifiers for Database, Schema, Table and Column names.

The description of a TTL job in the crdb_internal.jobs table and consequently the DB Console -> Jobs -> Job Detail page do not quote all column names. The Database, Schema and Table names are quoted correctly, it is just the PK column name(s) that is not.
This makes cutting and pasting the query for testing more complicated than it needs to be.

To Reproduce

CREATE DATABASE "CaseSensitiveDB";
USE "CaseSensitiveDB";

CREATE SCHEMA "CaseSensitiveSchema";

DROP TABLE IF EXISTS "CaseSensitiveSchema"."Dogs";
CREATE TABLE "CaseSensitiveSchema"."Dogs" (
      "Id" INT8 NOT NULL,
      "Name" VARCHAR NOT NULL,
      "Weight" FLOAT8 NULL,
      "CreatedDate" TIMESTAMPTZ,
      CONSTRAINT dogs_pkey PRIMARY KEY ("Id" ASC)
  ) WITH (
      ttl_expiration_expression = $$("CreatedDate" + INTERVAL '2 months')$$
    , ttl_job_cron = '*/1 * * * *'
);;

INSERT INTO "CaseSensitiveSchema"."Dogs" ("Id", "Name", "Weight", "CreatedDate")
SELECT 
    gs AS "Id",
    'Dog_' || gs AS "Name",
    random() * 50 + 5 AS "Weight",  -- Random weight between 5 and 55
    now() - (gs * INTERVAL '1 day') AS "CreatedDate"
FROM generate_series(1, 100) AS gs;  -- Generates 100 rows

-- wait for a minute

SELECT description
FROM crdb_internal.jobs
WHERE description like '%CaseSensitiveDB%'
order by finished desc limit 1;

--- The output shows the Id columns is not quoted.

                     description

---

ttl for "CaseSensitiveDB"."CaseSensitiveSchema"."Dogs"
-- for each span, iterate to find rows:
SELECT Id
FROM "CaseSensitiveDB"."CaseSensitiveSchema"."Dogs"
AS OF SYSTEM TIME INTERVAL '-30 seconds'
WHERE ((("CreatedDate" + INTERVAL '2 months')) <= $1)
AND (
(Id >= $3)
)
AND (
(Id <= $2)
)
ORDER BY Id ASC
LIMIT 500
-- then delete with:
DELETE FROM "CaseSensitiveDB"."CaseSensitiveSchema"."Dogs"
WHERE ((("CreatedDate" + INTERVAL '2 months')) <= $1)
AND (Id) IN (($2))
(1 row)

Expected behavior
All columns should be quoted as per the customers defined schema.

Additional data / screenshots

Screen shot of DB Console attached.

If applicable, add screenshots to help explain your problem.

Environment:

• CockroachDB version: v24.3.8
• Server OS: x86_64-pc-linux-gnu
• Client app: n/a

Additional context
What was the impact?

This makes cutting and pasting the TTL queries for testing more complicated than it needs to be.

Jira issue: CRDB-48614

[blathers-crl]

Hi @elizah18, please add branch-* labels to identify which branch(es) this C-bug affects.

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