History Log for Actian PSQL v12

This history log documents changes to the PSQL product in three releases:

PSQL 12.10 SP1 - June 2016
Enhancements and Problems Fixed Since PSQL v12 Update 8

The following table lists enhancements and fixes in the PSQL v12 SP1 (build 12.10.067), which also includes all changes in v12 Update 8 (build 12.01.070). For that longer list of changes, see the Update 8 readme posted on the PSQL v12 download web page.

 Tracking Number

Feature Request or Problem Description

PSQL-2565

Engine fails to block defragmentation request for file already undergoing defragmentation.

PSQL-3663

SQL engine is not handling combination of literal values consisting of "--" and "?" during insert.

PSQL-3724

Client may stop responding when exiting application. Related to PSQL-3723.

PSQL-3757

Error message "SQLBind parameter has not been called" returned on insert with literal value containing nested single quotes and '?'.

PSQL 12.01 Linux Release - May 2015
Enhancements and Problems Fixed Since PSQL 12.00

The following table lists enhancements and fixes in the 12.01 Linux release (build 12.01.021). This release also includes all changes from the following 12.00 history list that apply to Linux environments.

 Tracking Number

Feature Request or Problem Description

PSQL-2222

Defragmenter error 125 on segmented file.

PSQL-2247

Application crashes when trying to open Btrieve file on nonexistent drive mapping.

PSQL-2280

Periodic error message 'Animation Start' in PCC.

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

Query with cross join that uses table subquery may crash database engine.

PSQL-2344

NCHAR column without length produces incorrect results.

PSQL-2345

IIS application crashes with heap corruption when insufficient buffer length is specified.

PSQL-2348

Constraint in Create statement does not create index.

PSQL-2397

Deleting database name on bound database deletes DDFs.

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 very large NLONGVARCHAR.

PSQL-2522

Fragmented, Unused, and Not in Order percentages may be zero for certain files in Defragmenter even after much use.

PSQL-2557

JCL connection using domain name returns status 3103.

62463

Engine may stop responding while creating index on large file because of page compression problem.

62469

Incorrect first row may be returned from stored procedure calling SELECT with GROUP BY.

62471

IFNULL returns expression evaluation error.

62474

Possible crash on query containing parameterized value if incorrectly resolved.

62480

"Null not Valid" returned from view that has user-defined function.

PSQL 12.00 Windows Release - December 2014
Enhancements and Problems Fixed Since PSQL 11.30

The following table lists enhancements and fixes in the 12.00.160 Windows release.

 Tracking Number

Feature Request or Problem Description

56790

Repair RI database name feature added to PCC.

59978

Query should not be reexecuted when returning to a SQL Window in PCC.

60430

Possible corruption with page compression and heavy load during continuous operations.

60600

GUI Rebuild does not use the selected page size.

61616

Status 1 returned on End Transaction operation when Version call is made inside transaction.

61668

Random crash in the client cache engine (Escalation 223534).

61765

Correct Windows certificates on pre-Windows 8/2012 operating systems.

61777

SQL can have long delay before returning status code 84 on a locked record.

61807

SELECT * INTO not working across databases.

61808

Status 3/73/170/171 may be seen when many users access an RI-bound database over a long time.

61816

PDAC for XE3 does not correctly handle BCD for 64-bit integers.

61820

Engine may crash during shutdown while releasing resources.

61830

General Error returned from a query with an outer join containing a constant value in the select list.

61836

Problem with psp_indexes() function may cause indexes to be created with duplicate column entries.

61837

Incorrect results returned if query involves temp table and CONCAT of nonstring columns (Escalation 230353).

61848

ADO.NET Provider SDK 3.5 is not installing ADO.NET Provider templates when .NET CLR 2.0 is unavailable.

61856

SQL engine may crash on parameterized query with a SELECT list column name containing a ‘?’.

61881

Various customer-requested enhancements to the new Monitor in PCC.

61882

PCC may hang when opening a SQL script file with many comments containing double-byte characters.

61928

VSS Freeze stage may never complete if an EndTransaction was in progress.

61933

LIKE with multiple wildcards may not find all matching rows.

61941

Various display fixes & enhancements in Capacity Usage Viewer.

61953

EOF or Syntax Error creating a Function which contains CASE via PCC.

61954

Function Executor does not create file with nonsequential key numbers specified.

61955

Function Executor KeyNum list does not include all key numbers for a file with nonsequential keys.

61958

Added support for STDEVP group aggregate (Standard Deviation of a Population).

61964

Added support for VAR & VARP group aggregates (Variance of a Population).

61965

