usql icon indicating copy to clipboard operation
usql copied to clipboard

mysql 5.7 converting NULL to uint32 is unsupported

Open Wayne-Pan opened this issue 1 year ago • 1 comments

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=> 

Wayne-Pan avatar Jul 31 '24 06:07 Wayne-Pan

@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.

kenshaw avatar Jul 31 '24 06:07 kenshaw