You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by hz...@apache.org on 2016/03/08 00:57:56 UTC

[1/5] incubator-trafodion git commit: Fix jira1863. Pushdown V2 is disabled on columns with non null default as we are resolving default at select time and hbase don t know about the default values.

Repository: incubator-trafodion
Updated Branches:
  refs/heads/master 57d3ebd1d -> 17f3f658a


Fix jira1863. Pushdown V2 is disabled on columns with non null default as we are resolving default at select time and hbase don t know about the default values.


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/e9b02c2c
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/e9b02c2c
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/e9b02c2c

Branch: refs/heads/master
Commit: e9b02c2c37890626cccbb2e7fda40af0edc874c6
Parents: d5ab1ea
Author: Eric Owhadi <er...@esgyn.com>
Authored: Fri Mar 4 14:46:04 2016 +0000
Committer: Eric Owhadi <er...@esgyn.com>
Committed: Fri Mar 4 14:46:04 2016 +0000

----------------------------------------------------------------------
 core/sql/generator/GenPreCode.cpp | 4 ++--
 core/sql/optimizer/ValueDesc.cpp  | 5 ++---
 core/sql/optimizer/ValueDesc.h    | 4 ++--
 core/sql/regress/core/TEST029     | 1 -
 core/sql/regress/core/TEST056     | 2 --
 5 files changed, 6 insertions(+), 10 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e9b02c2c/core/sql/generator/GenPreCode.cpp
