Icon Incident Reports Addressed in 2.01

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

Serious Problems


Build#TitleWorkarounds
12675Long Index Names Cause Error During Migration from DBISAM TablesYes
12677Having Many Deleted Rows in a Table Can Negatively Affect INSERT, UPDATE, or DELETE PerformanceNo
12679LOAD UPDATES Failing When Replication Data Has Passed Through More than One PublisherNo
12680Using a Boolean Column by Itself in a WHERE Clause Expression Causes All Rows to be SelectedYes
12681Inserting Rows into a Table with Very Large Index Keys Can Cause HangNo
12682Truncation of String Values Not Raising an ExceptionNo
12687Engine Accumulating Memory During Session OpensNo
12688Using Specific DatabaseName in UPDATE or DELETE Statement Can Cause Subsequent Catalog Read ErrorNo
12689ODBC Driver Causing Commit Error with Microsoft AccessNo
12690ODBC Driver Causing ODBC Call Failed Error When Opening Table in Access with TimeStamp ColumnNo
12691ODBC Driver Causing Rouding Error When Opening Table in Access with Decimal ColumnNo
12693ElevateDB .NET Data Provider Does Not Remove Temporary TablesNo
12694Trying to Connect an ElevateDB 2.x Application to an ElevateDB 1.x Server FailsNo
12697LOAD UPDATES Can Fail with a Row Changed Error if Row Change Detection Turned OnNo
12698External Function with VARCHAR Return Data Type Can Cause Truncation ErrorNo
12734Setting the EDBCommand CommandText Property with ParamCheck=True Causes Long DelayYes
22701EXTRACT Function Not Working for TIME ValuesNo
22703OUT Parameters Not Being Populated Properly After CALL Statement Execution in ScriptsNo
22704Changing the Active Index with an Active OnFilterRecord Event Handler Can Cause Access ViolationYes
22706EXISTS Operator Can Cause Incorrect Scalar Sub-Query ErrorNo
22707.NET Data Provider Installation Incorrectly Registers Compact Framework AssemblyYes
22708Derived Tables Cause a Scalar Sub-Query ErrorNo
22709Altering a Job a Second Time Results in the Changes Not Being SavedNo
22712Remote Session Performance Needs ImprovementNo
22714SET STATUS MESSAGE Statement Not Working in Scripts or ProceduresNo
22715TEDBTable GotoCurrent Method Not Working ProperlyNo
22717Executing a CREATE JOB Statement that Inclues a USE Statement Causes Subsequent Lock FailuresNo
22719TEDBSession KeepTablesOpen Property Can Cause Access Error During DROP TABLE ExecutionNo
22720Disconnecting a Session in the ElevateDB Manager Can Leave Empty Open Table WindowsNo
22721The Manage Server Sessions and View Server Session Locks Options Not Working in ElevateDB ManagerNo
22722Multiple Executions of a Stored Procedure that Creates/Drops a Temporary Table Can Cause AVNo
22723Executing a Sensitive Query That Calls a Function in a Different Database Causes Incorrect ResultsYes
32725Copying from a Local Store to a Remote Store Causes a Write ErrorNo
42718Setting a Date/Time Value in .NET Data Provider Causes Invalid Cast ErrorNo
42728.NET Data Provider Installation Still Not Correctly Installing AssembliesYes
52735Disconnecting a Session in the EDB Manager While Tables are Open Can Cause an AVNo
52738Multiple Table Cursors Are Being Permitted to Acquire Concurrent Row Locks on the Same RowNo
52740Jobs that Call Stored Procedures Cause an AV When ExecutedNo
52742Selecting Close All Menu Option in ElevateDB Manager Causes Focus ErrorNo
52743Creating a New Session in the ElevateDB Manager Causes an AVYes
52744Executing a Query That Generates an Insensitive Result Set on the LogEvents Table Causes HangYes
52746UNION/EXCEPT/INTERSECT Queries with an ORDER BY Clause on Columns Not in the SELECT List Causes AVYes
52747GRANT ALL PRIVILEGES Statement Not Working ProperlyYes
52748Functions That Return DECIMAL/NUMERIC Values with a Scale Round Off Values IncorrectlyYes
52750Using a CONTAINS Wildcard Search in an Un-Optimized WHERE Condition Causes Incorrect ResultsYes
52751Loading More Than One Instance of an External Module Can Cause Module Load FailureNo
52752Using Compression with SAVE UPDATES and Published Tables Can Cause Uncompress ErrorYes
52756CASTing an INTEGER to an INTERVAL Type Causes ErrorNo
52757Improper Session Termination Can Cause Runaway CPU Consumption On One ProcessorNo
52760Executing an Un-Optimized Locate On a Ranged TEDBTable Component Can Cause Incorrect Row DisplayYes
52761Using Locate On Columns That Use Index Other than Active Index Can Cause Improper Row PositioningYes
52763Altering a Foreign Key Constraint Can Cause #401 ErrorNo
52764Compound Primary Key Columns Are Not All Having NOT NULL Constraint EnforcedNo
52765Dead Sessions that Contain Sensitive Query Result Sets that Reference Functions Can Cause AVNo
52766AVG, STDDEV, and RUNSUM Functions Return NULL When Used in ExpressionsNo
52767LIST Aggregate Function Not Not Resetting for Grouped QueriesNo
52768Updating a TEDBQuery with a TClientDataSet Causes ErrorYes
52771Adding a Constraint or Index with Large Page Size Requirement Can Cause ErrorYes
52772Remote TEDBTable Components with Empty Ranges Can Display Invalid Empty RowsNo
52773Closing Master Table in Master-Detail Link with Server Down and No OnReconnect Event Causes AVYes
52774Posting Changes to a Row After a Transaction Commit/Rollback Can Cause Row Unlock ErrorYes
52775SetRange Can Result In Incorrect Ranges of Rows with Unique IndexesNo
52776ElevateDB .Net Data Provider Can Experience Index Out of Range with Certain QueriesNo

