Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  com 2447 over 19 years sgarg Removed occurence of enum which is a keyword in...
  edu 2474 over 19 years sgarg 1. removed the call to QuerySpecification.print...
  perl 2432 over 19 years sgarg Replaced Usage Constraints with Usage Rights an...
addforeignkeyfortable.sql 135 Bytes 1626 over 21 years Jing Tao Create a foreign key for table accesssubtree.
clear.sql 312 Bytes 704 almost 24 years berkley added removal of relations
drop-postgres.sql 1.93 KB 2457 over 19 years Matt Jones dropping the sequences as well in the postgres ...
loaddtd.sql 2.36 KB 979 over 22 years Jing Tao Change every "http://@server@ to "@systemidserv...
loaddtdschema.sql 2.92 KB 2394 almost 20 years sgarg Added sql command to delete also schema entries...
loadschema.sql 476 Bytes 2229 over 20 years sgarg Modified directory name for eml-2.0.x checkouts...
package-count.sql 373 Bytes 2283 over 20 years Matt Jones Added sql for counting packages.
showdoc.sql 340 Bytes 390 over 24 years Matt Jones Added new utility query to return all of the xm...
sqlcatlist.sql 253 Bytes 123 over 24 years Matt Jones Modifying storage model to use DOM TEXT nodes
sqldoclist.sql 209 Bytes 531 about 24 years Matt Jones Changed utility query to include the user_owner...
sqlnodeslist.sql 94 Bytes 108 over 24 years Matt Jones added utility files and queries
sqlnodesview.sql 358 Bytes 166 over 24 years Matt Jones minor modifications to fix problems introduced ...
sqlrevisions.sql 205 Bytes 203 over 24 years Matt Jones Merged in substantial changes to DBWriter and a...
upgrade-db-to-1.2-postgres.sql 637 Bytes 2276 over 20 years Matt Jones New schema changes, including upgrade scripts. ...
upgrade-db-to-1.2.sql 596 Bytes 1827 over 21 years Matt Jones Renamed the upgrade sql files to more understan...
upgrade-db-to-1.3-postgres.sql 2.56 KB 2276 over 20 years Matt Jones New schema changes, including upgrade scripts. ...
upgrade-db-to-1.3.sql 1.44 KB 1827 over 21 years Matt Jones Renamed the upgrade sql files to more understan...
upgrade-db-to-1.4-postgres.sql 5.11 KB 2314 over 20 years sgarg Added code that changes the node column size
upgrade-db-to-1.4.sql 4.44 KB 2279 over 20 years Matt Jones Added lines for updating xml_catalog in the upg...
upgrade-db-to-1.5-postgres.sql 5.63 KB 2434 over 19 years sgarg Modified code such that nodedata column in xml_...
upgrade-db-to-1.5.sql 5.79 KB 2443 over 19 years sgarg Removed the code which created triggers. Added ...
upgrade_db_to_1_5.java 4.53 KB 2434 over 19 years sgarg Modified code such that nodedata column in xml_...
xmlpackage.sql 1.94 KB 439 over 24 years berkley sql file defining the table structure for eml-p...
xmltables-postgres.sql 13.2 KB 2442 over 19 years sgarg Removing code added for creating nodedata colum...
xmltables-sqlserver.sql 11.8 KB 2359 almost 20 years sgarg Modified database creation sql code so that in ...
xmltables.sql 15.7 KB 2442 over 19 years sgarg Removing code added for creating nodedata colum...

Latest revisions

# Date Author Comment
2474 04/07/2005 05:04 PM sgarg

1. removed the call to QuerySpecification.printAttributeSQL() from QuerySpecification.printExtendedSQL()
2. in QuerySpecification.printExtendedSQL() if ( returnFieldList.size() == 0 ) then it returns null
3. DBQuery.addReturnfield() doesnt execute the element query if printExtendedSQL returns null

2473 04/07/2005 04:08 PM Chris Jones

A minor change from containAtrributeReturnField to
containsAttributeReturnField

2472 04/07/2005 04:06 PM Chris Jones

I've added in a test in QuerySpecification.printExtendedSQL that checks
to see if attributes, and sometimes only attributes, are in the original
returnfield request. If so, the printAttributeQuery is called.

2467 04/07/2005 10:53 AM Chris Jones

Changed the handleReturnField() method so that it handles path expressions with
only attributes in the path.

2466 04/06/2005 07:04 PM sgarg

Added a check if printAttributeQuery() for returnPath to see that it is not null so that that this doesnt happen

xml_index.path like 'null' AND xml_nodes.nodename like 'id'

2465 04/06/2005 06:46 PM sgarg

Fixed a bug in previous commit

2464 04/06/2005 06:25 PM sgarg

Modified code for computing the returnfield string - earlier only elements were used to construct the string. e.g. /dataset/title
Now attributes are also added to the returnfield. e.g. title/@id

2462 04/06/2005 02:21 PM sgarg

Replaced 1.4.0 with release

2459 04/06/2005 02:23 AM Chris Jones

When a path expression includes element content and attribute content, then
the SQL generated needs to search for attribute nodetypes with parent
nodenames equal to the path expression element content. However, when
only searching for attribute content (such as just @packageId), then...

2458 04/06/2005 02:13 AM Chris Jones

When searching for attributes in the XPATH expression, an 'index out of bounds'
exception was thrown when only an attribute was included in the path string.

This fix changes the pathexpr.indexOf comparison to 0 rather than 1, since
the index starts at 0....

View revisions

Also available in: Atom