This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Failed to create a TRIGGER in MariaDB ColumnStore 1.0.1

I created a database migrate_test and two tables in MariaDB ColumnStore 1.0.1.

CREATE TABLE customers (
  customerNumber int(11) NOT NULL,
  customerName varchar(50) NOT NULL,
  PRIMARY KEY (customerNumber)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE _deltas_table_customers (
  _delta_statement_type tinyint(4) NOT NULL,
  customerNumber int(11) NOT NULL,
  PRIMARY KEY (_delta_statement_type,customerNumber)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

It is failed to create a trigger on the table:

CREATE TRIGGER migrate_test._deltas_trigger_delete_customers 
AFTER DELETE ON migrate_test.customers 
FOR EACH ROW REPLACE INTO migrate_test._deltas_table_customers(_delta_statement_type, customerNumber) VALUES (2, OLD.customerNumber);

The error message is as follows:

ERROR 1303 (2F003): Can't create a TRIGGER from within another stored routine

Please help take a look .Thank you very much.

Answer Answered by Andrew Hutchings in this comment.

I have reproduced this in 1.0.1. I have also tried with the latest version (1.0.3) and it works fine. I recommend upgrading to this version.

NOTE: The above example relates to InnoDB tables within a ColumnStore cluster.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.