Added support for DATEFROMPARTS, TIMEFROMPARTS, DATETIMEFROMPARTS, and DATETIMEOFFSETFROMPARTS scalar functions.

61967

SQL Engine deadlock when running with DX.

61971

SELECT DISTINCT query with joined tables may not return distinct values.

61972

Legacy tables not working properly with ADO.NET Entity Framework.

61975

Invalid Column Definition error when accessing a stored view in PSQL from a linked server connection in MS SQLServer.

61978

General Error returned on parameterized Select …WHERE ? BETWEEN column1 AND column2.

61985

File name in key buffer gets truncated when embedded spaces=On and file name contains multibyte characters.

61993

Incorrect results or SQL engine crash from REVERSE() on binary data on a Japanese OS.

62007

ODBC application may crash when run locally on a server whose name contains Japanese characters.

62013

PCC Server Monitor does not delete active sessions.

62014

Various fixes to DATEFROMPARTS, TIMEFROMPARTS, DATETIMEFROMPARTS, DATETIMEOFFSETFROMPARTS scalar functions.

62020

New Monitor does not show Japanese datasource or client host names on the SQL Active Sessions screen.

62022

Error message truncated or not returned when calling a stored procedure with an invalid parameter.

62023

Added status code 117 to be returned when corruption in a delta file is detected.

62024

Function Executor list of recent files opened may not be correctly maintained.

62041

NullPointerException error may be returned in PCC when viewing table properties.

62043

ORDER BY an aliased column in a table subquery returns Error in Expression.

62045

Possible Access Violation in SQL Server when using a Linked Server to PSQL.

62047

Status 3 returned when reading a corrupt file instead of Status 2.

62052

Workgroup Engine failing to autoload on first open request.

62059

Add IPv6 support for Linux.

62060

Add IPv6 support for PDAC and OLEDB.

62061

Add IPv6 support to pvdbpass and pvddl command line utilities.

62069

Incorrect results from query with multiple instances of the same alias.

62072

Incorrect results returned when calling DATETIMEOFFSETFROMPARTS with Fractions parameters set to 0.

62074

Count_Big() aggregate function added.

62075

Status 12 possible on multicore machine running multiple Btrieve applications.

62093

Delete Session functionality of Monitor is not removing sessions.

62094

OLEDB application connecting via IPv6 is using multiple licenses.

62097

Status 3012 on first call to Workgroup Engine because it fails to autoload.

62109

Possible engine crash when opening a database that has a large number of data paths defined.

62119

User defined function is returning cached results instead of requerying the database.

62129

Possible SQL Engine crash when using ALTER TABLE to add an IDENTITY column on a large file.

62131

Engine may crash when applying updates if “Accept Remote Requests” is off.

62151

Possible status 85 in a Windows 2012 Cluster environment.

62155

SQL engine returns incorrect results when query optimizes on a true null column’s index.

62158

User Defined Function returns no padding spaces for fixed length strings.

62161

Install build 024 for patch required original install files in order to complete.

62164

Possible incorrect data used when modifying a DBMemo (longvarchar) via PDAC.

62173

New Monitor & DTI do not properly handle Japanese machine names.

62178

Trace requesters intermix results from different threads.

62179

Possible segmentation fault when accessing a database through PHP using a web browser.

62180

Workgroup engine may return status 2 opening empty data file using 512 page size on a Win2008 machine with a 4K block size.

62181

LEFT & RIGHT scalar functions may not return correct results for binary data.

62184

Error -3390 was returned when attempting to drop a database you have a session with, even if you are the only user with a session.

62197

Unexpected deadlock when user is selecting on a primary key in a legacy table while another user in inserting into that table.

62202

Slow-down may be seen when license validation is executing.

62209

The ClientWait perfmon counter was not properly decrementing.

62210

L2 Cache size may be calculated incorrectly.

62237

Possible status 54 and/or engine hang from Update Chunk operation following an Update.

62239

Possible status 88 when ending continuous operations.

62253

Double values may lose precision in ODBC applications.

62262

Scale is missing when casting to Currency data type.

62263

Multiple executions of cached stored procedure that has UNION or UNION ALL may not execute correctly.

62267

Incorrect results when reexecution of  query with UNION or UNION ALL.

62268

ADO.NET provider may use an additional license on a Vista machine.

62277

SQL engine may crash or return error when inserting a row with a LongVarBinary column populated via a SELECT.

62278

Incorrect results when reexecuting a table query with both union & union all.

62289

Inserting and updating a binary column with an integer value produces different values.

62293

SQL OR optimization no longer requires columns to be specified in the same order as the index.

62298

SQL engine returns “currency not on record” instead of status 82.

62299

