[
https://issues.apache.org/jira/browse/DERBY-3687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12599237#action_12599237
]
Dag H. Wanvik commented on DERBY-3687:
--------------------------------------
I checked the standard, and SQL savepoints do allow nesting, cf. section 4.35.2
in ISO/IEC 9075-2:2003:
"An SQL-transaction has one or more savepoint levels, exactly one of which is
the current savepoint level. The
savepoint levels of an SQL-transaction are nested, such that when a new
savepoint level NSL is established,
the current savepoint level CSL ceases to be current and NSL becomes current.
When NSL is destroyed, CSL
becomes current again."
So the standard is not prohibiting this functionality in SQL. Then what is the
reason?
> Make client driver allow nested savepoints
> ------------------------------------------
>
> Key: DERBY-3687
> URL: https://issues.apache.org/jira/browse/DERBY-3687
> Project: Derby
> Issue Type: Improvement
> Components: Network Client
> Reporter: Dag H. Wanvik
>
> Currently, only the embedded driver allows nested savepoints, cf. the
> attached repro.
> In the interest of harmonizing the drivers it would be nice to make the
> client driver allow this as well.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
