Actian PSQL v12.10 Update 8

Patch Release - 8/09/2017

Install Build version 12.11.021

Components Build version 12.11.020

Products

This update is for the following Actian PSQL products:

Executables

These patch notes apply to the following executables:

By default, these updates create a patch installation log in the %temp% location. If instead you are using an .msp file extracted from one of these executables, then to create a log file when applying this patch, run the patch executable from a command line with the /l option. In the following example, the patch update creates a verbose log file named patch_install.log:

PSQLv12Patch_type.msp /l*v <path>\patch_install.log

Uninstalling Notes

On Windows systems, in most cases a PSQL patch update can be “rolled back” by uninstalling it. This removal restores PSQL binaries to their versions before the update. (See the note below about unremovable patches.)

To uninstall a product update for PSQL from the command line, you need the following:

·         Original installation package (.msi) or the Product Code GUID for the installation. Each PSQL install type has a different product code GUID.

·         Original Microsoft patch (.msp) file.

Either of the following commands can remove a product update:

·         msiexec /package <{path_to_MSI} or Product_Code_GUID> /uninstall <path_to_MSP> /l*v "%temp%\uninstall_patch.log"

·         msiexec /i <{path_to_MSI} or Product_Code_GUID> MSIPATCHREMOVE=<path_to_MSP> /l*v "%temp%\uninstall_patch.log"

Note that the user executing the command must be able to access the source files installed by the original PSQL installation.

Note: In certain cases, a PSQL patch cannot be removed. A warning message states “Uninstallation of the patch package is not supported,” which also is entered in the installation log file. If the patch must be removed, first uninstall PSQL entirely and then reinstall the version you need, along with the appropriate patches.

 

Issues Addressed

Specific issues addressed in this patch release (Build 12.11.021):


 Tracking Number


Description

PSQL-3992

Export Table Schema in PCC fails to export default if it is a single space

PSQL-5033

Complex query generating multiple temp tables with nested table subqueries returning a LONGVARCHAR column using a forward-only cursor may crash the SQL engine

PSQL-5078

SQLColumns may return multiple instances of columns in some cases with very large databases

PSQL-5101

PCC should prompt to restart engine when changing the “Use Cache Engine” setting

PSQL-5148

Query with CASE in the outer SELECT list and the SELECT list of a table subquery may crash the SQL engine

PSQL-5154

Status 22 returned by BDU when loading data into table with many indexes, even though data is loaded correctly.

PSQL-5171

Buffer overflow not detected on direct communication to port 1583/3351

PSQL-5185

Corrupt file causes a divide by zero crash in the MKDE

PSQL-5208

Complex query with CASE and table subqueries with joins may return a Syntax Error

PSQL-5217

BDU is not properly handling empty strings and null entries from import file

 

Previous issues addressed since release PSQL v12.10 


 Tracking Number


Description

PSQL-2367

Applying updates on PSQL v12.10 is not updating the registry to 12.11.xxx

PSQL-2585

Trace requester treating 0x09 character as printable causing output to be skewed

PSQL-3628

Patching adds duplicate –data & -configuration lines to Builder.ini and PCC.ini

PSQL-3737

Possible performance hit in an environment with a large number of open & close requests on files undergoing heavy I/O.

PSQL-3853

Enhanced ADO.NET’s performance when using dynamic parameters which required Unicode character conversion

PSQL-3858

Syntax Error returned on nested table subqueries

PSQL-3865

Uninstall hangs if PSQL services are set to manual and stopped before uninstalling

PSQL-3867

SRDE allows multiple users into the database when setting security on database

PSQL-3872

PCC About menu on Linux displays the components version instead of the install version

PSQL-3896

SRDE may crash when using dynamic parameter for TIMESTAMP column in IN clause

PSQL-3897

SQL engine may crash  when executing a query on joined tables with a non-correlated subquery on one of the same tables

PSQL-3899

Status 19 returned when updating multiple files with different file version in a transaction

PSQL-3921

Memory leak in PvTable.SetRange

PSQL-3926

Upgrade to v12 SP1 from v11 Client 64 on WGE32 may corrupt machine.config for ADO.NET

PSQL-3927