JDBC returns error or incorrect results on SELECT with subquery.

62307

SELECT with UNION and mismatched data types may return “Numeric value out of range.”

62310

MS Access 2013 64-bit may crash when connecting.

62313

ALTER TABLE to change a BINARY to VARCHAR does not properly transform the data.

62315

Added support for double-byte database names to Repair RI Database Name feature.

62323

Increased the limit to 5000 for the maximum number of databases open at one time (64-bit only).

62324

PCC option to add data file to database not showing browse/ellipsis option on Japanese OS.

62326

Possible engine crash when creating a table via ODBC using very long paths; now path can be 1024 bytes.

62337

Precision error from SELECT with DISTINCT on a decimal column when using OLEDB.

62338

11.30 engine may crash when executing SELECT INTO <temp table>.

62339

SELECT with UNION between bigint and ubigint returns SQL_ERROR -1.

62344

SELECT with UNION between longvarchar and numeric returns SQL_ERROR -1.

62346

Temp tables may not all get deleted after connection is closed.

62347

PSQL OLEDB memory leak.

62352

ALTER TABLE from legacy NOTE/LVAR to char/varchar corrupts data and may crash engine.

62355

"Invalid Index Name; index not found" on INSERT with JOINed subselect using named index.

62356

Incorrect Xf$Flags values for new tables created in V2 Metadata database.

62358

License Self Repair may fail when BackupAgent, DataExchange or AuditMaster is installed.

62359

Possible engine crash if block comment indicator “/*” is used in a string constant.

62360

CREATE TABLE with column DEFAULT specifying user-defined function  fails if function doesn't exist yet.

62361

Inconsistent upper/lower case results when fetching view names via catalog function dbo.fsqltables.

62367

"Not authorized to perform the operation" error may be returned when calling a stored procedure created with 'Execute as Master'.

62368

CREATE TABLE IN DICTIONARY with USING index number clause fails if the data file doesn't exist.

62369

Syntax error from ADO.NET provider if statement has a semicolon at the end.

62371

Added support for PDAC XE4 and XE5.

62373

Possible crash when stored procedure has typo in table name.

62377

Patch may not install over a custom installation of PSQL v11 SP3.

62379

Oledb not handling terminal service ID correctly, could cause crash.

62386

Setting the Client DSN Array Buffer Size to 64 disables the buffer.

62387

SQLBulkOperations() inserts incorrect data when auto translation is enabled and a nondefault code page is in use.

62388

Incorrect data inserted using arrays of parameters with auto translation.

62391

Incorrect results may be returned from a Stored Procedure containing a SELECT with GROUP BY.

62393

BUTIL -STAT using URI format (btrv:///demodata?dbfile=file.ddf) may cause the engine to hang.

62405

Fixed length strings may not be returned correctly when concatenated in a stored procedure or function.

62408

Engine crash when running stored procedure that use clob field.

62411

The client id had all zeroes in the PARC timeout messages.

62413

Triggers may not properly handle LONGVARCHAR/NOTE/LVAR data.

62416

Concatenating LongVarChar data in stored procedure not being handled correctly.

62421

Incorrect date return with stored procedure using user-defined function and ORDER BY DESC.

62422

SQLBindCol() + SQLFetch of longvarchar data does not return all the data.

62423

SQLGETData for multichunk data returns incorrect results for UTF8 database with auto translation.

62425

Alter table to change default to shorter value doesn’t set value correctly.

62427

ADO.NET batch statement not executing all statements.

62429

Possible hang on engine shutdown.

62431

Alter Table can change data type of Primary Key.

62432

Update trigger may crashes with recursive updates on CLOB column.

62433

Possible memory overrun when calling a Stored Procedure with user-defined function and view.

62439

Engine crash with an update trigger on longvarchar field.

62440

Stored procedure with group by may crash Engine when result set contains only 1 row.

62442

SQL LIKE operator does not work properly on strings with private characters.

62443

ADO.NET PSQLException only has the SQLSTATE Property set if SRDE SQLSTATE property is set to numeric.

62448

Possible engine crash with very large query exceeding 64k in length.

62450

SQL Catalog function DBO.FSQLSTATISTICS does not return all unique indexes.

62450

PDAC does not accept decimals with commas as decimal separators.

62451

General Error returned from Stored Procedure instead of actual error when message is too long.

62453

64-bit Microsoft Word crashes with ODBC DSN Connection on Windows 8 and Server 2012.

62461

ADO.NET may lose a row from resultset when ReturnValue parameter is set.

67617

Possible engine crash with key inserts into file with compressed pages and several indexes.

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 ©2016 Actian Corporation. All Rights Reserved.