Actian PSQL v12

Patch Release - 11/9/2016

Install Build version 12.01.071

Components Build version 12.01.054

Products

This patch applies to 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.01.071):


 Tracking Number


Description

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-3905

DDFBuilder edit table sql view repeats last 2 unicode characters

PSQL-4012

Incorrect results from SELECT with table subquery and mixed AND & OR predicates

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-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-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-4307

DDFBuilder returns Eclipse error when opening a table

PSQL-4309

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

PSQL-4336

Correlated subquery with UNION returns “General Error”

PSQL-4382

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

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-4418

Query with ANSI-PADDING off returns different results on second execution.

PSQL-4429

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

Previous issues addressed since release PSQL v12.00 


 Tracking Number


Description

PSQL-1313

Btrieve file version incorrect in Linux PCC

PSQL-1998

Possible status 3 during defragment validation process

PSQL-2121

Data truncation not reported for Unicode default values

PSQL-2138

Error messages from SRDE are in English and not Japanese for PSQL-J

PSQL-2159

On a Japanese OS the ADO.NET sample program LongDataTypes does not work

PSQL-2160

ADO.NET Data Provider's DataReader cannot read NLONGVARCHAR string data over 4K bytes in length

PSQL-2222

Defragmenter Error 125 on segmented file

PSQL-2247

Application crashes when trying to open Btrieve file on non-existent drive mapping

PSQL-2275

Fujitsu Cobol ODBC sample is not working correctly with Psql ODBC

PSQL-2280

Periodic error message ‘Animation Start’ in Pervasive Control Message

PSQL-2285

PVSW.Log has excessive messages, “the system cache will be used for file”

PSQL-2287

Data truncation error on Select statement with GROUP BY on LONGVARCHAR column

PSQL-2297

Constraint in Create statement does not create index

PSQL-2298

Cross Join query with table subquery may crash database engine

PSQL-2327

Memory leak in PDAC TPVQuery on table with LONGVARCHAR or NOTE field.

PSQL-2330

Table column and procedure column defaults not always working correctly

PSQL-2331

Unicode ODBC driver's SQLGetInfo call for SQL_DBMS_NAME returns garbage

PSQL-2337

Add Wire Encryption for PCC JDBC Connections

PSQL-2338

ISQL on linux doesn't display all characters when talking to windows server

PSQL-2344

Incorrect results on nchar without length

PSQL-2345

IIS application crashes with heap corruption on W3ODBCCI.DLL

PSQL-2348

Constraint in Create statement does not create index

PSQL-2362

Updates don't work on the 12.00.163 Japanese release

PSQL-2377

Updated PSQL ADO.NET 4.0 provider:

-          PsqlDataAdapter does not work with Japanese named tables

-          Stored Procedure returns ‘invalid cast’ error

PSQL-2397

Deleting database name on bound database was deleting the ddfs

PSQL-2398

'Fragmented', 'Unused', and 'Not in order' percentages are all zero for file even after much use in defragmenter

PSQL-2399

PSQL Services have trouble starting with Anti-Virus product Installed

PSQL-2414

SQL Engine crash with query including a User Defined Function that returned many rows

PSQL-2427

PSQL Engine crashes when ordered by is used in a select statement containing a very large NLONGVARCHAR

PSQL-2431

Creating Table with ACS Causes DDF Builder to fail

PSQL-2432

Deleting Table with ACS Causes DDF Builder to fail

PSQL-2433

PCC Grid's Status Bar does not update correctly

PSQL-2449

Problem using ODBC translation dll under Psql v12

PSQL-2451

Get Direct/Chunk with 'next in blob' may fail with error 106 after rebuild on 32 bit Window engines

PSQL-2467

Updated the postinstall.sh file  in Linux

PSQL-2473

Bind/unbind v2 metadata returns "General_Error"

PSQL-2475

ADO.NET install on Japanese operating system does not properly update .Net Framework machine.config file

PSQL-2479

Before Defrag stats truncated in the GUI summary panel