“Error in Expression” is returned if first parameter of the REPLACE() scalar is dynamic

PSQL-3956

Query with IN clause on a subquery using TOP returns incorrect results

PSQL-3993

Status 148 being returned from defragmenter

PSQL-4012

Identical SELECT query returns different results when run again

PSQL-4065

SQL Engine may crash when dropping a database while logged into a different database.

PSQL-4069

SELECT TOP with scrollable cursor returns incorrect rows

PSQL-4075

Engine stops responding when processing Stored Procedure with columns using Unicode names

PSQL-4081

Cannot create Stored Procedure if there is a SQL reserved words in the PRINT statement

PSQL-4084

Engine returns error -5099 when executing stored procedures that mix UTF-8 and DBEnc formats "Unable to open table"

PSQL-4090

Correlated query using EXISTS or IN or ANY/ALL may return incorrect results

PSQL-4095

Misconfigured Windows user may cause Engine crash when connecting via DTI/DTO

PSQL-4099

Non-segmented file with final size > 4GB becomes corrupted after defragmenting

PSQL-4104

Multiple issues with SELECT TOP were addressed

PSQL-4120

Top n returns incorrect results with scrollable cursor with SQL_FETCH_ABSOLUTE

PSQL-4181

Maintenance Utility error message is truncated

PSQL-4187

ODBC sessions disconnect after 7 hours if Pervasive Auto Reconnect is on

PSQL-4284

Possible status 3116 returned from Client Cache Engine under load

PSQL-4291

MKDE hangs instead of returning status 2 when accessing a corrupted file

PSQL-4293

Can now use NULL in selection list of an IF clause

PSQL-4296

OLE-DB Provider returns invalid column definition when using MS Linked Server

PSQL-4301

PCC database properties displays relational constraints incorrectly

PSQL-4302

“Error in Predicate" returned for SELECT … WHERE  <constant> IN subquery

PSQL-4304

Resizing GUI Defragmenter window returns "index out of range" error

PSQL-4307

DDFBuilder returns Eclipse error when opening a table

PSQL-4309

Table subquery with UNION and ORDER BY DESC may return incorrect results

PSQL-4329

Disable "Page server invalidation list is full" message

PSQL-4331

Defragmenter stuck in Commit Pending due to VSS

PSQL-4336

Correlated subquery with UNION returns “General Error”

PSQL-4382

Linux Server crash processing inserts from UTF-8 encoded CSV file

PSQL-4384

Cache engine can skip periodic page-invalidation requests

PSQL-4386

Using Cache Engine may return 3116 errors

PSQL- 4392

DDFBuilder sometimes does not display key segments properly

PSQL-4393

PSQL v12 cannot handle multibyte string path with in 255 bytes as ShiftJIS

PSQL-4410

Subquery using UNION returns unknown prefix ‘View4Tab1’ error

PSQL-4411

SELECT with WHERE clause on non-indexed string field returns empty grid in PCC

PSQL-4418

Query with ANSI-PADDING off requiring temp file returns different results on second execution

PSQL-4429

Inconsistent results using ANY (subquery) with VARCHAR versus LONGVARCHAR field

PSQL- 4433

For the PSQL Client on a 32-bit Windows OS, the version is not properly updated after patching

PSQL- 4434

Patching the PSQL 12 Workgroup Engine on a 32-bit OS produces an unnecessary “InstallDir64” registry entry

PSQL-4438

Possible incorrect results using extended operations when CACHE Engine is enabled

PSQL-4446

Security on metadata v2 database should not add ALL rights to PUBLIC on existing SP/UDF/Views

PSQL-4473

PDAC is updated to support Delphi 10.1(Berlin)

PSQL-4479

Collating sequence name not showing up in column properties of table in metadata v2 database

PSQL- 4484

ADO.NET 4.2 updated to support Entity Framework 6

PSQL-4511

Cache engine may hang under heavy load with multiple cache engines accessing shared files.

PSQL-4518

Nested subqueries within a table subquery may return “Error in expression”

PSQL-4520

Subquery table with TOP expression and alias COM2 returns "Invalid view or table name”

PSQL-4524

