s1ck commented on issue #24107: [SPARK-27174][SQL] Add support for casting integer types to binary URL: https://github.com/apache/spark/pull/24107#issuecomment-473316243 [DB2](https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_castingbetweendatatypes.html#db2z_castingbetweendatatypes) does not support casting integer types to binary types. [SQL Server](https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-2017#implicit-conversions) supports even *implicit* conversions from integer types to binary types. [Oracle](https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/CAST.html#GUID-5A70235E-1209-4281-8521-B94497AAEF75) supports explicit casts from integer types to binary types. We couldn't find a clear documentation of casting to binary in Postgres, MySQL and MariaDB to determine if this would work. Do you suggest adding a custom expression exposed by a function (as proposed by @maropu)?
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