PSQL-2530

Unicode driver issue with CURRENCY fields with value < 1

PSQL-2548

JCL error 3103 when URI contains Domain\\username

PSQL-2557

JCL Connection using domain name is returning status 3103

PSQL-2569

Post defrag handling of extended inserts may not be handled correctly

PSQL-2570

Decimal precision not handled properly in some cases

PSQL-2571

CAST decimal value as CHAR should maintain 0 place holders

PSQL-2574

Engine may crash when defragging file with fixed record size > 31k

PSQL-2589

Export table schema fails to include CR on each line of output file

PSQL-2599

Problem opening Btrieve file when working directory cannot be changed.

PSQL-2629

Possible crash when fetching with one handle and executing a drop table from another handle using the same sql connection

PSQL-2632

Possible crash rebuilding large segmented file into single segment file using file maintenance

PSQL-2635

Incompatible types in expression error after creating an index on one of the columns in the query.in ODBC application

PSQL-2638

Repair Bound database is not padding the Database Name with spaces

PSQL-2642

A Rebuild Analyze during a Rebuild improperly clears the "Under Rebuild" flag

PSQL-2643

IFNULL/ISNULL() in other scalar functions causes "Expression evaluation error"

PSQL-2650

Defrag may handle file segmentation incorrectly during defragmentation.

PSQL-2654

Analyzing a file during defragmentation may cause it to fail with error 125

PSQL-2658

"Out of Memory" error may occur using distinct and concat on nlongvarchar columns

PSQL-2665

PCC Displays Incorrect Version Number

PSQL-2677

Multiple triggers on same table are not respecting execution ORDER specified

PSQL-2679

The ADO.NET 4.2 Provider sample project LongDataTypes displays error "Unable to read beyond the end of the stream." when the Stream Object button is clicked.

PSQL-2725

ADO.Net returns “incompatible types in expression” after creating an index on one of the columns in the query

PSQL-2774

SQL statement is not returning the right results with ANSI_PADDING=off with temp table

PSQL-2779

SQL statement not executed in PCC on Japanese OS because of unpaired single quotes in a comment

PSQL-2794

Character conversion on Japanese OS is slower for 32-bit ODBC

PSQL-2789

ADO.NET fails with random error if there are nested datareaders

PSQL-2838

Monitor and Defrag utility may not come up on boxes with 32 or more processors

PSQL-2960

IndexoutOfRange exception may be returned by PSQL ADO.NET 4.0 and 4.1 providers when executing a stored procedure with a RETURNS clause

PSQL-3010

ADO.NET connections fail with Japanese named databases when using ADO.NET 4.2 Provider

PSQL-3018

Currency Not On Record error returned with Case expression in WHERE clause

PSQL-3020

Currency Not on Record error with ORDER BY on temp table with Case Expression

PSQL-3036

File with 1K page size and page compression may become corrupt during rebuild

PSQL-3042

Underscore (_) in table name may cause other table’s columns to show in table properties

PSQL-3043

A table with only one column of less than 4 characters displays incorrectly in DDFBuilder

PSQL-3045

CREATE DATABASE statement with blanks in the DDF or Data path may cause status 11 or 35

PSQL-3046

SRDE should create paths that do not exist when specified in CREATE DATABASE

PSQL-3052

Select from view with UNION and an invalid ORDER BY may crash the engine

PSQL-3068

PCC’s Monitor, Microkernel Communications Statistic Engine’s Uptime truncated at end of Japanese MAC

PSQL-3073

ADO.NET4.2  returns error when inserting double byte character into longvarchar data type

PSQL-3110

ADO.NET 4.1 provider: Stored Procedure INOUT parameter is not working with Command.Text

PSQL-3177

CREATE TABLE with USING clause specifying a path that does not exist should create the necessary folders and the file

PSQL-3178

CREATE…IN DICTIONARY…USING should succeed even if the specified file cannot be opened

PSQL-3222

Adding an owner name with encryption produced many extended files

PSQL-3249

