Can't do basic query after Pkg.update()

[JockLawrie]

Hi there,

I have recently been using ODBC to query a SQL Server instance without issue. I did a Pkg.update() 2 days ago and now can't run the same query. Example below. I have tried some of the variants of QDBC.query. Any ideas?

using ODBC
con = ODBC.DSN(dsn_name, username, password)
qry = "select * from INFORMATION_SCHEMA.TABLES where table_type = 'BASE TABLE' order by TABLE_NAME"
tablenames = ODBC.query(con, qry)

The error is:

ERROR: ArgumentError: Invalid # of rows for Data.Schema; use `nothing` to indicate an unknown # of rows
Stacktrace:
 [1] DataStreams.Data.Schema(::Array{Type,1}, ::Array{String,1}, ::Int64, ::Dict{String,Any}) at /home/jock/.julia/v0.6/DataStreams/src/DataStreams.jl:53
 [2] #Source#4(::Bool, ::Bool, ::Type{T} where T, ::ODBC.DSN, ::String) at /home/jock/.julia/v0.6/ODBC/src/Source.jl:156
 [3] (::Core.#kw#Type)(::Array{Any,1}, ::Type{ODBC.Source}, ::ODBC.DSN, ::String) at ./<missing>:0
 [4] #query#14 at /home/jock/.julia/v0.6/ODBC/src/Source.jl:347 [inlined]
 [5] query(::ODBC.DSN, ::String, ::Type{DataFrames.DataFrame}) at /home/jock/.julia/v0.6/ODBC/src/Source.jl:347
 [6] query(::ODBC.DSN, ::String) at /home/jock/.julia/v0.6/ODBC/src/Source.jl:342

[JockLawrie]

Following up, in src/DataStreams.jl, it works if I replace line 63:

!ismissing(rows) && rows < 0 && throw("Invalid # of rows for Data.Schema; use `nothing` to indicate an unknown # of rows")

with:

if !ismissing(rows) && rows < 0
    rows = -1
end

I couldn't run the tests because they depend on a file that I don't have (/Users/jacobquinn/...).
Is the replacement above an acceptable change

[JockLawrie]

Update:
My apologies, the replacement above is in the DataStreams package.
One test fails because an exception is not thrown.

[staples6]

is there a work around for this issue? I'm having the same problem querying an Oracle database. it appears that the rows being returned by ODBC.API.SQLRowCount is -1 in my case.