summaryrefslogtreecommitdiff
path: root/test
AgeCommit message (Collapse)Author
2024-08-11Implementation of SQLSetDescRec & SQLGetDescRec functions (#23)Hunaid Sohail
* Implemented SQLSetDescRec function - Fixed SQL_DESC_PRECISION field in IPDSetField & IPDGetField functions - Added support for other fields for bookmark column in ARDSetField - SQL_DESC_TYPE - SQL_DESC_DATETIME_INTERVAL_CODE - SQL_DESC_OCTET_LENGTH - SQL_DESC_PRECISION - SQL_DESC_SCALE * Implemented SQLGetDescRec function - Handled SQL_NO_DATA case in GetField functions - Handled 01004 SQLSTATE in GetField functions - Added support for SQL_DESC_NAME & SQL_DESC_NULLABLE IPDGetField functions * Implemented SQLGetDescRecW & SQLSetDescRecW functions - Updated PGAPI_GetFunctions function to get new functions - Updated psqlodbc.def file for new functions on Windows - Fixed HY007 error handling * Added regression test for DescRec functions
2024-05-24Fixed bugs, reported in issue #8. (#25)Alexandr Kuznetsov
* Fixed bugs, reported in issue #8. Bunch of memory leaks, occuring in tests. One heap-buffer-overrun in read operation at convert.c:3162. Two memory leaks, detected by my unit tests: password, conn_settings, pqopt fields overwrite if their values provided by both, system config and connstring. Restored reference counting lifetime managment of COL_INFO objects. Some minor cosmetic changes. Signed-off-by: Alexandr Kuznetsov <progmachine@xenlab.one> * Minor cosmetic changes. Signed-off-by: Alexandr Kuznetsov <progmachine@xenlab.one> * Forgot set col_info to NULL in TABLE_INFO object while clearing it. Signed-off-by: Alexandr Kuznetsov <progmachine@xenlab.one> * Fixing comments. Signed-off-by: Alexandr Kuznetsov <progmachine@xenlab.one> --------- Signed-off-by: Alexandr Kuznetsov <progmachine@xenlab.one>
2023-06-23Define TRUE and FALSE for regression tests in case they aren't defined.Hiroshi Inoue
2023-06-23Bug fix: SQLColAttribute returns wrong column name - In some circumstances ↵Adrian Grucza
it was returning a name from the previous result
2023-06-23Prevent cursors being closed prematurelyAdrian Grucza
2022-12-23Enable SQLColumnPrivileges functionality.Hiroshi Inoue
Add a regression test for SQLColumnPrivileges().
2022-11-30Fix FetchRefcursors issues 1. Fix crash if error occurs when fetching ↵Adrian Grucza
noninitial refcursor 2. Fix error when fetching NULL refcursor 3. Return empty result if all refcursors are NULL
2021-08-29Use ODBC 3 column names for the result set of catalog functions.Hiroshi Inoue
2021-06-07Suppress compiler warnings.Hiroshi Inoue
2021-05-26Named parameter binding supportAdrian Grucza
2021-05-26The commit 2e67af added a new ansi test dsn psqlodbc_test_dsn_ansi_debug. So ↵Hiroshi Inoue
change the way how to determine ansi test driver.
2021-05-26Suppress compiler warnings.Hiroshi Inoue
2021-05-25Support fetching results from multiple refcursors * Multiple result sets are ↵Adrian Grucza
returned if multiple refcursors are found * Works with both ODBC CALL and PostgreSQL CALL syntaxes * Query must be executed in a transaction to avoid cursors being closed * Now works when output parameters are present * Added fetch-refcursors regression test
2021-04-21Add a *update returning* test case to insertreturning regression test.Hiroshi Inoue
The diff of the result was reported by Patrick Cheung and will be fixed in the later commit.
2021-04-21Add a call for SQLDescribeCol() before SQLExecute() to prepare-test.Hiroshi Inoue
The diff of the result was reported by Mangold Fabian and will be fixed in the later commit.
2021-02-18Remove deprected-test from regression test. It is no longer neededHiroshi Inoue
and causes compilation errors in some environments.
2020-11-19fixed C99 mode.Hiroshi Saito
2020-07-27Fix a compilation error with GCC 10 due to conflicting variable names.Hiroshi Inoue
Patch by Paul Wise.
2020-06-18Fix a compilation error in cygwin.Hiroshi Inoue
2020-05-23Suppress a warning.Hiroshi Inoue
2020-05-20Add regression test for batch execution.Hiroshi Inoue
2020-02-28Use diff command of git bash in preference to wsl diff command.Hiroshi Inoue
Unfortunately >> (appending redirected output) doesn't work well with wsl.
2020-01-05Fix param-conversion and error-rollback regression test in PG12.Hiroshi Inoue
Old param-conversions.out was renamed param-conversions_2.out. Old param-conversions_1.out was renamed param-conversions_3.out. Old error-rollback.out was renamed error-rollback_1.out.
2020-01-05Update the expected result of odbc-escapes regression test for PG12's new ↵Hiroshi Inoue
floating point output format. Old odbc-escapes.out was renamed odbc-escapes_1.out.
2019-12-16Flush stdout before exiting.Hiroshi Inoue
2019-11-08Fix result-conversions regression test.Hiroshi Inoue
1. Remove tests for abstime type because the type was removed in PG12. 2. Update results for PG12's new floating point output format. Results for old floating point output format were moved to result-conversions_2.out and result-conversions_3.out.
2019-10-04Silence some compiler warnings.Hiroshi Inoue
2019-05-19Bug fix: don't forget to set parameter numbers while handling escaped ODBCHiroshi Inoue
functions. Report and patch by Grant Shirreiffs.
2019-05-01Fix a typo in SQLForeignKeys-ResultSet-Column.Hiroshi Inoue
'deferrablity' should be 'DEFERRABILITY'. Report from Alexander Roskamp.
2018-10-25Increase the number of choices for "diff" commands in Windows.Hiroshi Inoue
2018-10-21Ignore BOM(byte order mark)s when there are BOMs in the input lines of ↵Hiroshi Inoue
test/reset-db.
2018-08-28Review RegisterDsn.Hiroshi Inoue
1. Add a new functionality to 'check_dsn'(renamed from 'existCheck'). This option returns 0 when dsn exists,returns -1 when dsn does not exist, (new) returns -2 when dsn exists but the driver doesn't exist. 2. Add 'reinstall_driver' option. This option is effective when 'check_dsn' option returns -2.
2018-05-23Fix compiler warnings in i386-linux-gnu.Hiroshi Inoue
2018-05-23Call AC_CHECK_SIZEOF(long int) in configure.ac and always place config.h ↵Hiroshi Inoue
before sql....h. Due to this change, sqltypes.h of unixODBC can recognize SIZEOF_LONG_INT used in psqlodbc driver.
2018-05-23Fix compiler warnings.Hiroshi Inoue
2018-05-21Create an output variable from a shell variable ODBCLIB using AC_SUBST() in ↵Hiroshi Inoue
configure.ac. The variable is used in test/Makefile.in.
2018-05-17Reduce DB access to pg_class or pg_index by caching relhasoids, ↵Hiroshi Inoue
relhassubclass etc. It would improve the performance of SQLSetPos() or SQLBulkOperations() very much in some cases. Per report from Takayuki Tsunakawa.
2018-03-26Modify positioned-update-test.Hiroshi Inoue
1. Add a SQLSetPos(.., SQL_REFRESH, ..) call so that the test passes SC_pos_reload(). 2. Add a primary key to pos-update-test table(KEYSET-DRIVEN cursor needs non null int4/oid unique key). 3. Add expected/positioned-update-test_1.out for KEYSET-DRIVEN cursors.
2017-09-13Remove the "unknown" column from colattribute-test regression test.Hiroshi Inoue
Because there's no "unknown" output column in PG10 servers, it seems meaningless to test "unknown" case.
2017-09-12Handle PG 10 identity columns.Hiroshi Inoue
2017-08-30Review ER_ReturnError().Hiroshi Inoue
2017-08-19Add a test case to parse-test.Hiroshi Inoue
2017-08-19Fix catalogfunctions-test. The output of catalogfunctions-test was changed ↵Hiroshi Inoue
along with the change of parse-test.
2017-08-19Add 2 test cases to parse-test which handles '$'s in identifiers.Hiroshi Inoue
2017-08-18Add more test cases to parse-test.Hiroshi Inoue
2017-08-18Add a test case for parse-test.Hiroshi Inoue
2017-08-06Allow building test suite using nmake in a different place other than the ↵Hiroshi Inoue
source code is.
2017-08-06Add linker option /MANIFEST:EMBED so as to build test programs in regression ↵Hiroshi Inoue
test using nmake. It is necessary for update-test and positioned-update-test because they would require administrator privileges without the option.
2017-08-04Fix a linkage error when doing installcheck for test/win.mak.Hiroshi Inoue
Report and patch by Kazuki Uehara.
2017-07-23Specify the size of query[].Hiroshi Inoue
It is neccesary because the strings are appended later.