How to rewrite logical expressions such as EQUAL

[qianmoQ]

Hello

Hermit conversion of logical operators implemented in the following ways

    @ScalarOperator(value = EQUAL)
    @SqlType(StandardTypes.BOOLEAN)
    public static boolean equal_long(@SqlType(StandardTypes.BIGINT) long left, @SqlType(StandardTypes.VARCHAR) Slice right)
    {
        return left == Long.valueOf(right.toStringUtf8());
    }

An exception occurred in trino 389

2022-08-17T13:41:15.585+0800	ERROR	main	io.trino.server.Server	Can not register EQUAL functionMetadata: $operator$EQUAL(bigint,varchar):boolean
java.lang.IllegalArgumentException: Can not register EQUAL functionMetadata: $operator$EQUAL(bigint,varchar):boolean
	at com.google.common.base.Preconditions.checkArgument(Preconditions.java:435)
	at io.trino.metadata.GlobalFunctionCatalog.checkNotSpecializedTypeOperator(GlobalFunctionCatalog.java:112)```

So is there any other way to achieve hermit conversion of logical operators?

[findepi]

We have assumption that comparison sides are same type. See eg #13561

What you're looking for is a coercion between numbers and varchars (one way or the other). Such an implicit coercion doesn't exist. It was discussed many times before. Hopefully you can find prior discussions among closed issues.