view release on metacpan or  search on metacpan

Changes  view on Meta::CPAN

2.421  2025-01-09
        - Update join condition.
        - Update join menu and union menu.
        - Update function 'group_concat' and the respective equivalents.
        - Don't delete the alias of a column if the column has been removed from the selected columns.
        - String functions and Postgress: convert automatically to text if a column is not char and not varchar.
        - Removed backwards compatibility layer for old search_and_replace settings storage format.

2.420  2024-12-27
        - New option: use aliases in 'group by', 'having' or 'order by'.

2.419  2024-12-20
        - Update input filter Range_Rows.

2.418  2024-12-18
        - Update input filter Choose_Rows.
        - New input filter Empty_Rows.
        - Text::CSV_XS: use 'getline_all' instead of 'getline'.

2.417  2024-11-17
        - Confirm update/delete without where clause.

2.416  2024-10-28
        - Term::Choose minimum version 1.767.

2.415  2024-09-05
        Extended argument 'column': use horizontal format.

2.414  2024-06-13
        - Bugfix Informix 'not matches'.
        - Bugfix in 'replace' function: allow empty replacement string.
        - Bugfix Informix 'day_of_week'.

2.413  2024-05-23
        Bugfix import: don't check for emptiness of the first row if the file is a text file.

2.412  2024-05-21
        - New scalar function 'date_subtract'.
        - Oracle: bugfix in 'date_add' and 'to_epoch'.
        - Oracle does not 'left' and 'right' functions.
        - Bugfix in scalar function 'extract': uppercase field argument.
        - 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.