New Incident Reports for 2.04

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

Serious Problems

Build

Title

Workarounds

1	3288	Placing a RETURN Statement Inside of a Nested SQL/PSM Block Causes AV	Yes
1	3293	ALTER INDEX Allowed on System-Generated Constraint Indexes	Yes
1	3295	Very Large BLOBs Can Take Excessive Amounts of Time to Read	No
1	3296	Remote Login Can Cause Session Lock Error If User Name and Password Not Specified During Connection	Yes
1	3298	Adding Months to a DATE/TIMESTAMP Across Year Boundaries Causes Index/Range Check Error	No
1	3299	Custom Word Generators Not Loading Correctly	No
1	3300	Queries that Mix INNER and LEFT OUTER JOINs May Return Incorrect Results without NOJOINOPTIMIZE	No
1	3302	A View that References Other Databases Can Cause Write Lock Errors on Other Databases with View Open	Yes
2	3305	Manually Unlocking All Rows After a Previous Row was Manually Locked and Deleted Causes Error	No
2	3306	UPDATE Statements that Use Sub-Queries for Assignment Can Cause Dangling Catalog Read Lock	No
2	3307	Locates Can Cause Dangling Read Lock	No
2	3308	TClientDataSet Component Not Displaying DECIMAL Values Correctly	No
2	3309	Using a Scalar Sub-Query in an INSERT Statement Causes Parse Error	No
2	3310	Large Insert Operations Can Cause Unbounded Growth in Index Buffers	No
2	3311	Non-Updateable Views Can Cause AV When Refreshed	No
2	3312	Dropping a Column and Altering a Constraint in Same ALTER TABLE Statement Can Corrupt Tables	No
2	3313	Configuration Not Properly Saving Locking Information for Created Modules	No
2	3315	Sessions that Timeout on the Server Can Cause AV When Remote Session Reconnects	No
2	3364	ODBC Driver Not Binding VARCHAR Parameters Properly with Certain Front-Ends	No
3	3325	.NET Data Provider Returns Error When Using Table Adapters	No
3	3326	Exclusively-Opened Tables Can Cause Excessive Memory Consumption	No
3	3328	.NET Data Provider Raises Error When Executing Data Adapter Fill Method	Yes
4	3337	VCL Components Can Raise "Session Already Destroyed" in Delphi XE During Form/Data Module Destructor	No
4	3338	ElevateDB Manager Can Raise "Database name already exists" Error When Opening Database	No
4	3339	ElevateDB Unicode ODBC Driver Truncating CLOB Columns When Read from Microsoft Word	No
4	3340	Trying to Load Updates into Database with Circular Foreign Key/Primary Key Dependencies Causes Hang	No
4	3341	REPAIR TABLE Statement Can Cause AV When Repairing Damaged Indexes	No
4	3342	DELETE Statement Can Cause AV When Comparing Row Values in WHERE Clause	No
4	3343	Enclosing WHERE Clause Row Value Comparisons in Parentheses Causes Parse Error	No
4	3344	Using ALTER TABLE on a Table Containing GENERATED or COMPUTED Expression Columns Can Cause AV	No
4	3345	ElevateDB Server Not Sending Modified Flags for Default Column Values Back to Remote Sessions	No
4	3346	ElevateDB Manager Row Deletion Dialogs Not Working Properly When Escape Key Hit	No
4	3347	PUBLISH DATABASE Can Cause Catalog Corruption If Referenced Table(s) Cannot Be Opened Exclusively	No
4	3348	Cascading Triggers Can Cause Invalid Old Row Values to be Passed into a Trigger	No
4	3349	Inserting Rows From a Derived Table with ORDER BY and RANGE Causes Incorrect Inserted Rows	No
4	3350	Cannot Use HAVING Clause Without GROUP BY in SELECT Statement	No
4	3351	Adding Expression Filter to a Sensitive Query Result Set with RANGE Clause Causes Incorrect Results	No
4	3352	Invalid Internal Expression Columns Appearing in Sensitive Query Result Sets	No
4	3354	Executing a Query That Uses a UDF and Returns a Sensitive Result Set Can Cause Invalid Request Error	No
4	3356	Row Value Comparisons Not Working Properly If Row Values Contain NULLs	No
4	3358	Using Locate with OnFilterRecord Can Cause Rows to Not Be Found Properly	No
4	3359	Updates on Sensitive Result Set Cursors with ORDER BY Can Take Longer Than Necessary	No
4	3360	ElevateDB .NET Data Provider Not Triggering Progress/Status/Log Events Properly	No
4	3361	Using RIGHT OUTER JOIN Can Cause AV If ElevateDB Tries to Flip Join for Optimization	Yes
4	3362	JOINing a Derived Table with a RANGE Clause Can Cause Incorrect Results	No

Minor Problems

Build

Title

Workarounds

1	3289	ElevateDB Manager Table Dialog Not Showing DECIMAL Column Scale Values Properly after Column Altered	No
1	3290	Column SQL in ElevateDB Manager Generated with DECIMAL Precision of 20 Instead of 19	No
1	3291	Column Name Case Not Consistent in ElevateDB Manager Treeview and SQL View after Column Alteration	No
1	3292	Column Properties Do Not Update After Answering No to Table Dialog Prompt in ElevateDB Manager	No
1	3294	CASTing a BLOB to a VARCHAR Causes First 3 Characters to Be Truncated	Yes
1	3297	Double-Clicking on Procedure/Function Dependency in ElevateDB Manager Causes AV	No
2	3303	Custom Column/Constraint Error Messages Not Generated Properly in ElevateDB Manager	Yes
2	3365	Adding a File DSN and Not Specifying a User Name/Password in the DSN Configuration Can Cause Crash	No
3	3323	Referencing an Outer Column in a Correlated Sub-Query SELECT List Can Cause AV	Yes
3	3324	Freeing a TDataSet Descendant Without Closing Can Cause Dangling Row Locks	Yes
3	3327	VCL Example Applications Code Incorrect for Stored Procedure and Trigger Creation	Yes
4	3353	External Module Template Projects Not Correct for Delphi 2007	No
4	3355	Pasting Text with Embedded Tabs Causes Display Issues in SQL Editor of ElevateDB Manager	No
4	3357	Trying to Drop an Administrator that Has Granted Roles/Privileges Can Cause Dependency Error	Yes

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap