Skip to content

Bug: queries on FLOAT unsigned columns fail #173

@Sh4pe

Description

@Sh4pe

I've noticed that queries containing columns of type FLOAT unsigned fail. I'm using MySQL.jl v1.1.2 and Julia 1.5.3.

To reproduce, create this MySQL table:

CREATE DATABASE test;
USE test;

CREATE TABLE test_float(x FLOAT unsigned);
INSERT INTO test_float VALUES (1.1), (1.2);

In order to reproduce the error, execute this minimal script:

using MySQL

# customize the credentials and server connection to your case, obviously ;)
conn =  DBInterface.connect(MySQL.Connection, "127.0.0.1", "root", "test", port=9999)
DBInterface.execute(conn, "select x from test.test_float")

The last command fails with this backtrace:

ERROR: MethodError: no method matching rem(::Type{Float32}, ::Type{UInt64})
Closest candidates are:
  rem(::Any, ::Any, ::RoundingMode{:ToZero}) at div.jl:67
  rem(::Any, ::Any, ::RoundingMode{:Down}) at div.jl:68
  rem(::Any, ::Any, ::RoundingMode{:Up}) at div.jl:69
  ...
Stacktrace:
 [1] unsigned(::Type{T} where T) at ./int.jl:188
 [2] juliatype(::UInt32, ::Bool, ::Bool, ::Bool) at /home/XXX/.julia/packages/MySQL/pLoSZ/src/MySQL.jl:305
 [3] #8 at ./none:0 [inlined]
 [4] iterate at ./generator.jl:47 [inlined]
 [5] collect(::Base.Generator{Array{MySQL.API.MYSQL_FIELD,1},MySQL.var"#8#11"}) at ./array.jl:686
 [6] execute(::MySQL.Connection, ::String, ::Tuple{}; mysql_store_result::Bool) at /home/XXX/.julia/packages/MySQL/pLoSZ/src/execute.jl:157
 [7] execute at /home/XXX/.julia/packages/MySQL/pLoSZ/src/execute.jl:133 [inlined] (repeats 2 times)
 [8] top-level scope at REPL[17]:3

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions