[MADLIB-55] madlib.drop_sv_model() script error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Unresolved
• Environment: production
• Assignee: Kelvin Kakugawa
• Reporter: Brian Dolan
• Created: 29/Mar/11 05:54
• Updated: 29/Jun/11 21:06

Description

select madlib.drop_sv_model('myexp');
WARNING: PL/Python: plpy.SPIError: unrecognized error in PLy_spi_execute_query
CONTEXT: PL/Python function "drop_sv_model"
ERROR: syntax error at or near "in"
LINE 1: ... madlib.sv_results WHERE position( + modelname + in id) > 0
^
QUERY: DELETE FROM madlib.sv_results WHERE position( + modelname + in id) > 0
CONTEXT: PL/Python function "drop_sv_model"