[jira] [Created] (MADLIB-1184) k-NN install check fails on non-madlib schema name

[Nandish Jayaram (JIRA)]

Nandish Jayaram created MADLIB-1184:
---------------------------------------

             Summary: k-NN install check fails on non-madlib schema name
                 Key: MADLIB-1184
                 URL: https://issues.apache.org/jira/browse/MADLIB-1184
             Project: Apache MADlib
          Issue Type: Bug
          Components: k-NN
            Reporter: Nandish Jayaram
             Fix For: v1.13


The install check fails when MADlib is installed on a  schema named
anything other than `madlib`. The issue seems to be because the fn_dist
param expects a distance function name prefixed with `<madlib_schema>.`

With MADlib installed on schema `mad`, the following error happens:
{code}
psql:/tmp/madlib.OIue8c/knn/test/knn.sql_in.tmp:155: ERROR:  
spiexceptions.InvalidSchemaName: schema "madlib" does not exist
LINE 3:                 oid='madlib.squared_dist_norm2(DOUBLE PRECIS...
                            ^
QUERY:  select prorettype != 'DOUBLE PRECISION'::regtype
                OR proisagg = TRUE AS OUTPUT from pg_proc where
                oid='madlib.squared_dist_norm2(DOUBLE PRECISION[], DOUBLE 
PRECISION[])'::regprocedure;

CONTEXT:  Traceback (most recent call last):
  PL/Python function "knn", line 35, in <module>
    fn_dist
  PL/Python function "knn", line 147, in knn
  PL/Python function "knn", line 100, in knn_validate_src
{code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)