Bug 1296599
Summary: | Redshift - there is not function SUBSTR (RS uses SUBSTRING) | ||
---|---|---|---|
Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Juraj Duráni <jdurani> |
Component: | Teiid | Assignee: | Van Halbert <vhalbert> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | Juraj Duráni <jdurani> |
Severity: | unspecified | Docs Contact: | |
Priority: | unspecified | ||
Version: | 6.3.0 | CC: | aszczucz, blafond, jolee, mbaluch, thauser, vhalbert |
Target Milestone: | ER4 | ||
Target Release: | 6.3.0 | ||
Hardware: | Unspecified | ||
OS: | Unspecified | ||
Whiteboard: | |||
Fixed In Version: | Doc Type: | Bug Fix | |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: |
driver - PostgreSQL 9.2
translator - postgresql
|
|
Last Closed: | 2016-08-24 11:46:33 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
Juraj Duráni
2016-01-07 15:59:35 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-3888 to Resolved Note: a new redshift translator has been created to account for the different capabilities than the postgresql translator. This still does not work for function LOCATION(x,y,z). Query: SELECT INTKEY, STRINGKEY FROM Source.SmallA WHERE LOCATE('1', STRINGKEY, 2) IN (1, 2) Source-specific command: SELECT g_0.intkey, g_0.stringkey FROM smalla AS g_0 WHERE (position('1' in substr(g_0.stringkey, 2)) + 1) IN (1, 2) Root exception message: Caused by: org.postgresql.util.PSQLException: ERROR: function SUBSTR does not exist (Hint: use SUBSTRING instead) Juraj Duráni <jdurani> updated the status of jira TEIID-3888 to Reopened Steven Hawkins <shawkins> updated the status of jira TEIID-3888 to Resolved There is a new issue for LOCATE function. Adding as a new external tracker. Steven Hawkins <shawkins> updated the status of jira TEIID-4199 to Resolved Steven Hawkins <shawkins> updated the status of jira TEIID-4199 to Closed Steven Hawkins <shawkins> updated the status of jira TEIID-3888 to Closed |