Loading...

XML

Word

Printable

Type: Bug
Resolution: Done
Priority: Major
Fix Version/s: 8.12.11.6_4, 8.12.11.6_3
Affects Version/s: None
Component/s: OData
Labels:
None
Environment:

VDB accessed through OData4 where the primary key is of bigdecimal type.

Steps to Reproduce:

Hide

1) Deploy VDB:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="odataFacetError" version="1">
<description>test vdb showing odata issue with bigdecimal</description>
<model visible = "true" type = "VIRTUAL" name = "odataFacetError">
<metadata type = "DDL"><![CDATA[
CREATE VIEW fauxdata(
intkey bigdecimal(38,38) PRIMARY KEY
) AS
select convert(1.1,bigdecimal) as intkey;
]]>
</metadata>
</model>
</vdb>

2) Navigate to page http://server:8080/odata4/odataFacetError/odataFacetError/fauxdata

Show
1) Deploy VDB: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <vdb name="odataFacetError" version="1"> <description>test vdb showing odata issue with bigdecimal</description> <model visible = "true" type = "VIRTUAL" name = "odataFacetError"> <metadata type = "DDL"><![CDATA[ CREATE VIEW fauxdata( intkey bigdecimal(38,38) PRIMARY KEY ) AS select convert(1.1,bigdecimal) as intkey; ]]> </metadata> </model> </vdb> 2) Navigate to page http://server:8080/odata4/odataFacetError/odataFacetError/fauxdata
Bugzilla References:
https://bugzilla.redhat.com/show_bug.cgi?id=1442239, https://bugzilla.redhat.com/show_bug.cgi?id=1451785, https://bugzilla.redhat.com/show_bug.cgi?id=1445044

Attempting to access the VDB through OData4 (http://server:8080/odata4/odataFacetError/odataFacetError/fauxdata) results in an error like:

org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '1.1' does not match the facets' constraints.

is duplicated by

TEIID-5063 Issues with bigdecimal values and odata