[3/4] trafodion git commit: various fixes

2018-04-04 Thread ansharma 
various fixes

-- JIRA 2980 support for INSTR function.
   INSTR(source_string, pattern, startPos, occurrence)
   Search for pattern in source_string.
   Start at startPos'th character. Optional, default 1
   Return occurrence'th occurrence. Optional, default 1
   (exp/exp_function.cpp/h, exp/ExpPCodeClauseGen.cpp,
generator/GenItemFunc.cpp, optimizer/BindItemExpr.cpp, ItemExpr.cpp,
optimizer/ItemFunc.h, SynthType.cpp, parser/sqlparser.y)

-- hivemd returns precision, scale, display_datatype
  (comexe/ComTdbExeUtil.h, common/BaseTypes.cpp,NAType.cpp/h,
   executor/ExExeUtilGet.cpp, ExExeUtil.h)

-- hive decimal type is treated as sql NUMERIC for performance.
  (common/NAType.cpp)

-- hive select from hivemd with prepare and multiple executes work
  (executor/ExExeUtilGet.cpp)

-- fix for crash in sql buffer pool when allocating large size rows.
   (executor/sql_buffer.cpp)

-- SIGN(op) now returns error if op is not numeric
   (BindItemExpr.cpp)

-- strings of length zero are no longer cached. Caching them causes problem
   during backpatching.
   (optimizer/ItemCache.cpp)

--- compile time predicates on constants were not being created correctly
in some cases. That has been fixed.
   (ValueDesc.cpp)

-- trim now supported on scaled numeric, float and bignum datatypes
   (BindItemExpr.cpp)

-- CASE is now supported on scaled numerics, float, bignum
   (BindItemExpr.cpp)

-- char_length is now supported on numerics
   (ItemFunc.h, BindItemExpr.cpp)

-- DAYOFMONTH now allowed only on datetime datatypes
   (common/OperTypeEnum.h, sqlparser.y, BindItemExpr.cpp, ItemExpr.cpp)

-- TO_TIME now allowed only on 'datetime with time' or character datatypes.
   (BindItemExpr.cpp, bin/SqlciErrors.txt)

-- updated expected file for compGeneral/test042


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

Branch: refs/heads/master
Commit: 43984c46cc9ea2cfc0e816080e93e0dc7e61369a
Parents: 659e8ec
Author: Anoop Sharma 
Authored: Mon Apr 2 16:40:16 2018 +
Committer: Anoop Sharma 
Committed: Mon Apr 2 16:40:16 2018 +

--
 core/sql/bin/SqlciErrors.txt|   2 +-
 core/sql/comexe/ComTdbExeUtil.h |  32 +-
 core/sql/common/BaseTypes.cpp   |   3 +-
 core/sql/common/NAType.cpp  |  12 +-
 core/sql/common/NAType.h|   3 +-
 core/sql/common/OperTypeEnum.h  |   1 +
 core/sql/executor/ExExeUtil.h   |  12 +-
 core/sql/executor/ExExeUtilGet.cpp  | 121 +++--
 core/sql/executor/sql_buffer.cpp|   3 +-
 core/sql/exp/ExpPCodeClauseGen.cpp  |   4 +
 core/sql/exp/exp_function.cpp   | 249 +++---
 core/sql/exp/exp_function.h |  30 +-
 core/sql/generator/GenItemFunc.cpp  |   6 +-
 core/sql/optimizer/BindItemExpr.cpp | 300 +---
 core/sql/optimizer/ItemCache.cpp|   8 +
 core/sql/optimizer/ItemExpr.cpp |   7 +-
 core/sql/optimizer/ItemFunc.h   |  12 +-
 core/sql/optimizer/SynthType.cpp|  41 +-
 core/sql/optimizer/ValueDesc.cpp|  57 ++-
 core/sql/parser/sqlparser.y |  39 +-
 core/sql/regress/compGeneral/EXPECTED006.SB |  10 +-
 core/sql/regress/compGeneral/EXPECTED042| 139 +++---
 core/sql/regress/core/EXPECTED038.LINUX |  26 +-
 core/sql/regress/executor/EXPECTED012   | 598 ++-
 core/sql/regress/executor/TEST012   | 103 +++-
 core/sql/regress/hive/EXPECTED005   | 112 ++---
 core/sql/regress/seabase/EXPECTED002| 288 ++-
 core/sql/regress/seabase/EXPECTED030|  14 +
 core/sql/regress/seabase/EXPECTED031|  44 +-
 core/sql/regress/seabase/TEST002|  41 +-
 core/sql/regress/seabase/TEST030|   4 +
 core/sql/regress/seabase/TEST031|  10 +
 32 files changed, 1758 insertions(+), 573 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/trafodion/blob/43984c46/core/sql/bin/SqlciErrors.txt
--
diff --git a/core/sql/bin/SqlciErrors.txt b/core/sql/bin/SqlciErrors.txt
index e66e170..981dabc 100644
--- a/core/sql/bin/SqlciErrors.txt
+++ b/core/sql/bin/SqlciErrors.txt
@@ -1047,7 +1047,7 @@ $1~String1 
 3412 Z 9 BEGINNER MAJOR DBADMIN IDENTITY column $0~ColumnName must be 
the primary key or must have a unique index on it.
 3413 Z 9 BEGINNER MAJOR DBADMIN The NOT NULL constraint on IDENTITY 
column $0~ColumnName must be NOT DROPPABLE.
 3414 Z 9 BEGINNER MAJOR

[1/4] trafodion git commit: various fixes

2018-04-04 Thread ansharma 
Repository: trafodion
Updated Branches:
  refs/heads/master 3edf1f6c0 -> 81640f930


http://git-wip-us.apache.org/repos/asf/trafodion/blob/43984c46/core/sql/regress/seabase/EXPECTED002
--
diff --git a/core/sql/regress/seabase/EXPECTED002 
b/core/sql/regress/seabase/EXPECTED002
index 563e322..286b157 100644
--- a/core/sql/regress/seabase/EXPECTED002
+++ b/core/sql/regress/seabase/EXPECTED002
@@ -76,9 +76,9 @@ Stats Summary
 Stats Details
 =
 
-  RegionServer:   edev06:35801
+  RegionServer:   ansharma-4:49525
   RegionNum:  1
-  RegionName: TRAFODION.T002SCH.T002T2/1503018204323
+  RegionName: TRAFODION.T002SCH.T002T2/1521232475166
   NumStores:  2
   NumStoreFiles:  0
   UncompressedSize:   0 (less than 1MB)
@@ -87,9 +87,9 @@ Stats Details
   ReadRequestsCount:  0
   WriteRequestsCount: 0
 
-  RegionServer:   edev06:35801
+  RegionServer:   ansharma-4:49525
   RegionNum:  2
-  RegionName: TRAFODION.T002SCH.T002T2/1503018204323
+  RegionName: TRAFODION.T002SCH.T002T2/1521232475166
   NumStores:  2
   NumStoreFiles:  0
   UncompressedSize:   0 (less than 1MB)
@@ -98,9 +98,9 @@ Stats Details
   ReadRequestsCount:  1
   WriteRequestsCount: 1
 
-  RegionServer:   edev06:35801
+  RegionServer:   ansharma-4:49525
   RegionNum:  3
-  RegionName: TRAFODION.T002SCH.T002T2/1503018204323
+  RegionName: TRAFODION.T002SCH.T002T2/1521232475166
   NumStores:  2
   NumStoreFiles:  0
   UncompressedSize:   0 (less than 1MB)
@@ -109,9 +109,9 @@ Stats Details
   ReadRequestsCount:  0
   WriteRequestsCount: 0
 
-  RegionServer:   edev06:35801
+  RegionServer:   ansharma-4:49525
   RegionNum:  4
-  RegionName: TRAFODION.T002SCH.T002T2/1503018204323
+  RegionName: TRAFODION.T002SCH.T002T2/1521232475166
   NumStores:  2
   NumStoreFiles:  0
   UncompressedSize:   0 (less than 1MB)
@@ -145,9 +145,9 @@ Stats Summary
 Stats Details
 =
 
-  RegionServer:   edev06:35801
+  RegionServer:   ansharma-4:49525
   RegionNum:  1
-  RegionName: TRAFODION.T002SCH.T002T2/1503018204323
+  RegionName: TRAFODION.T002SCH.T002T2/1521232475166
   NumStores:  2
   NumStoreFiles:  0
   UncompressedSize:   0 (less than 1MB)
@@ -156,9 +156,9 @@ Stats Details
   ReadRequestsCount:  0
   WriteRequestsCount: 0
 
-  RegionServer:   edev06:35801
+  RegionServer:   ansharma-4:49525
   RegionNum:  2
-  RegionName: TRAFODION.T002SCH.T002T2/1503018204323
+  RegionName: TRAFODION.T002SCH.T002T2/1521232475166
   NumStores:  2
   NumStoreFiles:  0
   UncompressedSize:   0 (less than 1MB)
@@ -167,9 +167,9 @@ Stats Details
   ReadRequestsCount:  0
   WriteRequestsCount: 0
 
-  RegionServer:   edev06:35801
+  RegionServer:   ansharma-4:49525
   RegionNum:  3
-  RegionName: TRAFODION.T002SCH.T002T2/1503018204323
+  RegionName: TRAFODION.T002SCH.T002T2/1521232475166
   NumStores:  2
   NumStoreFiles:  0
   UncompressedSize:   0 (less than 1MB)
@@ -178,9 +178,9 @@ Stats Details
   ReadRequestsCount:  0
   WriteRequestsCount: 0
 
-  RegionServer:   edev06:35801
+  RegionServer:   ansharma-4:49525
   RegionNum:  4
-  RegionName: TRAFODION.T002SCH.T002T2/1503018204323
+  RegionName: TRAFODION.T002SCH.T002T2/1521232475166
   NumStores:  2
   NumStoreFiles:  0
   UncompressedSize:   0 (less than 1MB)
@@ -218,7 +218,7 @@ AB
 >>invoke table(region stats ());
 
 -- Definition of Trafodion table TRAFODION.T002SCH.EXE_UTIL_REGION_STATS__
