Bug 1515768 – PrestoDB translator - Convert to float not pushed correctly

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 1515768 - PrestoDB translator - Convert to float not pushed correctly

Summary:	PrestoDB translator - Convert to float not pushed correctly

Status:	CLOSED WONTFIX

Aliases:	None

Product:	JBoss Data Virtualization 6
Classification:	JBoss
Component:	Teiid, Documentation (Show other bugs)
Sub Component:
Version:	6.4.0
Hardware:	Unspecified Unspecified

Priority	high Severity high
Target Milestone:	GA
Target Release:	6.4.0
Assigned To:	David Le Sage
QA Contact:	Jan Stastny
Docs Contact:

URL:
Whiteboard:
Keywords:	Documentation

Duplicates:	1533482 (view as bug list)
Depends On:
Blocks:
	Show dependency tree / graph

Reported:	2017-11-21 06:05 EST by Andrej Smigala
Modified:	2018-02-01 03:17 EST (History)
CC List:	8 users (show)

See Also:
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 03:17:03 EST
Type:	Bug
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
JBoss Issue Tracker	TEIID-5168	Major	Resolved	PrestoDB translator - Convert to float not pushed correctly	2018-06-05 08:38 EDT

Groups: None (edit)

Description Andrej Smigala 2017-11-21 06:05:07 EST

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 18:09:03 EST

Documented as known issue in release notes errata.

Comment 5 Jan Stastny 2018-01-15 09:16:18 EST

*** Bug 1533482 has been marked as a duplicate of this bug. ***

Note You need to log in before you can comment on or make changes to this bug.