view release on metacpan or  search on metacpan

Changes  view on Meta::CPAN

        - Input filter 'join_columns': bugfix undefined column name.

2.411  2024-05-20
        - Bugfix aliases in 'order_by'.
        - Pg and SQLite: bugfix in 'dateadd'.
        - Bugfix window functions arguments.
        - 'group_concat': add 'order by' if available.
        - Update cte.

2.410  2024-05-04
        - Derived table/Cte: bugfix in 'choose_query'.
        - Bugfix in 'Operators.pm'.
        - Refactoring and cleanup.
        - SQLite does not have the operators ANY and ALL.
        - Term::Choose minimum version 1.765.

2.409  2024-04-28
        - SQLite plugin: new option to set the busy timeout.
        - SQLite: Renamed and modified the user defined scalar function 'truncate'.
                  Now 'trunc' treats any value that looks like a number as a number.
        - Bugfix in the limit/offset submenu.
        - New input filter 'convert datetime'.
        - Quote entered numbers if the data type is not numeric and no placeholders are used.
        - Added scalar convert functions.
        - Epoch_to_DateTime: bugfix and updates.
        - Data import: if chosen a deleted directory warn and remove the directory from history.

2.408_05  2024-04-21
        - sqlite_busy_timeout.
        - Bugfix limit, offset.

2.408_04  2024-04-15
        - New input filter: convert_datetime.

2.408_03  2024-04-05
        - Quote numbers if the data type is not numeric.
        - Refactoring.

2.408_02  2024-04-01
        - New: to_xxx scalar functions.
        - Refactored ScalarFunctions.
        - If chosen a deleted directory: warn and remove it from history.

2.408_01  2024-03-21
        - Epoch_to_DateTime: bugfix and updates.
        - New: Unix_Timestamp.

2.407  2024-03-11
        - Bugfix: auto-increment primary key quoted twice.

2.406  2024-03-11
        - New 'create table' options: 'table constraints' and 'table options'.
        - Update option 'auto increment column'.
        - Use storable to make deep copies.
        - DB2, Oracle, Firebird: regex operator bugfix.
        - DBD::SQLite minimum version '1.74'.

2.405  2024-02-12
        - Bugfixes in the 'search & replace' input filter.

2.404  2024-02-01
        - Update and bugfixes documentation.

2.403  2024-01-25
        - Update documentation.
        - Term::Choose minimum version '1.763'.

2.402  2024-01-03
        - Updated input filter 'search & replace'.
        - Update documentation.
        - Term::TablePrint minimum version '0.162'.

2.401  2023-12-24
        - Reset HAVING substatement when leaving the aggregate mode.
        - Use String::Substitution in the 'search & replace' input filter.
        - Now it is possible to use captured groups in the replacement part of a 'search & replace'.

2.400  2023-12-18
        - Changed SQL submenu behavior.
        - New scalar functions.
        - New extension to set aliases for all selected columns.
        - Fixes for submenus HAVING and ORDER_BY when in aggregate mode.
        - Updates for option alias.
        - Update aggregate mode.
        - Catch table-print execute errors earlier.
        - Removed backwards compatibility for old f_attached_db and f_subqueries format.
        - Use Clone to backup data.
        - Term::Choose::Util minimum version '0.140'.
        - Update documentation.

2.345_05  2023-12-09
        - Fixes for submenus HAVING and ORDER when in aggregate mode.
        - Update aggregate mode.
        - Update CTEs.
        - Update option alias for derived tables and non-unique columns in join.
        - Bugfix backup data in join.
        - Update documentation.

2.345_04  2023-11-16
        - Bugfixes in the HAVING submenu.
        - Removed option 'fast_reset'.
        - Catch table-print execute errors earlier.

2.345_03  2023-10-28
        - Use Clone to backup data.
        - New option 'fast_reset'.

2.345_02  2023-10-23
        - Bugfixes, updates and cleanups.

2.345_01  2023-10-21
        - Changed SQL submenu behavior.
        - Removed backwards compatibility for old f_attached_db and f_subqueries format.
        - Added scalar new functions.
        - Added extension to set aliases for all selected columns.
        - Update option alias.
        - Term::Choose::Util minimum version '0.140'.

2.344  2023-10-15
        - Bugfix: no table alias in update/insert/delete.