Hi,
I’m currently in the process of upgrading our Julia 0.6 codebase to Julia 0.7, however I’m hitting a very weird issue with ODBC.
If I call a method, any method prior to issuing a sql query the julia process starts consuming vast quantities of memory, and the query never returns, doesn’t seem to happen julia 1.0.
The sample below causes the issue in Julia 0.7 but not 1.02, but I’m tring to use 0.7 to transition to 1.02.
import ODBC
function hello_world()
println("hello")
end
hello_world()
# Sample query, seems only happen there are a lot of columns in the resultset.
sql_query = """
SELECT CAST('Text' AS NVARCHAR(200)) AS Text1
,CAST('Text' AS NVARCHAR(200)) AS Text2
,CAST('Text' AS NVARCHAR(200)) AS Text3
,CAST('Text' AS NVARCHAR(200)) AS Text4
,CAST('Text' AS NVARCHAR(200)) AS Text5
,CAST('Text' AS NVARCHAR(200)) AS Text6
,CAST('Text' AS NVARCHAR(200)) AS Text7
,CAST('Text' AS NVARCHAR(200)) AS Text8
,CAST('Text' AS NVARCHAR(200)) AS Text9
,CAST('Text' AS NVARCHAR(200)) AS Text11
,CAST('Text' AS NVARCHAR(200)) AS Text12
,CAST('Text' AS NVARCHAR(200)) AS Text13
,CAST('Text' AS NVARCHAR(200)) AS Text14
,CAST('Text' AS NVARCHAR(200)) AS Text15
,CAST('Text' AS NVARCHAR(200)) AS Text131
,CAST('Text' AS NVARCHAR(200)) AS Text142
,CAST('Text' AS NVARCHAR(200)) AS Text153
,CAST('Text' AS NVARCHAR(200)) AS Text134
,CAST('Text' AS NVARCHAR(200)) AS Text145
,CAST('Text' AS NVARCHAR(200)) AS Text156
,CAST('Text' AS NVARCHAR(200)) AS Text137
,CAST('Text' AS NVARCHAR(200)) AS Text148
,CAST('Text' AS NVARCHAR(200)) AS Text159
,CAST(5 AS BIGINT) AS Number1
,CAST(5 AS BIGINT) AS Number2
,CAST(5 AS BIGINT) AS Number3
,CAST(5 AS BIGINT) AS Number4
,CAST(5 AS BIGINT) AS Number5
,CAST(5 AS BIGINT) AS Number6
,CAST(5 AS BIGINT) AS Number7
,CAST(5 AS BIGINT) AS Number8
,CAST(5 AS BIGINT) AS Number9
,CAST(5 AS BIGINT) AS Number11
,CAST(5 AS BIGINT) AS Number22
,CAST(5 AS BIGINT) AS Number33
,CAST(5 AS BIGINT) AS Number44
,CAST(5 AS BIGINT) AS Number55
,CAST(5 AS BIGINT) AS Number66
,CAST(5 AS BIGINT) AS Number77
,CAST(5 AS BIGINT) AS Number88
,CAST(5 AS BIGINT) AS Number99
,CAST(5 AS BIGINT) AS Number111
"""
dsn = ODBC.DSN("Driver={SQL Server};Server=sqlserver;Database=DB;Trusted_Connection=True;", prompt=false)
df = ODBC.query(dsn, sql_query)
Thanks,
Adrian.