log tests/JDBC_API_Tester.java @ 927:d311affc65f0

age author description
6 months ago Sjoerd Mullender Stop referring to monetdb.org/bugzilla, point straight to github.
8 months ago Martin van Dinther Extend JDBC_API_Tester program with optional second startup argument '-skipMALoutput'.
9 months ago Martin van Dinther Improve construction of SQL query in showTblContents()
9 months ago Martin van Dinther Correct expected output of getClientInfoProperties() for Dec2023 and older releases.
9 months ago Martin van Dinther Add final to classes
10 months ago Joeri van Ruth Add ClientInfo tests
10 months ago Joeri van Ruth Minor changes to JDBC_API_Tester
11 months ago Martin van Dinther Adapt output of Test 'getIndexInfo(null, sys, key_types, false, false)' for servers 11.50 or higher.
12 months ago Martin van Dinther Improve and optimize PreparedStatement.setBigDecimal() implementation. It now checks on null input parameter to prevent NPE. Also removed code to trim leading zero's.
13 months ago Martin van Dinther Corrected ResultSetMetaData methods getPrecision(), getColumnDisplaySize() and ParameterMetaData method getPrecision() for the interval data types. They now return more precise information for the 13 possible interval data types.
13 months ago Martin van Dinther Improved ResultSetMetaData.getColumnTypeName() and ParameterMetaData.getParameterTypeName() for interval types. It now returns more precise information for the 13 possible interval data types.
14 months ago Martin van Dinther Extend Test_DBCmetadata() test with missing calls to getProcedures(), getProcedureColumns(), getFunctions() and getFunctionColumns() for user defined procedure and user defined function.
15 months ago Martin van Dinther Extend Test_DBCmetadata() with calls to DatabaseMetaData methods which return a String and need to sent a query to the server to get the info.
15 months ago Martin van Dinther Adjust JDBC_API_Tester to accept new behavior of returning a varchar instead of clob or char as metadata. This new behavior applies to MonetDB servers 11.50 or higher.
15 months ago Martin van Dinther Branch cleanup_types has been merged into default, so enable the condition where type_digits is now returning a lower number.
15 months ago Martin van Dinther Resolve warning: no comment
15 months ago Martin van Dinther Prepare JDBC_API_Tester for changed output (digits return 31 instead of 32 for int, 15 instead 16 for smallint) once branch cleanup_types will be merged into default.
16 months ago Joeri van Ruth Merge 'default' into 'monetdbs' monetdbs
16 months ago Martin van Dinther Adjust test to not compare output that changes when run in different time zones.
16 months ago Martin van Dinther The String types[] passed to getTables() may contain entries containing null or empty string "". Those are invalid table types.
16 months ago Sjoerd Mullender Update copyright for the new year, move to MonetDB Foundation, add SPDX.
16 months ago Martin van Dinther In ResultSet.getObject(column, Class<T> type) and ResultSet.getObject(column, Map<String,Class<?>>) methods added support to return objects for classes: java.time.LocalDate, java.time.LocalDateTime.
16 months ago Martin van Dinther Enhanced DatabaseMetaData.getTables() method by adding support for SQL table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY' in parameter types[].
16 months ago Martin van Dinther In ResultSet.getObject() method added support for retrieving
16 months ago Martin van Dinther Fix the computed CHAR_OCTET_LENGTH value of resultsets returned by getColumns(), getFunctionColumns() and getProcedureColumns().
16 months ago Joeri van Ruth Use new MapiSocket.connect() method In CopyIntoSTDIN test monetdbs
16 months ago Joeri van Ruth Remove naive url check because the world has become more complicated monetdbs
17 months ago Joeri van Ruth Arrange testing monetdbs
18 months ago Martin van Dinther Adapt expected output of Bug_PrepStmtSetString_6382() for servers 11.48 and higher which store JSON string values in optimized form (without whitespace characters).
22 months ago Martin van Dinther Fixed javac version 20 compiler warnings.
22 months ago Martin van Dinther Corrected implementation of Connection methods getClientInfo() and setClientInfo().
22 months ago Martin van Dinther Corrected DatabaseMetaData method getClientProperties().
2023-04-20 Martin van Dinther On power8 platform on testweb the SQL parser gives different error message. Add a condition to skip the comparison for this error msg.
2023-04-18 Martin van Dinther Adapt output of command: debug SELECT 5; which is now different depending on the tested server.
2023-04-06 Martin van Dinther Enlarge timeout test from 1 to 4 seconds to prevent potential differences reported on testweb for slow (MS windows) platforms.
2023-03-16 Martin van Dinther UTF-8 is a standard character set always available on Java, so use it where needed.
2023-03-16 Martin van Dinther Correct test Test_PSsetBytes() by explicitly converting a unicode String to a UTF-8 bytes array.
2023-03-08 Martin van Dinther Change expected output values into unicode characters.
2023-02-02 Martin van Dinther Extend JDBC_API_Tester with test on calling ResultSet.getBytes() method on a blob column. It was not yet tested.
2023-02-02 Martin van Dinther Adding a missing test for testing method setBytes() on a PreparedStatement.
2023-01-26 Martin van Dinther Fixed issue when you create a new Statement, call getGeneratedKeys().getMetaData().
2023-01-19 Martin van Dinther Corrected DatabaseMetaData.getUDTs() output.
2023-01-19 Martin van Dinther Improved implementation of PreparedStatement.getParameterMetaData().
2023-01-05 Martin van Dinther Improved implementation of PreparedStatement.getMetaData().
2023-01-05 Martin van Dinther Updated Copyright year.
2023-01-04 Martin van Dinther Improve implementation of ResultSet.getMetaData().
2022-12-22 Martin van Dinther Counting only parameter markers to determine the fetchSize is not sufficiant for all Prepared statements.
2022-12-08 Joeri van Ruth Refactor BufferedMCLReader
2022-12-01 Martin van Dinther Adjust Test_DBCmetadata() to exclude creating, retrieving and dropping indices on temporary tables for MonetDB servers before Jan2022 (11.45).
2022-11-23 Martin van Dinther Eliminate hardcoded value 250 in the constructor of MonetPreparedStatement. For this an internal package method MonetConnection.getDefaultFetchSize() is added.
2022-11-23 Martin van Dinther Use nrParams when working with Parameters.
2022-11-23 Martin van Dinther Optimize number of SQL queries sent to server when ResultSetMetaData info is fetched from highest column number to first column 1.
2022-11-17 Martin van Dinther Add checks for sql String parameter to prevent NullPointerException or executing an empty sql String.
2022-11-17 Martin van Dinther Fixed an invalid error issue when a PreparedStatement had more than 250 parameters.
2022-11-16 Martin van Dinther Store retrieved rdbms version info in JDBC_API_Tester object, so it can be used by all tests, when they need it.
2022-11-16 Martin van Dinther Add test for reproducing issue #7337
2022-11-16 Martin van Dinther Add missing cleanup when an error occurs.
2022-11-10 Martin van Dinther Adapt JDBC_API_Tester to conditionally invoke running OnClientTester.
2022-11-03 Martin van Dinther Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
2022-11-03 Martin van Dinther Improve composeMatchPart(final String in). Prevent parsing pattern when length is 0. Optimise patterns: % or %%.
2022-10-31 Joeri van Ruth Add tests for autocommit and timezone handshake options
2022-10-27 Martin van Dinther Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(), getMetaData().getPrecision() and getParameterMetaData().getPrecision().
2022-10-20 Martin van Dinther Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
2022-10-19 Martin van Dinther Adding test DecimalPrecisionAndScale for showing incorrect precision and scale values.
2022-08-25 Martin van Dinther Improved DatabaseMetaData.getBestRowIdentifier() further by introducing an extra cte: tableids. It makes it easier to understand/maintain and possibly faster.
2022-08-24 Martin van Dinther Improved and optimized DatabaseMetaData.getBestRowIdentifier().
2022-07-13 Martin van Dinther Extend tests by also calling ResultSetMetaData methods getColumnTypeName(), getColumnType(), getPrecision() and getScale() from compareResultSet().
2022-06-30 Martin van Dinther Correcting implementation of Statement.setQueryTimeout(int seconds).
2022-05-11 Martin van Dinther By fixing methods getPrimaryKeys(), getBestRowIdentifier() and getIndexInfo() for local temporary tables, it also caused it to fail for global temporary tables in schema tmp.
2022-04-14 Martin van Dinther Adapt test for getTableTypes(). Filter out UNLOGGED TABLE value for stable output on all future and past MonetDB versions.
2022-03-31 Martin van Dinther Add printing missing newlines when a failure us detected.
2022-03-30 Martin van Dinther Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier() and getIndexInfo() for temporary tables in schema tmp.
2022-02-10 Martin van Dinther Forgot to cleanup created type xml. Now it will be dropped after use.
2022-02-10 Martin van Dinther Added recognition of 'xml' type.
2022-01-28 Pedro Ferreira Approved output of new label
2022-01-27 Martin van Dinther Add tests for getBestRowIdentifier() on a table which does not have a primary key but two unique constraints of which one is defined on a column which allows NULL.
2022-01-27 Martin van Dinther Added test to execute PLAN, EXPLAIN, TRACE and DEBUG queries via JDBC API.
2022-01-19 Martin van Dinther Fixed an SQL query problem in DatabaseMetaData.getBestRowIdentifier() method when used with MonetDB Jan2022 (or newer) releases.
2022-01-05 Martin van Dinther Updated Copyright year.
2021-11-23 Pedro Ferreira Restored test to outputs before Jul2021, after fixing bug #7200
2021-11-18 Martin van Dinther Simplify OnClientTester program.
2021-11-05 Joeri van Ruth Merge onclient into default
2021-11-05 Joeri van Ruth Make SQLcopyinto test work onder monetdbd
2021-09-14 Joeri van Ruth Run the OnClient tests from JDBC_API_Tester onclient
2021-10-05 Pedro Ferreira Use valid json
2021-08-04 Martin van Dinther Speed up Test_Sbatching() by including: SET sys.optimizer = 'minimal_pipe'
2021-04-15 svetlin Revert "redirect errors to stderr and exit abnormally"
2021-03-30 svetlin redirect errors to stderr and exit abnormally
2021-06-10 Martin van Dinther Approve changed output.
2021-06-01 Martin van Dinther Add code to close the resultset after use to free resources on the server.
2021-04-14 Martin van Dinther Change output to stderr when differences are found.
2021-04-07 Martin van Dinther Convert and add Test_PSlargeamount to JDBC_API_Tester.java.
2021-04-07 Martin van Dinther Remove output of Test_PStimezone which changes when summertime or wintertime is changing the default timezone.
2021-03-18 Martin van Dinther Adjust test BugConcurrent_sequences to check for the version of MonetDB server and accept the post Oct2020 server response as correct.
2021-03-11 Martin van Dinther Converted and added test bogus-auto-generated-keys (which is currently run via JdbcClient)
2021-03-04 Martin van Dinther Avoid using table names called t1 in tests, make them more unique.
2021-03-03 Martin van Dinther Implemented PreparedStatement.toString() as requested by https://github.com/MonetDB/monetdb-java/issues/8
2021-03-03 Martin van Dinther Converted and added example program SQLcopyinto() to JDBC_API_Tester.java
2021-03-03 Martin van Dinther Converted and added Test_Int128() to JDBC_API_Tester.java.
2021-02-18 Martin van Dinther Converted 12 more JDBC tests from Bug*.java into "output on exception only" tests and included them into JDBC_API_Tester.java
2021-02-10 Martin van Dinther include missing )
2021-02-10 Martin van Dinther Extended PreparedStatement.setString() json string validity test for json parameters to now also accept: numbers (with optional fractions and exponent), string literals between double quotes, and keywords: true, false and null.
2021-02-03 Martin van Dinther Added support for escaped wildcards (\% en \_) in String arguments of
2021-01-06 Martin van Dinther Update Copyright year.
2021-01-06 Martin van Dinther Improved code and implemented all tests.
2020-12-09 Martin van Dinther Implemented some more tests
2020-12-02 Martin van Dinther Implemented some more tests
2020-12-02 Martin van Dinther Changed test 'getIndexInfo(null, sys, table_types, false, false)' to resolve difference (9 instead of 10) reported on testweb for default branch.
2020-11-26 Martin van Dinther Add JDBC_API_Tester program to test JDBC Driver API methods and behavior of MonetDB server.