Table of Contents |
---|
Uudet ominaisuudet
PSQL 13
PSQL 12
PSQL 11
Korjaukset
PSQL 13
Specific issues addressed in patch release (Build 13.31.015):
...
|
|
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):
...
|
|
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):
...