You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by an...@apache.org on 2019/02/23 21:18:09 UTC
[trafodion] 02/03: turn off binary support by default except from
sqlci/trafci
This is an automated email from the ASF dual-hosted git repository.
ansharma pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/trafodion.git
commit e8d2c3c3fa3d2cec8c95bc970ef57439d0dcf9ea
Author: Anoop Sharma <an...@esgyn.com>
AuthorDate: Fri Feb 22 01:32:50 2019 +0000
turn off binary support by default except from sqlci/trafci
When all clients have been updated to handle binary datatypes,
then default will be turned on.
Queries coming from sqlci and trafci will be ok as this feature
is automatically turned on during sqlci/trafci initialization.
---
core/conn/trafci/src/main/java/org/trafodion/ci/Session.java | 11 +++++++++++
core/sql/sqlcomp/nadefaults.cpp | 2 +-
2 files changed, 12 insertions(+), 1 deletion(-)
diff --git a/core/conn/trafci/src/main/java/org/trafodion/ci/Session.java b/core/conn/trafci/src/main/java/org/trafodion/ci/Session.java
index 194f2fb..d2c7d4b 100644
--- a/core/conn/trafci/src/main/java/org/trafodion/ci/Session.java
+++ b/core/conn/trafci/src/main/java/org/trafodion/ci/Session.java
@@ -1568,11 +1568,22 @@ static {
try
{
Statement stmt = this.connObj.createStatement();
+ stmt.executeUpdate("CQD TRAF_BINARY_SUPPORT 'ON'");
+ } catch (Exception se)
+ {
+ System.out.println("error:"+se.getMessage());
+ }
+
+ try
+ {
+ Statement stmt = this.connObj.createStatement();
stmt.executeUpdate("CQD TRAF_BINARY_OUTPUT 'ON'");
} catch (Exception se)
{
System.out.println("error:"+se.getMessage());
}
+
+
}
protected String getUserRoleName()
diff --git a/core/sql/sqlcomp/nadefaults.cpp b/core/sql/sqlcomp/nadefaults.cpp
index a63ff18..a429eeb 100644
--- a/core/sql/sqlcomp/nadefaults.cpp
+++ b/core/sql/sqlcomp/nadefaults.cpp
@@ -2879,7 +2879,7 @@ XDDkwd__(SUBQUERY_UNNESTING, "ON"),
DDkwd__(TRAF_BINARY_INPUT, "OFF"),
DDkwd__(TRAF_BINARY_OUTPUT, "OFF"),
DDkwd__(TRAF_BINARY_SPJ_SUPPORT, "OFF"),
- DDkwd__(TRAF_BINARY_SUPPORT, "ON"),
+ DDkwd__(TRAF_BINARY_SUPPORT, "OFF"),
DDkwd__(TRAF_BLOB_AS_VARCHAR, "OFF"), //set to OFF to enable Lobs support