mysql 1 and 0 are incorrectly automatically converted to true and false. #47907
Labels
.Backend
Database/MySQL
Priority:P2
Average run of the mill bug
Querying/Processor
.Team/Querying
Type:Bug
Product defects
Comments
|
There may not be much we can do here, since this behaviour is coming directly from the JDBC driver. ;; Create a basic table with a tinyint(1) column.
(jdbc/execute! mysql ["create table boolean_demo (number tinyint(1), description text)"])
(jdbc/execute! mysql ["insert into boolean_demo values (1, 'true?'), (0, 'false?')"])
;; Using the MySQL JDBC driver directly, nothing from Metabase.
(with-open [connection (java.sql.DriverManager/getConnection conn-string)
statement (.prepareStatement connection "select * from boolean_demo")
rs (.executeQuery statement)]
(let [column-count (.getColumnCount (.getMetaData rs))]
(into []
(take-while some?)
(repeatedly
(fn []
(when (.next rs)
(into [] (for [i (range 1 (inc column-count))]
(.getObject rs i)))))))))
;; which returns
[[true "true?"] [false "false?"]](Hat tip to @dpsutton for the exploration.) That is, the JDBC driver interprets |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Describe the bug
use_typetinyint(1)To Reproduce
Expected behavior
0 or 1
Logs
No response
Information about your Metabase installation
{ "browser-info": { "language": "en-US", "platform": "MacIntel", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36", "vendor": "Google Inc." }, "metabase-info": { "databases": [ "h2", "mysql" ], "run-mode": "prod", "plan-alias": "", "version": { "date": "2024-09-06", "tag": "v0.50.24.4", "hash": "3b502f8" }, "settings": { "report-timezone": "Asia/Shanghai" }, "hosting-env": "unknown", "application-database": "h2", "application-database-details": { "database": { "name": "H2", "version": "2.1.214 (2022-06-13)" }, "jdbc-driver": { "name": "H2 JDBC Driver", "version": "2.1.214 (2022-06-13)" } } }, "system-info": { "file.encoding": "UTF-8", "java.runtime.name": "OpenJDK Runtime Environment", "java.runtime.version": "11.0.24+8", "java.vendor": "Eclipse Adoptium", "java.vendor.url": "https://adoptium.net/", "java.version": "11.0.24", "java.vm.name": "OpenJDK 64-Bit Server VM", "java.vm.version": "11.0.24+8", "os.name": "Linux", "os.version": "3.10.0-1160.el7.x86_64", "user.language": "en", "user.timezone": "US/Pacific" } }Severity
I hope it can be displayed consistently with MySQL Console
Additional context
No response
The text was updated successfully, but these errors were encountered: