[MDEV-9700] ROUTINE_DEFINITION contains broken procedure body when used shielding quotes inside even after server upgrade to 10.1.12 version Created: 2016-03-08  Updated: 2017-06-13

Status: Open
Project: MariaDB Server
Component/s: Data Definition - Procedure
Affects Version/s: 10.1
Fix Version/s: 10.1

Type: Bug Priority: Major
Reporter: Mikhail Gavrilov Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Sprint: 10.1.13

 Description   

In addition to MDEV-7231 is possible recreate (convert) all existed procedures and triggers in right format for get right procedure body from INFORMATION_SCHEMA?

Currently for solve MDEV-7231 also needed recreate manually all procedures, functions and triggers.

 Comments   
Comment by Elena Stepanova [ 2016-03-08 ]

Assigning to bar to decide whether it's doable.

Comment by Alexander Barkov [ 2016-03-14 ]

It should be possible to recreate routines using these commands:

mysqldump -uroot --routines --no-create-info --no-data --no-create-db  --all-databases >output.sql
 
mysql -uroot <output.sql

Would this help?

Comment by Mikhail Gavrilov [ 2016-03-16 ] 

$ mysql -uroot <output.sql

ERROR 1359 (HY000) at line 31: Trigger already exists

This not worked because try create (not recreate)

Generated at Thu Feb 08 07:36:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.