calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Atkinson <chris.atkins...@ocado.com>
Subject Suggested PATCH Oracle does not support CHARACTER SET for VARCHAR data type
Date Fri, 11 Mar 2016 11:44:07 GMT
Suggested fix for joining two varchar fields of differing length:
Error: DATA_READ ERROR: The JDBC storage plugin failed while trying setup
the SQL query.

sql SELECT *
FROM (SELECT "DESCRIPTION", CAST("DESCRIPTION" AS VARCHAR(20) CHARACTER SET
"ISO-8859-1") "$f2"
FROM "UTPDBA"."A_TABLE") "t"
INNER JOIN "UTPDBA"."B_TABLE" ON "t"."$f2" = "B_TABLE"."DESCRIPTION20"
plugin utd_utpdba
Fragment 0:0

[Error Id: 2f9a1975-fa57-4b07-8642-4dca3d03ae39 on x.x.x.x:31010]

  (java.sql.SQLSyntaxErrorException) ORA-00907: missing right parenthesis

---

 core/src/main/java/org/apache/calcite/sql/SqlDialect.java | 1 +

 1 file changed, 1 insertion(+)


diff --git a/core/src/main/java/org/apache/calcite/sql/SqlDialect.java
b/core/src/main/java/org/apache/calcite/sql/SqlDialect.java

index 88c6d63..2e38d42 100644

--- a/core/src/main/java/org/apache/calcite/sql/SqlDialect.java

+++ b/core/src/main/java/org/apache/calcite/sql/SqlDialect.java

@@ -465,6 +465,7 @@ public boolean supportsCharSet() {

     case HSQLDB:

     case PHOENIX:

     case POSTGRESQL:

+    case ORACLE:

       return false;

     default:

       return true;

--

-- 


Notice:  This email is confidential and may contain copyright material of 
members of the Ocado Group. Opinions and views expressed in this message 
may not necessarily reflect the opinions and views of the members of the 
Ocado Group. 

 

If you are not the intended recipient, please notify us immediately and 
delete all copies of this message. Please note that it is your 
responsibility to scan this message for viruses. 

 

Fetch and Sizzle are trading names of Speciality Stores Limited, a member 
of the Ocado Group.

 

References to the “Ocado Group” are to Ocado Group plc (registered in 
England and Wales with number 7098618) and its subsidiary undertakings (as 
that expression is defined in the Companies Act 2006) from time to time.  
The registered office of Ocado Group plc is Titan Court, 3 Bishops Square, 
Hatfield Business Park, Hatfield, Herts. AL10 9NE.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message