Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
1.5.2
-
None
-
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