Mercurial > hg > monetdb-java
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) { |