Actions
Bug #2082
closedUse of INSTR in SQL statements.
Start date:
05/16/2005
Due date:
% Done:
0%
Estimated time:
Bugzilla-Id:
2082
Description
INSTR is not a function in Postgres. And it is used by Metacat code at 2-3
places. e.g. in DBUtil.java in getMaxDocid()
"SELECT docid, rev, SUBSTR+1)+0 acc FROM
xml_documents WHERE docid LIKE ? ORDER BY acc DESC"
Usage of INSTR has to be removed from the code.
Chris reported this.
Actions