[MCOL-3545] prepared statements - error when i run it in a prepare vs raw Created: 2019-10-07  Updated: 2023-03-06  Resolved: 2023-03-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.2.5
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: David Hill (Inactive) Assignee: Unassigned
Resolution: Won't Do Votes: 1
Labels: None

Attachments: File storedProc.sql     File storedProcSetup.sql    

 Description   

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.



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

This ticket was created prior to convergence with the server and may be obsolete. If you find this issue still exists in a modern version, please open a new ticket.

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