Error message is misleading when interval is too big

[mneverov]

To reproduce execute the following query:

select interval '10000000000000000000000000000000000 year';
invalid syntax: statement ignored: at or near "EOF": syntax error: could not parse "10000000000000000000000000000000000 year" as type interval: interval: missing unit at position 35: "10000000000000000000000000000000000 year"
SQLSTATE: 22007
DETAIL: source SQL:
select interval '10000000000000000000000000000000000 year'
                                                          ^

The same query in PG:

postgres=# select interval '10000000000000000000000000000000000 year -1 hour';
ERROR:  interval field value out of range: "10000000000000000000000000000000000 year -1 hour"
LINE 1: select interval '10000000000000000000000000000000000 year -1...
                        ^

Build CRDB from master branch commit fc2f2c3.

[blathers-crl]

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

It looks like you have not filled out the issue in the format of any of our templates. To best assist you, we advise you to use one of these templates.

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.

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

[rafiss]

Thanks for the bug report @mneverov !