summaryrefslogtreecommitdiff
path: root/statement.c
AgeCommit message (Collapse)Author
2007-03-04The version is now 8.2.0204.Hiroshi Inoue
. 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.
2006-12-181. Correct the command/responce sequence of Function Call used for largeHiroshi Inoue
object handling. 2. Add support for NaN and (-)Infinity float values.
2006-12-16The version is now 8.2.0203.Hiroshi Inoue
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) .
2006-11-20The version is now 8.2.0202.Hiroshi Inoue
1) Change to use NULL indicator instead of the length buffer in SQLFetch. 2) Fix long -> serial conversion error in MS Access.
2006-11-14The version is now 8.2.0201.Hiroshi Inoue
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.
2006-10-24Avoid backend crash caused by Execute Requests for committedHiroshi Inoue
holdable cursors.
2006-10-23The version is now 8.2.0105.Hiroshi Inoue
1. SQLStatistics now returns indices based on expression also. 2. Add a TEST button on the setup dialog.
2006-10-20Fixed a bug in UseDeclareFetch mode.Hiroshi Inoue
2006-10-17The version is now 8.2.0104.Hiroshi Inoue
Take 64bit mode into account for the format parameter of (s(n))printf, sscanf etc.
2006-10-13The version is now 8.2.0103.Hiroshi Inoue
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.
2006-09-13Refine oneshot exection sequence.Hiroshi Inoue
More type changes for 64 bit compilation.
2006-09-11The version is now 8.1.0102Hiroshi Inoue
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.
2006-08-26. Fix a select() blocking bug in *nix environment.Hiroshi Inoue
. Fix some header files depedecies.
2006-08-24The version is now 8.2.0.7.Hiroshi Inoue
. 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.
2006-07-18The version is now 8.2.0006.Hiroshi Inoue
. 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.
2006-06-12The version is now 8.2.0005.Hiroshi Inoue
2006-04-08Commit the changed files from the enhanced branchDave Page
2006-01-26add support for returning right SQLSTATE from SQLGetDiagField and SQLGetDiagRecLudek Finstrle
2006-01-26correct autocommit off behaviourLudek Finstrle
2005-12-09Fix catalog finctions which were still slightly broken in declare/fetch mode ↵Dave Page
[Ludek Finstrle]
2005-11-28Fix for bug "#1000444 Table names repeated in BDE with usedeclarefetch=1", ↵Dave Page
courtesy of Ludek Finstrle
2005-11-09Fix non-declare/fetch mode.Dave Page
2005-11-041) QR_get_fields() gets called when SC_fetch() is entered. However, the QRDave Page
cleanup will free the QResultClass object. And the pointer "coli" is no longer valid when CI_get_oid() gets called further down. I have fixed this by calling QR_get_fields() after the first if-statement. 2) This is basically the same "cache" bug: PGAPI_ExtendedFetch() caches the stored QResultClass object when the function is entered. But after SC_fetch() was called, the pointer is no longer valid. I have fixed this by calling SC_get_Curres() again after the call to SC_fetch(). [Rainer Bauer]
2005-11-03Fix declare/fetch memory leak. Now we get a nice flat line :-)Dave Page
2005-11-03Fix a major memory leak in declare/fetch mode. Ensure that forward only ↵REL-08_01_0006Dave Page
cursors can only be used in a forward direction.
2005-11-02Fix Declare/fetch when used with bound columns.Dave Page
2005-10-31Initial fix for Declare/Fetch option [Anoop, Sivakumar and Vaidhy @ Pervasive]Dave Page
2005-10-20Massive compiler warnings cleanup.Peter Eisentraut
2005-10-04I've attached a patch that uses the SQLSTATE from the backend any timeDave Page
the error condition after executing a query is STMT_ERROR_TAKEN_FROM_BACKEND. Besides solving the problem I reported, this seems to make much more sense than setting the SQLSTATE arbitrarily to HY000 "General Error" in this situation. I look forward to your feedback. [Chris Ingram]
2005-09-19Socket code is removed from the source. Now, psqlodbc driver relies ↵Anoop Kumar
completely on Libpq for the communication.
2005-09-17This patch corrects the previous fix for returning 08S01 error code for the ↵Dave Page
server disconnecting. The previous patch sent this error code for any error on the statement (such as a primary key collision). [Scot Loach]
2005-08-31Please find the patch for the other bug pointed out by Scot. (Thanks toDave Page
Sivakumar) "Another difference is the "state" that is returned from SQLGetDiagRec when a connection is lost during a query. This used to return 08S01. It now returns HY000."
2005-08-30Bloody line ends. Grrr.Dave Page
2005-08-30Fix line ends.Dave Page
2005-08-04Fix leak in SC_Destructor [Kelly Burkhart] - ↵Dave Page
http://archives.postgresql.org/pgsql-odbc/2005-03/msg00091.php
2005-08-01Fix memory leak per gborg bug 1356 [pauldaugherty]Dave Page
2005-07-13New version of the driver with libpq based comms layer, courtesy of Anoop ↵Dave Page
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.
2005-02-23Don't barf when parsing queries with functions in the table list (eg. SELECT ↵Dave Page
* FROM version() ) [Joost Kraaijeveld]
2004-12-21There is a 16-byte leak for every statement handle that has SQLFetch called ↵Dave Page
on it. I have tracked this leak down to its source: SC_Fetch calls extend_getdata_info, which allocates memory for the stmt.getdata_info. However, this memory is never freed when the statement is deallocated. [Scot Loach]
2004-07-21Make the driver ODBC 3 only.Dave Page
2004-07-11Make ODBC 0x0300 and Unicode the default on Unix, and fix the compilation inPeter Eisentraut
these modes.
2004-07-01This patch fixes several misguided assumptions that sizeof(long) == 4, which ↵Dave Page
is not true on 64-bit architectures (Peter Eisentraut)
2004-02-05[7.3.0208]Hiroshi Inoue
1) Change catalog functions to search 'public' schema if a user tries to search the user named schema and finds no record to return. 2) Set the statement status to STMT_FINISHED(not STMT_PREPARED) if the pre execution causes an error. 3) Adjust null terminator for SQL_C_WCHAR type. 4) Change getCharColumnSize to return max size when the statement has no result. 5) Cache the number of parameters for statements.
2004-01-061) Correct the handling of SQL_C_ULONG (for *nix).Hiroshi Inoue
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)
2003-12-09[7.3.0205]Hiroshi Inoue
(for *nix) 1. Detect -lsocket for some platforms. 2. Handle unix domain sockets. 3. EINTR safety for send/recv. 4. Set TCP_NDEALY option for inet connections. <1-4: thanks to Hartmut Raschick> 5. Use recursive mutex if possible. 6. Add descriptor.c to Makefile. (for Windows) 7. Automatic setting of client encoding for latin1(9). (common) 8. Avoid those notorious core dumps when logging on hitting "null" data... <8: thanls to Hartmut Raschick> 9. Removed a static varible for thread-safety. 10. Improve the performance of keyset-driven fetch operation. 11. Map (var)char type to SQL type more properly. 12. Change create_params for NUMERIC type to (precison, scale). 13. Add type cast to remove some compiler warnings.
2003-11-10[7.03.0203]Hiroshi Inoue
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).
2003-10-25[7.03.0201]Hiroshi Inoue
1) Revise the handling of descriptors and implement SQLCopyDesc. 2) Handle data_at_execution columns for SQLSetPos or SQLBulkOperations.
2003-09-151. Serialize the connection use for communication(multi-thread).Hiroshi Inoue
2. Let escape strings case-insensitive.
2003-08-271) Fix a bug on SQLSetStmtAttr(.., SQL_CONCURRENCY) reported by Shachar Shemesh.Hiroshi Inoue
2) Apply a patch to changes the storage type of the debug "func" variables to be stored in the constant area of the program(Shachar Shemesh). 3) Correct the column size in case of bytea as LO.
2003-07-311) Distinguish the rowset size for SQLFetch(Scroll) from that forHiroshi Inoue
SQLExtendedFetch. 2) Implement SQLGetDiagFieldW() for the Unicode driver.