Icon 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

12819Executing a Script in the EDB Manager that Includes Log-Generating Statement Causes Multiple WindowsNo
12820Altering a Table Immediately After Publishing Causes a Version Mismatch Error When Table Is OpenedNo
12823Using TEDBDataSet Locate Method with Delphi 2009 CausesYes
12824Remote DataSet Navigation Results in Incorrect Row DisplayYes
12827Referencing a Different Database In a UNION/EXCEPT/INTERSECT Query Causes Dangling Read LockNo
12834Columns Incorrectly Allowed with Aggregate Functions in Expressions in SQL StatementsYes
12835Altering the Number of Columns in a Table Constraint Can Corrupt the TableNo
22836Executing a Script with OUT Parameters in EDB Manager Causes Dialog to Be Shown Multiple TimesNo
22838Empty Remote Ranges Do Not Refresh Properly When New Row Inserted Into RangeYes
22840Heavy Concurrent Inserts Can Cause #601 Corruption Error with a SessionNo
22843Referencing a UNIONed SELECT Column Correlation Name in an ORDER BY Causes Incorrect SortNo
32848Debugging Scripts in the ElevateDB Manager Using a Remote Session Causes a HangNo
32852NEWROW BLOB Column Values Are Always Empty in AFTER INSERT TriggersYes
32854Moving Indexed Columns in an ALTER TABLE Statement Can Cause ErrorNo
32856Calling a Procedure from Within a Trigger Can Cause an AV if the Procedure Returns a Result SetYes
32857Clearing the Contents of a TDBMemo Control Does Not WorkNo
32859Exceptions Raised During the Execution of a Job Can Cause the ElevateDB Server to TerminateNo
32860Trying to Compile the Lazarus Packages Causes Compilation ErrorsNo
32861Dropping a Column Referenced in a Trigger in an ALTER TABLE Statement Causes Incorrect ErrorYes
32863DISTINCT, UNION, EXCEPT, and INTERSECT Queries with More than 4 Columns Cause Incorrect ResultsNo
42864Index Navigation Can Cause Array Index Error Under .NETNo
42865Index Navigation Can Skip Rows Due to Read-Ahead OptimizationNo
52869Help Files Not Installed Into Correct Namespace in Delphi 2009No
52871Triggers Not Working Properly If DDL Statements Cause Reload of the Database CatalogNo
52873Trying to Connect to a Database with Views Causes Object Reference ErrorNo
52874Bookmarks Not Working Properly with Delphi 2009No
52876Assigning a Script to the CommandText Property of an EDBCommand Object Causes Compilation ErrorNo
52877Setting a BLOB Column to an Empty String Causes The Existing Text to Still ShowNo
62890Deleting All Rows From a Table Can Cause #601 Cannot Find Index Page ErrorNo
62891Executing a DELETE Statement on Table with Trigger that Starts Transaction Can Cause Lost DeletionsYes
62892Subtracting a Day Interval From a Date Across Year Boundaries Causes Incorrect ResultsNo
72906A CONTAINS Filter Can Cause an AV During Navigation of the DatasetNo
72907ALTER JOB Followed By PUBLISH DATABASE Statement in a Script or Job Causes Hang Due to Lock ConflictNo
72908Deleted BLOB Space Not Being Re-Used ProperlyNo
72909Using EXTRACT Function with Sensitive Query Result Set in Remote Session Can Cause Compilation ErrorNo
72910GUID Columns Not Displayed Properly in Visual Studio Query Designer Result Set GridYes
72911Visual Studio Query Designer Using Improper SQL Syntax for JOINsNo
72912Job Start Times Can Drift According to the Finish TimesYes
72914Cannot Use ODBC Driver in MS Access Due to Reserved Error -7778No
72915Embedded CRLF Pairs in CLOB Values Being Converted to Only CR Characters in IMPORT TABLENo
72916ElevateDB Requiring OnRemoteReconnect Event Handler for Re-ConnectionYes
72917Querying the Files Table in the Configuration Database While File Creation in Progress Causes ErrorNo
72920External Procedure Parameter Names Being Changed During CALL ExecutionYes
72922Insensitive Query Result Sets Refreshing When They Should Remain StaticNo
72924Using Views in Joins in a SELECT Statement Results in Very Slow PerformanceNo
72925ODBC Driver Not Working Properly with Word and Excel When Importing DataNo
72926CAST Function Returns Incorrect Results When Casting Date and TimeStamp Values to StringsNo
72929Migrating a Database with KeepTablesOpen Setting Turned on for the Session Causes #100 ErrorNo
82903Executing Query that Uses Same Derived Table Correlation Name as Existing Query Can Cause AVNo
82930MIGRATE DATABASE Slows Down Considerably in .NET with Many Tables in the Source DatabaseNo
82931Altering a Stored Procedure with No Parameters Using a Remote Session Causes Error in EDB ManagerNo
82934Populating BLOB Parameters via a Stream in Delphi 2007 Unicode Causes Incorrect Data PopulationNo
82935Large Backup Restore Operation May Fail with an Uncompress ErrorNo
82937Changing the Action Time for a Trigger Does Not Take Effect ImmediatelyNo
82939Opening a Table Containing a DATE Column with Microsoft Access and a Remote Session Doesn't WorkNo
82940Unicode EDB Manager Saving SQL Editor Files as ANSI TextNo
82941Concatenating Compressed CLOB Columns in SQL Can Cause Embedded NULL Byte CharactersNo
82942Executing a DELETE Statement Can Cause #601 Invalid Page Number Specified ErrorNo
82943Trying to Continue Debugging a Script Window after a Close Attempt in the EDB Manager Can Cause AVNo
82944Referring to a Column by Name Instead of the Correlation Name Can Cause ORDER BY to Not WorkYes
82947CREATE VIEW Statement Can Result in an Incorrect View DefinitionNo
102950CopyOnAppend Causing BLOB Columns To Share the Same Internal OffsetsNo
102954Trying to Open a Table in a Database with Read-Only Attributes Causes #401 "Table Not Found" ErrorNo
102955TEDBEngine UseLocalSessionEngineSettings Property Not Being Restored Properly During Project LoadNo
102956ElevateDB SQL Reference Help Not Being Loaded Properly in ElevateDB ManagerYes
102957XML Export from BLOB Columns in .NET Data Provider Results in Incorrect XML DataNo
102958UNIONed SELECT Statements Not Binding Column References ProperlyNo
102959.NET Data Provider Causes LOWER() Function to Return Results as UPPER() FunctionNo
102963Restoring a Database Can Cause Issues if New Tables Were Added Since BackupNo
102964Unicode ElevateDB Manager Experiencing Random AVsNo
102965Remote Encryption Password Not Being Set Properly in ElevateDB ODBC DriverNo
102966Single-Row Aggregate Queries with Only Constants and Aggregate Functions Return Incorrect ResultsNo
102967SQL Can Cause "Value Cannot Be Null" Error When Executed Using .NET Data ProviderNo
102968Creating a Database with an Invalid Path Can Cause Database to Become Read-OnlyYes
102969Using REFERENCES Clause for Columns Causes Parsing Error in CREATE TABLE StatementYes
102971Cannot Migrate Certain Older DBISAM Tables with BCD Columns to ElevateDBNo
102972Jobs Defined as EVERY x HOURS Not Executing After the First Day CompletesNo
102973Jobs Defined as WEEKLY Not Executing ProperlyNo
112978Weekly Scheduled Jobs Not Firing on Scheduled DaysNo
112980Tables with Indexed Computed Columns Can Cause AV When OpenedNo
112981UNION Queries Can Cause Index Page Size Error with Unicode DatabasesNo
112982Calling the Same UDF More Than Once in the Same Expression Can Cause Incorrect ResultsNo
112983Jobs Scheduled as Every X Hours Are Firing Every X+1 Hours InsteadYes
112984Compiling an EDB Application with Range Checking Can Cause Range Check Errors at RuntimeNo
112985BDE Migrator Module Not Setting Transliterate Parameter Properly for Paradox TablesNo
112986Concatenated CHAR or VARCHAR Columns Can Cause Error When the Length Exceeds 1024 CharactersNo
113074ElevateDB Sessions Not Releasing Memory for Cached Updates Manager Until Engine ShutdownNo
122987Using Locate Method on an Indexed Computed Column or CLOB Column Can Cause Locate to FailNo
122988Migrating a BDE Database to a Unicode ElevateDB Database Fails with Value ErrorsNo
122989Row Updates that Only Update Non-Indexed Columns Can Cause Errors in Other SessionsNo
122990Altering an Existing Index Can Cause Either a Corrupted Index or an Index Page Buffer ErrorYes
132998Trying to Open an Updateable View with Correlated Sub-Queries in the SELECT List Causes AVNo
133000Executing a UNION Query with Expressions in the SELECT List Can Cause AVNo
133001Upgrade Reverse-Engineering Not Working Properly in Unicode EDB ManagerNo
143015Login Attempts that Wait for User Input Do Not Time-Out Properly After the Server Timeout is ReachedNo
143016Trying to Alter an Existing Table and Add a Foreign Key that References the Same Table Causes AVNo
143018Self-Referencing Triggers Not Executing Properly and Stop After One RecursionNo
143019Insensitive Result Sets are Generated Very Slowly When Forced Buffer Flushing Turned OnNo
143020ElevateDB Data Provider EDBDataReader GetBytes Method Returning Data with All Null BytesYes
143021COPY FILE Statement Can Cause Incomplete Destination File During Interrupted Remote CopiesNo
143022Sub-Select Queries that Reference the Same Table as the Outer Query Can Cause Incorrect ResultsNo
143024Updating a Row in a Table with a Text Index on a CLOB Column Can Corrupt the Text IndexNo
143025Aggregate Functions Not Returning Correct Results with Single-Row SELECT Queries with WHERE ClauseNo
143026Trying to ALTER a Prepared Stored Procedure Can Cause Access Violation When Procedure ExecutedYes
143027Invalid Column References Cause Incorrect Error Message When Table Qualified with Database NameNo
143028Reverse-Engineering Dialog in EDB Manager Reports Database Error When Cancelling UpgradeNo
143029Internal PadL and PadR Functions Not Working ProperlyNo
153030SELECT Statements with Large ORDER BY Columns Can Cause AVNo
153044Specifying a Database Correlation Name in a DML Statement Can Cause #401 Error for Other TablesNo
153045Parameters Not Being Recognized When Used in a UNION/INTERSECT/EXCEPT SELECT StatementNo
153046Updateable Views Returning Incorrect Columns with Remote SessionsNo
153051Scheduling a Job for the Last Day of a Month Can Cause the ElevateDB Server to CrashNo
153052LOAD UPDATES Statement Not Loading Tables in Proper Referential Integrity Dependency OrderNo
153053TEDBTable GotoKey and FindKey Methods Returning True on an Empty TableNo
153056Putting a Database in the Program Files Folder under Microsoft Vista Causes Access Denied ErrorYes
153058LIKE Producing Incorrect Results for Partial-String Matches with Certain LanguagesNo
153059Adding the Same Table Twice to a SELECT Statement Using a Correlation Name Can Cause ErrorYes
153062Using a Sub-Query that Returns a CLOB Expression in the SELECT Column Expressions Results in NULLsYes
153063Repairing a Table that Contains Foreign Keys that Refer to the Same Table Can Cause Lock ErrorNo
153064Displaying Binary Values in the ElevateDB Manager Can Cause an AVNo

Minor Problems

12821Move Down Button Does Not Work for Columns or Parameters in the EDB ManagerNo
12822EDB Manager Reverse Engineer Generating Duplicate Table TriggersNo
12825EDB Manager Form State Not Being Restored Properly When Maximized and SQL Window OpenNo
12826Specifying More Values Than Columns Causes in an INSERT Statement Causes an AVYes
12828Setting an Invalid Filter in the EDB Manager Does Not Raise an ExceptionNo
22837VCL Unicode Example Projects Contain Invalid TStringField ReferencesNo
22839TEDBTable FindNearest Method Not Working Properly with Active Filter SetNo
22841Hitting F8 Without an Active SQL Window Causes AV in ElevateDB ManagerNo
22842The TEDBSession CurrentRemoteID Property is Returning an Incorrect ValueNo
22844Rows Locked Manually Using LockCurrentRecord Method Can Cause Memory LeakYes
32850Adding a Description to a Function or Procedure Parameter Causes Error in ElevateDB ManagerNo
32851Reverse-Engineering Generates Incorrect SQL for VIEW WITH CHECK OPTION ClauseNo
32855Unicode ElevateDB Manager Does Not Compile Properly Under Delphi 2009No
32858Attempting to CAST an INTEGER to an Incompatible Interval Value Causes a Conversion ErrorNo
32862Multiplying or Dividing INTERVAL Values Causes Incorrect ResultsYes
42866Derived Tables Not Allowing ORDER BY Statement in INSERT..SELECT StatementsNo
52868FETCH Statement Causes AV when Number of Target Variables Does Not Match ColumnsYes
52870TEDBSession OnRemoteTrace Event Not Showing Correct Trace Record InformationNo
52872TEDBEngine Component EngineType Property Not Changing Properly When Loading New Project in IDENo
52875Queries Upon Non-Updateable Views Not Using Indexes for OptimizationNo
62889Incorrect Default Increment Values When Altering a Table in ElevateDB ManagerNo
72904Cannot Run Multiple Instances of the ElevateDB Server as a Service on the Same MachineNo
72913SQL Manual Shows Improper Syntax for Interval ValuesNo
72918varShortInt Not Handled Properly as a Variant Value for Parameters in Delphi 2009No
72919Exceptions Being Displayed in EDB Manager Script Debugger with Pause On Exceptions Un-CheckedNo
72921.NET Data Provider EDBConnectionStringBuilder Improperly Defaulting Compression to Level 6No
72923EDBCommandBuilder Constructor Not Initializing DataAdapter Property ProperlyYes
82932SQL Editor Caret Disappears When Scrolling Horizontally in the EDB ManagerNo
82933Stored Procedure Parameter Descriptions Not Being Populated During Alter in EDB ManagerNo
82936Remote Store Selection in EDB Manager Not Working ProperlyYes
82938Changing the OF Clause of an UPDATE Trigger Does Nothing in the EDB ManagerYes
82945Executing a CREATE TABLE..LIKE Statement with LIKE Table Prefaced with Database Name Causes ErrorYes
82946Visual Studio TableAdapter Designer Not Working Properly with Procedures Containing ParametersYes
102960ElevateDB Manager Explorer TreeView Scrollbars Not Working Properly Under VistaNo
102961ElevateDB Manager SQL Editor Exhibits a Display Issue When Scrolling HorizontallyNo
102962Foreign Key Constraint Violation Errors are Indicating the Incorrect Table NamesNo
102970Trying to Create a Temporary Table in the Configuration Database Causes AVYes
102977GUID Parameters Not Working Properly with TableAdapters Under .NETNo
133002Executing an INSERT, UPDATE, or DELETE Statement Against the Configuration Database Could Cause AVNo
143013Importing an Empty CSV File into a Table Causes ErrorNo
143014Creating a Copy of a Session in the EDB Manager Causes the Session to Use the Existing Session NameNo
143017Extra Text After the Last END Block of an SQL Script Does Not Raise an ExceptionNo
143023Clicking on Column Header of Indexed Column in EDB Manager Data View Does NothingNo
153047External Module Parameters Not Working Properly When Constant Passed Instead of VariableNo
153049Migrating a DBISAM 3 Database Table Containing Formatted-Memo Fields Causes #700 ErrorNo
153054Temporary Tables Leaving Behind .OLD Files When AlteredNo
153055Reverse-Engineering Adding Triggers Before Functions and ProceduresNo
153057Exporting Tables from Configuration Database Causes ErrorNo
153060Subtracting a DATE from a TIMESTAMP Column Results in a NULL ValueNo
153061Using the h:mm:ss Time Format with the IMPORT TABLE Statement Can Cause an ErrorYes
153065Using a Parameter in a CAST() Function Can Cause a Conversion ErrorNo
153066INTERVAL Constants Can Be Specified as Integer Constants When They Should Be In QuotesYes