News

DISQLite3 5.36.4
- Yet another patch release to fix obscure problems in features associated with SQLite 3.35.0:
  - Fix segmentation fault and error reporting in new RETURNING feature.
  - Fix defect in query planner optimization related to EXISTS operators in the WHERE clause.

DISQLite3 5.36.3
- Fix a handful of problems discovered in prior releases:
  - Enhance the OP_OpenDup opcode of the bytecode engine so that it works even if the cursor being duplicated itself came from OP_OpenDup.
  - When materializing correlated common table expressions, do so separately for each use case, as that is required for correctness.
  - Improvements to error messages generated by faulty common table expressions.
  - Fix to the SELECT statement syntax diagram so that the FROM clause syntax is shown correctly.
  - Improvements the xBestIndex method in the implementation of the wholenumber virtual table extension so that it does a better job of convincing the query planner to avoid trying to materialize a table with an infinite number of rows.

YuOpenSSL 1.0.1
- Update to OpenSSL 1.1.1k.
- Add identifiers used by ICS (Internet Component Suite).

DISQLite3 5.36.2
- Patch release to fix problems that were discovered shortly after the previous release:
  - Fix a problem with growing databases in the Append VFS extension.
  - Ensure that date/time functions with no arguments (which generate responses that depend on the current time) are treated as non-deterministic functions.
  - Limit the new UNION ALL optimization so that it does not try to make too many new subqueries.

DISQLite3 5.36.1
- Fix a bug in the new ALTER TABLE DROP COLUMN feature when used on columns that are indexed and that are quoted in the index definition.

DISQLite3 5.36.0
- New language features:
  - Support for ALTER TABLE DROP COLUMN.
  - support for RETURNING clause on DELETE, INSERT, and UPDATE statements.
  - Built-in math functions.
  - Generalized UPSERT.
  - MATERIALIZED hint on common table expressions.
- Query planner optimizations to UNION ALL subqueries, the IN operator, and IS NOT NULL expressions.

SQLiteSpy 1.9.15
- Update built-in DISQLite3 engine to SQLite 3.34.1.
- Add bytecode*() table-valued function.
- Add tables_used*() table-valued function.
- Add the uint collation sequence.
- Add decimal extension functions for arbitrary-precision decimal arithmetic.

YuXMLSec 0.1.0 Beta New!
- Initial public release of YuXMLSec, which provides major XML Security standards for Delphi:
  - XML Signature Syntax and Processing (XMLDSIG).
  - XML Encryption Syntax and Processing (XMLENC).
  - Security Assertion Markup Language (SAML).

YuOpenSSL 0.5.0 Beta
- Convert some C macros to Pascal for better ICS (Internet Component Suite) support.
- Fix wrong type in Indy (Internet Direct).
- Add Synapse thread demo to illustrate thread memory cleanup.

DISQLite3 5.35.1
- Fix a potential use-after-free bug when processing a a subquery with both a correlated WHERE clause and a “HAVING 0” clause and where the parent query is an aggregate.
- Fix minor problems in extensions.

YuOpenSSL 0.4.0 Beta
- Add ICS 8.65 files modified to use YuOpenSSL instead of the OpenSSL DLLs.

YuPcre2 1.15.0
- Improve the List, List2, Replace, and Replace2 methods so that the OnFormatVariable Sender argument can be queried for MatchedStr, SubStr, etc.
- Work around compiler bugs from Delphi 7 to Delphi 2009 which resulted in “Internal Error” under certain conditions.
- Fix inifinite loop with invalid UTF-8 mode enabled.
- Fix multiple JIT problems, including character ranges optimization, character set matching, and word boundary check.

YuOpenSSL 0.3.0 Beta
- Update to OpenSSL 1.1.1i, with fix for a high risk potential NULL pointer de-reference in GENERAL_NAME_cmp.
- Add more than 150 new OpenSSL API functions.
- New Synapse TCP/IP and serial library support.

DISQLite3 5.35.0
- New TDISQLite3UniDirQuery.IntegerPrimaryKeyField option to work around potential data loss due to the 32-bit limitation of Delphi's ftAutoInc DataType.
- Query planner enhancements.
- Multiple recursive SELECTS in recursive common table expressions.
- Better error messages from CHECK constraint failures.

YuOpenSSL 0.2.1 Alpha
- Add EVP_VerifyInit(), EVP_VerifyInit_ex(), and EVP_VerifyUpdate(), ported from OpenSSL macros.
- Fix memory leaks in ICS (Internet Component Suite).

YuStemmer 5.4.0
- New Yiddish stemmer.
- Fix decoding of 4-byte UTF-8 sequences.

YuBrotli 2.2.0
- Based on Brotli v0.9.0 release: Fix a decoder “integer overflow” problem where an input size (chunk size) larger than 2GiB may cause a crash.
- Raise an exception if decoder wrapper functions run out of input. Previously, this data error was silently ignored.
- Many improvements and bug fixes.

Yunqa • The Delphi Inspiration