New Incident Reports for 2.02

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

Serious Problems

Build

Title

Workarounds

1	2819	Executing a Script in the EDB Manager that Includes Log-Generating Statement Causes Multiple Windows	No
1	2820	Altering a Table Immediately After Publishing Causes a Version Mismatch Error When Table Is Opened	No
1	2823	Using TEDBDataSet Locate Method with Delphi 2009 Causes	Yes
1	2824	Remote DataSet Navigation Results in Incorrect Row Display	Yes
1	2827	Referencing a Different Database In a UNION/EXCEPT/INTERSECT Query Causes Dangling Read Lock	No
1	2834	Columns Incorrectly Allowed with Aggregate Functions in Expressions in SQL Statements	Yes
1	2835	Altering the Number of Columns in a Table Constraint Can Corrupt the Table	No
2	2836	Executing a Script with OUT Parameters in EDB Manager Causes Dialog to Be Shown Multiple Times	No
2	2838	Empty Remote Ranges Do Not Refresh Properly When New Row Inserted Into Range	Yes
2	2840	Heavy Concurrent Inserts Can Cause #601 Corruption Error with a Session	No
2	2843	Referencing a UNIONed SELECT Column Correlation Name in an ORDER BY Causes Incorrect Sort	No
3	2848	Debugging Scripts in the ElevateDB Manager Using a Remote Session Causes a Hang	No
3	2852	NEWROW BLOB Column Values Are Always Empty in AFTER INSERT Triggers	Yes
3	2854	Moving Indexed Columns in an ALTER TABLE Statement Can Cause Error	No
3	2856	Calling a Procedure from Within a Trigger Can Cause an AV if the Procedure Returns a Result Set	Yes
3	2857	Clearing the Contents of a TDBMemo Control Does Not Work	No
3	2859	Exceptions Raised During the Execution of a Job Can Cause the ElevateDB Server to Terminate	No
3	2860	Trying to Compile the Lazarus Packages Causes Compilation Errors	No
3	2861	Dropping a Column Referenced in a Trigger in an ALTER TABLE Statement Causes Incorrect Error	Yes
3	2863	DISTINCT, UNION, EXCEPT, and INTERSECT Queries with More than 4 Columns Cause Incorrect Results	No
4	2864	Index Navigation Can Cause Array Index Error Under .NET	No
4	2865	Index Navigation Can Skip Rows Due to Read-Ahead Optimization	No
5	2869	Help Files Not Installed Into Correct Namespace in Delphi 2009	No
5	2871	Triggers Not Working Properly If DDL Statements Cause Reload of the Database Catalog	No
5	2873	Trying to Connect to a Database with Views Causes Object Reference Error	No
5	2874	Bookmarks Not Working Properly with Delphi 2009	No
5	2876	Assigning a Script to the CommandText Property of an EDBCommand Object Causes Compilation Error	No
5	2877	Setting a BLOB Column to an Empty String Causes The Existing Text to Still Show	No
6	2890	Deleting All Rows From a Table Can Cause #601 Cannot Find Index Page Error	No
6	2891	Executing a DELETE Statement on Table with Trigger that Starts Transaction Can Cause Lost Deletions	Yes
6	2892	Subtracting a Day Interval From a Date Across Year Boundaries Causes Incorrect Results	No
7	2906	A CONTAINS Filter Can Cause an AV During Navigation of the Dataset	No
7	2907	ALTER JOB Followed By PUBLISH DATABASE Statement in a Script or Job Causes Hang Due to Lock Conflict	No
7	2908	Deleted BLOB Space Not Being Re-Used Properly	No
7	2909	Using EXTRACT Function with Sensitive Query Result Set in Remote Session Can Cause Compilation Error	No
7	2910	GUID Columns Not Displayed Properly in Visual Studio Query Designer Result Set Grid	Yes
7	2911	Visual Studio Query Designer Using Improper SQL Syntax for JOINs	No
7	2912	Job Start Times Can Drift According to the Finish Times	Yes
7	2914	Cannot Use ODBC Driver in MS Access Due to Reserved Error -7778	No
7	2915	Embedded CRLF Pairs in CLOB Values Being Converted to Only CR Characters in IMPORT TABLE	No
7	2916	ElevateDB Requiring OnRemoteReconnect Event Handler for Re-Connection	Yes
7	2917	Querying the Files Table in the Configuration Database While File Creation in Progress Causes Error	No
7	2920	External Procedure Parameter Names Being Changed During CALL Execution	Yes
7	2922	Insensitive Query Result Sets Refreshing When They Should Remain Static	No
7	2924	Using Views in Joins in a SELECT Statement Results in Very Slow Performance	No
7	2925	ODBC Driver Not Working Properly with Word and Excel When Importing Data	No
7	2926	CAST Function Returns Incorrect Results When Casting Date and TimeStamp Values to Strings	No
7	2929	Migrating a Database with KeepTablesOpen Setting Turned on for the Session Causes #100 Error	No
8	2903	Executing Query that Uses Same Derived Table Correlation Name as Existing Query Can Cause AV	No
8	2930	MIGRATE DATABASE Slows Down Considerably in .NET with Many Tables in the Source Database	No
8	2931	Altering a Stored Procedure with No Parameters Using a Remote Session Causes Error in EDB Manager	No
8	2934	Populating BLOB Parameters via a Stream in Delphi 2007 Unicode Causes Incorrect Data Population	No
8	2935	Large Backup Restore Operation May Fail with an Uncompress Error	No
8	2937	Changing the Action Time for a Trigger Does Not Take Effect Immediately	No
8	2939	Opening a Table Containing a DATE Column with Microsoft Access and a Remote Session Doesn't Work	No
8	2940	Unicode EDB Manager Saving SQL Editor Files as ANSI Text	No
8	2941	Concatenating Compressed CLOB Columns in SQL Can Cause Embedded NULL Byte Characters	No
8	2942	Executing a DELETE Statement Can Cause #601 Invalid Page Number Specified Error	No
8	2943	Trying to Continue Debugging a Script Window after a Close Attempt in the EDB Manager Can Cause AV	No
8	2944	Referring to a Column by Name Instead of the Correlation Name Can Cause ORDER BY to Not Work	Yes
8	2947	CREATE VIEW Statement Can Result in an Incorrect View Definition	No
10	2950	CopyOnAppend Causing BLOB Columns To Share the Same Internal Offsets	No
10	2954	Trying to Open a Table in a Database with Read-Only Attributes Causes #401 "Table Not Found" Error	No
10	2955	TEDBEngine UseLocalSessionEngineSettings Property Not Being Restored Properly During Project Load	No
10	2956	ElevateDB SQL Reference Help Not Being Loaded Properly in ElevateDB Manager	Yes
10	2957	XML Export from BLOB Columns in .NET Data Provider Results in Incorrect XML Data	No
10	2958	UNIONed SELECT Statements Not Binding Column References Properly	No
10	2959	.NET Data Provider Causes LOWER() Function to Return Results as UPPER() Function	No
10	2963	Restoring a Database Can Cause Issues if New Tables Were Added Since Backup	No
10	2964	Unicode ElevateDB Manager Experiencing Random AVs	No
10	2965	Remote Encryption Password Not Being Set Properly in ElevateDB ODBC Driver	No
10	2966	Single-Row Aggregate Queries with Only Constants and Aggregate Functions Return Incorrect Results	No
10	2967	SQL Can Cause "Value Cannot Be Null" Error When Executed Using .NET Data Provider	No
10	2968	Creating a Database with an Invalid Path Can Cause Database to Become Read-Only	Yes
10	2969	Using REFERENCES Clause for Columns Causes Parsing Error in CREATE TABLE Statement	Yes
10	2971	Cannot Migrate Certain Older DBISAM Tables with BCD Columns to ElevateDB	No
10	2972	Jobs Defined as EVERY x HOURS Not Executing After the First Day Completes	No
10	2973	Jobs Defined as WEEKLY Not Executing Properly	No
11	2978	Weekly Scheduled Jobs Not Firing on Scheduled Days	No
11	2980	Tables with Indexed Computed Columns Can Cause AV When Opened	No
11	2981	UNION Queries Can Cause Index Page Size Error with Unicode Databases	No
11	2982	Calling the Same UDF More Than Once in the Same Expression Can Cause Incorrect Results	No
11	2983	Jobs Scheduled as Every X Hours Are Firing Every X+1 Hours Instead	Yes
11	2984	Compiling an EDB Application with Range Checking Can Cause Range Check Errors at Runtime	No
11	2985	BDE Migrator Module Not Setting Transliterate Parameter Properly for Paradox Tables	No
11	2986	Concatenated CHAR or VARCHAR Columns Can Cause Error When the Length Exceeds 1024 Characters	No
11	3074	ElevateDB Sessions Not Releasing Memory for Cached Updates Manager Until Engine Shutdown	No
12	2987	Using Locate Method on an Indexed Computed Column or CLOB Column Can Cause Locate to Fail	No
12	2988	Migrating a BDE Database to a Unicode ElevateDB Database Fails with Value Errors	No
12	2989	Row Updates that Only Update Non-Indexed Columns Can Cause Errors in Other Sessions	No
12	2990	Altering an Existing Index Can Cause Either a Corrupted Index or an Index Page Buffer Error	Yes
13	2998	Trying to Open an Updateable View with Correlated Sub-Queries in the SELECT List Causes AV	No
13	3000	Executing a UNION Query with Expressions in the SELECT List Can Cause AV	No
13	3001	Upgrade Reverse-Engineering Not Working Properly in Unicode EDB Manager	No
14	3015	Login Attempts that Wait for User Input Do Not Time-Out Properly After the Server Timeout is Reached	No
14	3016	Trying to Alter an Existing Table and Add a Foreign Key that References the Same Table Causes AV	No
14	3018	Self-Referencing Triggers Not Executing Properly and Stop After One Recursion	No
14	3019	Insensitive Result Sets are Generated Very Slowly When Forced Buffer Flushing Turned On	No
14	3020	ElevateDB Data Provider EDBDataReader GetBytes Method Returning Data with All Null Bytes	Yes
14	3021	COPY FILE Statement Can Cause Incomplete Destination File During Interrupted Remote Copies	No
14	3022	Sub-Select Queries that Reference the Same Table as the Outer Query Can Cause Incorrect Results	No
14	3024	Updating a Row in a Table with a Text Index on a CLOB Column Can Corrupt the Text Index	No
14	3025	Aggregate Functions Not Returning Correct Results with Single-Row SELECT Queries with WHERE Clause	No
14	3026	Trying to ALTER a Prepared Stored Procedure Can Cause Access Violation When Procedure Executed	Yes
14	3027	Invalid Column References Cause Incorrect Error Message When Table Qualified with Database Name	No
14	3028	Reverse-Engineering Dialog in EDB Manager Reports Database Error When Cancelling Upgrade	No
14	3029	Internal PadL and PadR Functions Not Working Properly	No
15	3030	SELECT Statements with Large ORDER BY Columns Can Cause AV	No
15	3044	Specifying a Database Correlation Name in a DML Statement Can Cause #401 Error for Other Tables	No
15	3045	Parameters Not Being Recognized When Used in a UNION/INTERSECT/EXCEPT SELECT Statement	No
15	3046	Updateable Views Returning Incorrect Columns with Remote Sessions	No
15	3051	Scheduling a Job for the Last Day of a Month Can Cause the ElevateDB Server to Crash	No
15	3052	LOAD UPDATES Statement Not Loading Tables in Proper Referential Integrity Dependency Order	No
15	3053	TEDBTable GotoKey and FindKey Methods Returning True on an Empty Table	No
15	3056	Putting a Database in the Program Files Folder under Microsoft Vista Causes Access Denied Error	Yes
15	3058	LIKE Producing Incorrect Results for Partial-String Matches with Certain Languages	No
15	3059	Adding the Same Table Twice to a SELECT Statement Using a Correlation Name Can Cause Error	Yes
15	3062	Using a Sub-Query that Returns a CLOB Expression in the SELECT Column Expressions Results in NULLs	Yes
15	3063	Repairing a Table that Contains Foreign Keys that Refer to the Same Table Can Cause Lock Error	No
15	3064	Displaying Binary Values in the ElevateDB Manager Can Cause an AV	No

