summaryrefslogtreecommitdiff
path: root/statement.h
AgeCommit message (Collapse)Author
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-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-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-04-08Commit the changed files from the enhanced branchDave Page
2006-01-26correct autocommit off behaviourLudek Finstrle
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-15Fix identifier case sensitivity [Chris Ingram]Dave Page
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-24Remove trailing commas in structs; reported by jason dangBruce Momjian
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.
2003-05-271) Corrent the handling of bookmark in SQLBulkOperations.Hiroshi Inoue
2) Correct the calculation of a global index in SC_pos_add. 3) Cleanup global/rowset/resultset index handling a little.
2003-04-231) Avoid password leak in the log.Hiroshi Inoue
2) Reduce time() calls for the performance. 3) Improve the handling of per Driver resource. 4) #define HAVE_STRTOLL etc.
2002-12-20Change SQLFreeStmt(.., SQL_CLOSE) to not DEALLOCATE prepared statements.Hiroshi Inoue
2002-12-161) Separate APD and IPD more explicitly.Hiroshi Inoue
2) Add a conversion functionality between SQL_C_CHAR and SQL_VARBINARY. 3) The first cut of the use of server side prepare. 4) Check if a relation is a view more precisely. 5) Fix a crash bug with no parameter binding for prepare statements with parameter markers(bug report from Han). 6) Fix a bug about SQLGetDiagField(bug report from Han). 7) Add a missing ENTER_STMT_CS at the start of SQLForeignKey().
2002-11-26Change CURSOR_TYPE or CONCURRENCY statement attribute toHiroshi Inoue
be reset on cursor close per bug report from Glen Parker.
2002-10-24Add multithreading on Solaris and Linux by Janet BorschowaHiroshi Inoue
<borschow@roguewave.com>.
2002-09-231) Removed most static variables for thread safety.Hiroshi Inoue
2) Trial implementation of the thread safe driver under Windows. 3) Fix a bug about DSN options setting. 4) Fix a bug about Driver options setting. 5) Implement SQLProcedureColumns(). 6) Changed default numeric precision/scale. 7) Fix some memory leaks in Unicode driver. 8) datetime -> timestamp with time zone since 7.0. 9) Change manually started(using begin) transactions never be implicitly committed.
2002-08-09Change LOCK statements to start new transactionHiroshi Inoue
in auto-commit off mode.
2002-05-221) Support Keyset Driven driver cursors.Hiroshi Inoue
2) Supprt ARD precision/scale and SQL_C_NUEMRIC. 3) Minimal implementation of SQLGetDiagField(). 4) SQLRowCount() reports the result of SQLSetPos and SQLBulkOperation. 5) int8 -> SQL_NUMERIC for Microsoft Jet. 6) Support isolation level change. 7) ODBC3.0 SQLSTATE code. 8) Append mode log files.
2002-04-121) Fix a bug in declare/fetch mode.Hiroshi Inoue
2) Suppress some error logs for the request to other drivers.
2002-03-28[2002-03-28]Hiroshi Inoue
1) Prepare to separate 4 kinds of Descriptor handles. 2) Detect the transaction status more naturally. 3) Improve Parse Statement functionality for the use of updatable cursors. 4) Improve updatable cursors. 5) Implement SQLGetDescField() and improve SQLColAttribute(). 6) etc.
2002-03-141) Internal improvements to handle updatable cursors(1st cut).Hiroshi Inoue
2) Fix a bug in SQLColAttribute().
2002-03-081) Implement SQLParamOptions().Hiroshi Inoue
2) Handle Multiple results and implement SQLMoreResult(). 3) Improve multibyte handling thanks to Eiji Tokuya. 4) Add new options. LF <-> CR/LF converion. TRUE is -1 (for VB). 5) Introduce unicode(UCS-2) support. 6) Reduce the length of connection strings. 7) Improve SQLError, SQLGetDiagRec(ODBC 3.0). 8) Implement SQLTablePrivileges(). 9) Miscellaneous changes for ODBC 3.0 support.
2002-02-18The version is now 7.01.0010.Hiroshi Inoue
1) Handle parameter array. 2) Allow re-use of the connection handle after SQLDisconnect. 3) Reject NULL if no indicator specified. 4) Improve the handling of '_' in table name. 5) Unify internal begin/commit/abort operations. 6) Change SQLTables() to return null not "" for the table_owner. 7) Fix a bug about parameter handling reported by Benoit Menendez. 8) Add cast in handling ODBC date/time escape sequences. 9) Fix a bug about cache_size handing in declare/fetch mode. [ODBC3.0 related] 10) Improve the handling of descriptor handles(ODBC3.0). 11) Improve the type handling of some types for ODBC3.0. [Thanks to Marcelo Aceto for his useful patches] 12) Allow nested ODBC escape. 13) Allow changing autocommit on/off inside the transaction block. 14) Improve the handling of ODBC scalar functions.
2002-01-14Small AIX fixes from Rick Flower.REL7_2_RC2REL7_2_RC1REL7_2REL7_2_STABLEBruce Momjian
2001-10-28Another pgindent run. Fixes enum indenting, and improves #endifBruce Momjian
spacing. Also adds space for one-line comments.
2001-10-25pgindent run on all C files. Java run to follow. initdb/regressionREL7_2_BETA1Bruce Momjian
tests pass.
2001-09-22Provide some initial support for building the ODBC driver forPeter Eisentraut
an already installed iODBC or unixODBC driver manager. In particular, use the include files provided by the driver manager over our own, and use the odbcinst library of the driver manager rather than gpps.c. Migrate portability sections common to several files into psqlodbc.h.
2001-09-101) Fix SQLForeignKeys() in multibyte mode.Hiroshi Inoue
2) Fix a bug with NUMERIC scale in case of Parse statement option. 3) Remove a no longer needed loop in CC_send_query(). Hiroshi Inoue
2001-09-08Resolve compile errors on unix.Hiroshi Inoue
Rename psqlodbc.def -> psqlodbc_win32.def. Improve internal *declare cursor* handling a little. Hiroshi Inoue
2001-09-071) Most driver options could be set per DSN.Hiroshi Inoue
2) Keep FE/BE protocol more precisely. 3) Improve procedure calls. 4) A trial to avoid PREMATURE execution(#ifdef'd now). Hiroshi Inoue
2001-08-24Rename config.h to pg_config.h and os.h to pg_config_os.h, fix a number ofPeter Eisentraut
places that were including the wrong files.
2001-08-181) Change all internal SQL function calls fromHiroshi Inoue
SQLxxxx() to PGAPI_xxxx(). 2) Handle an escaped date/time format as a parameter. 3) Improve the tuple allocation a little. 4) The preparation of ODBC 3.0 a little. 5) Updatable cursors(may be deprecated before long).
2001-06-27Handle Procedure calls.Hiroshi Inoue
Now the version is 7.01.0006.
2001-06-20Change the driver so that large error messages are returnedHiroshi Inoue
by multiple SQLError calls.
2001-05-25Get rid of the following size limit.Hiroshi Inoue
1) Query size limit(was 65536) for >=7.0 servers. 2) Text size limit(was 8190) for 7.1 servers.
2001-05-08Run pgindent on ODBC code only, to reformat new comments.Bruce Momjian