Note: This is a beta release of Red Hat Bugzilla 5.0. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Also email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback here.

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: ---

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. ***