search

xo / usql

Universal command-line interface for SQL databases
MIT License
9.07k stars 352 forks source link

mysql 5.7 converting NULL to uint32 is unsupported #476

Open vinzpp opened 3 months ago

vinzpp commented 3 months ago

it's happend to me for usql_static 0.19.3 version

WARN[0000]log.go:256 gosnowflake.(*defaultLogger).Warn DBUS_SESSION_BUS_ADDRESS envvar looks to be not set, this can lead to runaway dbus-daemon processes. To avoid this, set envvar DBUS_SESSION_BUS_ADDRESS=$XDG_RUNTIME_DIR/bus (if it exists) or DBUS_SESSION_BUS_ADDRESS=/dev/null.
Connected with driver mysql (5.7.23-log)
Type "help" for help.

my:dba@10/mydb=> show slave status;
error: mysql: sql: Scan error on column index 43, name "SQL_Remaining_Delay": converting NULL to uint32 is unsupported
my:dba@10/mydb=>
kenshaw commented 3 months ago

@vinzpp Thanks for reporting this. I'll look into this, and see if this is a conversion that can be handled by usql or not.