[MADLIB-1141] Graph - SSSP with empty string grouping_col fails

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: v1.12
• Component/s: Module: Graph
• Assignee: Unassigned
• Reporter: Nandish Jayaram
• Created: 17/Jul/17 17:57
• Updated: 17/Aug/17 18:03
• Resolved: 26/Jul/17 22:09

Description

Using the dataset provided in Graph SSSP's user doc page, the following query results in an error:

SELECT madlib.graph_sssp(                                                                                                                                                                       'vertex',      -- Vertex table                                                                                                                                                       NULL,          -- Vertix id column (NULL means use default naming)                                                                                                                   'edge',        -- Edge table                                                                                                                                                         NULL,          -- Edge arguments (NULL means use default naming)                                                                                                                     0,             -- Source vertex for path calculation                                                                                                                                 'out',
''     -- empty grouping_col);

The error is:

ERROR:  spiexceptions.SyntaxError: syntax error at or near ","
LINE 2:                      ,  src AS id, weight,
                             ^
QUERY:   CREATE TABLE out AS (SELECT
                     ,  src AS id, weight,
                    src AS parent FROM edge LIMIT 0)

CONTEXT:  Traceback (most recent call last):
  PL/Python function "graph_sssp", line 23, in <module>
    return sssp.graph_sssp(**globals())
  PL/Python function "graph_sssp", line 151, in graph_sssp
PL/Python function "graph_sssp"

Empty grouping_col string must be treated the same as a NULL.