Release Notes of Invantive^® SQL for Core 24.0.471

Product Forums

Reference Manual

Invantive^® SQL for Core

Invantive UniversalSQL for Core is the .NET Core version of Invantive UniversalSQL that allows access to over 75 platforms, all acting together as one global database.

These release notes describe all bug fixes and enhancements on Invantive^® SQL for Core per released version. The release number consists of three elements: major version, minor version and patch version. The latest version is listed on top of the list, with older releases further down. Notes are listed per patch release for the current minor release. Changes from patch releases are bundled for previous minor releases. The release notes include all changes deemed informative for use outside the product development team. Refactoring, logging, translations and internal code-only changes are not included in these external release notes. A change is considered a bug fix when it solves a problem with previously released functionality. A change is considered an enhancement when the software change extends previously released functionality.

This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

• Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
• Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
• Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
• Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
• Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
• Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
• Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
• Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

Version: 24.0.471

Released: 02-12-2024 23:32:49 (UTC)

State: Production

Manufacturer: Invantive Software B.V.

Brand: Invantive

Copyright: © Copyright 2004-2024 Invantive Software B.V., the Netherlands. All rights reserved.

Limitations: For use in service area within important safety and usage conditions.

Category: Business

Email: sales@invantive.com

Forums (URL): https://forums.invantive.com/tag/invantive-sql

Manual (URL): https://go.invantive.com/sqlgrammar

MSI Product ID: 8cec1224-21c8-484e-95f0-75c4b35765a2

Version 24.0.471, released 2024-12-02.

Enhancements:
- Add SystemLocks table.
- Allow file_info to test directories and non-existing files too.
- Improved build for multiple target platforms.
- Support Oracle (21c) container databases.

Version 23.1.59-BETA, released 2023-11-25.

Enhancements:
- Add execution profile log.
- Add row counts to session I/Os.
- Added caching properties to session I/Os.
- Split session I/O duration in CPU, I/O and sleep


Details of Release Notes:


Version 24.0.471:
Split session I/O duration in CPU, I/O and sleep
#	src/Invantive.Data.Core/Providers/Os/OsProvider.cs

Version 22.1.276-BETA, released 2022-07-02.

Enhancements:
- Add Danish, Finnish, Norwegian Bokmal and Swedish.
- Add Japanese.
- Capability to ignore error when accessing a non-existing file with file_info.
- Enable configuration of default thread pool size.
- Extend file copy by additional options.
- Improve performance by retrieving metadata in the background on startup.
- Move AccountView, Odbc and Oracle for .NET Core to support both .NET Framework and .NET Core.
- Reduce errors on event log unavailable for .net core.
- Upgrade from .net Framework 4.7.2 to 4.8.0.

Bug fixes:
- Avoid ArgumentOutOfRangeException on Oracle RDBMS with 128 character limit on bulk loading.
- Disable bulk insert on Oracle .net core.
- Fix itgengpr015 on Invantive Composition/Invantive Control edit parameters.
- Fix precision/scale missing on Oracle.
- Fix regexp_split_row to return multiple columns.
- Fix SQL parameter naming for fields containing invalid identifier characters.
- Improve determination of object name.
- Make all Oracle fields "influences insert".
- Register Oracle client IP address.

Version 20.2.241, released 2021-11-30.

Enhancements:
- Add error message on failed calls.
- Add Oracle Managed Core provider.
- Cancellation on pending requests.
- Centralize rate limiting.
- Change execution log and native call logging to NDJSON format.
- Improve Linux directory separator and CR/LF compatibility.
- Make email address resolution through registry only available on Windows.
- Move incremental data to cache folder.
- Reduce garbage collection.
- Switch to IPv6.
- Upgrade to .NET 6.

Version 20.1.471-BETA, released 2021-04-12.

Enhancements:
- Add compiler options to error itgenshr008.
- Add ignore_errors to read_file and read_file_text on OS-connector.
- Add log file and trace file name path to Data Hub end-user failure reports.
- Add main category to providers.
- Add public query parameters to session I/O in data dictionary.
- Better clean email addresses.
- Enable free space on system disk check during startup using environment variable INVANTIVE_MIN_GB_FREE_SYSTEM.
- Improve handling of disk full.
- Introduce INVANTIVE_CONFIGURATION_PERMANENT_CACHE_FOLDER and INVANTIVE_CONFIGURATION_INCREMENTAL_DATA_FOLDER environment variables for configuring location of permanent cache (such as Swagger specifications) and incremental data (such as Exact Online sync APIs).
- Log native calls also to disk.
- Make free disk space check configurable.
- Make locker readonly.
- Memorize last action.
- Refactoring [INTERLAL]
- Rename Open Data to Public Data.
- Replace return value to exception.
- Return primary key, row count and native answer from insert.

Bug fixes:
- Fix race condition in determining IUID.
- Improve concurrency.
- Improve Windows 10 detection

Version 17.33.303-BETA, released 2019-06-16.

Enhancements:
- Add Mac OSX support.
- Add OS provider to .NET Core applications.
- Allow check on maximum length of file name and path combined.
- Bridge Online provider.
- Improve usability on MacOS.
- Initial release for .net core 2.0.
- SQL: Add htmltable table function.
- Twinfield.
- Update to .NET Core 3.1.

Bug fixes:
- Exclude non-existent path from files@os.
- Make read_file_text return identical Incapable to read_file when file doesn't exist.