Check if dialect can support the recently added functions

[AnastasiiaSergienko]

Situation

We have added a few new functions to the common part recently. We need to check if the dialect can support them. The list of the new function capabilities to check is:

• FN_BIT_LROTATE -> missing in MySQL
• FN_BIT_RROTATE -> missing in MySQL
• FN_BIT_LSHIFT -> added
• FN_BIT_RSHIFT -> added
• FN_FROM_POSIX_TIME-> missing in MySQL
• FN_HOUR -> added
• FN_INITCAP -> missing in MySQL
• FN_AGG_EVERY -> missing in MySQL
• FN_AGG_SOME -> MySQL has ANY function but it's used only in WHERE clause
• FN_AGG_MUL_DISTINCT -> missing in MySQL
• FN_PRED_IS_JSON -> There is a function JSON_SCHEMA_VALID (https://dev.mysql.com/doc/refman/8.0/en/json-validation-functions.html#function_json-schema-valid), but this is not predicate. Mapping won't be implemented until we have integration test for predicates.
• FN_PRED_IS_NOT_JSON -> missing in MySQL
• FN_HASHTYPE_MD5 -> missing in MySQL
• FN_HASHTYPE_SHA1 -> missing in MySQL
• FN_HASHTYPE_SHA256 -> missing in MySQL
• FN_HASHTYPE_SHA512 -> missing in MySQL
• FN_HASHTYPE_TIGER -> missing in MySQL
• FN_AGG_MUL -> missing in MySQL
• FN_JSON_VALUE -> (introduced 8.0.21) https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#function_json-value. I wouldn't add this as we don't check the source version
• FN_MIN_SCALE -> missing in MySQL
• FN_AGG_LISTAGG -> missing in MySQL
• FN_AGG_LISTAGG_DISTINCT
• FN_AGG_LISTAGG_SEPARATOR
• FN_AGG_LISTAGG_ON_OVERFLOW_ERROR
• FN_AGG_LISTAGG_ON_OVERFLOW_TRUNCATE
• FN_AGG_LISTAGG_ORDER_BY
• FN_AGG_COUNT_TUPLE -> missing in MySQL