Project

Profile

Help

Bug #5747

closed

sql:update function ignores the where-clause.

Added by Herbert Brückner about 2 years ago. Updated almost 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Saxon extensions
Sprint/Milestone:
-
Start date:
2022-11-27
Due date:
% Done:

100%

Estimated time:
Legacy ID:
Applies to branch:
10, 11, trunk
Fix Committed on Branch:
10, 11, trunk
Fixed in Maintenance Release:
Platforms:
Java

Description

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.


Files

Example.xslt (1.1 KB) Example.xslt Test script Herbert Brückner, 2022-11-27 13:39
SQL_TEST.SQL (289 Bytes) SQL_TEST.SQL DB table for testing Herbert Brückner, 2022-11-27 13:39
Example2.xslt (1.29 KB) Example2.xslt Herbert Brückner, 2022-11-29 10:35

Please register to edit this issue

Also available in: Atom PDF