Unexpected Error: overflow during Encode

[bajinsheng]

Describe the problem

Please describe the issue you observed, and any steps we can take to reproduce it:

To Reproduce

CREATE TABLE t4 (c0 CHAR, c1 INTERVAL UNIQUE);
INSERT INTO t4 (c0, c1) VALUES('1', NULL);

SELECT * FROM t4 WHERE (INTERVAL '100000000 year')<t4.c1; -- {}
SELECT * FROM t4 @{FORCE_INDEX=t4_c1_key} WHERE (INTERVAL '100000000 year')<t4.c1; -- ERROR: overflow during Encode

Expected behavior Since the index does not exist, I expect it either ignores the index hint or throws the error: index "t4_c1_key" not found.

Environment:

• CockroachDB version [CockroachDB CCL v23.2.0-alpha.00000000-dev-d7738743c955be36b1c9304a40d9e4e7b3edc4ad]
• Server OS: [Ubuntu]
• Client app [cockroach sql]

Additional context What was the impact?

Add any other context about the problem here.

Jira issue: CRDB-31913

[blathers-crl[bot]]

Hello, I am Blathers. I am here to help you get the issue triaged.

Hoot - a bug! Though bugs are the bane of my existence, rest assured the wretched thing will get the best of care here.

I was unable to automatically find someone to ping.

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

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

[yuzefovich]

Thanks for the report! I think this is a known issue #45993, so I'm closing as a dup.

[yuzefovich]

Actually, sorry, that issue is about an INSERT, and this issue is for a read-only query. We'll take a closer look shortly.

[bajinsheng]

Thanks for your prompt reply! Hope this report is useful.