Project

General

Profile

Bug #2082

Use of INSTR in SQL statements.

Added by Saurabh Garg over 14 years ago. Updated about 14 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.

History

#1 Updated by Saurabh Garg about 14 years ago

Fixed.

#2 Updated by Redmine Admin over 6 years ago

Original Bugzilla ID was 2082

Also available in: Atom PDF