Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1515768

Summary: PrestoDB translator - Convert to float not pushed correctly
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Andrej Smigala <asmigala>
Component: Teiid, DocumentationAssignee: David Le Sage <dlesage>
Status: CLOSED WONTFIX QA Contact: Jan Stastny <jstastny>
Severity: high Docs Contact:
Priority: high    
Version: 6.4.0CC: blafond, drieden, gjospin, jolee, jschatte, jstastny, thauser, vhalbert
Target Milestone: GAKeywords: Documentation
Target Release: 6.4.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
If you attempt to convert a value to float in a PrestoDB query, you will encounter a exception. This only happens if convert is one of the criteria. This issue is caused by the fact that PrestoDB support was developed before the database lacked a single float type. To work around this issue, aboid using float in conjunction with convert in your PrestoDB queries.
 Story Points: ---
Clone Of: Environment:
Last Closed: 2018-02-01 08:17:03 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Andrej Smigala 2017-11-21 11:05:07 UTC 
Running query such as

SELECT StringKey, (convert(StringKey, float)+3)  FROM BQT1.SmallA

Fails with an exception: line 1:45: '+' cannot be applied to varchar(10), double


See jira for more details
Comment 4 David Le Sage 2017-11-27 23:09:03 UTC 
Documented as known issue in release notes errata.
Comment 5 Jan Stastny 2018-01-15 14:16:18 UTC 
*** Bug 1533482 has been marked as a duplicate of this bug. ***