New Incident Reports for 2.05

The following is a list of the new incidents reported for version 2.05. Click on the incident # in order to view the details of the incident report.

Serious Problems

Build

Title

Workarounds

1	3366	ALL Triggers Incorrectly Raising Error Message When NEWROW Columns Modified	Yes
1	3368	.NET Data Provider Leaking Memory for EDBCommand Created Automatically in the EDBDataAdapter Class	No
1	3369	Loading Updates Using LOAD UPDATES Statement Can Cause AV	No
1	3370	Restoring a Backup Created Using EXCLUDE PUBLISHED UPDATES Clause Causes Error	Yes
1	3371	Parameters Not Working Correctly When Used in CAST Functions	No
2	3372	Replication Not Handling BLOB/CLOB Column Values for Inserted Rows Correctly	No
2	3375	INOUT Parameters Not Working Properly with Recursive Procedures	Yes
2	3376	C++Builder Trial Versions Are Missing HPP Header Files	No
2	3377	Trying to Update a Published Table That Is Being Loaded Can Cause Hang	No
3	3381	Loading Information Tables with Many Descriptions Takes Too Long	No
3	3382	Cannot Recompile Servers or Utilities Due to Missing Units	No
3	3384	VERIFY/REPAIR Functionality Not Verifying Header Information Properly	No
3	3385	Altering a Foreign Key Column Via ALTER TABLE Can Cause #601 Corruption Error	No
3	3386	EDB Incorrectly Allowing Configuration Objects to be Renamed to an Existing Object	No
3	3387	Recursive Procedures Still Not Working Correctly	Yes
3	3388	Unknown Parameter Types Not Being Assigned Properly from Passed Parameter Values	No
3	3389	Jobs Scheduled for Monthly Execution Incorrectly Execute Every Minute	No
3	3390	Altering INTEGER Columns to IDENTITY Columns Can Cause Incorrect Last Identity Seed Value in Table	No
3	3391	ERROR Triggers Consuming Exceptions Even When WHEN Clause Evaluates to False	No
3	3392	ODBC Driver Can Cause Issue with Client Applications Using Fixed Buffers for Connection Strings	No
4	3405	LIKE Operator Not Working Correctly Both With and Without Escape Characters	No
4	3410	EXPORT TABLE Not Working Correctly with Views	No
4	3411	Using REPAIR TABLE to Fix Indexes After Word Generator Changes Causes Error	No
4	3413	Assigning a DECIMAL Column with a Larger Scale to a Column in a Routine Can Cause Rounding Issue	No
4	3414	LIST Aggregate Function Ignoring Empty Strings	No
4	3415	Self-Referencing Foreign Key Constraints Not Checked for Current Row During Updates	No
4	3416	Calling RETRY From an ERROR Trigger Has No Effect	No
4	3417	Unicode Migrators Not Converting Memo Fields to Unicode Properly	No
4	3420	Using Constant Array Version of TEDBDatabase.StartTransaction Method Causes Error on Commit/Rollback	Yes
4	3421	ElevateDB Server Allowing Remote Sessions to Improperly Reconnect to Sessions	No
4	3422	Opening and Closing Tables with Foreign Key Constraints in Certain Orders Can Cause an AV	No
5	3423	Creating a Database with Many Foreign Key Definitions Can Cause Exclusive Lock Error	No
5	3425	Tables Containing Many Foreign Key Dependencies Taking Too Long to Open	No
6	3426	Sensitive Query Results with SELECT Statements that Contain Expressions Can Cause AV	No
6	3427	ElevateDB Server Not Cleaning Up Dead Sessions Properly	No
6	3428	Sensitive Queries with Nested Derived Tables Can Cause AV	Yes
6	3432	Dropping Foreign Key Constraints Can Cause #401 Error with Database Catalog	No
6	3434	Dependency Checks Done When Dropping Users/Roles Can Cause Invalid Error Message	No
6	3437	Using NULL Constant in CASE Operator Can Cause Compilation Error	No
6	3438	UPDATE Statements that Use Sub-Selects with Multiple Columns Can Cause AV	No
7	3442	Table Files Not Updated Properly if Old Catalog File Cannot Be Overwritten During ALTER TABLE	No
7	3443	Updates to a Table Can Cause Next/Prior Operations on a Table Cursor to Skip Rows	No
7	3444	Missing Error Codes in the ElevateDB Manuals	No
7	3449	Trying to Alter a Table That is Opened Via a Foreign Key from Another Table Can Cause Locking Errors	No
7	3450	ODBC Driver Can Experience AV When Accessing any Tables Containing Column Without Default Expression	No
7	3452	Unicode DBISAM 2.x Migrator Causes Various Errors During Migration	No
7	3453	Insertions Into an Updateable View Are Not Reflected in the Dataset	No
7	3455	Parameterized INSERTs Causing Errors in ElevateDB .NET Data Provider	No
8	3456	Altering a Table Can Result in Error #100	No
9	3466	Executing Queries Against the ServerSessions Configuration Information Table Can Cause AV	No
9	3469	ElevateDB Manager Allows Alteration of Outdated SQL Triggers, Procedures, Functions, and Jobs	No
9	3470	Queries with Nested Derived Tables Can Experience Slowdowns with IN/NOT IN Operations	No
9	3472	Error Triggers Not Re-Raising Exceptions Properly with RAISE Statement	No
9	3474	Custom Error Codes/Messages For Columns Can Cause an AV with a Remote Session	No
9	3477	Session Connection Interruptions During Table Opens Can Cause "Error Creating Table Handle" Errors	No
10	3479	INNER JOINs On Row Values That Contain Constants Can Cause Incorrect Results	Yes
10	3486	Renaming a Job to an Invalid Name Is Improperly Being Allowed to Occur	No
10	3487	INTERSECT Queries Can Cause Result Set Error When DECIMAL Columns Use Different Scales	No
10	3488	LENGTH() Function Returning Incorrect Results for Compressed CLOB/BLOB Columns	No
10	3489	Trying to Refresh Multiple Data Connections in Excel with ODBC Driver Causes Error	Yes
10	3490	Altering a Table with Computed Columns Can Cause Invalid Floating Point Operation	No
10	3491	Closing Down a Connection In Response to a "Connection Lost" Error Does Not Work with Active Filters	No
10	3492	Importing an Export File Created Using ElevateDB Can Cause Quote Characters To Be Removed	No
10	3493	ODBC Driver Causing Single Character to Be Removed from CLOB Columns During Retrieval	No
10	3495	DBISAM 1.x Migrator Causing AV and Application Shutdown with Certain BCD Values	No
10	3496	Using a DISTINCT Query with a UNION ALL Operation Can Cause Improper BLOB Column Error	Yes
10	3499	Using CAST() With LIST() Aggregate Function Causes Incorrect Results.	No
11	3502	INSERT..SELECT Statement Not Respecting ORDER BY Clause	No
11	3504	Trying to Drop a Column in a Table Created With CREATE TABLE..AS Statement Causes Dependency Error	No
11	3506	Using the DISTINCT Clause with Aggregate Functions and GROUP BY Can Cause Incorrect Results	No
11	3507	REPAIR TABLE Not Handling Fatal Errors During Index Repair Properly	No

