DBMS Linter Modifications List of 18.07.2012

18.07.2012

Platforms:

Windows

A new variant of inter-task memory exchange implemented for communication between the kernel, clients and network utilities. Support of several new compilers added, including the new versions of Visual Studio (C, C++, C#) and PHP. New selection options added to the distribution (new network utilities and many other selection parameters).

UNIXх64 Systems

QNX

INTROS-VM

The situation with insufficient size of 64k for an object during lindesk build eliminated.

Itanium

DBMS Kernel and SQL Translator:

A numeric sequence can now be generated by an SQL query (syntax: SELECT LEVEL FROM (SELECT 1) CONNECT BY LEVEL < value; ).
Hierarchic query processing optimized for many parent elements having only one child element each.
The REBUILD command can now rebuild only the indexes without rebuilding the converter. Syntax: REBUILD TABLE table_name INDEXES ONLY.
A command added to locally correct an index page in which problems were detected. Syntax: CORRECT INDEX index_name ON table_name FOR [FILE file_number] PAGE page_number.
Using NCHAR and NCHAR VARYING arguments for FINDBLOB and COUNTBLOB functions allowed.
Transaction work in the Optimistic mode optimized.
Codepage description correctness checks (on codepage creation) added.
Query parameter values can now be entered into LINTER.LOG.
A NaN value can be returned as a result of any scalar operation with floating-point numbers if at least one of the arguments is a NaN value.
The work of the GREATEST and LEAST functions for string-type arguments corrected (varying-length type arguments allowed; CHAR/VARCHAR arguments cannot be mixed in order to avoid incorrect processing).

Utilities:

.NET

lindeskx

testdb

Incorrect warnings about not supporting long files (for tables containing such files) eliminated.
It is now possible to detect the existence of several rows in a simple index for the same rowid at the -i 2 level (in the previous version, only level -i 3 was possible).
Complete index check (-i 3) for Version 6.1 optimized.

inl

The time of parameter values entry by the user excluded from the query processing time calculation.
The output of result column names starting with spaces enhanced.

migration

Single-file saving support added.
Qt3Support is no longer used for Qt4 in all utilities based on the Qt interface.

Interfaces:

Call

Thread stack size can now be set by default or from a user program (by calling the inter_control function with the ICR_SET_STACK_SIZE operation code).
BOOLEAN parameter values can now be entered in the lower case (t, f, true, false).

LinAPI

A new field (OPEN_DESC structure) has been added to the t_Connection structure to get the database description in the asynchronous mode in the AstConnect function.

LINCPPAPI

If a connection is broken, it cannot be re-established for asynchronous commands, and the saved queries buffer cannot be run. Any asynchronous calls of LINCPPAPI functions are now fully supported by the asynchronous LINAPI calls. When the saved queries buffer is run, all the queries are executed synchronously. Three tests for the LINCPPAPI library asynchronous mode have been added to the examples.
Error code generation in input-output operations added.

ADO.NET

ODBC

PHP

Problems Solved:

with possible omission of phrase index generation after restoring the database from the lhb archive;
with possible data access conflicts between two channels in the same transaction;
with omission of the action after a channel adding a row waits;
with slow deletion of large indexes due to displacement of pages from the pool;
with the insufficient size of the buffer for PDF file indexing;
with TEST TABLE command looping if an error is generated before table check;
with writing BLOB values for a certain size of source data;
with processing NCHAR arguments in the XML function;
with processing EXISTS and NOT EXISTS predicates in the CASE construction;
with the LOGIN ERROR TIMEOUT functionality;
with the execution of PARTITION BY for the LEAD and LAG functions;
with executing UNION/INTERSECT/EXCEPT and CASE operations with string-type operands one of which is in the UTF-8 encoding and the other is not;
with the TABLESAMPLE construction for Versions 5.9 and 6.0;
with the LIMIT N, -1 selection limitation use;
with insertion to a table containing the GENERATED AS IDENTITY column;
with incorrect calculation of a DEFAULT value address;
with incorrect encoding for the USER pseudocolumn value;
with incorrect results when joining a column with itself;
with the operation of the MULTIME function if the long tick value overfills.