New Features:

• add mysql environment verbose info
• add JSONFind function, which support JSON iterate
• add new test database world_x
• SplitStatement support optimizer hint /*+xxx */
• include bats bash auto test framework
• replace mysql database driver mymysql with go-sql-driver
• add new -report-type ast-json, tiast-json
• command line dsn args support '@', '/', ':' in password
• add new heuristic rule RES.009, "SELECT * FROM tbl WHERE col = col = 'abc'"
• add new heuristic rule RuleColumnNotAllowType COL.018
• add string escape function for security

Fixed BUGs:

• fix #173 with JSONFind WHERE col = col = '' and col1 = 'xx'
• fix #184 table status field datatype overflow
• fix explain result with multi rows error
• fix #178 JSON datatype only support utf8mb4
• fix #122 single table select * don't auto-complete table name
• fix #171 support socket access type
• fix #58 sampling not deal with NULL able string
• fix #172 compatible with mysql 5.1, which explain has no Index_Comment column
• fix #163 column.Tp may be nil, which may raise panic
• fix #151 bit type not config as int, when two columns compare will give ARG.003 suggestion.

            - Git integration:
                - Create projects in remote repositories
                - Pull/commit/push automation from the DBeaver perspective
                - Integrate existing projectys with Git repositories
            - Problem with SSH and SSL connections was solved
            - Problem with missing legacy character encoding was fixed
            - Data editor:
                - "Delete cascade" feature was added
                - Problem with column order was fixed (when result contains multiple columns with the same name)
                - Problem with duplicated values in column filters was fixed
                - "Default" values were added for numbers, strings and booleans
            - Data transfer:
                - Export to a single file was fixed
                - TXT format: extra options were added
                - CSV import: timestamp columns parser was fixed
            - PostgeSQL:
                - Extensions management was added
                - Partitions DDL was added
                - Partitions create/drop support was added
                - Object description reading was fixed (+ problem with duplicated objects was solved)
                - Complex data types rendering was fixed
                - float4 data type support was fixed (wrong value render)
            - Greenplum: ERD renderer was fixed
            - Orclele:
                - Problem with read-only tables was fixed (for some Oracle versions)
                - View management: problem with semicolons was fixed
            - DB2 for iSeries:
                - Procedures DDL was added
                - Problem with schema list reading  was fixed
            - Generic driver (SQLite and others): problem with view create command was fixed
            - Plenty of minor UI bugs were fixed
        

5.10.1 (2019-07-14)

Bug Fixes

• types: text length is string constant (#11098) (6e0b137)

Bug fixes:

• keyProperty specified with parameter name could cause ExecutorException. #1485
• False positive error 'Ambiguous collection type ...' . #1472
• EnumTypeHandler is not used when the enum has methods. #1489
• Auto-mapping fails in a result map referenced from a constructor arg with columnPrefix. #1496
• Constructor auto-mapping could fail when columnPrefix is specified in the parent result map. #1495
• LocalTimeTypeHandler loses fractional seconds part. #1478
• LocalDateTypeHandler and LocalDateTimeTypeHandler could return unexpected value. #1478

Enhancements:

• You can now return 'script' from a SQL provider. The returned script is parsed using the language driver specified by @Lang. #1391
• You can now omit method attribute from SQL provider annotations when the provider method has the same name as the mapper method or its name is provideSql. #1279
• You can now get databaseId in SQL providers. #1503
• The default type handler for LONGVARCHAR is changed from ClobTypeHandler to StringTypeHandler. This improves compatibility with SAP ASE. #1484

There is a backward incompatible change.

• Because of the fix for #1478 , LocalDateTypeHandler, LocalTimeTypeHandler and LocalDateTimeTypeHandler now require a JDBC driver that supports JDBC 4.2 API. Also, these type handlers no longer work with Druid. See #1516

Early-access preview of some of the upcoming new features in Flyway 6.0.0.

See https://flywaydb.org/blog/flyway-6.0.0-beta2

This maintenance release contains bug and security fixes since the 1.3.1 release. We deem it moderate-to-high priority for upgrading.

This release fixes some security vulnerabilities, specifically related to being able to elevate role-based permissions by database users that already have access to the database. We strongly recommend that users who rely on role-based permissions upgrade to this release as soon as possible.

Security Fixes

• #1311 Fix role-based permission checking logic

Bugfixes

• #1315 Fix potentially lost invalidations in continuous aggs
• #1303 Fix handling of types with custom time partitioning
• #1299 Arm32: Fix Datum to int cast issue
• #1297 Arm32: Fix crashes due to long handling
• #1019 Add ARM32 tests on travis

Thanks

• @hedayat for reporting the error with handling of types with custom time partitioning

The music for this release was The Beatles' Magical Mystery Tour.

This is a pre-release for the new version of osquery, based on the really cool refactor done by the Facebook's team in London.

Changes between 3.4.0 and 4.0.0

This prerelease mostly introduces CMake support, CI and packaging. The following are the commits that are not related to the build system:

1. e6fe15e: macos: Add hack for boost asio string_view detection (#5592)
2. 597a0c6: buck: Remove quotes from project/buck_out config
3. 826723c: Fix boost asio string_view detection hack
4. ae25976: Fixing port logic (bugfix for a small compatibility issue between remote::http_client and certain HTTP proxies)

Full changelog: git fetch --tags && git log 214302bdeb38fbdb606774ae9165dd633b908604..4.0.0

Requirements

Linux

Ubuntu 18.04 or better

macOS

Mojave

Windows

Windows 10 or Windows Server 2016

• Fix wrong query results caused by column pruning in some cases #11019
• Fix the wrongly displayed information in db and info columns of show processlist #11000
• Fix the issue that MAX_EXECUTION_TIME as a SQL hint and global variable does not work in some cases #10999
• Support automatically adjust the incremental step allocated by auto-increment ID based on the load #10997
• Fix the issue that the Distsql memory information of MemTracker is not correctly cleaned when a query ends #10971
• Add the MEM column in the information_schema.processlist table to describe the memory usage of a query #10896
• Add the max_execution_time global system variable to control the maximum execution time of a query #10940
• Fix the panic caused by using unsupported aggregate functions #10911
• Add an automatic rollback feature for the last transaction when the load data statement fails #10862
• Fix the issue that TiDB returns a wrong result in some cases when the OOMAction configuration item is set to Cancel #11016
• Disable the TRACE statement to avoid the TiDB panic issue #11039
• Add the mysql.expr_pushdown_blacklist system table that dynamically enables/disables pushing down specific functions to Coprocessor #10998
• Fix the issue that the ANY_VALUE function does not work in the ONLY_FULL_GROUP_BY mode #10994
• Fix the incorrect evaluation caused by not doing a deep copy when evaluating the user variable of the string type #11043