v1.1.2

ODBC v1.1.2

Diff since v1.1.1

Closed issues:

• SQL Query returns wrong number of rows instead of Divide by Zero error encountered (8134) (SQLFetch) (#352)

Merged pull requests:

• Handle runtime error on Base.iterate (#353) (@pankgeorg)

v1.1.1

ODBC v1.1.1

Diff since v1.1.0

Closed issues:

• Decimal conversion of null-terminated strings results in error (#340)
• slowdown when the query returns hundreds of nullable columns (#343)
• could not load library ".../lib/libodbc.so" (#350)

Merged pull requests:

• Debug CI issue (#348) (@quinnj)
• Fix query perf when there are lots of nullable columns. Fixes #343 fr… (#349) (@quinnj)
• Don't store _jll lib names as consts (#351) (@quinnj)

v1.1.0

ODBC v1.1.0

Diff since v1.0.4

Closed issues:

• Error converting ODBC.Cursor to DataFrame (#306)
• ODBC prepared insert into MS SQL Server failing (#307)
• updates of ODBC.jl break ini files (#315)
• params argument in DBInterface.execute argument not option. (#317)
• Documentation URL Links Are Incorrect (#318)
• Firebird. UTF-16 -> UTF-8 problem (#319)
• Use a more recent Documenter version (#321)
• Delete travis.yml? (#323)
• How to execute query with multiple DSNs? (#324)
• Cannot install ODBC on Windows 10 with Julia 1.6.1 (problem unixODBC) (#326)
• BoundsError Issue when converting to DataFrames regression #306 (#328)
• Failed to precompile Julia v1.7.2 on Mac (M1) (#335)
• Loading the package kills julia with LLVM ERROR: Unsupported calling convention. on Apple Silicon (#338)

Merged pull requests:

• Fix #315 by using Scratch.jl for a permanent ODBC.jl config location (#320) (@quinnj)
• Bump Documenter (#322) (@ViralBShah)
• missing interface element (#336) (@lawless-m)
• Guard ccalls with stdcall convention with @static (#339) (@giordano)
• Fix case when SQLGetData data size exceeds column size (#346) (@quinnj)

v1.0.4

ODBC v1.0.4

Diff since v1.0.3

Closed issues:

• PostgreSQL connection error: ERROR: IM004: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed (#298)
• Failed to precompile - related to Printf and DecFP (#311)
• Issues setting up connection (#312)
• Problem with unhandled exceptions (#314)

Merged pull requests:

• remove user and password from DSN record (#305) (@akdor1154)
• further demote diagnostics log output to debug (#313) (@ExpandingMan)

v1.0.3

ODBC v1.0.3

Diff since v1.0.2

Closed issues:

• Bump DecFP? (#303)

Merged pull requests:

• Bump DecFP compat (#304) (@quinnj)

v1.0.2

ODBC v1.0.2

Diff since v1.0.1

Closed issues:

• Doesn't work on 1.5.0-beta1 (or 1.6) (#297)
• Seems incompatible with system-wide drivers/DSNs on Linux/Mac (#299)
• Can't read system odbcinst.ini (#300)

Merged pull requests:

• Support system config (#302) (@quinnj)

v1.0.1

ODBC v1.0.1

Diff since v1.0.0

Closed issues:

• ERROR: LoadError: UndefVarError: Printf not defined (#285)
• Documentation: Dec64 type conversion to Integer (#288)
• Can't connect to azure db (v1.0.0 (#289)
• Unicode issues with Impala (#291)
• Julia crash (win 10 - MS ODBC 17 - ODBC v1.0.0) (#292)

Merged pull requests:

• Update README.md (#286) (@KristofferC)
• ODBC info messages changed from warn to info (#287) (@ExpandingMan)
• Doc updates and small fix (#293) (@quinnj)
• Fix #291 by adding troubleshooting section to docs (#294) (@quinnj)
• Finalize statements before closing connection (#296) (@quinnj)

v1.0.0

ODBC v1.0.0

Diff since v0.9.1

Closed issues:

• Prevent SQL injection (prepared statement + escape meta) (#74)
• Concurrent database calls (#80)
• bigint negative value fail (#152)
• Possible to loop over rows without pulling entire table? (#155)
• No rows in ODBC query to SQLite db (#157)
• Problems with inserting negative integers (#161)
• Impossible to load more than 65000 records (#165)
• disconnect DSN in a finalizer (#172)
• Function to check if a connection is valid (#176)
• Selecting boolean columns returns strings (#180)
• Type conversions into a dataframe (#181)
• Error when converting SQLTimestamp with milliseconds to DateTime (#184)
• Inserting datetimeoffset's using microsoft sql server produces inconsistent results (#186)
• Error: ccall: could not find function SQLAllocHandle in library (#191)
• Silent error when extracting text from SQL Server (#192)
• ODBC can't determine DSN settings for Redshift (#198)
• InexactError() with large numbers (#199)
• Can't save SQLTimestamp column with Feather.jl (#202)
• Support parameterized and prepared queries which return rows of data (#210)
• OutOfMemory Erro with Oracle 11g (#214)
• query cann't return dataframe from MariaDB (#216)
• ccall: could not find function SQLDriversW in library (#218)
• Large Memory footprint for processing String results (#219)
• Handling of GUID on MS SQL (#221)
• ODBC load won't work (#222)
• ODBC crash Julia (#223)
• How to query data encoded in GBK from SQL Server (#227)
• Query (#229)
• Execute large script on SQL server (#231)
• Documentation out of date (#232)
• ODBC.drivers() does not list/find drivers (#233)
• Struct ODBCError (#234)
• NO_SQL_DATA error returned on CREATE TABLE and others (#236)
• BoundsError when loading >256 character varchar fields from Amazon Athena (#240)
• Non-deterministic connection error with Amazon Athena connector (#241)
• Source and Sink types (#242)
• Using Julia-native types (#244)
• Normalizing field names (#245)
• ODBC.execute! not working (#247)
• Feature Request: Allow username and password to be specified in DSN (#248)
• Bounds error when selecting more than 255 rows from Netezza tables (#249)
• ODBC.jl returns bad values for negative bigints with Vertica (#250)
• ODBC.query on MS Access (mdb) databases hangs or restarts the kernel (#252)
• Documentation: Add example of creating a DSN-based connection (#266)
• stackoverflow on adddriver error (#270)
• Codecov migration to marketplace app (#273)
• need a place for ODBC config files that can be written to (#274)
• LoadError: IOError: realpath: no such file or directory (ENOENT) (#278)

Merged pull requests:

• Grab bag of issue fixes (#264) (@quinnj)
• Fix #176 by defining isopen on ODBC.Connection (#265) (@quinnj)
• Allow a fix for #249 (#267) (@quinnj)
• Try only using SQLDriverConnect for connections (#268) (@quinnj)
• Fix #80 by enabling async operations (#269) (@quinnj)
• Avoid stack overflow in installer error (#271) (@quinnj)
• Move config files to build-time creation to avoid write permissions. … (#275) (@quinnj)
• Couple of fixes noticed while testing athena (#276) (@quinnj)
• Clean up connections a bit (#277) (@quinnj)
• Don't run mkdir if dir exists (or it will error) (#279) (@iamed2)
• Cleanup new build process a bit. Fixes #278 (#280) (@quinnj)
• Add a ODBC.load convenience function that attempts to auto-generate a… (#281) (@quinnj)
• Allow passing column suffix when doing ODBC.load by column name as Sy… (#283) (@quinnj)
• Add some doc manual sections (#284) (@quinnj)

v0.9.1

ODBC v0.9.1

Diff since v0.9.0

Closed issues:

• Query with global temp tables errors out when querying against a DB2 database (#251)
• ODBC query request to MS SQL Server fails with ODBC v0.8.5, works with v0.8.1 (#255)
• Precompile fails on Julia v1.4.0 due to Printf (#258)
• Query now too long? (#259)
• OutOfMemory when selecting VARCHAR with the Snowflake ODBC driver (#260)
• ODBC failing to Precompile (#262)

Merged pull requests:

• Updates for Tables.jl 1.0 (#257) (@quinnj)
• Big rewrite of package (#263) (@quinnj)

v0.9.0

ODBC v0.9.0

Diff since v0.8.6

Merged pull requests:

• Updates for Tables.jl 1.0 (#257) (@quinnj)