Minor Problems

Build

Title

Workarounds

1	2821	Move Down Button Does Not Work for Columns or Parameters in the EDB Manager	No
1	2822	EDB Manager Reverse Engineer Generating Duplicate Table Triggers	No
1	2825	EDB Manager Form State Not Being Restored Properly When Maximized and SQL Window Open	No
1	2826	Specifying More Values Than Columns Causes in an INSERT Statement Causes an AV	Yes
1	2828	Setting an Invalid Filter in the EDB Manager Does Not Raise an Exception	No
2	2837	VCL Unicode Example Projects Contain Invalid TStringField References	No
2	2839	TEDBTable FindNearest Method Not Working Properly with Active Filter Set	No
2	2841	Hitting F8 Without an Active SQL Window Causes AV in ElevateDB Manager	No
2	2842	The TEDBSession CurrentRemoteID Property is Returning an Incorrect Value	No
2	2844	Rows Locked Manually Using LockCurrentRecord Method Can Cause Memory Leak	Yes
3	2850	Adding a Description to a Function or Procedure Parameter Causes Error in ElevateDB Manager	No
3	2851	Reverse-Engineering Generates Incorrect SQL for VIEW WITH CHECK OPTION Clause	No
3	2855	Unicode ElevateDB Manager Does Not Compile Properly Under Delphi 2009	No
3	2858	Attempting to CAST an INTEGER to an Incompatible Interval Value Causes a Conversion Error	No
3	2862	Multiplying or Dividing INTERVAL Values Causes Incorrect Results	Yes
4	2866	Derived Tables Not Allowing ORDER BY Statement in INSERT..SELECT Statements	No
5	2868	FETCH Statement Causes AV when Number of Target Variables Does Not Match Columns	Yes
5	2870	TEDBSession OnRemoteTrace Event Not Showing Correct Trace Record Information	No
5	2872	TEDBEngine Component EngineType Property Not Changing Properly When Loading New Project in IDE	No
5	2875	Queries Upon Non-Updateable Views Not Using Indexes for Optimization	No
6	2889	Incorrect Default Increment Values When Altering a Table in ElevateDB Manager	No
7	2904	Cannot Run Multiple Instances of the ElevateDB Server as a Service on the Same Machine	No
7	2913	SQL Manual Shows Improper Syntax for Interval Values	No
7	2918	varShortInt Not Handled Properly as a Variant Value for Parameters in Delphi 2009	No
7	2919	Exceptions Being Displayed in EDB Manager Script Debugger with Pause On Exceptions Un-Checked	No
7	2921	.NET Data Provider EDBConnectionStringBuilder Improperly Defaulting Compression to Level 6	No
7	2923	EDBCommandBuilder Constructor Not Initializing DataAdapter Property Properly	Yes
8	2932	SQL Editor Caret Disappears When Scrolling Horizontally in the EDB Manager	No
8	2933	Stored Procedure Parameter Descriptions Not Being Populated During Alter in EDB Manager	No
8	2936	Remote Store Selection in EDB Manager Not Working Properly	Yes
8	2938	Changing the OF Clause of an UPDATE Trigger Does Nothing in the EDB Manager	Yes
8	2945	Executing a CREATE TABLE..LIKE Statement with LIKE Table Prefaced with Database Name Causes Error	Yes
8	2946	Visual Studio TableAdapter Designer Not Working Properly with Procedures Containing Parameters	Yes
10	2960	ElevateDB Manager Explorer TreeView Scrollbars Not Working Properly Under Vista	No
10	2961	ElevateDB Manager SQL Editor Exhibits a Display Issue When Scrolling Horizontally	No
10	2962	Foreign Key Constraint Violation Errors are Indicating the Incorrect Table Names	No
10	2970	Trying to Create a Temporary Table in the Configuration Database Causes AV	Yes
10	2977	GUID Parameters Not Working Properly with TableAdapters Under .NET	No
13	3002	Executing an INSERT, UPDATE, or DELETE Statement Against the Configuration Database Could Cause AV	No
14	3013	Importing an Empty CSV File into a Table Causes Error	No
14	3014	Creating a Copy of a Session in the EDB Manager Causes the Session to Use the Existing Session Name	No
14	3017	Extra Text After the Last END Block of an SQL Script Does Not Raise an Exception	No
14	3023	Clicking on Column Header of Indexed Column in EDB Manager Data View Does Nothing	No
15	3047	External Module Parameters Not Working Properly When Constant Passed Instead of Variable	No
15	3049	Migrating a DBISAM 3 Database Table Containing Formatted-Memo Fields Causes #700 Error	No
15	3054	Temporary Tables Leaving Behind .OLD Files When Altered	No
15	3055	Reverse-Engineering Adding Triggers Before Functions and Procedures	No
15	3057	Exporting Tables from Configuration Database Causes Error	No
15	3060	Subtracting a DATE from a TIMESTAMP Column Results in a NULL Value	No
15	3061	Using the h:mm:ss Time Format with the IMPORT TABLE Statement Can Cause an Error	Yes
15	3065	Using a Parameter in a CAST() Function Can Cause a Conversion Error	No
15	3066	INTERVAL Constants Can Be Specified as Integer Constants When They Should Be In Quotes	Yes

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap