prepared statements - error when i run it in a prepare vs raw

Report by customer. This is probably not supported, but might be a BUG. Opening BUG to determine which and provided details back to the customer

From Customer

I am finding something strange when running some prepared statements that i plan to use in a stored procedure. Can you help me understand the error? below is my script that i am running. the only thing that has an error is at the end PREPARE insert_stmts FROM @insert_stmt;

The thing that is confusing me is that the output of select @insert_stmt is valid. I take the result and can run it and it works. So why does it error when i run it in a prepare vs raw? I know this is alot to look through so if we need to schedule a call for next week to go over this then let me know.

Error:

1178 - The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported.