Project

General

Profile

Actions

Bug #2082

closed

Use of INSTR in SQL statements.

Added by Saurabh Garg over 19 years ago. Updated about 19 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
metacat
Target version:
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

Also available in: Atom PDF