Skip to content

Calling a function with parentheses at the end of the function name returns always 0 #2463

@SteBoe82

Description

@SteBoe82

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

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

Status

Closed Issues

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions