Closed
Description
openedon Jul 29, 2019
Driver version
7.2.2
SQL Server version
Microsoft SQL Server 2017 (RTM-CU15-GDR) (KB4505225) - 14.0.3192.2 (X64)
Jun 15 2019 00:45:05
Copyright (C) 2017 Microsoft Corporation
Developer Edition (64-bit) on Linux (Ubuntu 19.04)
Client Operating System
ubuntu 19.04
JAVA/JVM version
java version "1.8.0"
Problem description
- Expected behaviour: call for
DatabaseMetaData#getStringFunctions
returnsASCII,CHAR,CONCAT, DIFFERENCE,INSERT,LCASE,LEFT,LENGTH,LOCATE,LTRIM,REPEAT,REPLACE,RIGHT,RTRIM,SOUNDEX,SPACE,SUBSTRING,UCASE
so there is a space between,
andDIFFERENCE
The similar thing is forDatabaseMetaData#getNumericFunctions
which returns
ABS,ACOS,ASIN,ATAN,ATAN2,CEILING,COS,COT,DEGREES,EXP, FLOOR,LOG,LOG10,MOD,PI,POWER,RADIANS,RAND,ROUND,SIGN,SIN,SQRT,TAN,TRUNCATE
so there is a space between,
andFLOOR
- Actual behavior: no spaces, e.g. https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#getNumericFunctions-- tells about comma-separated
Retrieves a comma-separated list of math functions available with this database. These are the Open /Open CLI math function names used in the JDBC function escape clause.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment