[
https://issues.jboss.org/browse/TEIID-1766?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1766.
-----------------------------------
Resolution: Out of Date
This was resolved in Teiid 7.4 by adding direct parsing support for pg escaped literals.
In 7.1 the issue is caused in ODBCServerRemoteImpl by line 354:
modified = modified.replaceAll("E'", "'"); //$NON-NLS-1$
//$NON-NLS-2$
Which is far too generic. ODBCServerRemoteImpl version 3045 contained a fix and related
fixes. The specific change would be:
modified = modified.replaceAll("E('[^']*')+", "$1");
//$NON-NLS-1$ //$NON-NLS-2$
EDS ODBC query on a namespace ending in 'e' fails
-------------------------------------------------
Key: TEIID-1766
URL:
https://issues.jboss.org/browse/TEIID-1766
Project: Teiid
Issue Type: Bug
Components: ODBC
Affects Versions: 7.1.1
Reporter: Debbie Steigner
Assignee: Steven Hawkins
Attachments: Testing.vdb
The attached testing vdb contains the following namespaces:
LOOKHERE
TestPG
LOOKAGAIN
If you run the following query via ODBC (JDBC works ):
select nspname from pg_catalog.pg_namespace where nspname = 'LOOKHERE'
It returns zero rows, but if you run the same query with 'LOOKAGAIN' in your
criteria you get the one row, It seems that any namespace ending in an E doesn't
match via ODBC.
--
This message is automatically generated by JIRA.
For more information on JIRA, see:
http://www.atlassian.com/software/jira