exec: vectorized engine incorrectly supports dates outside of range

[yuzefovich]

logictest/edge doesn't succeed with auto if we lower the row count threshold to 0 (meaning if the query is streaming, it'll always be executed with the vectorized engine):

root@127.0.0.1:57035/defaultdb> SELECT _date - 1 FROM t WHERE key = 'min';
pq: date is out of range
root@127.0.0.1:57035/defaultdb> explain (vec) SELECT _date - 1 FROM t WHERE key = 'min';
                           text                           
+--------------------------------------------------------+
   │                                                      
   └── Node 1                                             
        └── *distsqlrun.materializer                      
             └── *exec.simpleProjectOp                    
                  └── *exec.projMinusInt64Int64ConstOp    
                       └── *exec.CancelChecker            
                            └── *distsqlrun.colBatchScan  
(7 rows)

Time: 776µs

root@127.0.0.1:57035/defaultdb> set vectorize = off;
SET

Time: 245µs

root@127.0.0.1:57035/defaultdb> SELECT _date - 1 FROM t WHERE key = 'min';
pq: date is out of range
root@127.0.0.1:57035/defaultdb> set vectorize = experimental_on;
SET

Time: 239µs

root@127.0.0.1:57035/defaultdb> SELECT _date - 1 FROM t WHERE key = 'min';
  ?column?   
+-----------+
  -infinity  
(1 row)

Time: 1.771ms

What happens is that Matt added the support for date type exactly like postgres has, but in the vectorized land we're using int64. This should be fixed.

Jira issue: CRDB-5547

[github-actions]

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
5 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

[github-actions]

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!