Open
Description
As discovered during the work on testing a wider range of data types, even if the field in the main index and the lookup index both have the same type date_nanos, no matches are ever found.
This behaviour changes to a validation error in the PR at #126150, so if we fix this, we need to change that validation and test too.
Note that the work on date_nanos implicit casting did partial support for LOOKUP JOIN, and that support needs to be completed when this bug is fixed, either as part of this bug-fix or in a followup PR.