Github user zellerh commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1444#discussion_r169390910
--- Diff: core/sql/regress/executor/TEST002 ---
@@ -1188,6 +1188,32 @@ select * from regexp_test where c1 regexp
'^(25[0-5]|2[0-4][0-9]|[0-1]{1}[0-9]{2
select * from regexp_test where c1 regexp '(ä¸ææµè¯)';
select * from regexp_test where c1 regexp '[^\';
drop table regexp_test;
+
+--create table have 1K rows
+create table T002T1K (uniq int not null,
+ c1K int, c100 int,
+ c10 int, c1 int, c0 int )
+ STORE BY (uniq)
+ ATTRIBUTES ALIGNED FORMAT
+ SALT USING 8 PARTITIONS
+ ;
+
+upsert using load into T002T1K select
+0 + (1000 * x10) + (100 * x1) + (10 * x1) + (1 * x01),
+0 + (100 * x10) + (10 * x1) + (1 * x01),
+0 + (10 * x1) + (1 * x01),
+0 + (1 * x01),
+0,
+X01
+from (values(0)) t
+transpose 0,1,2,3,4,5,6,7,8,9 as x10
+transpose 0,1,2,3,4,5,6,7,8,9 as x1
+transpose 0,1,2,3,4,5,6,7,8,9 as X01;
+
+select sleep(5) from dual;
+select 'unixtimestamp',unix_timestamp() from dual;
+select 'uuidrow', uuid(), unix_timestamp() from T002T1K;
--- End diff --
If you want to ensure that we see different uuids and not the same one
repeated, you could add a query select count(distinct uuid()) from T002T1K.
---
