Incident Reports Addressed in 2.03

The following is a list of the incident reports addressed in version 2.03. Click on the incident # in order to view the details of the incident report.

Serious Problems

Build

Title

Workarounds

1	3030	SELECT Statements with Large ORDER BY Columns Can Cause AV	No
1	3044	Specifying a Database Correlation Name in a DML Statement Can Cause #401 Error for Other Tables	No
1	3045	Parameters Not Being Recognized When Used in a UNION/INTERSECT/EXCEPT SELECT Statement	No
1	3046	Updateable Views Returning Incorrect Columns with Remote Sessions	No
1	3051	Scheduling a Job for the Last Day of a Month Can Cause the ElevateDB Server to Crash	No
1	3052	LOAD UPDATES Statement Not Loading Tables in Proper Referential Integrity Dependency Order	No
1	3053	TEDBTable GotoKey and FindKey Methods Returning True on an Empty Table	No
1	3056	Putting a Database in the Program Files Folder under Microsoft Vista Causes Access Denied Error	Yes
1	3058	LIKE Producing Incorrect Results for Partial-String Matches with Certain Languages	No
1	3059	Adding the Same Table Twice to a SELECT Statement Using a Correlation Name Can Cause Error	Yes
1	3062	Using a Sub-Query that Returns a CLOB Expression in the SELECT Column Expressions Results in NULLs	Yes
1	3063	Repairing a Table that Contains Foreign Keys that Refer to the Same Table Can Cause Lock Error	No
1	3064	Displaying Binary Values in the ElevateDB Manager Can Cause an AV	No
2	3068	LOAD UPDATES Fails with "Column Not Found" Error When Loading Empty BLOB Update	No
2	3070	Possible AV When Querying on a Table During Multi-User Updating	No
3	3071	Opening the Tables Information Schema Table Can Cause Conversion Error for Published Tables	No
4	3074	ElevateDB Sessions Not Releasing Memory for Cached Updates Manager Until Engine Shutdown	No
4	3075	INSERT INTO SELECT Statements Incorrectly Including Deleted Rows	No
5	3084	Exporting an Updateable View Causes All Rows to Be Exported from the Base Table	No
5	3085	Sensitive Query Result Sets Show Incorrect Results for Generated Columns in Base Table	No
5	3086	Attempting to Repair or Optimize More than One Table in a Row Causes Temporary Table Error	No
5	3088	Floating-Point Numbers Cannot Be Entered Properly When Windows Locale is set to Spanish	No
5	3089	ALTER TABLE ALTER COLUMN..MOVE Clause Can Cause Data Loss Errors When Moving Columns	No
5	3090	Dead Sessions on the EDB Server Containing Updateable Views Can Cause Lock Errors	No
5	3091	Bookmarks Not Being Set Properly for Navigation of UNIQUE Constraint Indexes	No
5	3092	RIGHT OUTER JOINs Not Working Properly When Not Referring to Immediately Prior Table	Yes
6	3093	Derived Tables Can Cause AV During Destruction of Owning Query or View	No
6	3095	ALTER TABLE Statements That Encounter Errors Can Cause Error About a Non-Existent Temporary Table	No
6	3097	VARBYTE Columns Assignments Causing an AV in Delphi/C++Builder Applications	No
7	3103	ElevateDB Incorrectly Re-Writing LEFT OUTER JOINs that Don't Contain Join Conditions	Yes
7	3104	Executing UPDATE Statements Against Tables with Nested Foreign Key Constraints Can Cause AV	No
7	3106	Progress, Status, and Log Messages Not Being Triggered for Remote Sessions	No
7	3107	Running the ElevateDB Server under Windows 98 or Earlier Causes AV	No
7	3109	Self-Referencing Foreign Keys Causing Improper Exceptions	No
7	3110	GotoCurrent Not Working Correctly with Remote Sessions	No
7	3111	Aggregate Queries with HAVING Clause Used as Sub-Select with IN Clause Can Return Incorrect Results	Yes
7	3112	Using QUOTE CHAR #0 with IMPORT TABLE Statement Does Not Work Properly	No
7	3113	CAST Function Not Truncating VARCHAR Columns Properly	No
7	3115	Index Statistics Being Calculated Improperly for Tables and Causing Query Optimizer to Make Mistakes	No
7	3117	Query Optimizer Making Bad Decisions with Certain Join Re-Orderings	Yes
7	3118	Trying to Reconnect a Remote Session After a Timeout Event Causes Server to Not Respond to Connects	No
7	3119	Joins Taking Too Much Time and CPU when Executed on Very Large Tables	No
7	3124	Creating a Generated Expression Column with NOT NULL Constraint Causes Parsing Error	Yes
8	3131	Large Keys In Indexes Can Cause Corruption	No
8	3132	IMPORT TABLE Not Parsing Unicode Characters Properly	No
8	3134	Deleting Rows with an Active Filter or Range Can Cause #100 "Buffers Corrupt" Error	No
8	3135	Using ALTER TABLE to Move Columns that are Referenced in Triggers Can Cause AV	No
8	3136	Altering a Table Several Times and Trying to Drop a Second FK Constraint Causes Error #401	No
8	3139	Setting a Range Can Cause an AV	No
8	3142	Altering a Database to Point to a New Empty Path Can Cause Existing Catalog to Be Copied to New Path	No
9	3144	Cannot Rename an Indexed Column without First Dropping Index	No
9	3146	Large Column Sizes in ORDER BY Can Cause Infinite Loop When Navigating Result Set	No
9	3147	Modifying the Privileges of the Logged-On User Requires Session Restart	Yes
9	3148	Altering an INTEGER Column as a Generated Column Does Not Change Column Values	Yes
9	3150	Using Expressions with Sensitive Result Sets and Remote Sessions Can Cause Memory Leak on Client	No
9	3151	TemporaryTables Information Schema Table Not Reflecting CREATE and DROP Statements Accurately	No
9	3152	Queries/filters Not Refreshing on Empty Table After Inserting First Row	No
9	3153	CopyOnAppend Not Copying BLOB Column Values Correctly	No
9	3156	Mixing Column References From Multiple Tables in a Function Causes Incorrect Results	No
9	3157	Query Optimizer Re-Ordering Joins Improperly When Joins Are Already in the Correct Order	No
10	3172	Creating or Dropping Tables Can Cause #901 Errors in Functions Used in Triggers	No
10	3173	RENAME TABLE Statement Can Cause AV Later During Execution	No
10	3174	Query Optimizer May Re-Order Joins in a Way that Invalidates the Query Result	Yes
10	3176	Joins On Tables that are also Referenced in the WHERE Clause Can Cause Performance Issues	No
10	3177	Transaction Timeout Parameter Not Working for Remote Sessions	No
10	3178	Stored Procedures Not Properly Setting RowsAffected Property in .NET EDBCommand Class	No
10	3179	IN Operator Not Working Properly	No
10	3181	Mixing Column References with Aggregate Functions Causes #700 Error	Yes
10	3182	Using a Tab (#9) Character with the IMPORT TABLE Statement Can Cause Error	Yes
10	3183	Computed Columns Not Evaluating Properly	No
10	3184	Using IN Operator with Sub-Query Containing Only Aggregate Function Causes Error	No
11	3185	Using ALTER TABLE To Change the Encrypted Status or Index Page Size Can Corrupt Table	No
11	3186	Using ALTER TABLE to Add a Primary Key to an Existing Table with No Primary Key Can Cause Corruption	No
12	3187	CONTAINS Searches Using More than One Wildcard in Search Words Return Incorrect Results	Yes
12	3188	Parameterized Derived Tables Ignoring Parameters	No
12	3189	Cannot DROP a Column Used in a Constraint that is also DROPed in the Same ALTER TABLE Statement	No
12	3190	Constraint Indexes Can be Dropped Using DROP INDEX Statement	Yes
12	3191	Using ALTER TABLE to Add IDENTITY Column Causes Column to be Populated with 1 Values	No
12	3192	#601 Error When Altering a Table and Adding a New Primary Key	No
12	3193	#601 Error When Altering a Table and Dropping a Column	No
12	3194	Using ALTER TABLE to Alter an Indexed Column on a Large Table Can Cause #601 Error	No
13	3195	Temporary Tables Created by DLLs Can Conflict with Temporary Tables Created in Main Executable	Yes
13	3196	CONTAINS/NOT CONTAINS with Wildcards Not Respecting Case-Sensitivity of Indexed Column Collation	No
13	3197	ALTER TABLE Adding/Dropping BLOB Columns Can Cause Blob Corruption in Other BLOB Columns	No
13	3198	Tables or Derived Tables That Contain 0 Rows Confusing Query Join Optimizer	No
13	3199	NULL Parameters Incorrectly Returning Rows with = Operator	Yes
14	3204	Attempting to Execute RENAME TABLE Statement Against Temporary Tables Cause Access Denied Error	No
14	3205	Using IMPORT TABLE to Import a Text File Containing Large CLOB Columns Can Cause Memory Exhaustion	No
14	3206	Executing RENAME TABLE on a Newly-Created Table Can Cause File Manager Error	Yes
14	3207	Cannot Define Recursive Functions Directly and Recursive Functions Cause AV When Executed	No
14	3208	INNER JOINs Combined with LEFT OUTER JOINs Not Producing Correct Results	No
14	3209	Derived Tables with Parameters Not Executing Properly On Second and Subsequent Executions	No
14	3212	Restoring a Database with Different Table Structures Can Cause Rename Error When Adding BLOB Columns	No
14	3213	ODBC Driver Returning Incorrect Column Name for SELECT Expression Columns with Correlation Names	No
14	3216	Row Pointer Not Re-Positioning Correctly After Deletes	No
14	3217	ElevateDB Server Can Deadlock with Frequent Updates to the Configuration or Database Catalogs	No
14	3218	Using LIKE Operator with a Trailing Single-Character Wildcard (_) Causes Incorrect Results	No
15	3220	Connect Errors Cause Access Violation on Windows CE/Mobile with Lazarus/FreePascal	No
15	3221	CONTAINS Operator Not Returning Correct Results When Specifying Multiple Search Words	No
15	3222	FreePascal/Lazarus Alignment Error When Referencing TDateTimeFields	No
15	3223	NexusDB Migrator Converting Non-Unique Indexes to Primary Keys	No
15	3224	Trigger NEWROW and OLDROW Values NULL After Execution of DDL Statements	No
15	3225	Reverse-Engineering Generating Incorrect Schema Update Code	Yes
15	3226	Using COMPUTED Columns Causes AV with Remote Sessions	No
15	3227	Disconnecting and Reconnecting a Remote Session with a Filtered Table Can Cause Error	No
15	3228	Changing the Global Delphi/C++Builder/FreePascal DecimalSeparator Variable Can Cause Errors	No
15	3229	Parameters Not Working Correctly in Correlated Sub-Queries	No
15	3230	Cached Updates Not Working Properly When Used with Primary Keys Containing IDENTITY Columns	No
16	3232	Running Script in the ElevateDB Manage Debugger Can Cause Invalid Request Error with Remote Sessions	No
16	3234	IDENTITY Columns Not Assigning Values When Inserting Rows with Cached Updates On	No
16	3236	Removal of Dead Sessions with Open Query Result Sets Can Cause AV in Server	No
16	3237	Cached Updates Duplicating Rows During Application with Remote Sessions	No
17	3238	Remote Stores Incorrectly Working Like Local Stores	No
17	3240	TableAdapter Fill Method Causing NullReferenceException under Visual Studio	No
17	3241	Deleting the Last Row in a Ranged Dataset Can Cause Incorrect Positioning of Row Pointer	No
17	3242	Recursive Functions Can Incorrectly Cause Stack Overflow	Yes
17	3243	Database Catalog Table Structure Checksums Calculating Incorrectly	No
18	3244	Random AVs Can Occur When Altering Tables in ElevateDB Manager in a Way that Affects Dependencies	No
18	3245	Altering a GENERATED Column Does Not Update the Row/Index Keys Properly	Yes
18	3246	Internal Temporary Tables Being Included in ServerSessionLocks Information Schema Table	No
18	3247	Manual Row Locks Can Cause AV During Dead Session Removal	No
18	3248	Attempting to Open a Table that References a Missing External Procedure Module Can Cause AV	Yes
18	3249	Partial Locates Using Certain Collations Causes Incorrect Results	No
18	3253	Queries that Return Sensitive Result Sets Not Matching Ascending/Descending ORDER BY Properly	Yes
18	3254	Certain Collations Not Working Correctly with Text Indexing	No
18	3255	Altering VARCHAR/CHAR Columns Involved in a Key Constraint Can Cause #601 Error	No
18	3256	OnFilterRecord Not Being Respected with FindKey/Locate	Yes
18	3261	Manually Copying a File from a Local Store to a Remote Store Using a Remote Session Causes Hang	No
19	3262	ElevateDB Manager Not Picking Up Changes to Procedure/Function Parameters	No
19	3263	Requesting an Execution Plan for UPDATE Statements Can Cause AV	Yes
19	3264	Script Debugger in ElevateDB Manager Locks Up When Hitting Exception or Breakpoint	No
19	3265	Multi-Threading Issue with the DECIMAL/FLOAT Conversion to/from Strings in EDB	No
19	3266	A Failed Lookup Call Causing Subsequent Locate Calls to Improperly Fail	No
19	3267	Performing a Locate After an Insert Can Cause Invalid Records to Appear in Attached Grids	No
19	3268	ORDER BY Sorting Not Correct When Only Descending Index Present and RequestSensitive=True	Yes
19	3269	NOT LIKE Operator that Peforms Partial-Length Search Causing AV	No
20	3273	AV Can Occur When Configuration Updated After External Module Loaded	No
20	3274	ElevateDB Manager Script Debugger Can Cause Deadlock with Remote Sessions	Yes
21	3277	Placing a RETURN Statement Inside of a Nested SQL/PSM Block Causes AV	Yes
21	3282	ALTER INDEX Allowed on System-Generated Constraint Indexes	Yes
21	3284	Very Large BLOBs Can Take Excessive Amounts of Time to Read	No
21	3285	Remote Login Can Cause Session Lock Error If User Name and Password Not Specified During Connection	Yes
21	3287	Adding Months to a DATE/TIMESTAMP Across Year Boundaries Causes Index/Range Check Error	No
22	3316	Manually Unlocking All Rows After a Previous Row was Manually Locked and Deleted Causes Error	No
22	3317	Locates Can Cause Dangling Read Lock	No
22	3318	Large Insert Operations Can Cause Unbounded Growth in Index Buffers	No
22	3319	Non-Updateable Views Can Cause AV When Refreshed	No
22	3320	Dropping a Column and Altering a Constraint in Same ALTER TABLE Statement Can Corrupt Tables	No
22	3321	Sessions that Timeout on the Server Can Cause AV When Remote Session Reconnects	No
23	3329	Exclusively-Opened Tables Can Cause Excessive Memory Consumption	No
23	3330	.NET Data Provider Returns Error When Using Table Adapters	No
23	3331	ElevateDB Manager Raises AV Exception When Opening Any Table	No
23	3333	Trying to Load Updates For a Database with Circular RI Can Cause Hang	No

Minor Problems

Build

Title

Workarounds

1	3047	External Module Parameters Not Working Properly When Constant Passed Instead of Variable	No
1	3049	Migrating a DBISAM 3 Database Table Containing Formatted-Memo Fields Causes #700 Error	No
1	3054	Temporary Tables Leaving Behind .OLD Files When Altered	No
1	3055	Reverse-Engineering Adding Triggers Before Functions and Procedures	No
1	3057	Exporting Tables from Configuration Database Causes Error	No
1	3060	Subtracting a DATE from a TIMESTAMP Column Results in a NULL Value	No
1	3061	Using the h:mm:ss Time Format with the IMPORT TABLE Statement Can Cause an Error	Yes
1	3065	Using a Parameter in a CAST() Function Can Cause a Conversion Error	No
1	3066	INTERVAL Constants Can Be Specified as Integer Constants When They Should Be In Quotes	Yes
2	3069	Closing a Database Does Not Cause All Temporary Table .OLD Files To Be Deleted	No
5	3072	Migrating a Paradox Table with Paradox OLE Fields Causes Error	No
5	3073	ElevateDB Templates Not Installing Properly Into the RAD Studio 2009 IDE	No
5	3087	Starting Cached Updates on the Same Base Table Multiple Times Causes Error	No
7	3105	Can Delete a Function that is Referenced in a Trigger	Yes
7	3108	Low Disk Space Not Being Handled Gracefully	No
7	3114	Internal TDataSet InitRecord Method Not Handling Remote Session Connection Errors Properly	No
7	3120	Renaming a Procedure Does Not Also Rename the Internal SQL in the Procedures Catalog Table	No
7	3122	Using the Same Parameter Name with Two Different Column Expressions Can Cause Truncation Errors	Yes
7	3123	Delphi 2010 Documentation Missing Section on Tutorial Application	No
8	3133	Certain Filters and Ranges Can Cause Inserted Rows to Be Excluded Improperly from the Set	No
8	3138	Parameters Are Incorrectly Being Allowed in CREATE VIEW Statements	No
9	3145	ElevateDB Manager Reverse-Engineering Incorrect For Databases without Tables	No
9	3149	Altering a Trigger in the ElevateDB Manager Causes List of Triggers to Disappear	Yes
9	3154	Double-Clicking on the Tables Node in the ElevateDB Manager Causes Unrelated Table to Open	No
9	3155	ElevateDB Manager Not Reflecting Disabled/Enabled Triggers Properly	No
10	3171	Maximizing and Then Restoring the Main ElevateDB Manager Window Can Cause Properties To Disappear	Yes
10	3175	ElevateDB Manager Can Raise Exception if an SQL Window is Opened with No Active Database	Yes
10	3180	ElevateDB Manager Not Showing Constraint Descriptions	No
14	3211	Trying to Delete a Row that is in the Process of Being Edited Can Cause Table Corruption Error	No
14	3215	ServerSessionLocks Table Not Showing Transaction Locks on Un-Opened Tables	No
15	3219	Accessing ElevateDB Manager Preferences Dialog Causes Exception	No
16	3231	Dependencies View Not Showing All Dependencies in ElevateDB Manager	No
16	3235	Parameter Names with Spaces Not Working Correctly	Yes
18	3250	Dependency Support in ElevateDB Manager Causes Major Slowdown with Remote WAN Connection	No
18	3251	SQL Execution Plan Hints Showing Incorrectly for Certain Conditions	No
18	3252	Date/Time Formats for CAST and IMPORT/EXPORT TABLE Not Working Correctly without Separators	No
19	3260	New Warning for Missing Table Files Being Triggered During Database Restore	No
20	3275	ElevateDB Manager Reverse-Engineering Not Wrapping Large Binary Literals Properly	No
20	3276	DBISAM Migrators Not Converting Hexadecimal Integer Values Properly	No
21	3278	ElevateDB Manager Table Dialog Not Showing DECIMAL Column Scale Values Properly after Column Altered	No
21	3280	Column Name Case Not Consistent in ElevateDB Manager Treeview and SQL View after Column Alteration	No
21	3281	Column Properties Do Not Update After Answering No to Table Dialog Prompt in ElevateDB Manager	No
21	3283	CASTing a BLOB to a VARCHAR Causes First 3 Characters to Be Truncated	Yes
21	3286	Double-Clicking on Procedure/Function Dependency in ElevateDB Manager Causes AV	No
22	3322	Freeing a TDataSet Descendant Without Closing Can Cause Dangling Row Locks	Yes
23	3332	Opening the Same Database Name in Two Different Sessions in ElevateDB Manager Can Cause Error	No

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap