| Age | Commit message (Collapse) | Author |
|---|
|
When a statement with array-bound data-at-execution parameters is executed
twice, the second result set was not returned when UseServerSidePrepare=1.
This was demonstrated by the data-at-execution regression test case.
|
|
change fixes the problem *UseDeclareFetch=1, Fetch=100, UseServerSidePrepare=1 causes Windows client to intermittently hang* reported by Jack Wilson. I hope it would also fix the problem *Segmentation Fault in Postgres server when using psqlODBC* reported by Joshua Berry.
|
|
If you passed a VARCHAR parameter with column_size 5 to SQLPrepare, and you
had UseServerSideprepare=0 and BoolsAsChar=1, the code describes the
parameters before running the query, so that it can check if the parameter
is a boolean. That produced a bogus extra empty result set to the caller in
subsequent SQLExecute().
This fixes the two regression test failures.
Patch by Hiroshi Inoue, with minor copy-editing by me.
|
|
|
|
|
|
notice.txt doesn't exist anymore, the copyright and license information is
in readme.txt now. Update references in comments.
|
|
crash on SQL Server linked servers.
|
|
SQLResultNumCols(), SQLDescribeCol() or SQLColAttribute() available for insert/update/delete .. returning statements.
|
|
as a type oid parameter as an extension of pgtype_xxxx functions so that SQLColumns and SQLDescribeCol(SQLColAttrinute) could use common functions.
2.Call PQconnectdbParams instead of PQconnectdb when it's available.
3.Make cursor open check at transaction end a little more effective.
4.Added code for SQL_INTERVAL support and refcursor support though
they are disabled.
|
|
2.Fix a bug when creating a connection string.
|
|
|
|
of ODBC escape { .
|
|
2. Fix a bug about UTF8 handling.
3. Wait a ReadyForQuery Message after errors correctly.
|
|
|
|
1. Close (holdable) cursors on commit if possible.
2. Recycle columns cache info if the size becomes pretty large.
3. Add sslverify=none to conninfo in case of SSL connections
via libpq of version 8.4.
4. Add a functionality to change the directory for logging.
5. Correct the error code for communication errors.
|
|
1. SQLGUID type support thanks to Jan-Willem Goossens.
2. Fix a bug about silently adding a *for read only* clause.
3. Fix a 64bit mode bug about handling of arrays of parameters.
4. Change the implemetatin of SQLForeignKeys() for 8.3+ servers.
5. Not commit the transaction too early in useDeclareFetch mode.
6. Add a cursor open check for SQLPrepare().
|
|
2. Support column alias without "as" so that links from
the SQLServer work.
3. Take ';' into account when the driver adds "for read only"
clause.
4. Use the E'.. ' notation not only in '=' expressions but
also in LIKE expressions.
5. Change to return milliseconds parts for timestamp fields.
6. Change to return a specific sqlstate in case of multiple
parameters.
|
|
. Fix some bugs in case without MSDTC support.
. Refine the realloc handling.
. Put back the @@IDENTITY implementation so as not to use lastval().
. Change SQLColumns() to return correct column length in the Unicode driver.
. Remove the connection count limitation.
. Fix Protocol=7.4--1 notation (should be Protocol=7.4).
. Fix a typo in socket.c (bug report from Rainer bauer).
|
|
. Append DETAIL messages to GetDiag...() messages.
. Use SQL_SUCCEEDED macros so as to simplify the code.
. Use lastval() function to replace IDENTITY on 8.1 or later servers.
. Remove WSAStartup() and WSACleanup() from DllMain.
. Load libpq from the driver's folder.
. Use QR_get_value_backend_int/_text() funcs instead of
QR_get_value_backend_row().
. Improve the implemetation of SQLSetPos(.., SQL_ADD/SQL_UPDATE)
using the 8.2 new feature INSERT/UPDATE .. returning .
. Seaparate DTC code as a Delayload DLL.
|
|
. Configure the combination of time.h and sys/time.h.
. Treat the tables in information_schema as system tables.
. Correct the precision of SQL_NUMERIC_STRUCT.
. Change the default max varchar size from 254 to 255.
. Reset the fields information properly in case of SQLMoreResults.
. Implement SQLDescribeParam() also in case of multi-command queries.
. Handle dollar-quotes more properly.
. Provide a make option to link dynamic multithread library.
. Set the default nullablity to TRUE.
. Parse command delimiters(;) more correctly.
. Use QR_get_value_backend_text() or QR_get_value_backend_int()
instead of QR_get_value_backend_row().
. Apply Parse statement or disallow premature properly.
. Reset current_schema cache in case 'set search_path ..' command
is issued.
|
|
1. Fix a bug which forgets unnamed plans too early especially
when handling large objects.
2. Don't treat charcters whose value >= 128 as alphanumeric in case
of conversion of binary data to bytea.
3. Change ConfigDSN() so that it takes the options in Setup Dialog
page 1 into account.
4. Simplify the memory management of statements'columns info
so as to prevent memory leaks or a crash in parse_statement etc.
5. SQLTables("", SQL_ALL_SCHEMAS. "", ..) now returns a list of
valid schemas.
6. SQLTables("", "", "", SQL_ALL_TABLE_TYPES) now returns a list
of valid table types.
7. SQLGetInfo SQL_DATABASE_NAME now returns the database name.
8. Improve the automatic setting mechanism of the client_encoding
for Windows code page 125x (ANSI drivers only) .
|
|
|
|
1. Ditinguish the indicaitor and the octet_length field of APD
clcearly.
2. Handle @@IDENTITY more generally.
3. Take outer join into account so as to evaluate nullability.
4. Fix a bug about Keyset-driven cursors.
|
|
1. SQLStatistics now returns indices based on expression also.
2. Add a TEST button on the setup dialog.
|
|
Take 64bit mode into account for the format parameter of
(s(n))printf, sscanf etc.
|
|
1.Improve the handling of connection error messages.
2.Add an option to convert empty strings to NULL.
3.Handle domain type as the basetype.
4.Fake MSS in case of not only SQLExecute but also SQLParamData.
5.Prevent SQLColumns from displaying system columns.
6.Unload delayLoaded libraries on dll detach (not on disconnect time).
7.Fix a SQLGetDiagField crash bug.
8.Fix a insertion count bug.
9.Take win98 cases into account a little.
|
|
More type changes for 64 bit compilation.
|
|
1. Compensate a loss of report of being Jet when using MS Access.
2. Add NULL <-> "" date converion function for FOXPRO and
revise parse/describe/execute mechanism.
3. Miscellaneous type changes for 64 bit drivers.
|
|
. Fix some SQLPrimaryKey, SQLForeignKey bugs.
Fill PK_NAME or FK_NAME columns.
Return right update_rule values.
Remove duplicates.
. Handle SQL_ALL_SCHEMAS parameter in SQLTables.
. Handle unaligned indicator/length buffers more properly.
. Fix a bug in ProcedureColumns in case of set returning functions.
. Fix a buffer overrun in handle_notice_message (Bart Samuel)
. Fix a output parameters problem (Bart Samuel)
. Hold the connection lock while a rollbackable statement
running.
. Add Extra Opts option to the DSN option setupdialog.
|
|
. Add an option to fake Microsoft SQL Server which would improve
SERIAL type handling.
. Add support for LOGIN_TIMEOUT.
. Improve Statement error handling about the reference of Connection error.
. Improve the handling BIGINT type in the OSs without having strtoll().
. Support ODBC CONVERT scalar functions in some cases.
. Close qlog, mylog files on detach dll.
. Improve comunication performance in case of the driver's original
socket.
. Send a Close message at the end of normal command processing.
|
|
|
|
is still broken
|
|
it avoid bad data_at_exec parameters
|
|
or SQLExecDirect with Server side prepare. The patch is based on patch
posted by Reiner. I thank you for patch and testing.
[Ludek Finstrle]
|
|
Ludek Finstrle, with test case from Andrus]
|
|
|
|
|
|
completely on Libpq for the communication.
|
|
|
|
when no row got affected in UPDATE/DELETE. (Thanks to Sivakumar)
|
|
Kumar of Pervasive PostgreSQL. Version number bumped, and extra strings modified in the resource file to make it obvious when the libpq version of the driver is being run.
|
|
|
|
|
|
these modes.
|
|
|
|
support on Unix. I changed some code that assumes two-byte SQLWCHAR and I changed configure.ac and Makefile.am, as necessary.
I tested this with unixODBC 2.2.7 on SuSE Linux 8.2. I built unixODBC --with-iconv-ucode-enc=UCS-4LE and with SQL_WCHART_CONVERT defined, so that SQLWCHAR is wchar_t. I have not tested it with UCS-2 / unsigned short.
I also tested this with iODBC 3.51.1, which always uses wchar_t on Unix.
One caveat, if anyone actually plays with this: sqlext.h should include sqlucode.h, so I haven't patched psqlodbc to do so. The next release of unixODBC will contain this fix, and I've mentioned it to the iODBC maintainer.
|
|
2) Prevent plan deallocation errors when the transaction
is in abort status.
3) Avoid a connection failure when notice message arrives.
4) Improve the handling of mutex(critical section).
5) Correct the cursor open check.
6) Change the Unicode driver to set the NULL terminator
of SQL_C_WCHAR type data properly.
7) Add some m(re)alloc error check.
8) Add proper cleanup steps for some functions.
9) Return proper min & max scale for timestamp data type.
10) Return proper scale for timestamp data fields.
11) Fix the bug that .009 numeric generates .9 output. (George A.J)
|
|
1) Clear statements' cursors on commit/rollback.
2) Change SQLColumns, SQLTablePrivileges to take show_system_tables
option into account.
3) When an ODBC 2.x application working with an ODBC 3.x driver
calls SQLExecDirect, SQLExecute, or SQLParamData, and a searched
update or delete statement was executed but did not affect any
rows at the data source, the ODBC 3.x driver should return
SQL_SUCCESS. When an ODBC 3.x application working with an ODBC
3.x driver calls SQLExecDirect, SQLExecute, or SQLParamData
with the same result, the ODBC 3.x driver should return
SQL_NO_DATA.
|
|
1) Add conversion from text to SQL_C_BINARY(bug report from Brad Wilson).
2) Change SQLColumns, SQLTables etc to initialize the statement handle
properly(bug report from Yutaka Tanida).
3) Improve the handling of mutex under *nix(bug report from Steve Wampler).
|
|
1) Revise the handling of descriptors and implement SQLCopyDesc.
2) Handle data_at_execution columns for SQLSetPos or SQLBulkOperations.
|
