comparison src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java @ 218:5cc7101c5c8d

Corrected method DatabaseMetaData.getFunctions().
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 19 Apr 2018 19:03:40 +0200 (2018-04-19)
parents 7cbd20ff628c
children 4572f0694fde
comparison
equal deleted inserted replaced
217:7cbd20ff628c 218:5cc7101c5c8d
3907 " WHEN 1 THEN ").append(DatabaseMetaData.functionNoTable) 3907 " WHEN 1 THEN ").append(DatabaseMetaData.functionNoTable)
3908 .append(" WHEN 2 THEN ").append(DatabaseMetaData.functionNoTable) 3908 .append(" WHEN 2 THEN ").append(DatabaseMetaData.functionNoTable)
3909 .append(" WHEN 3 THEN ").append(DatabaseMetaData.functionNoTable) 3909 .append(" WHEN 3 THEN ").append(DatabaseMetaData.functionNoTable)
3910 .append(" WHEN 4 THEN ").append(DatabaseMetaData.functionNoTable) 3910 .append(" WHEN 4 THEN ").append(DatabaseMetaData.functionNoTable)
3911 .append(" WHEN 5 THEN ").append(DatabaseMetaData.functionReturnsTable) 3911 .append(" WHEN 5 THEN ").append(DatabaseMetaData.functionReturnsTable)
3912 .append(" WHEN 6 THEN ").append(DatabaseMetaData.functionNoTable)
3913 .append(" WHEN 7 THEN ").append(DatabaseMetaData.functionNoTable)
3912 .append(" ELSE ").append(DatabaseMetaData.functionResultUnknown).append(" END AS \"FUNCTION_TYPE\", " + 3914 .append(" ELSE ").append(DatabaseMetaData.functionResultUnknown).append(" END AS \"FUNCTION_TYPE\", " +
3913 // only the id value uniquely identifies a function. Include it to be able to differentiate between multiple overloaded functions with the same name 3915 // only the id value uniquely identifies a function. Include it to be able to differentiate between multiple overloaded functions with the same name
3914 "cast(\"functions\".\"id\" as varchar(10)) AS \"SPECIFIC_NAME\" " + 3916 "cast(\"functions\".\"id\" as varchar(10)) AS \"SPECIFIC_NAME\" " +
3915 "FROM \"sys\".\"functions\" JOIN \"sys\".\"schemas\" ON (\"functions\".\"schema_id\" = \"schemas\".\"id\") "); 3917 "FROM \"sys\".\"functions\" JOIN \"sys\".\"schemas\" ON (\"functions\".\"schema_id\" = \"schemas\".\"id\") ");
3916 if (useCommentsTable) { 3918 if (useCommentsTable) {