Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Uudet ominaisuudet

PSQL 13


PSQL 12


PSQL 11


Korjaukset

PSQL 13

Specific issues addressed in patch release (Build 13.31.015):

...


 Tracking Number


Description

PSQL-3992

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

PSQL-4633

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

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

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

PSQL-4864

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

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

Excess handles allocated and not released due to legacy delay in communication components.

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

BDU may return "DataLoader | 22: The data buffer parameter is too short" when the data file has many keys.

PSQL-5163

Status 84 may be returned after issuing a SELECT FOR UPDATE query that has an empty result set

PSQL-5164

Updated Setup<product_type>_<platform>.exe launchers address an error 1723 during install

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

Old PSQL Logo displayed in PCC Preferences

PSQL-5193

Actian PSQL Perfmon counters are not properly registered after upgrade install

PSQL-5194

PSQL install/patch on Windows 10 with limited resources uses 100% CPU and does not terminate properly

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

PSQL-5247

Status 5 returned when creating a table in a database where X$Field already has an ID=65535

PSQL-5248

Add support for PARTIAL index in Schema Export/Import

PSQL 12

Specific issues addressed in patch release (Build 12.11.033):

...


 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.

PSQL 11

Specific issues addressed in Patch release (Build 11.31.101):

...