[MCOL-3634] Sleep function not supported in ColumnStore Created: 2019-11-28  Updated: 2023-03-06  Resolved: 2023-03-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.4
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: Gagan Goel (Inactive) Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None

Issue Links:
PartOf
is part of MCOL-3600 Create bit_count(), charset(), unhex(... Closed
Relates
relates to MCOL-3924 Error message points to wrong function Closed

 Description   

The sleep() function is not yet implemented in CS:

MariaDB [test]> create table c1 (a int)engine=columnstore;
 
Query OK, 0 rows affected (0.286 sec)
 
 
 
MariaDB [test]> insert into c1 values (1), (2), (3);
 
Query OK, 3 rows affected (0.244 sec)
 
Records: 3  Duplicates: 0  Warnings: 0
 
 
 
MariaDB [test]> select sleep(a) from c1;
 
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1001: Function 'sleep' can only be used in the outermost select or order by clause and cannot be used in conjunction with an aggregate function.



 Comments   
Comment by Todd Stoffel (Inactive) [ 2023-03-06 ]

This ticket was opened prior to convergence with the server. It may have been rendered obsolete. If this issue still exists in a modern version, please open a new request.

Generated at Thu Feb 08 02:44:17 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.