Fix #25: interpret TINYINT(1) and BIT(1) as booleans by default, and add settings to disable this behavior

duckdb / duckdb_mysql

https://duckdb.org/docs/extensions/mysql

MIT License

55 stars 13 forks source link

Fix #25: interpret TINYINT(1) and BIT(1) as booleans by default, and add settings to disable this behavior #26

Closed Mytherin closed 10 months ago

Mytherin commented 10 months ago

Fixes #25

Apparently MySQL lacks a proper boolean type and TINYINT(1) and BIT(1) are commonly used instead. To support this behavior we now convert these types to boolean by default. We also add two new settings to disable this behavior: mysql_tinyint1_as_boolean and mysql_bit1_as_boolean.