--- Definition current  Fri Aug 18 01:04:11 2017
+-- Definition current  Fri Mar 16 20:35:17 2018
 
   (
 CATALOG_NAME CHAR(256 BYTES) CHARACTER SET UTF8 COLLATE
@@ -245,7 +245,7 @@ AB
 >>invoke table(region stats (t002t1));
 
 -- Definition of Trafodion table TRAFODION.T002SCH.EXE_UTIL_REGION_STATS__
--- Definition current  Fri Aug 18 01:04:12 2017
+-- Definition current  Fri Mar 16 20:35:18 2018
 
   (
 CATALOG_NAME CHAR(256 BYTES) CHARACTER SET UTF8 COLLATE
@@ -280,7 +280,7 @@ AB
 (EXPR)REGION_NUM   
 REGION_NAME





   NUM_STORES   NUM_STORE_FILES  
STORE_FILE_UNCOMP_SIZE

[2/4] trafodion git commit: various fixes

2018-04-04 Thread ansharma 
http://git-wip-us.apache.org/repos/asf/trafodion/blob/43984c46/core/sql/regress/compGeneral/EXPECTED042
--
diff --git a/core/sql/regress/compGeneral/EXPECTED042 
b/core/sql/regress/compGeneral/EXPECTED042
index e766c48..1cd8b5f 100644
--- a/core/sql/regress/compGeneral/EXPECTED042
+++ b/core/sql/regress/compGeneral/EXPECTED042
@@ -1,9 +1,9 @@
 >>showstats for table t042_orderline on ol_o_id detail;
 
 Detailed Histogram data for Table TRAFODION.ORDERENTRY.T042_ORDERLINE
-Table ID: 1700229370398217975
+Table ID: 8379103414832633643
 
-Hist ID:767276153
+Hist ID:1428267625
 Column(s):  OL_O_ID
 Total Rows: 10
 Total UEC:  4
@@ -1725,10 +1725,6 @@ SQL query=select '0123456789' from t042_t1;
 HQC key=SELECT #NP# FROM T042_T1 ; 
 
 HQC::AddEntry(): passed
-SQL query=select '' from t042_t1;
-HQC key=SELECT #NP# FROM T042_T1 ; 
-
-HQC::AddEntry(): passed
 SQL query=select b from t042_t1 where a like 'BOO_%';
 HQC key=SELECT B FROM T042_T1 WHERE A LIKE #NP# ; 
 
@@ -1763,18 +1759,18 @@ HQC key=SELECT T . VARCHAR0_UNIQ AS T_VARCHAR0_UNIQ , T 
. CHAR2_2 AS T_CHAR2_2 ,
 >>-- test compile time
 >>
 >>sh more /proc/loadavg  | cut -d' ' -f 1-3 | sed -e 's/^/System load: /' >> 
 >>LOG042;
-System load: 0.37 0.36 0.74
+System load: 1.39 2.74 2.71
 >>sh grep "model name" /proc/cpuinfo | head -1 | cut -d '@' -f 2 | sed -e 
 >>'s/^/CPU frequency: /' >> LOG042;
-CPU frequency:  2.40GHz
+CPU frequency: model name  : Intel Core Processor (Haswell)
 >>set statistics on;
 >>prepare xx from select * from t042_orderline where ol_o_id = 1 ;
 
 --- SQL command prepared.
 
-Start Time 2017/01/31 17:26:48.806392
-End Time   2017/01/31 17:26:48.808005
-Elapsed Time  00:00:00.001613
-Compile Time  00:00:00.001613
+Start Time 2018/03/22 01:04:54.921227
+End Time   2018/03/22 01:04:54.924930
+Elapsed Time  00:00:00.003703
+Compile Time  00:00:00.003703
 Execution Time00:00:00.00
 
 
@@ -1805,10 +1801,10 @@ HQC key=SELECT * FROM T042_ORDERLINE WHERE OL_O_ID = 
#NP# ;
 
 --- SQL command prepared.
 
-Start Time 2017/01/31 17:26:48.970491
-End Time   2017/01/31 17:26:48.972007
-Elapsed Time  00:00:00.001516
-Compile Time  00:00:00.001516
+Start Time 2018/03/22 01:04:55.115150
+End Time   2018/03/22 01:04:55.117539
+Elapsed Time  00:00:00.002389
+Compile Time  00:00:00.002389
 Execution Time00:00:00.00
 
 
@@ -1841,7 +1837,7 @@ HQC key=SELECT * FROM T042_ORDERLINE WHERE OL_O_ID = #NP# 
;
 NUM_ENTRIES  TEXT_ENTRIES  NUM_PLANS 
 ---    --
 
- 6510  65
+ 64 9  64
 
 --- 1 row(s) selected.
 >>select num_entries, text_entries, num_plans from table(querycache('meta', 
 >>'local'));
@@ -1849,7 +1845,7 @@ NUM_ENTRIES  TEXT_ENTRIES  NUM_PLANS
 NUM_ENTRIES  TEXT_ENTRIES  NUM_PLANS 
 ---    --
 
- 31 0  31
+ 22 0  22
   2 0   2
 
 --- 2 row(s) selected.
@@ -1861,8 +1857,8 @@ NUM_ENTRIES  TEXT_ENTRIES  NUM_PLANS
 NUM_ENTRIES  TEXT_ENTRIES  NUM_PLANS 
 ---    --
 
- 6510  65
- 31 0  31
+ 64 9  64
+ 22 0  22
   2 0   2
 
 --- 3 row(s) selected.
@@ -1875,8 +1871,6 @@ NUM_ENTRIES  TEXT_ENTRIES  NUM_PLANS
 NUM_HITSNUM_PARAMS  (EXPR)  (EXPR)
 --  --  --  

 
- 0   0  QUERY:  select '' from t042_t1;

 
- 0   0  QUERY:  select '' from t042_t1;

 
  0   0  QUERY:  select '0123456789' from t042_t1;  

 
  0   0  QUERY:  select * from t042_BTA1P006;

[4/4] trafodion git commit: PR-1502 Various fixes, details in pull request

2018-04-04 Thread ansharma 
PR-1502 Various fixes, details in pull request


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

Branch: refs/heads/master
Commit: 81640f93068fc9803cc7c34a1e6a14e6232fc12e
Parents: 3edf1f6 43984c4
Author: Anoop Sharma 
Authored: Thu Apr 5 00:09:38 2018 +
Committer: Anoop Sharma 
Committed: Thu Apr 5 00:09:38 2018 +

--
 core/sql/bin/SqlciErrors.txt|   2 +-
 core/sql/comexe/ComTdbExeUtil.h |  32 +-
 core/sql/common/BaseTypes.cpp   |   3 +-
 core/sql/common/NAType.cpp  |  12 +-
 core/sql/common/NAType.h|   3 +-
 core/sql/common/OperTypeEnum.h  |   1 +
 core/sql/executor/ExExeUtil.h   |  12 +-
 core/sql/executor/ExExeUtilGet.cpp  | 121 +++--
 core/sql/executor/sql_buffer.cpp|   3 +-
 core/sql/exp/ExpPCodeClauseGen.cpp  |   4 +
 core/sql/exp/exp_function.cpp   | 249 +++---
 core/sql/exp/exp_function.h |  30 +-
 core/sql/generator/GenItemFunc.cpp  |   6 +-
 core/sql/optimizer/BindItemExpr.cpp | 300 +---
 core/sql/optimizer/ItemCache.cpp|   8 +
 core/sql/optimizer/ItemExpr.cpp |   7 +-
 core/sql/optimizer/ItemFunc.h   |  12 +-
 core/sql/optimizer/SynthType.cpp|  41 +-
 core/sql/optimizer/ValueDesc.cpp|  57 ++-
 core/sql/parser/sqlparser.y |  39 +-
 core/sql/regress/compGeneral/EXPECTED006.SB |  10 +-
 core/sql/regress/compGeneral/EXPECTED042| 139 +++---
 core/sql/regress/core/EXPECTED038.LINUX |  26 +-
 core/sql/regress/executor/EXPECTED012   | 598 ++-
 core/sql/regress/executor/TEST012   | 103 +++-
 core/sql/regress/hive/EXPECTED005   | 112 ++---
 core/sql/regress/seabase/EXPECTED002| 288 ++-
 core/sql/regress/seabase/EXPECTED030|  14 +
 core/sql/regress/seabase/EXPECTED031|  44 +-
 core/sql/regress/seabase/TEST002|  41 +-
 core/sql/regress/seabase/TEST030|   4 +
 core/sql/regress/seabase/TEST031|  10 +
 32 files changed, 1758 insertions(+), 573 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/trafodion/blob/81640f93/core/sql/parser/sqlparser.y
--

[2/5] trafodion git commit: make UUID non-reserved key word, one can create table name uuid

2018-04-04 Thread liuming 
make UUID non-reserved key word, one can create table name uuid


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

Branch: refs/heads/master
Commit: 4e70418b6849ecf668a43c6f71c3c66eb30bd176
Parents: e355fd3
Author: Liu Ming 
Authored: Wed Mar 21 21:45:20 2018 +
Committer: Liu Ming 
Committed: Wed Mar 21 21:45:20 2018 +

--
 core/sql/parser/sqlparser.y | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)
--


http://git-wip-us.apache.org/repos/asf/trafodion/blob/4e70418b/core/sql/parser/sqlparser.y
--
diff --git a/core/sql/parser/sqlparser.y b/core/sql/parser/sqlparser.y
index 69df367..7c33f42 100755
--- a/core/sql/parser/sqlparser.y
+++ b/core/sql/parser/sqlparser.y
@@ -34336,7 +34336,7 @@ nonreserved_func_word:  TOK_ABS
   | TOK_UCASE
//  | TOK_UPSERT
   | TOK_UNIQUE_ID
-   //  | TOK_UUID
+  | TOK_UUID
  | TOK_USERNAMEINTTOEXT
   | TOK_VARIANCE
   | TOK_WEEK

[5/5] trafodion git commit: merge [TRAFODION-2999]

2018-04-04 Thread liuming 
merge [TRAFODION-2999] 


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

Branch: refs/heads/master
Commit: 3edf1f6c026b97595c0c8f884cf6ee966da787ee
Parents: 659e8ec c41cb45
Author: Liu Ming 
Authored: Wed Apr 4 05:14:51 2018 +
Committer: Liu Ming 
Committed: Wed Apr 4 05:14:51 2018 +

--
 core/sql/common/ComResWords.cpp | 2 --
 core/sql/parser/sqlparser.y | 2 +-
 2 files changed, 1 insertion(+), 3 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/trafodion/blob/3edf1f6c/core/sql/parser/sqlparser.y
--

[1/5] trafodion git commit: [TRAFODION-2999] make UUID non reserved keyword

2018-04-04 Thread liuming 
Repository: trafodion
Updated Branches:
  refs/heads/master 659e8ec9f -> 3edf1f6c0


[TRAFODION-2999] make UUID non reserved keyword


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

Branch: refs/heads/master
Commit: e355fd36ce9ddf8214b953ee8153d624dae06999
Parents: 75c7b39
Author: Liu Ming 
Authored: Mon Mar 19 22:17:20 2018 +
Committer: Liu Ming 
Committed: Mon Mar 19 22:17:20 2018 +

--
 core/sql/common/ComResWords.cpp | 2 --
 1 file changed, 2 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/trafodion/blob/e355fd36/core/sql/common/ComResWords.cpp
--
diff --git a/core/sql/common/ComResWords.cpp b/core/sql/common/ComResWords.cpp
index 64e7352..8796f6b 100644
--- a/core/sql/common/ComResWords.cpp
+++ b/core/sql/common/ComResWords.cpp
@@ -395,8 +395,6 @@ const ComResWord ComResWords::resWords_[] = {
   ComResWord("USAGE",ANS_|RESWORD_),
   ComResWord("USER", ANS_|RESWORD_),
   ComResWord("USING",ANS_|RESWORD_),
-  ComResWord("UUID",ANS_|RESWORD_),
-  ComResWord("VALUE",ANS_|RESWORD_),
   ComResWord("VALUES",   ANS_|RESWORD_|MPWORD_),
   ComResWord("VARCHAR",  ANS_|RESWORD_),
   ComResWord("VARIABLE", POTANS_|RESWORD_),

[3/5] trafodion git commit: make VALUE reserved again

2018-04-04 Thread liuming 
make VALUE reserved again


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

Branch: refs/heads/master
Commit: a3fe11eff84ff89e3ba3257e10777df21f474c1d
Parents: 4e70418
Author: Liu Ming 
Authored: Mon Mar 26 22:45:00 2018 +
Committer: Liu Ming 
Committed: Mon Mar 26 22:45:00 2018 +

--
 core/sql/common/ComResWords.cpp | 1 +
 1 file changed, 1 insertion(+)
--


http://git-wip-us.apache.org/repos/asf/trafodion/blob/a3fe11ef/core/sql/common/ComResWords.cpp
--
diff --git a/core/sql/common/ComResWords.cpp b/core/sql/common/ComResWords.cpp
index 8796f6b..0c9f9c5 100644
--- a/core/sql/common/ComResWords.cpp
+++ b/core/sql/common/ComResWords.cpp
@@ -395,6 +395,7 @@ const ComResWord ComResWords::resWords_[] = {
   ComResWord("USAGE",ANS_|RESWORD_),
   ComResWord("USER", ANS_|RESWORD_),
   ComResWord("USING",ANS_|RESWORD_),
+  ComResWord("VALUE",   ANS_|RESWORD_|MPWORD_),
   ComResWord("VALUES",   ANS_|RESWORD_|MPWORD_),
   ComResWord("VARCHAR",  ANS_|RESWORD_),
   ComResWord("VARIABLE", POTANS_|RESWORD_),

[4/5] trafodion git commit: remove VALUE as reserved word

2018-04-04 Thread liuming 
remove VALUE as reserved word


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

Branch: refs/heads/master
Commit: c41cb45f476848abafcf24da47ae3f1017da5ca8
Parents: a3fe11e
Author: Liu Ming 
Authored: Tue Apr 3 19:24:03 2018 +
Committer: Liu Ming 
Committed: Tue Apr 3 19:24:03 2018 +

--
 core/sql/common/ComResWords.cpp | 1 -
 1 file changed, 1 deletion(-)
--


http://git-wip-us.apache.org/repos/asf/trafodion/blob/c41cb45f/core/sql/common/ComResWords.cpp
--
diff --git a/core/sql/common/ComResWords.cpp b/core/sql/common/ComResWords.cpp
index 0c9f9c5..8796f6b 100644
--- a/core/sql/common/ComResWords.cpp
+++ b/core/sql/common/ComResWords.cpp
@@ -395,7 +395,6 @@ const ComResWord ComResWords::resWords_[] = {
   ComResWord("USAGE",ANS_|RESWORD_),
   ComResWord("USER", ANS_|RESWORD_),
   ComResWord("USING",ANS_|RESWORD_),
-  ComResWord("VALUE",   ANS_|RESWORD_|MPWORD_),
   ComResWord("VALUES",   ANS_|RESWORD_|MPWORD_),
   ComResWord("VARCHAR",  ANS_|RESWORD_),
   ComResWord("VARIABLE", POTANS_|RESWORD_),