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

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

    [ http://tools.oasis-open.org/issues/browse/CMIS-177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=10631#action_10631 ] 

Ryan McVeigh commented on CMIS-177:
-----------------------------------

Well that didn't translate well from the JIRA client to the actual issue in the browser... but imagine a table above.

> 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