SELECT query with IF expressions returns incorrect results with ANSI_PADDING set to OFF

PSQL-4534

SELECT INTO with an expression subquery can fail with the error "Table or view already exists."

PSQL-4566

DROP PROCEDURE with more than one space at the end returns a syntax error

PSQL-4578

Possible crash with four or more SELECT queries using a LIKE operator combined with UNION

PSQL-4579

Running the same parameterized query many times in a loop may fail with a SQLBindParameter error

PSQL-4581

ADO.NET Provider returns incorrect results for query with more than two statements combined with 'union all'

PSQL-4617

Possible incorrect values used when executing multiple SQL statements from the same statement handle, and changing parameters for each statement.

PSQL-4619

Data truncated when fetching multiple rows with longvarchar/longvarbinary data

PSQL-4627

ADO.NET provider generates PsqlException on datatable fill method on Select with IFNULL function

PSQL-4633

Possible hang in the  SQL Manager when many connect requests come in from different clients at the same time

PSQL-4669

Length & RTRIM scalar functions return incorrect results when ANSI_PADDING=OFF

 

PSQL-4675

Linux Monitor may show IP and hostname as "0.0.0.0" / "Unknown user" for application running locally

PSQL-4681

Engine should check for multiple consecutive key segments in TEMP tables for optimization

 

PSQL-4684

Cache engine may hang under load

PSQL-4707

Updated Ado.net sdk sample project "Escapes" to fix compiling error

PSQL-4708

Revoking individual rights after granting all rights on a table to a particular user can deny all rights to that users

PSQL-4739

ADO.NET provider may return intermittent errors such as System.FormatException or System.Data.ConstraintException in a high volume multi-threaded environment

 

PSQL-4778

Cache engine crash due to a memory overwrite of an incorrect keybuffer

PSQL-4779

AnsiPadding setting is causing incorrectly padded strings to be returned

PSQL-4782

Accessing a corrupt file may crash engine due to specific key page corruption

PSQL-4796

Specifying a COLLATE attribute on a non-string column in a CREATE/ALTER table could produce status 49: "Key Type is invalid" when creating an index on the column

PSQL-4808

Bulk insert via ODBC with multiple dynamic parameters set to be null may cause the engine to crash

PSQL-4832

Incorrect results returned using multiple restrictions on an indexed date column with different operators, such as = and BETWEEN

PSQL-4839

SQL engine may hang or crash when reading a view definition that is an exact multiple of 1996 bytes

PSQL-4844

Creating a legacy table with a LOGICAL column that has a DEFAULT can return Unknown Error: -19

PSQL-4853

Linux PCC monitor for MicroKernel Sessions displays "Remote" for "Local" applications

PSQL-4856

64-bit SQL engine may crash with very large query involving 2000+ conditions in the WHERE clause

PSQL-4859

When file gets to the maximum possible size, the engine may incorrectly spawn a new extension file 

PSQL-4864

IN subquery on columns with different data types (such as VARCHAR and INTEGER) may never return

N/A

Added support for Windows 10 Creators

PSQL-4930

Incorrect number of records displayed in PCC grid when a query has an embedded comment including “WHERE”

PSQL-4969

Incorrect number of rows may be returned when non-leading index segment is defined as CHAR when ansi_padding is off

PSQL-4981

"SELECT * FROM X$User" is slow to return when USER.DDF is missing

PSQL-5006

Abnormally ending a SQL connection on a Linux server may cause other connections to crash

PSQL-5034

A select with a UNION and a User Defined Function in an Order By may crash the engine

 

Technical Support

You can obtain technical support from several online options at the PSQL website:

  • Knowledge Base. Search hundreds of articles for answers and solutions others have found useful.
  • Community Forums. Join a technical discussion or post a question to start a new one.

Disclaimer

ACTIAN CORPORATION LICENSES THE SOFTWARE AND DOCUMENTATION PRODUCT TO YOU OR YOUR COMPANY SOLELY ON AN "AS IS" BASIS AND SOLELY IN ACCORDANCE WITH THE TERMS AND CONDITIONS OF THE ACCOMPANYING LICENSE AGREEMENT.

Copyright ©2015 Actian Corporation. All Rights Reserved.