Minor Problems

Build

Title

Workarounds

2	3373	EXECUTE IMMEDIATE USING Clause Not Allowing ERROR Functions in ERROR Triggers	Yes
2	3374	Cannot Use a DATE Expression in a Default Expression for a TIMESTAMP Column	Yes
3	3378	Cannot Execute ALTER TABLE Statements Against Temporary Tables	Yes
3	3380	CAST with DATE FORMAT Clause Not Working Correctly without Date Delimiters	No
3	3383	Duplicate Users Can Appear in the ElevateDB Manager When Renaming a User	No
4	3409	UPDATE Statements Using Correlated Sub-Queries that Reference Outer Statement Columns Can Cause AV	Yes
4	3412	Ctrl+Tab Not Always Working for Moving Between Tabs in the ElevateDB Manager	No
4	3418	Inline CASE Operator Not Performing Type Promotion Properly on Returned Values	Yes
4	3419	Grid Columns Not Reflecting ALTER TABLE Modifications in ElevateDB Manager	No
6	3429	Modules Can Be Dropped When They Are Still In Use by Functions/Procedures	No
6	3430	Ctrl+N Shortcut Keys Causing Deletion of Selected Text in ElevateDB Manager SQL Editor	No
6	3431	ANSI ElevateDB Manager Not Remembering BIGINT Parameters Between Executions	No
6	3433	Cannot Change Statement Terminator Properly in the Preferences Dialog of the ElevateDB Manager	No
6	3435	ElevateDB Manager Does Not Insert Statement Terminator When Dragging/Dropping SQL	No
6	3436	Improper Text Not Found Error When Searching and Replacing Text in ElevateDB Manager	No
7	3445	Using Original Table Names Instead of Table Correlation Names Causes Exception with INSERT Query	No
7	3447	Breaking Up Multi-Word SQL Statement Keywords Can Cause SQL Execution to Not Occur	No
7	3448	Trigger Error Messages Have the Table Name and Trigger Names Reversed	No
7	3451	Altering Tables Causes Generated Expression Columns to Appear as Identity Columns	No
7	3454	Not Passing All Parameters to a Stored Procedure Can Cause an AV	Yes
9	3462	LargeInt Parameter Assignment Not Working Properly in ElevateDB Manager	No
9	3464	Migration of DBISAM Database Not Creating Text Indexes as Case-Insensitive	No
9	3467	Dropping a User with Granted Database Privileges Can Cause Error	Yes
9	3468	Including shlobj.h Header File with C++Builder Project Can Cause Compilation Error	No
9	3471	ElevateDB Manager Statement Selection Not Working Properly in Generic Scripts	No
9	3473	Creating a Copy of a Session in the ElevateDB Manager Can Cause an AV	No
9	3475	Importing Comma-Delimited Text Files with Missing Last CRLF Can Cause AV	No
9	3476	Template Installation Into Repository Does Not Work Properly When Shared Repository Set	No
10	3485	ElevateDB Manager Re-Preparing Queries Between Executions When Query Text Has Not Changed	No
10	3494	Conversion Error Occurring When Assigning Short Integers to Parameters	No
11	3498	Cannot Remove a Filter Column From a Text Index By Specifying "" for the FILTER TYPE COLUMN Clause	No
11	3501	IMPORT/EXPORT TABLE Statements Do Not Allow Database Names	Yes
11	3503	ElevateDB Manager Not Saving Monitor for Main Form	No
11	3505	Incorrect Error Message When Invalid Statement Keywords Used in ElevateDB Manager	No
11	3605	ElevateDB Manager Can Experience Parsing Error When Using a Custom Statement Terminator	No

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap