bug: Geometry need to have an equal function

[cdmikechen]

Search before asking

• I had searched in the issues and found no similar issues.

Version

v1.2.653-nightly

What's Wrong?

SQL 错误: Failover Retry Error executing query after 0 failover retry: SQL: select * from a, b where a.point=b.point
 Query failed: QueryErrors{code=1065, message=error: 
  --> SQL:1:33
  |
1 | select * from a, b where a.point=b.point
  |                                 ^ no function matches signature `eq(Geometry NULL, Geometry NULL)`, you might need to add explicit type casts.

candidate functions:
  eq(Variant, Variant) :: Boolean                               : unable to unify `Geometry NULL` with `Variant`
  eq(Variant NULL, Variant NULL) :: Boolean NULL                : unable to unify `Geometry` with `Variant`
  eq(String, String) :: Boolean                                 : unable to unify `Geometry NULL` with `String`
... and 31 more

} cause: null

Geometry should either support the = operator, or have an equal function, such as ST_Equals.

How to Reproduce?

set enable_geo_create_table=1
create table a (point geometry);
create table b (point geometry);
select * from a, b where a.point=b.point

Are you willing to submit PR?

• Yes I am willing to submit a PR!