adding changes to make paged query results possible
Removed the release ant token from all files in 'src'.
release
Reverting to previous QueryTerm.java that uses 'LIKE' for comparisons. Thisallows substring matching to work properly, but prevents the postgres indexfrom being used. As a result, full table scans are done on the tables, causinga major performance hit. Need to determine how to eliminate the use of LIKE...
Modifications to the table definitions to add indices that should be usedwhen searching the database. Added an upgrade script to create theseindices as well. Modified QueryTerm.java to use the '=' comparator ratherthan 'LIKE' so that we can do index scans rather than table scans. This needs...
Bug fix in the changes made in previous commit
Fix for bug 2222. So that correct query is generated when searchmode is 'not-contains'.
Adding code to check if all the paths being searched for indexed are not. If all paths are indexed, the code will use xml_path_index instead of using xml_nodes and xml_index
Fixed a bug in last commit. Doing a search likepathquery version="1.2"><returndoctype>eml://ecoinformatics.org/eml-2.0.0</returndoctype><returnfield>originator/individualName/surName</returnfield><querygroup operator="INTERSECT"><queryterm casesensitive="false" searchmode="contains"><value>%</value></queryterm><queryterm casesensitive="false" searchmode="contains"><value>National Center for Ecological Analysis and Synthesis</value><pathexpr>organizationName</pathexpr></queryterm></querygroup></pathquery>...
When a path expression includes element content and attribute content, thenthe SQL generated needs to search for attribute nodetypes with parentnodenames equal to the path expression element content. However, whenonly searching for attribute content (such as just @packageId), then...
Modified handling of greater-than and less-than so that comparison is done against nodedatanumerical column.
Created new printExtendedSQL function that can get the extendedreturn fields using only xml_nodes and not xml_index. Onestep closer to eliminating the dependence ofn xml_index.
Created test class QuerySpecificationTest and started process of removing the xml_index from the QuerySpecification code. Reformatted some classes for readability.
Remove UPPER function for >, < operator.
Add a new search mode not-contains.
New class will be used in metacat ecogrid impl.