comparison src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java @ 222:75a5b5754020

Correction: Loader functions (type = 7) should return a table.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 26 Apr 2018 19:33:12 +0200 (2018-04-26)
parents 34f9ddd1a4e5
children 51e886d7f3b4 68b9452f1215
comparison
equal deleted inserted replaced
221:d034679a1a00 222:75a5b5754020
3926 .append(" WHEN 2 THEN ").append(DatabaseMetaData.functionNoTable) 3926 .append(" WHEN 2 THEN ").append(DatabaseMetaData.functionNoTable)
3927 .append(" WHEN 3 THEN ").append(DatabaseMetaData.functionNoTable) 3927 .append(" WHEN 3 THEN ").append(DatabaseMetaData.functionNoTable)
3928 .append(" WHEN 4 THEN ").append(DatabaseMetaData.functionNoTable) 3928 .append(" WHEN 4 THEN ").append(DatabaseMetaData.functionNoTable)
3929 .append(" WHEN 5 THEN ").append(DatabaseMetaData.functionReturnsTable) 3929 .append(" WHEN 5 THEN ").append(DatabaseMetaData.functionReturnsTable)
3930 .append(" WHEN 6 THEN ").append(DatabaseMetaData.functionNoTable) 3930 .append(" WHEN 6 THEN ").append(DatabaseMetaData.functionNoTable)
3931 .append(" WHEN 7 THEN ").append(DatabaseMetaData.functionNoTable) 3931 .append(" WHEN 7 THEN ").append(DatabaseMetaData.functionReturnsTable)
3932 .append(" ELSE ").append(DatabaseMetaData.functionResultUnknown).append(" END AS \"FUNCTION_TYPE\", " + 3932 .append(" ELSE ").append(DatabaseMetaData.functionResultUnknown).append(" END AS \"FUNCTION_TYPE\", " +
3933 // only the id value uniquely identifies a function. Include it to be able to differentiate between multiple overloaded functions with the same name 3933 // only the id value uniquely identifies a function. Include it to be able to differentiate between multiple overloaded functions with the same name
3934 "cast(\"functions\".\"id\" as varchar(10)) AS \"SPECIFIC_NAME\" " + 3934 "cast(\"functions\".\"id\" as varchar(10)) AS \"SPECIFIC_NAME\" " +
3935 "FROM \"sys\".\"functions\" JOIN \"sys\".\"schemas\" ON (\"functions\".\"schema_id\" = \"schemas\".\"id\") "); 3935 "FROM \"sys\".\"functions\" JOIN \"sys\".\"schemas\" ON (\"functions\".\"schema_id\" = \"schemas\".\"id\") ");
3936 if (useCommentsTable) { 3936 if (useCommentsTable) {