Project

General

Profile

« Previous | Next » 

Revision 7366

include WHERE in the sql where clause - encountered by SAEON's node admin, Alex Niehaus.

View differences:

src/edu/ucsb/nceas/metacat/oaipmh/provider/server/catalog/MetacatCatalog.java
99 99
  " AND id.guid IN " +
100 100
  "     (SELECT guid " +
101 101
  "     FROM xml_access " +
102
  "		AND lower(principal_name) = 'public' " +
102
  "		WHERE lower(principal_name) = 'public' " +
103 103
  " 	AND perm_type = 'allow' " +
104 104
  " 	AND permission > 3" +
105 105
  "		) " +

Also available in: Unified diff