Incident Reports Addressed in 1.09

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

Serious Problems

Build

Title

Workarounds

1	2549	Queries that Generate Sensitive Result Sets with Expressions Cause an AV with Remote Sessions	No
1	2552	Error Line and Column Numbers Not Being Returned During Compilation Errors with Remote Sessions	No
1	2553	RANGE Clause Not Working Properly with ORDER BY Query	No
1	2554	Delphi 5 Experiencing Internal Compiler Error L1496 When Compiling Application That Uses EDBComps	No
1	2555	BLOB Procedure Parameters Not Working When Used As Further Parameters to Statements	No
1	2557	Using a Sub-Query in the SELECT Column List with a GROUP By Query Causes an AV	No
1	2558	Error #503 Possible When Refreshing Insensitive Result Set from Stored Procedure	No
1	2564	After Update Triggers Not Working When Limited to Specific Updated Columns	No
1	2565	Insert Triggers Are Being Executed During Repair, Optimize, or Alter	No
1	2568	Incorrect Variable Name References in SQL/PSM Routine Cause Incorrect Error Message	No
2	2583	CREATE JOB Statement Causes Access Violation	No
2	2586	TParam Objects Not Being Stored in DFM File for TEDBQuery, TEDBStoredProc, or TEDBScript Components	Yes
2	2587	INSERT..SELECT Statements with Constant Value as First Select Column Not Working Properly	Yes
2	2589	An Attempt to Create a Duplicate Index Name using CREATE INDEX Causes Table Version Number Increment	No
2	2592	Custom TEDBSession RemoteEncryptionPassword Property Settings Not Working Properly	No
2	2594	PDF Manuals Missing Examples	No
2	2595	Executing a SELECT * Query Against Multiple Databases Causes a Compilation Error	No
2	2597	Using UDF in First Column of SELECT Statement Used with INSERT Statement Results in Null Values	No
2	2599	Using EDBDataAdapter Update Method With INSERT Statement Causes NullReference Exception	No
2	2601	Triggers That Update Their Source Table Cause Access Violation	No
2	2602	Inserting Rows Using .Net Can Cause Error When Trying to Delete the Rows Using Win32 Application	No
3	2603	Closing a Remote Session Causes the Server to Enter a Hard Loop	No
3	2604	Altering a Stored Procedure or Function with a Description Causes Compilation Error	Yes
4	2610	MIN and MAX Aggregate Functions Not Working Properly on VARCHAR or CHAR Columns	No
4	2615	Column Descriptions Being Used by ADO for Column Names	No
4	2616	Tables with VARCHAR Columns Not Displaying Properly in Microsoft Access Using ODBC Driver	No
4	2617	Boolean Connection String Properties Not Assigned Properly for .Net Data Provider and ODBC Driver	No
4	2618	ElevateDB Server Window Hangs When Running as a Service	No
4	2619	Compilation of Applications Using Unicode Version Require Inclusion of Compiler Define	Yes
4	2620	Importing Text Files Using Unicode Version of ElevateDB Can Cause Import Error	No
4	2624	Computed Columns Not Calcuating Correctly for String Concatenation	Yes
4	2629	Daily, Weekly, and Monthly Jobs Are Being Executed Every Minute	No
4	2630	CREATE JOB Fails with Compilation Error for MONTHLY Jobs	No
4	2631	Altering an Existing Job and Only Modifying the Job SQL Causes the Changes to Be Ignored	No
4	2632	Creating a Monthly Job for a Specific Day of the Month Causes AV	No
4	2633	Log Manager Not Showing New Log Records Without Closing and Restarting Session	Yes
4	2636	DOES NOT CONTAIN Conditions Not Selecting Correct Rows	No
4	2639	Executing Remote SELECT Statements that Generate Insensitive Query Result Sets Can Cause #9999 Error	No
4	2640	Changes to the Collation for Column Involved in Constraints are Ignored	Yes
4	2641	Connecting a Session With Pinging Turned Off Can Cause AV	No
4	2642	Calling Procedures or Functions from Scripts Causes AV	Yes

Minor Problems

Build

Title

Workarounds

1	2556	EDBReverse.pas Unit Missing From ElevateDB Manager Source Code	No
1	2559	Re-Arranging Columns That Are Past the First Visible Set of Columns in EDB Manager Doesn't Work	No
1	2561	Using LIKE in a Correlated Sub-Query On Correlated Columns Can Cause Incorrect Results	Yes
1	2566	Out Parameters in a Script or Stored Procedure Not Being Assigned Properly in USING Clause	No
1	2567	Assigning a Byte Array to a BLOB Column Using ElevateDB .NET Data Provider Causes Conversion Error	No
1	2569	Sub-Queries with Parameters Are Slower Than Sub-Queries without Parameters	No
2	2590	Generated Columns That Contain Functions Not Being Updated when Rows are Updated	No
2	2591	SQL Manual Missing Documentation on SQL/PSM UNPREPARE Statement	No
2	2593	Extra Parameter in SQL/PSM Statement Does Not Raise Exception	No
2	2598	Attempting to Insert an Empty String into a BLOB Column Causes a Null Exception in .NET Provider	Yes
3	2605	Windows Requires Two Shutdown Requests When ElevateDB Server is Running as an Application	No
3	2606	The .Net Data Provider Not Pinging the Server By Default	Yes
4	2613	Previous Fix for Windows Shutdown Issue in Incident #2605 is Incomplete	Yes
4	2614	Incorrect Information in Manual for SQL/PSM UNPREPARE Statement	No
4	2621	Including an ORDER BY Clause in a Single-Row SELECT Statement Causes AV	Yes
4	2622	ElevateDB Manager Not Executing Stored Procedures that Contain Only Output Parameters	No
4	2623	KeepTablesOpen Property is Preventing Changes From Being Detected During Table Opens	Yes
4	2625	Altering a Text Index Results in a Blank Filter Type Column in the ElevateDB Manager	Yes
4	2626	TEDBDatabase Database Property in Component Reference Documentation Incorrect	No
4	2627	RESTART WITH Clause Allowed with Non-IDENTITY Columns	No
4	2628	Leaving Out Interval Specification from CREATE JOB Statement Causes AV	Yes
4	2634	Altering Certain Jobs in the ElevateDB Manager Results in Incorrect Settings in the Alter Job Dialog	No
4	2635	Conversion Errors Not Displaying Proper Value in Error Message	No
4	2637	Opening a Table with an Active Index that Has Been Dropped Causes Error in ElevateDB Manager	No
4	2638	Documentation Missing on Error Codes #1100 and #1101	No

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap