Releases: dbfit/dbfit
Release 4.0.0
Release date: 23 July 2022
Thanks to all contributors and to everyone who reported issues and provided feedback about DbFit!
The release notes here are still under refinement.
DbFit already needs Java 8 to run (it is not compatible with Java 7 and lower). Other changes are listed below.
New features
- Bump up FitNesse version to 20220319 (#715)
- Support SQL Server binary data types (#687)
- Support jsonb data type with Postgres database (#671)
- Add support for snowflake tests. (#665)
- Bump up to jdk8 (#657)
- Allow parameter name patterns to be varied from and restored to default values. (#622)
- Bump up FitNesse to 20180127 (#615)
- Bump up FitSharp to 2.5 (#594)
- Fix failing Netezza symbols core tests (#579)
- Fix postgres symbol tests failure (#565)
- Symbol setter value parser support (#562)
- Execute Procedure Expect Exception in standalone mode (#556)
- Enhance HSQLDB stored routine support (#554)
- Hidden symbol getter/setter support (#551)
- Oracle jdbc 12 support (#539)
- Support for executing stored procedures and functions in Derby (#524)
- Closing open connection if new method connect* is called (#485)
- Bump up hsqldb version to 2.3.3 (#461)
- Bump up derby version to 10.12.1.1 (#460)
- Support IBM Informix (#452)
- Allow escaped column and table names in postgres. (#450)
- MySql: support for unreferenced BIT columns (#439)
- Support Informix (#436)
- Support non-transactional databases (#434)
- Add support for MySQL TINY/MEDIUM/LONGTEXT data types (#428)
Minor improvements and bugfixes
- Fix website rendering (#707)
- Fix BigDecimalParseDelegate test (normalise -> transform) (#674)
- Fix Teradata doc typo (referencing Netezza) (#599)
- Fix failing Netezza symbols core tests (#579)
- test_vm: fix postgres changelog table creation (#519)
- Fix and refactor Informix DateTime types lists (#466)
- Bump up Gradle to 6.8.3 (#668)
- Bump up Gradle to 6.6.1 (#660)
- Bump up Gradle to 6.1.1 (#659)
Documentation improvements
- Corrections to instructions for publishing SNAPSHOT versions (#710)
- Fix website rendering (#707)
- Broken link/missing version? (#706)
- improve Connecting to the DB instructions (#629)
- Update Netezza emulator instructions for v7.2 (#590)
- Add Java style guide reference to contributors guide (#523)
- Fix docs typos in working with parameters section (#506)
- more MSSQL notes (#496)
- add MSSQL Database engine configuration (#495)
The details below are auto-generated and might be duplicated with the above info.
What's Changed
- add MSSQL Database engine configuration by @jeremysimmons in #495
- Bump up Gradle version to 2.14 by @javornikolov in #497
- Bump up FitNesse version to 20160515 by @javornikolov in #498
- Bump up Gradle to 3.0 by @javornikolov in #505
- more MSSQL notes by @jeremysimmons in #496
- Bump up FitNesse to 20160618 (RowSetFixture updated accordingly) by @javornikolov in #499
- Fix docs typos in working with parameters section by @javornikolov in #506
- Bump up gradle to 3.1 by @javornikolov in #511
- Bump up Mockito to 2.2.2 by @javornikolov in #512
- Set execute mode on Informix installation shell scripts by @MMatten in #514
- Test VM: updated base box (centos/7), cookbooks and packages by @MMatten in #513
- test_vm: migrate from Librarian-Chef to Berkshelf by @javornikolov in #516
- test_vm: fix postgres changelog table creation by @javornikolov in #519
- Bump up FitNesse to 20161106 by @javornikolov in #518
- Update cookbook versions by @javornikolov in #517
- Add Java style guide reference to contributors guide by @MMatten in #523
- Bump up Gradle to 3.2.1 by @javornikolov in #526
- Support for executing stored procedures and functions in Derby by @MMatten in #524
- Update test vm cookbooks (lvm and others) by @javornikolov in #534
- Bump up gradle to 3.3 by @javornikolov in #537
- Add Oracle integration tests execution to Travis CI build by @javornikolov in #540
- Oracle jdbc 12 support by @javornikolov in #539
- Add DB2 to TravisCI build by @MMatten in #543
- Bump up gradle to 3.4 by @javornikolov in #547
- Add RecentChanges.wiki to .gitignore by @javornikolov in #549
- Refactor and add tests for symbol utils by @javornikolov in #550
- Enhance HSQLDB stored routine support by @MMatten in #554
- Hidden symbol getter/setter support by @javornikolov in #551
- Add postgres to the Travis CI build by @javornikolov in #558
- Execute Procedure Expect Exception in standalone mode by @MMatten in #556
- Run travisbuild in --continue mode by @javornikolov in #561
- Bump up Gradle to 3.4.1 by @javornikolov in #559
- sql scripts: trim trailing spaces, convert to unix format by @javornikolov in #563
- Parameter value parsing refactoring by @javornikolov in #564
- Symbol setter value parser support by @javornikolov in #562
- Correct path name to SQL object creation script after move for Travis by @MMatten in #567
- Fix MySQL vagrant test vm build by @MMatten in #569
- Disable IPV6 Informix connections as problematic on vagrant CentOS image by @MMatten in #573
- Informix CalcLength: rename 1st arg to unify the definition by @javornikolov in #574
- Bump up Netezza JDBC driver version to 7.2 by @MMatten in #576
- Fix postgres symbol tests failure by @javornikolov in #565
- Provision MS SQL Server on Linux dev VM by @MMatten in #577
- Align CalcLength stored routine name for CoreTests by @MMatten in #582
- Correct paths to Informix connection properties files in .gitignore by @MMatten in #584
- Include SQL Server integration tests in Gradle tasks by @MMatten in #583
- Fix failing Netezza symbols core tests by @javornikolov in #579
- Deploy Netezza acceptance test objects via dbdeploy by @MMatten in #580
- Generalize integration test connection properties gradle tasks & gitignore by @javornikolov in #586
- Correct Netezza test DB setup/teardown by @MMatten in #587
- Add zips dir to .gitignore by @javornikolov in #588
- bump up gradle to 4.0 by @javornikolov in #589
- Update Netezza emulator instructions for v7.2 by @MMatten in #590
- Gradle wrapper - use http instead of https by @javornikolov in #593
- Bump up gradle to 4.0.2 by @javornikolov in #595...
DbFit 3.2.0
Release date: 15 August 2015
This release adds various small enhancements and bug fixes. A notable news is that we're starting to upload DbFit in the Maven Central Repository.
Thanks to all contributors and to everyone who reported issues and provided feedback about DbFit!
Special thanks to Mark Matten who contributed most of the changes!
New features
- Support long Teradata object names (#402)
bigint unsigned
support for mysql (#395)- Auto-commit configuration support (#385)
- MS SQL Server: Support access to DB objects in connection's non default DB (#376)
- Support dollar characters in SQL Server object names (#374)
- HSQLDB: allow mixed case table names in Insert/Update/Clean (#356)
- mssql stored procedure implicit return value support (#352)
- Add support for Oracle nested tables and varrays as stored procedures arguments (#347) - thanks to @avskor
- Update FitNesse to 20150424 (#364)
- Publish dbfit jars to Maven Central (#384)
Bug fixes
- bump up mysql jdbc to 5.1.36 resolving NumberFormatException issue (#408)
- Fix support for BIGINT in SPL params (#389)
- Support case sensitive collation object names in SQL Server (#362)
- fix mssql proc params metadata query errors (#353)
Documentation improvements
- Add instructions for remote debugging with Eclipse (#378)
- integrated windows authentication setup instructions (#344) - thanks to Daniel Maresma
Development and Project improvements
- Internal tests refactoring and improvements
- Ability to control which integration tests to run
- Test VM base box update, 8085 port forwarding, other maintenance
- Gradle updated to latest version
- Others
Full list of changes is available here
DbFit 3.1.0
Release date: 9 September 2014
With this release we introduce support for Netezza and greatly enhanced support for Teradata. Huge thanks respectively to Patrick and to Mark Matten who contributed to these!
New features
- Teradata support (#307, #316, #322) - thanks to Mark Matten.
- Netezza support (#337) - thanks to Patrick.
- Add Execute Ddl fixture (#312)
- Better support for statements raising exceptions outside a transaction (#309)
- Update FitNesse to 20140903 (#339)
Documentation improvements
- Enhance Eclipse usage instructions (#323)
Code Changes Which May Affect Customizations and Extensions
- AbstractDbEnvironment: moved setAutocommit(false) to afterConnectionEstablished (#327)
Development and Project improvements
- DbFit build: allow customizing Oracle connection details for the acceptance tests (#338)
DbFit 3.0.1
Release date: 13 May 2014
This is mainly a maintenance and development environment improvement release.
Thanks to all contributors and to everyone who reported issues and provided feedback about DbFit.
Thanks to Jake Benilov for carefully reviewing all pull requests and for opening up know-how about the release process to enable releasing DbFit more frequently.
Minor improvements and bugfixes
- Let undefined symbols default to NULL (#300)
- Explicitly close database statements when done with them (#291)
Documentation improvements
- Update driver name in configuration instructions for Db2 (#296)
Development and project improvements
- DB2 installer for dev/test VM (#286). Thanks to Mark Matten for contributing this.
DbFit 3.0.0
Release date: 7 May 2014
The long-overdue 3.0.0 release is out! The highlights are:
- Support for more datatypes for MySQL and MS SQL Server
- More efficient comparison of large result sets
Now that Java8 is out, we're dropping support for Java6 with this release (and since we follow semantic versioning, this release is a major release number).
Huge thanks go to:
- Yavor Nikolov for doing almost all of the work towards this release
- Mitch Davis and Marcus Rehm for their patch and feature contributions.
New features
- MS SQL Server: DATE datatype support (#255)
- MS SQL Server: TIME datatype support (#249)
- MySQL: TIME datatype support (#246)
- MySQL: allow procedure params with precision and scale (#245)
- More efficient comparison of large resultsets (#10)
Breaking changes
- Drop support for Java 1.6 (#228)
Minor improvements and bugfixes
- Bump fitnesse version to 20140317 (edge) (#252)
- Fix support for symbols with NULL value (#278)
- Scale independence when comparing decimal numbers (#261)
- MS SQL Server: Fix function calling (#257)
- MS SQL Server: allow connections to datasource\namedInstance (#256)
- Fix for CompareStoredQueries with null values (#254)
- Fix startFitnesse.bat.tmpl quotes around classpath (#236)
- Fix path separator for startFitnesse.bat (#235)
- MS SQL Server: handle columns with spaces (#234)
- include version number for dbfit-docs jar (#223)
Documentation improvements
DbFit 2.2.0
Release date: 26th January 2014
New features
- Good news for fans of comparing large data sets in DbFit. While I personally think that production data and performance tests written in DbFit are a bad idea, nonetheless we've added the ability to hide successful matches when comparing queries (#203). Thanks to Marcus Rehm and Yavor Nikolov for driving the implementation.
Minor improvements and bugfixes
DbFit 2.1.1
Release date: 12th January 2014
The DbFit project has now moved to its own GitHub organisation and the website now resides under http://dbfit.github.io/dbfit. This should allow us to better group the projects that fall under the DbFit umbrella - the dbfit-teradata project (by Mark Matten and Paul Brian) has already moved to the new org. If you have DbFit fixtures or useful code that you want to include in the org, get in touch!
Minor improvements and bugfixes
- Bugfix: Side effects on tests with Stored Queries are messing up subsequent tests with them (#205, #206)
Documentation improvements
- Re-wrote the execute procedure documentation in the command reference (#188)
- Fixed a broken link in the getting started section (#202)
- Added a new section about the test framework (#196)
Development and project improvements
Lots of work by Yavor Nikolov to upgrade the DbFit virtual machine setup and gradle build, see the GitHub milestone for details.
DbFit 2.1.0
Release date: 22nd December 2013
New features
- Support for IBM's "DB2 for i" flavor of DB2, which is integrated into i5/OS on System i (iSeries) (#162, #167) - huge thanks to Mike Patrick for contributing this!
- Oracle: support for spacial types (and other object types) (#172)
- Fitnesse docs are now unpacked along with the DbFit docs (#136)
Minor improvements and bugfixes
- Upgrade of Fitnesse to the Spring 2013 official release (v20130530) (#133)
- SQLServer: support for the DATETIME2 datatype (#157)
- DB2: support for the REAL and NUMERIC datatypes (#158)
- Postgres: support for the BOOL and BOOLEAN datatypes (#177)
- MySQL: support for column aliases (#185)
- Fix wiki doc unpacking under Windows (#166) - thanks to Mark Hopkins
- Postgres: fix for insert with increment (#138)
- Fix for autogenerated keys (#135)
- Oracle: fix for CLOB in ref cursor issue (#126) - thanks to Mark Hopkins
Documentation improvements
- Fix broken markup in FAQ (#130)
- New team behind DbFit section (#128)
- New resources added (#131)
Development and project improvements
Too many to mention, see the GitHub milestone for details.
DbFit 2.0.0 final
Release date: 31st Oct 2013
- Lots and lots of new stuff since the 1.1 release. For details, see the release notes for the previous release candidates:
- v2.0.0-RC1
- v2.0.0-RC2
- v2.0.0-RC3
- v2.0.0-RC4
- v2.0.0-RC5
- This is identical to the RC5 release, which has been stable for several months now.