You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by li...@apache.org on 2018/07/30 12:36:25 UTC
[2/5] trafodion git commit: add regress test for sys_guid
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 <ov...@sina.com>
Authored: Sat Jul 21 11:33:19 2018 -0400
Committer: Liu Ming <ov...@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;
------------------------------------------------------------------------