issue is very serious. Sybase ASE is firing the query twice when execution plan is on and set noexec off is set so the query plan query is actually executing. This will require some redesign as the xml plan can only be extracted if the query is actually executed.
issue is fixed but wish to do a code review so will not check in till tomorrow.
issue is fixed but wish to do a code review so will not check in till tomorrow.
Resolved for version 14 and 15. The bug was introduced in version 14, when we added XML explain plan. On a side not, it should be known that in order to extract the XML explain plan the SQL statement must be fired by the server. If you ask for just the XML explain plan on an insert statement it will execute the statement. Sybase Central also does it this way.
Resolved for version 14 and 15. The bug was introduced in version 14, when we added XML explain plan. On a side not, it should be known that in order to extract the XML explain plan the SQL statement must be fired by the server. If you ask for just the XML explain plan on an insert statement it will execute the statement. Sybase Central also does it this way.
Issue #12210 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 14.0.15 |
No time estimate |
issue is very serious. Sybase ASE is firing the query twice when execution plan is on and set noexec off is set so the query plan query is actually executing. This will require some redesign as the xml plan can only be extracted if the query is actually executed.