Login  |  Register
Forgot your password?


DBMS Linter Release Notes


Over 500 Changes in Various Components of the System


  • Interfaces for Python (substantially renovated) and Ruby (new)
  • ADO.NET 2.0 interface
  • DBMS kernel, backup server and other DBMS utilities management interfaces

LINPHP Interface

  • Option for fetching BLOB field values in the same way as for other field types (CO_FETCH_BLOBS_AS_USUAL_DATA)
  • Fetching BLOB values from a cursor returned by a stored procedure
  • BIND for BLOB values added
  • Work with the database optimized by removing extra calls
  • Possibility to set transformation of parameters via a php.ini file
  • New interfaces PDO and ADO
  • New PHP versions (5,6) now supported

Full Text Search System

  • Construction for building attributive indices implemented:
  • Automatic selection of filter by file contents or BLOB value
  • Indexed document secrecy tabs now supported
  • PPOOL key added for DBMS kernel start and setting the phrase index creation buffer size
  • New filter for UTF-8 documents added
  • Filters, sorting algorithms and main memory use optimized

LinDeskX Utility

  • Automatic database connection added
  • SNMP agent and remote database management enabled
  • Event mechanism added

INL Utility

  • Column encoding information can be displayed
  • ECHO {ON|OFF|ERROR} command added

SQL and Stored Procedure Language

  • Regular expression search added (SIMILAR predicate and SUBSTRING( ... SIMILAR ... ESCAPE ...) function)
  • Stored events added
  • NOW, CONCAT, and UNIX_TIMESTAMP functions added for compatibility with MySQL
  • FROM_DAYS function added
  • LEAD and LAG functions added, with syntax similar to those in Oracle (OVER (PARTITION BY ... ORDER BY...) construction)
  • EXTRACT function for working with date fields added
  • VSIZE function returning the number of bytes in the argument internal view added
  • Sub-queries allowed in the left part of the IN and NOT IN predicates, equalities and inequalities
  • Sub-queries allowed in a SELECT list (with some limitations)
  • Non-constant templates allowed in LIKE and NOT LIKE predicates
  • Expressions in lists allowed in the right part of the IN and NOT IN predicates
  • Empty list in the right part of the NOT IN predicate allowed
  • Duplicate column names in sub-queries allowed
  • ORDER BY construction allowed in sub-queries (makes sense in combination with ROWNUM construction)
  • BOOLEAN expressions allowed (in a SELECT list; in INSERT in VALUES list; in UPDATE after =; in GROUP BY; in ORDER BY)
  • Reference of an external character key to a primary key of the same type but different length allowed
  • LINTER_SYSTEM_USER pseudo-value returning the numeric ID of the current user added
  • CORRECT INDEX and CORRECT BITMAP commands added to make minor corrections to the table structure
  • Commands for temporary reference integrity prohibition added
  • SORT {DATA|INDEX} hint added for sorting method selection management
  • UNION/INTERSECT/EXCEPT operation result command naming modified
  • Commands for deleting the source code of stored procedures and triggers from the database added
  • BY APPEND modifier allowed at the end of ALTER TABLE ADD PRIMARY KEY, ALTER TABLE ADD UNIQUE, ALTER TABLE ADD FOREIGN KEY (creating an index by successively adding elements, not by sorting)
  • SLEEP function for stored procedures added
  • Transaction support added to the stored procedure language

DBMS Kernel

  • Kernel interface enhanced to support new startup parameters
  • Multilanguage assembly for Windows CE revised
  • Automatic authentication for UNIX added
  • Detailed information about loaded page types shown during startup with the /trace=decomp key
  • UNION ALL query execution optimized
  • Sorting optimized using hash search of pages in the sorting pool
  • IGNERROR kernel start key added to ignore database recovery errors
  • New columns added to the $$$CHAN information table: BASE_PRIORITY – channel priority, QUERY_PRIORITY – current query priority, CURRENT_PRIORITY – current execution quantum priority
  • Index structure testing by TEST TABLE command (and TESTDB utility) optimized
  • Parallel processing of several SELECT queries optimized
Main | Back to the list
ѕрокрутить вверх