[
https://issues.apache.org/jira/browse/TRAFODION-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16370282#comment-16370282
]
ASF GitHub Bot commented on TRAFODION-2954:
-------------------------------------------
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.
> support sleep/unix_timestamp/uuid/uuid_short of MySQL
> -----------------------------------------------------
>
> Key: TRAFODION-2954
> URL: https://issues.apache.org/jira/browse/TRAFODION-2954
> Project: Apache Trafodion
> Issue Type: Sub-task
> Reporter: liu ming
> Assignee: liu ming
> Priority: Major
>
> support these MySQL functions:
> uuid
> uuid_short
> unix_timestamp
> sleep
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
