[MCOL-2119] delete throw error in Stored Procedures Created: 2019-01-29  Updated: 2020-04-01  Resolved: 2019-01-29

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.0.0, 1.2
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Richard Stracke Assignee: Unassigned
Resolution: Duplicate Votes: 1
Labels: None

Issue Links:
Blocks
blocks MCOL-1065 Implement full Stored Procedure support Closed

 Description   

delete in stored procedures throw error

ERROR 1178 (42000): The storage engine for the table doesn't support This stored procedure syntax is not supported by Columnstore in this version

to reproduce:

CREATE DATABASE `testsp`;
 
use testsp;
 
CREATE TABLE `ts1` (
 
	`id` int
 
)
 
ENGINE=columnstore
 
;


CREATE DEFINER=`root`@`%` PROCEDURE `simpledelete`()
 
BEGIN
 
delete from ts1;
 
END



 Comments   
Comment by Richard Stracke [ 2019-01-29 ]

duplicate from
https://jira.mariadb.org/browse/MCOL-1065

Documented here
https://mariadb.com/kb/en/library/columnstore-create-procedure/

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