[MDEV-15003] Innovation: CREATE PROCEDURE ... LIKE Created: 2018-01-19  Updated: 2018-04-18

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Juan Telleria Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: usability


 Description   

Just as CREATE TABLE ... LIKE exists, it would be very useful to have also such SQL expression for procedures:

CREATE [OR REPLACE] PROCEDURE [IF NOT EXISTS] sp_name
   { LIKE old_stored_procedure_name | (LIKE old_stored_procedure_name ) }

If in such procedures tables used relative references (Different Databases depending on which is in USE), that would allow to copy procedures from one database to another, and call them in the new database, without having to load the procedures again with a SQL script in the new database.

This would allow to automatize execution at the databases level, without having to re-load the procedures from a second programming language for working in MariaDB.


Generated at Thu Feb 08 08:17:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.