search

EnterpriseDB / mysql_fdw

PostgreSQL foreign data wrapper for MySQL
Other
530 stars 162 forks source link

Change to address asymmetric treatment of bytea <->binary values #142

Closed sir-galahad closed 7 years ago

sir-galahad commented 7 years ago

varbinary and bytea values can be compared to escaped strings in mysql and postgres respectively, but with different formats (X'0102' vs '\x0101') up until now mysql_fdw had been sending the postgres string to mysql so equality comparisons would always fail. This change converts the postgres string to mysql's format before sending.

Hopefully this change meets your approval. Thanks for creating mysql_fdw :)

sir-galahad commented 7 years ago

@ibrarahmad I believe I have now done what you were asking for.