Modify ↓

Ticket #413 (closed defect: fixed)

Opened 2 years ago

Last modified 2 years ago

PDOSQLExecTask does not recognize "delimiter" command

Reported by: mmalone@… Owned by: mrook
Priority: major Milestone: 2.4.0
Component: phing-core Version: 2.3.3
Keywords: Cc:

Description

In MySQL, the "DELIMITER" command is often used for defining stored procedures and triggers. PDOSQLExecTask task currently sends such commands to the server, which results in a syntax error since "DELIMITER" is a client-side command and not a valid query. The attached patch adds the needed logic to the runStatements() method for handling SQL files with multiple delimiters.

Attachments

delimiter.diff Download (1.3 KB) - added by mmalone@… 2 years ago.
Patch

Change History

Changed 2 years ago by mmalone@…

Patch

comment:1 Changed 2 years ago by mrook

  • Status changed from new to assigned

comment:2 Changed 2 years ago by mrook

(In [682]) Refs #413 - apply patch to recognize MySQL 'DELIMITER' syntax

comment:3 Changed 2 years ago by mrook

  • Status changed from assigned to closed
  • Resolution set to fixed

This issue has been fixed in the SVN tree, revision r682.

Thank you for the report, and for helping us make Phing better!

View ↑

Add a comment

Modify Ticket

Action
as closed
The resolution will be deleted. Next status will be 'reopened'
Author


E-mail address and user name can be saved in the Preferences.

Attachments ↑
 
Note: See TracTickets for help on using tickets.