Driver version
12.6.3
SQL Server version
Microsoft SQL Server 2022 (RTM-CU7) (KB5028743) - 16.0.4065.3 (X64)
Client Operating System
Windows 11 & Ubuntu
JAVA/JVM version
jdk-21.0.1
Table schema
See the example which contains a simple SQL function and a Java test case which calls the function.
FunctionTest.zip
Problem description
When calling a function whose name contains parentheses at the end, 0 of type Integer is always returned.
In the profiler I could see that the correct value was returned.
Testing with driver version '12.6.2' the correct value is returned regardless of whether 'foobar' or 'foobar()' is called.
Expected behavior
The SQL driver returns the correct value as received from the database system
Actual behavior
0 if type Integer is returned
Driver version
12.6.3
SQL Server version
Microsoft SQL Server 2022 (RTM-CU7) (KB5028743) - 16.0.4065.3 (X64)
Client Operating System
Windows 11 & Ubuntu
JAVA/JVM version
jdk-21.0.1
Table schema
See the example which contains a simple SQL function and a Java test case which calls the function.
FunctionTest.zip
Problem description
When calling a function whose name contains parentheses at the end, 0 of type Integer is always returned.
In the profiler I could see that the correct value was returned.
Testing with driver version '12.6.2' the correct value is returned regardless of whether 'foobar' or 'foobar()' is called.
Expected behavior
The SQL driver returns the correct value as received from the database system
Actual behavior
0 if type Integer is returned