----------------------------------------------------------------------
diff --git a/core/sql/generator/GenPreCode.cpp b/core/sql/generator/GenPreCode.cpp
index e6a3e01..93c76bd 100644
--- a/core/sql/generator/GenPreCode.cpp
+++ b/core/sql/generator/GenPreCode.cpp
@@ -11386,7 +11386,7 @@ NABoolean HbaseAccess::isHbaseFilterPredV2(Generator * generator, ItemExpr * ie,
   }
   //check if not an added column with default non null
   if ((foundBinary || foundUnary)&& (NOT hbaseLookupPred)){
-        if (colVID.isAddedColumnWithNonNullDefault()){
+        if (colVID.isColumnWithNonNullDefault()){
             foundBinary=FALSE;
             foundUnary=FALSE;
         }
@@ -11827,7 +11827,7 @@ RelExpr * HbaseAccess::preCodeGen(Generator * generator,
           {
             if (originExePreds->isNotNullable(vid)){// it is non nullable
                 OperatorTypeEnum operatorType = vid.getItemExpr()->getOperatorType();
-                if ((operatorType == ITM_BASECOLUMN || operatorType == ITM_INDEXCOLUMN) && !vid.isAddedColumnWithNonNullDefault()){//check if  added and  with default... notgood
+                if ((operatorType == ITM_BASECOLUMN || operatorType == ITM_INDEXCOLUMN) && !vid.isColumnWithNonNullDefault()){//check if with non null default... notgood
                     needAddingNonNullableColumn = false; // we found one column meeting all criteria
                     break;
                 }

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e9b02c2c/core/sql/optimizer/ValueDesc.cpp
----------------------------------------------------------------------
diff --git a/core/sql/optimizer/ValueDesc.cpp b/core/sql/optimizer/ValueDesc.cpp
index 891ba15..fe2a6fa 100644
--- a/core/sql/optimizer/ValueDesc.cpp
+++ b/core/sql/optimizer/ValueDesc.cpp
@@ -514,7 +514,7 @@ ValueId::getNAColumn(NABoolean okIfNotColumn) const
 }
 
 
-NABoolean ValueId::isAddedColumnWithNonNullDefault() const{
+NABoolean ValueId::isColumnWithNonNullDefault() const{
   NAColumn * nac = NULL;
   ItemExpr *ck = getItemExpr();
   if ( ck == NULL )
@@ -529,14 +529,13 @@ NABoolean ValueId::isAddedColumnWithNonNullDefault() const{
   default:
       break;
   }
-  if (nac && nac->isAddedColumn() && nac->getDefaultValue())
+  if (nac &&  nac->getDefaultValue() && strcmp(nac->getDefaultValue(),"NULL") != 0)
       return TRUE;
   else
       return FALSE;
 }
 
 
-
 // Since we *can* have an INSTANTIATE_NULL inside a VEG_REFERENCE, a loop
 // was required for the function below.
 //

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e9b02c2c/core/sql/optimizer/ValueDesc.h
----------------------------------------------------------------------
diff --git a/core/sql/optimizer/ValueDesc.h b/core/sql/optimizer/ValueDesc.h
index 559588b..f0fb753 100644
--- a/core/sql/optimizer/ValueDesc.h
+++ b/core/sql/optimizer/ValueDesc.h
@@ -194,9 +194,9 @@ public:
   NABoolean isSaltColumn() const;
 
   // return TRUE if I am a ValueId associated with an Index Column, or
-  // a base column , and I am an added column with a default value that is not
+  // a base column , and I am a column with a default value that is not
   // null.
-  NABoolean isAddedColumnWithNonNullDefault() const;
+  NABoolean isColumnWithNonNullDefault() const;
 
   // ---------------------------------------------------------------------
   // change the ValueId's type to the given type

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e9b02c2c/core/sql/regress/core/TEST029
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/TEST029 b/core/sql/regress/core/TEST029
index adfc463..7601251 100755
--- a/core/sql/regress/core/TEST029
+++ b/core/sql/regress/core/TEST029
@@ -39,7 +39,6 @@ obey TEST029(ddbMX);
 drop   table MT;
 create table MT(a int);		-- empty table, for NULL data source
 #ifMX
-cqd hbase_filter_preds 'on' ;
 log  LOG029 clear;
 obey TEST029(tests);
 obey TEST029(ddbMXMP);

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e9b02c2c/core/sql/regress/core/TEST056
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/TEST056 b/core/sql/regress/core/TEST056
index 29085bb..823f66e 100755
--- a/core/sql/regress/core/TEST056
+++ b/core/sql/regress/core/TEST056
@@ -806,7 +806,6 @@ alter table t056t56 add column t056t56_col3 pic 9 default +00;
 alter table t056t56 add column t056t56_col4 decimal default 0;
 select * from t056t56;
 
-cqd hbase_filter_preds 'on' ;
 create table t056t57 (a1 numeric(2,2) signed default 0 not null);
 showddl t056t57;
 insert into t056t57 default values;
@@ -831,7 +830,6 @@ create table t056t61 (a1 numeric(2,2) default -0.0 not null);
 showddl t056t61;
 insert into t056t61 default values;
 select * from t056t61;
-cqd hbase_filter_preds '2' ;
 
 ?section test4ddl
 ------------------------------------------------


[5/5] incubator-trafodion git commit: [TRAFODION-1863] PR340 caused PushdownV2 issues with column having non null default

Posted by hz...@apache.org.
[TRAFODION-1863] PR340 caused PushdownV2 issues with column having non null default


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/17f3f658
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/17f3f658
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/17f3f658

Branch: refs/heads/master
Commit: 17f3f658a3fcdad5a607829c6250b2742cd42824
Parents: 57d3ebd b6d2a07
Author: Hans Zeller <hz...@apache.org>
Authored: Mon Mar 7 23:55:32 2016 +0000
Committer: Hans Zeller <hz...@apache.org>
Committed: Mon Mar 7 23:55:32 2016 +0000

----------------------------------------------------------------------
 core/sql/generator/GenPreCode.cpp    | 4 ++--
 core/sql/optimizer/ValueDesc.cpp     | 5 ++---
 core/sql/optimizer/ValueDesc.h       | 6 +++---
 core/sql/regress/core/EXPECTED056.SB | 6 ------
 core/sql/regress/core/TEST029        | 1 -
 core/sql/regress/core/TEST056        | 2 --
 6 files changed, 7 insertions(+), 17 deletions(-)
----------------------------------------------------------------------



[4/5] incubator-trafodion git commit: Using getDefaultClass is better practice that initial implementation looking at NULL string. Also added improvement suggested about checking for DEFAULT_CURRENT. This is indeed good addition...

Posted by hz...@apache.org.
Using getDefaultClass is better practice that initial implementation looking at NULL string. Also added improvement suggested about checking for DEFAULT_CURRENT. This is indeed good addition...


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/b6d2a07f
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/b6d2a07f
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/b6d2a07f

Branch: refs/heads/master
Commit: b6d2a07fcc478b3a37dd19603df1375a8ac15534
Parents: 11c58b6
Author: Eric Owhadi <er...@esgyn.com>
Authored: Mon Mar 7 20:29:00 2016 +0000
Committer: Eric Owhadi <er...@esgyn.com>
Committed: Mon Mar 7 20:29:00 2016 +0000

----------------------------------------------------------------------
 core/sql/generator/GenPreCode.cpp | 4 ++--
 core/sql/optimizer/ValueDesc.cpp  | 4 ++--
 core/sql/optimizer/ValueDesc.h    | 4 ++--
 3 files changed, 6 insertions(+), 6 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/b6d2a07f/core/sql/generator/GenPreCode.cpp
----------------------------------------------------------------------
diff --git a/core/sql/generator/GenPreCode.cpp b/core/sql/generator/GenPreCode.cpp
index 93c76bd..dd04a94 100644
--- a/core/sql/generator/GenPreCode.cpp
+++ b/core/sql/generator/GenPreCode.cpp
@@ -11386,7 +11386,7 @@ NABoolean HbaseAccess::isHbaseFilterPredV2(Generator * generator, ItemExpr * ie,
   }
   //check if not an added column with default non null
   if ((foundBinary || foundUnary)&& (NOT hbaseLookupPred)){
-        if (colVID.isColumnWithNonNullDefault()){
+        if (colVID.isColumnWithNonNullNonCurrentDefault()){
             foundBinary=FALSE;
             foundUnary=FALSE;
         }
@@ -11827,7 +11827,7 @@ RelExpr * HbaseAccess::preCodeGen(Generator * generator,
           {
             if (originExePreds->isNotNullable(vid)){// it is non nullable
                 OperatorTypeEnum operatorType = vid.getItemExpr()->getOperatorType();
-                if ((operatorType == ITM_BASECOLUMN || operatorType == ITM_INDEXCOLUMN) && !vid.isColumnWithNonNullDefault()){//check if with non null default... notgood
+                if ((operatorType == ITM_BASECOLUMN || operatorType == ITM_INDEXCOLUMN) && !vid.isColumnWithNonNullNonCurrentDefault()){//check if with non null or non current default... notgood
                     needAddingNonNullableColumn = false; // we found one column meeting all criteria
                     break;
                 }

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/b6d2a07f/core/sql/optimizer/ValueDesc.cpp
----------------------------------------------------------------------
diff --git a/core/sql/optimizer/ValueDesc.cpp b/core/sql/optimizer/ValueDesc.cpp
index fe2a6fa..95246aa 100644
--- a/core/sql/optimizer/ValueDesc.cpp
+++ b/core/sql/optimizer/ValueDesc.cpp
@@ -514,7 +514,7 @@ ValueId::getNAColumn(NABoolean okIfNotColumn) const
 }
 
 
-NABoolean ValueId::isColumnWithNonNullDefault() const{
+NABoolean ValueId::isColumnWithNonNullNonCurrentDefault() const{
   NAColumn * nac = NULL;
   ItemExpr *ck = getItemExpr();
   if ( ck == NULL )
@@ -529,7 +529,7 @@ NABoolean ValueId::isColumnWithNonNullDefault() const{
   default:
       break;
   }
-  if (nac &&  nac->getDefaultValue() && strcmp(nac->getDefaultValue(),"NULL") != 0)
+  if (nac &&  nac->getDefaultValue() && nac->getDefaultClass()!=COM_NULL_DEFAULT && nac->getDefaultClass()!=COM_CURRENT_DEFAULT)
       return TRUE;
   else
       return FALSE;

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/b6d2a07f/core/sql/optimizer/ValueDesc.h
----------------------------------------------------------------------
diff --git a/core/sql/optimizer/ValueDesc.h b/core/sql/optimizer/ValueDesc.h
index f0fb753..b0e7300 100644
--- a/core/sql/optimizer/ValueDesc.h
+++ b/core/sql/optimizer/ValueDesc.h
@@ -195,8 +195,8 @@ public:
 
   // return TRUE if I am a ValueId associated with an Index Column, or
   // a base column , and I am a column with a default value that is not
-  // null.
-  NABoolean isColumnWithNonNullDefault() const;
+  // null or not Current.
+  NABoolean isColumnWithNonNullNonCurrentDefault() const;
 
   // ---------------------------------------------------------------------
   // change the ValueId's type to the given type


[3/5] incubator-trafodion git commit: fix EXPECTED056 to remove the workaround introduced with PR340

Posted by hz...@apache.org.
fix EXPECTED056 to remove the workaround introduced with PR340


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/11c58b6d
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/11c58b6d
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/11c58b6d

Branch: refs/heads/master
Commit: 11c58b6d9e4331f01236bd588397189f2b626352
Parents: b929e6e
Author: Eric Owhadi <er...@esgyn.com>
Authored: Fri Mar 4 21:45:18 2016 +0000
Committer: Eric Owhadi <er...@esgyn.com>
Committed: Fri Mar 4 21:45:18 2016 +0000

----------------------------------------------------------------------
 core/sql/regress/core/EXPECTED056.SB | 6 ------
 1 file changed, 6 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/11c58b6d/core/sql/regress/core/EXPECTED056.SB
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTED056.SB b/core/sql/regress/core/EXPECTED056.SB
index c1621af..4eb2f50 100755
--- a/core/sql/regress/core/EXPECTED056.SB
+++ b/core/sql/regress/core/EXPECTED056.SB
@@ -2026,9 +2026,6 @@ T056T56_COL            T056T56_COL2  T056T56_COL3  T056T56_COL4
 
 --- 1 row(s) selected.
 >>
->>cqd hbase_filter_preds 'on' ;
-
---- SQL operation complete.
 >>create table t056t57 (a1 numeric(2,2) signed default 0 not null);
 
 --- SQL operation complete.
@@ -2153,9 +2150,6 @@ A1
     .00
 
 --- 1 row(s) selected.
->>cqd hbase_filter_preds '2' ;
-
---- SQL operation complete.
 >>
 >>obey TEST056(tests4);
 >>obey test056(test4OLTops);


[2/5] incubator-trafodion git commit: Merge branch 'master' of github.com:apache/incubator-trafodion into jira1863

Posted by hz...@apache.org.
Merge branch 'master' of github.com:apache/incubator-trafodion into jira1863


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/b929e6e2
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/b929e6e2
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/b929e6e2

Branch: refs/heads/master
Commit: b929e6e20f66a5ce9f27f16ee90f4598519784bf
Parents: e9b02c2 e24ea17
Author: Eric Owhadi <er...@esgyn.com>
Authored: Fri Mar 4 14:50:36 2016 +0000
Committer: Eric Owhadi <er...@esgyn.com>
Committed: Fri Mar 4 14:50:36 2016 +0000

----------------------------------------------------------------------
 .../transactional/TransactionManager.java       |  22 +-
 .../transactional/TransactionalScanner.java     |  14 +-
 .../java/org/trafodion/dtm/HBaseTxClient.java   |  14 +-
 core/sql/arkcmp/CmpContext.cpp                  |  12 +-
 core/sql/arkcmp/CmpContext.h                    |  18 +
 core/sql/arkcmp/CmpStatement.cpp                |  19 +-
 core/sql/arkcmp/CmpStatement.h                  |   1 +
 core/sql/bin/SqlciErrors.txt                    |   1 +
 core/sql/cli/Context.cpp                        | 106 +++-
 core/sql/cli/Context.h                          |  13 +-
 core/sql/cli/ExSqlComp.cpp                      |   5 +
 core/sql/cli/Statement.cpp                      |  36 +-
 core/sql/comexe/CmpMessage.h                    |  23 +
 core/sql/common/ComSmallDefs.h                  |   9 +
 core/sql/common/DateTimeType.cpp                |   3 +-
 core/sql/executor/ExExeUtil.h                   |   1 +
 core/sql/executor/ExExeUtilGet.cpp              |  55 +-
 core/sql/executor/ExStats.cpp                   |  13 +-
 core/sql/executor/HBaseClient_JNI.cpp           |  16 +-
 core/sql/executor/HBaseClient_JNI.h             |   4 +-
 core/sql/executor/ex_ddl.cpp                    |   2 +
 core/sql/executor/ex_transaction.cpp            | 278 ++++------
 core/sql/executor/ex_transaction.h              |   2 +-
 core/sql/exp/ExpHbaseInterface.cpp              |  26 +-
 core/sql/exp/ExpHbaseInterface.h                |   4 +-
 core/sql/generator/GenRelExeUtil.cpp            |  31 +-
 core/sql/generator/GenRelMisc.cpp               |  13 +-
 core/sql/optimizer/NARoutine.cpp                |   2 +-
 core/sql/optimizer/NARoutineDB.h                |   5 +-
 core/sql/optimizer/NATable.cpp                  |  51 +-
 core/sql/optimizer/NATable.h                    |  10 +-
 core/sql/optimizer/RelExeUtil.cpp               | 155 +++---
 core/sql/optimizer/RelExeUtil.h                 |  30 +-
 core/sql/parser/SqlParserAux.cpp                |   2 +-
 core/sql/parser/StmtDDLAlter.cpp                |  11 +
 core/sql/parser/StmtDDLNode.cpp                 |  14 +
 core/sql/parser/StmtDDLNode.h                   |  15 +-
 core/sql/regress/core/DIFF116.KNOWN.SB          |  21 +
 core/sql/regress/core/EXPECTED056.SB            |  17 +-
 core/sql/regress/core/EXPECTED116               | 542 +++++++++++--------
 core/sql/regress/core/TEST056                   |   5 +-
 core/sql/regress/core/TEST116                   | 123 +++--
 core/sql/regress/executor/EXPECTED013.SB        |   1 +
 core/sql/regress/executor/EXPECTED140           |  40 +-
 core/sql/regress/fullstack2/EXPECTED062         |   3 +
 core/sql/regress/fullstack2/EXPECTED062.RELEASE |   3 +
 core/sql/regress/seabase/EXPECTED010            | 460 +++++++++-------
 core/sql/regress/seabase/EXPECTED011            |  13 +-
 core/sql/regress/seabase/EXPECTED016            |  35 +-
 core/sql/regress/tools/runregr_catman1.ksh      |   3 +-
 core/sql/regress/tools/runregr_charsets.ksh     |   3 +-
 core/sql/regress/tools/runregr_compGeneral.ksh  |   3 +-
 core/sql/regress/tools/runregr_core.ksh         |   3 +-
 core/sql/regress/tools/runregr_executor.ksh     |   3 +-
 core/sql/regress/tools/runregr_fullstack2.ksh   |   3 +-
 core/sql/regress/tools/runregr_hive.ksh         |   4 +-
 core/sql/regress/tools/runregr_privs1.ksh       |   3 +-
 core/sql/regress/tools/runregr_privs2.ksh       |   3 +-
 core/sql/regress/tools/runregr_qat.ksh          |   3 +-
 core/sql/regress/tools/runregr_seabase.ksh      |   4 +-
 core/sql/regress/tools/runregr_udr.ksh          |   9 +-
 core/sql/regress/tools/sbdefs                   |   1 +
 core/sql/sqlcomp/CmpDescribe.cpp                |   6 +-
 core/sql/sqlcomp/CmpSeabaseDDL.h                |  42 +-
 core/sql/sqlcomp/CmpSeabaseDDLcleanup.cpp       |  42 +-
 core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp        | 283 +++++++---
 core/sql/sqlcomp/CmpSeabaseDDLindex.cpp         |  98 +++-
 core/sql/sqlcomp/CmpSeabaseDDLrepos.cpp         |   2 +-
 core/sql/sqlcomp/CmpSeabaseDDLroutine.cpp       |   8 +-
 core/sql/sqlcomp/CmpSeabaseDDLschema.cpp        |  22 +-
 core/sql/sqlcomp/CmpSeabaseDDLtable.cpp         | 470 +++++++++-------
 core/sql/sqlcomp/CmpSeabaseDDLupgrade.cpp       |  14 +-
 core/sql/sqlcomp/CmpSeabaseDDLupgrade.h         |   6 +-
 core/sql/sqlcomp/CmpSeabaseDDLview.cpp          |  30 +-
 .../java/org/trafodion/sql/HBaseClient.java     |  37 +-
 core/sql/ustat/hs_globals.cpp                   |  20 -
 .../src/asciidoc/_chapters/about.adoc           |   1 +
 .../src/asciidoc/_chapters/odb.adoc             |  14 +-
 .../src/asciidoc/_chapters/about.adoc           |   1 +
 docs/cqd_reference/pom.xml                      | 291 ++++++++++
 .../src/asciidoc/_chapters/about.adoc           | 179 ++++++
 .../src/asciidoc/_chapters/histograms.adoc      | 215 ++++++++
 .../src/asciidoc/_chapters/introduction.adoc    | 111 ++++
 .../_chapters/operational_controls.adoc         | 110 ++++
 .../src/asciidoc/_chapters/query_plans.adoc     | 515 ++++++++++++++++++
 .../asciidoc/_chapters/runtime_controls.adoc    |  83 +++
 .../src/asciidoc/_chapters/schema_controls.adoc |  49 ++
 .../src/asciidoc/_chapters/transactions.adoc    |  94 ++++
 .../src/asciidoc/_chapters/update_stats.adoc    |  92 ++++
 docs/cqd_reference/src/asciidoc/index.adoc      |  69 +++
 docs/load_transform/pom.xml                     | 289 ++++++++++
 .../src/asciidoc/_chapters/about.adoc           | 186 +++++++
 .../src/asciidoc/_chapters/bulk_load.adoc       | 291 ++++++++++
 .../src/asciidoc/_chapters/bulk_unload.adoc     |  73 +++
 .../src/asciidoc/_chapters/introduction.adoc    | 117 ++++
 .../src/asciidoc/_chapters/monitor.adoc         |  77 +++
 .../src/asciidoc/_chapters/tables_indexes.adoc  | 208 +++++++
 .../src/asciidoc/_chapters/trickle_load.adoc    | 496 +++++++++++++++++
 .../src/asciidoc/_chapters/troubleshoot.adoc    | 159 ++++++
 docs/load_transform/src/asciidoc/index.adoc     |  68 +++
 .../src/asciidoc/_chapters/about.adoc           |   3 +
 docs/odb_user/src/asciidoc/_chapters/about.adoc |   3 +
 docs/odb_user/src/asciidoc/_chapters/load.adoc  |  48 +-
 .../src/asciidoc/_chapters/about.adoc           |   2 +
 .../src/asciidoc/_chapters/about.adoc           |   2 +
 .../src/asciidoc/_chapters/cqds.adoc            |  20 -
 .../src/asciidoc/_chapters/sql_statements.adoc  |   8 +-
 .../src/asciidoc/_chapters/sql_utilities.adoc   | 117 +++-
 docs/src/site/markdown/download.md              |  18 +-
 docs/src/site/markdown/index.md                 |  12 +-
 docs/src/site/markdown/logo.md                  |  56 ++
 docs/src/site/resources/css/site.css            |  18 +-
 .../site/resources/images/carousel/scale.png    | Bin 93783 -> 127571 bytes
 .../site/resources/images/carousel/stack.png    | Bin 102472 -> 170554 bytes
 .../resources/images/logos/pb-Trafodion.png     | Bin 0 -> 49089 bytes
 .../resources/images/logos/pb-trafodion.jpg     | Bin 0 -> 80904 bytes
 .../images/logos/trafodion-dragon-large.jpg     | Bin 0 -> 50000 bytes
 .../images/logos/trafodion-dragon-large.png     | Bin 0 -> 20595 bytes
 .../resources/images/logos/trafodion-dragon.png | Bin 0 -> 12786 bytes
 .../resources/images/logos/trafodion-logo.jpg   | Bin 18953 -> 58953 bytes
 docs/src/site/site.xml                          |  20 +-
 121 files changed, 6190 insertions(+), 1349 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/b929e6e2/core/sql/regress/core/TEST056
----------------------------------------------------------------------