[CMIS-911] CMIS Query - no hits when float

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: OpenCMIS 0.13.0
• Component/s: opencmis-client, opencmis-workbench

Environment

Alfresco Community 5.0.d on Linux with MySQL
Client on Windows 8

• Assignee: Unassigned
• Reporter: Tomaž Kolmanič
• Created: 20/May/15 15:52
• Updated: 23/May/15 20:49
• Resolved: 23/May/15 20:49

Description

CMIS query with search on float (and double also) property always returns nothing even they are some hits.

The same query on the same data custom model works fine when Alfresco and MySQL are running on Windows, and also when Alfresco is running with Postgre DB on Linux.

It's the same bug from Workbench or from our java client.

Query:
SELECT * FROM ba:doc WHERE ba:amount > 10 AND ba:amount < 150

where amount is float property:
<property name="ba:amount">
<type>d:float</type>
</property>