sql:update function ignores the where-clause.
I am using Saxon 11.3 EE with Java 11 and an Oracle 19 database with the standard oracle jdbc driver. Now I found an unexpected behavior when I worked with the Saxon SQL functions. It seems that the sql:update function (and sql:prepared-statement as well) ignores the where-clause. A little example is appended to this mail.
Updated by Herbert Brückner 2 months ago
- File Example2.xslt added
Sorry, just to mention the sql:prepared-statement here is not comprehensible. In fact, my first try was to define an update-Statement using sql:prepared-statement. When I could'nt work it out, I started using the sql:update function. A little example using sql:prepared-statement for an update statement with unexpected results is now appended.
Updated by Michael Kay about 2 months ago
Sorry for the delay in responding to this. It's taken me a while to get the SQL tests working again in my development environment (for a while now, we've only been running them in our automated build scripts, which makes debugging any problems difficult). I've now got the tests running and passing so should be able to start work on this bug.
Please register to edit this issue