[OASIS Issue Tracker] Created: (CMIS-177) How do the variouscomparison operators work with the various property types?

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

How do the various comparison operators work with the various property types?
-----------------------------------------------------------------------------

                 Key: CMIS-177
                 URL: http://tools.oasis-open.org/issues/browse/CMIS-177
             Project: OASIS Content Management Interoperability Services (CMIS) TC
          Issue Type: Bug
          Components: Domain Model
    Affects Versions: Draft 0.61
            Reporter: Ryan McVeigh
            Assignee: Ethan Gur-esh
            Priority: Critical


The spec needs to provide guidance about how the various comparison operators work with the various property types.  Here's a list of the types, operators, literal type and possible result.  

This is our interpretation and ?'s are areas we are looking for guidance on.  

Possible values for ? might be: invalidArgumentException, always evaluate false, always evaluate true, do something else....

We should include this type of information in the spec.

String 		 =, <>, IN, NOT IN 	string 	string equality test
String 		<, <=, >, >= 	string 	collation? what locale? ?
String 		LIKE, NOT LIKE 	string 	string wildcard match
String 		=, <>, IN, NOT IN 	numeric 	?
String 		<, <=, >, >= 	numeric 	?
Decimal, Integer 	=, <>, IN, NOT IN 	string 	?
Decimal, Integer 	<, <=, >, >= 	string 	?
Decimal, Integer 	=, <>, IN, NOT IN 	numeric 	numeric equality
Decimal, Integer 	<, <=, >, >= 	numeric 	numeric comparison
Boolean 		=, <>, IN, NOT IN 	string 	? (what valid string values?)
Boolean 		<, <=, >, >= 	string 	?
Boolean 		LIKE, NOT LIKE 	string 	?
Boolean 		=, <>, IN, NOT IN 	numeric 	?
Boolean 		<, <=, >, >= 	numeric 	?
DateTime 		=, <>, IN, NOT IN 	string 	equality match if string matches xsd:dateTime? - if not: ?
DateTime 		<, <=, >, >= 	string 	before/after match if string matches xsd:dateTime? ?
DateTime 		LIKE, NOT LIKE 	string 	?
DateTime 		=, <>, IN, NOT IN 	numeric 	?
DateTime 		<, <=, >, >= 	numeric 	?
ID 		=, <> 	string 	string match
ID 		IN, NOT IN 	string 	Not allowed (line 877) (? is this intended?)
ID 		<, <=, >, >= 	string 	Not allowed (line 877)
ID 		LIKE, NOT LIKE 	string 	Not allowed (line 877)
ID 		=, <> 	numeric 	?
ID 		IN, NOT IN 	numeric 	Not allowed (line 877)
ID 		<, <=, >, >= 	numeric 	Not allowed (line 877)
URI, XML, HTML 	=, <>, IN, NOT IN 	string 	? (string match?)
URI, XML, HTML 	<, <=, >, >= 	string 	?
URI, XML, HTML 	LIKE, NOT LIKE 	string 	?
URI, XML, HTML 	=, <>, IN, NOT IN 	numeric 	?
URI, XML, HTML 	<, <=, >, >= 	numeric 	?



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira