QueryRecCount error when query uses PLAN

bero · Post by **bero** » Fri 30 Mar 2012 10:48

I have a situation where query uses PLAN clause and QueryRecCount is set to True. When I open the query, exception is raised because the PLAN clause stays in a SQL which retrieves record count.
This happens because ORDER BY clause is removed but in PLAN clause stays a primary key to use in ORDER BY. The PLAN clause should be removed in this new query.

Example:

SELECT
FROM table1 t1
JOIN table2 t2 ON
PLAN JOIN (t2 ORDER PK_table2, t1 INDEX (PK_table1))
ORDER BY

This produces an error when opening query.

Version of UniDAC we are using is 4.1.5.

AndreyZ · Post by **AndreyZ** » Mon 02 Apr 2012 13:54

Hello,

Thank you for the information. We have reproduced the problem and investigation of the problem is in progress. As soon as we have any results we will let you know.

AndreyZ · Post by **AndreyZ** » Thu 05 Apr 2012 10:15

We have fixed this problem. This fix will be included in the next IBDAC build.