sql: 'infinity'::time should be greater than any other time #129148
Description
In the current implementation, 'infinity'::time is equal to '23:59:59.999999' and smaller than '24:00:00'.
We should make it greater than any other time to fit the semantics of 'infinity', and the updated behaviour will also aligne with pr #127141
demo@127.0.0.1:26257/demoapp/movr> SELECT 'infinity'::time = '23:59:59.999999'::time;
?column?
------------
t
demo@127.0.0.1:26257/demoapp/movr> SELECT 'infinity'::time < '24:00:00'::time;
?column?
------------
t
Alternatively, we can align it's behaviour with postgres, which prohibits 'infinity'::time:
postgres=# SELECT 'infinity'::time;
ERROR: invalid input syntax for type time: "infinity"
LINE 1: SELECT 'infinity'::time;
^
postgres=# SELECT 'infinity'::time > '23:59:59.999999'::time;
ERROR: invalid input syntax for type time: "infinity"
LINE 1: SELECT 'infinity'::time > '23:59:59.999999'::time;
This issue complements issue #41564
Jira issue: CRDB-41399
Epic CRDB-60811