Add support for the LINQ take() & skip() functions, and parameterized TOP queries for use in ODATA applications

PSQL-3258

PCC is repeating index columns when viewing indexes in the index view

PSQL-3276

OLEDB application may crash when inserting SQL_BINARY data into a NOTE column

PSQL-3289

UNION ALL query returns more records than expected when index used for IN list restriction

PSQL-3310

Incorrect results re-executing query with mixed UNION/UNION ALL and TOP clause

PSQL-3337

Continous Ops is logging messages for every file in pvsw.log

PSQL-3340

Re-executing batch sql statements with dynamic parameters may return SQLBindParameter errors

PSQL-3353

CREATE TABLE statement via SQLPrepare followed by SQLExecDirect may crash when using the Unicode ODBC driver

PSQL-3379

Defragmentation returned status 124

PSQL-3440

Add support for PDAC XE8 and XE10

PSQL-3443

Last character missing from longvarchar or nlongvarchar field on a SELECT INTO call

PSQL-3452

Make monitor max worker threads unlimited instead of displaying a value which exceeded 256

PSQL-3474

Incorrect results with ANY/ALL with TOP query using dynamic parameters

PSQL-3481

Exception with message “Object reference not set to an instance of an object” from stored procedure execution in Entity Framework application.

PSQL-3497

Possible engine crash when dynamic parameter fails to indicate a large chunk of data as LONGVARCHAR

PSQL-3531

Substring did not handle arguments that referenced positions beyond the end of the string.

PSQL-3549

AM hook module crashes when opening file whose path is greater than 256 characters.

PSQL-3557

Incorrect results from using ACOS() scalar function when column is indexed

PSQL-3575

PCC displays message when it has run out heap memory loading a very large sql document

PSQL-3576

SQLProcedureColumns do return default value for UDF functions

PSQL-3590

Engine crashes when dropping a database if another database exists that points to the same location

PSQL-3594

Incorrect results when using SELECT DISTINCT on Unicode data type

PSQL-3605

Incorrect results from ADO.NET when executing stored procedure with select procedure into a temporary table followed by a select query.

PSQL-3622

Query Plan Viewer chops strings inside filter windows

PSQL-3633

Create Database SQL command creates unneeded Windows Folder in Japanese PSQL version

PSQL-3658

Access violations in PDAC when using CURRENCY and LONGVARBINARY datatypes

PSQL-3659

PSQL Engine stops responding on SQL query with excessive predicates

PSQL-3665

Maximum number of sort columns exceeded error return from forward only cursor

PSQL-3666

IP address shown in AMViewer from remote clients is not correct

PSQL-3671

Query with static/dynamic cursor returns different results

PSQL-3702

SQL Engine returns Memory Allocation Error while running query

PSQL-3719

Message to close Notification Viewer is confusing in cluster environment

PSQL-3723

Possible crash in w3odbci.dd when PARC is enabled

PSQL-3765

Invalid cursor state returned by execute (‘create view v1 (vc1) as select 1’)

PSQL-3784

ADO.NET 4.2 provider sending incorrect parameter set to server when query has multiple statements with parameters passed in ANSI mode

PSQL-3796

Locate function in Stored Procedure does not work as expected

PSQL-3814

PCC’s text window was not scrolling properly to display results from DDL statements

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-3881

Removed PSA’s dependency on keyhelp.ocx

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-3925

Client64 installed on WGE environment corrupts ADO.NET machine.config when updates are applied to it

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 after update 7 was applied

62463

Engine may crash creating index on large file because of  a problem related to page compression

62469

Incorrect first row may be returned from Stored Procedure calling SELECT with GROUP BY

62471

IFNULL returns Expression Evaluation Error

62473

Random PDAC access violation errors using TPVQuery to retrieve data

62474

Possible crash on query containing parameterized value if incorrectly resolved.

62475

System.Access.ViolationException seen on  ADODB.RecordSetClass.Move with dynamic cursor

62480

“Null not Valid” returned from view which has an UDF.

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.