geo/geogfn: unknown signature: st_distance(geography, geometry)

[timgraham]

Describe the problem

PostGIS doesn't document that ST_Distance (implemented in #48395) has that signature but I guess it works.

To Reproduce

SELECT "geogapp_city"."name" FROM "geogapp_city"
WHERE ST_Distance("geogapp_city"."point", ST_GeomFromEWKB('...'::bytea)) <= 804672.0

Environment:

• CockroachDB version 20.2 alpha 3

[blathers-crl]

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 have CC'd a few people who may be able to assist you:

• @otan (author of geo/geogfn: implement ST_Distance({geography,geography,bool}) #48395)

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.}

[otan]

unknown signature: st_distance(geography, geometry)

this is because we don't have implicit casts (in particular, from geometry->geography :()
this would be a duplicate of #38965