Minor Problems


Build#TitleWorkarounds
12674Multiple Values Are Allowed for Scalar Sub-QueriesNo
12678Defining Computed Columns Too Small for the Data Results in Value Truncation ErrorYes
12685Double-Clicking on a Table in the EDB Manager to Open the Table Can Cause an AVNo
12686Attempting to Open a Connection When the Configuration Path Contains Invalid EDB DLL Can Cause ErrorNo
12692ElevateDB Error Messages Appendix Still Contains Some Links to ElevateDB 1 SQL ManualNo
12695Migrating a DBISAM Database Containg Indexes with the Prefix "Text_" in the Name Causes ErrorYes
12696Filter Not Being Updated When Table Is Re-Opened in the ElevateDB ManagerNo
22700Reverse-Engineering Text Indexes Causes Incorrect Generation of INDEXED WORD LENGTH ValueNo
22702Restoring State of ElevateDB Manager Can Cause PageIndex ErrorNo
22711ElevateDB Manager Does Not Allow for Modification of Case-Insensitivity for IndexesNo
42727Creating or Altering Local Stores Does Not Save the DescriptionNo
52733ElevateDB Command-Line Server Missing .INI Entries for Catalog Name and Publish Files ExtensionNo
52736Block Labels Not Being Parsed Correctly in SQL/PSM RoutinesNo
52741Manual Indicates Incorrect Error Code for EDB_ERROR_LOGIN Error IdentifierNo
52745Newly-Created Objects Not Showing in Main Properties Page List View in ElevateDB ManagerYes
52749Manual Incorrectly States that SQL/PSM RAISE Statement Can Only Be Used in EXCEPTION BlockNo
52753SQL Manual Has Incorrect Syntax for CREATE/ALTER TABLE PUBLISH COMPRESSION ClauseNo
52754ElevateDB VCL Manual Has Incorrect Usage Links for TEDBDatabase StartTransaction MethodNo
52758Altering an External Function and Changing it to an SQL/PSM Function Does Not WorkYes
52759Altering a Column in the Alter Table Dialog in ElevateDB Manager Causes Constraint Column DuplicatesNo
52762Reverse-Engineering Converts RESTRICT Foreign Key Constraint Actions to NO ACTIONNo
52770Using a LIST Aggregate Function in Another Expression Causes ErrorYes
52777Trying to Load SQL File From a Non-Existent Path Can Cause AV on Database Close in EDB ManagerNo

Image