add regress test for sys_guid
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/a748fbb9 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/a748fbb9 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/a748fbb9 Branch: refs/heads/master Commit: a748fbb91c131d9c257886aba59d8042d9f7215c Parents: 6ad70a3 Author: Liu Ming <ovis_p...@sina.com> Authored: Sat Jul 21 11:33:19 2018 -0400 Committer: Liu Ming <ovis_p...@sina.com> Committed: Sat Jul 21 11:33:19 2018 -0400 ---------------------------------------------------------------------- core/sql/regress/executor/EXPECTED002.SB | 8 ++++++++ core/sql/regress/executor/FILTER002 | 1 - core/sql/regress/executor/TEST002 | 1 + 3 files changed, 9 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/a748fbb9/core/sql/regress/executor/EXPECTED002.SB ---------------------------------------------------------------------- diff --git a/core/sql/regress/executor/EXPECTED002.SB b/core/sql/regress/executor/EXPECTED002.SB index cb581bd..4ad0058 100644 --- a/core/sql/regress/executor/EXPECTED002.SB +++ b/core/sql/regress/executor/EXPECTED002.SB @@ -6910,6 +6910,14 @@ good 1000 --- 1 row(s) selected. +>>select distinct(count(sys_guid())) from T002T1K; + +(EXPR) +---------- + + 1000 + +--- 1 row(s) selected. >>drop table t002timert; --- SQL operation complete. http://git-wip-us.apache.org/repos/asf/trafodion/blob/a748fbb9/core/sql/regress/executor/FILTER002 ---------------------------------------------------------------------- diff --git a/core/sql/regress/executor/FILTER002 b/core/sql/regress/executor/FILTER002 index 1b5f042..1e37216 100755 --- a/core/sql/regress/executor/FILTER002 +++ b/core/sql/regress/executor/FILTER002 @@ -31,7 +31,6 @@ if [ "$fil" = "" ]; then fi sed " s/\.[ ]*\*\*\*/\. \*\*\*/g -s/^uuidrow.*$/uuid/ s/^sleeptimetest002.*$/good/ s/^unixtimestamp.*$/unixtimestamp/ " $fil http://git-wip-us.apache.org/repos/asf/trafodion/blob/a748fbb9/core/sql/regress/executor/TEST002 ---------------------------------------------------------------------- diff --git a/core/sql/regress/executor/TEST002 b/core/sql/regress/executor/TEST002 index d66b483..69c6866 100755 --- a/core/sql/regress/executor/TEST002 +++ b/core/sql/regress/executor/TEST002 @@ -1218,6 +1218,7 @@ insert into t002timert select 1, sleep(5) , unix_timestamp() from t002tmp1; insert into t002timert select 2, sleep(5) , unix_timestamp() from t002tmp1; select 'sleeptimetest002', di from (select ( max(c2) - min(c2)) as di from t002timert ) where di between 5 and 9; select distinct(count(uuid())) from T002T1K; +select distinct(count(sys_guid())) from T002T1K; drop table t002timert; drop table t002tmp1; ------------------------------------------------------------------------