Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Duplicate
-
Affects Version/s: 1.5.2
-
Fix Version/s: N/A
-
Component/s: N/A
-
Labels:None
-
Sprint:2021-3
Description
Recieved this error
The storage engine for the table doesn't support IDB-1001: Function 'convert_tz' isn't supported.
CREATE or replace ALGORITHM=UNDEFINED VIEW vrfps AS
select id,substr(name,1,100) as name,substr(notes,1,100) as notes,convert_tz(created_at,'UTC','America/New_York') AS created_at,convert_tz(updated_at,'UTC','$cust_tz') AS updated_at, substr(bill_to,1,16) as bill_to from rfps where deleted_at is null;
> select * from vrfps;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1001: Function 'convert_tz' isn't supported.
sql statement in following commands
Attachments
Issue Links
- duplicates
-
MCOL-1356 CONVERT_TZ Throws "IDB-1815: Unknown Error" in UPDATE or SELECT statement
-
- Closed
-