Line break in DB Task

[filip-cz]

I would like to update stored procedures on multiple connections at once using database task. The problem is that DB Task seem to not persist line brakes in SQL code.

Example script:

DELIMITER $$
DROP FUNCTION IF EXISTS `tst`.`git_tst`$$
CREATE DEFINER=`admin`@`%` FUNCTION `tst`.`git_tst`() RETURNS int(11)
BEGIN
/*
* 	Multile comments works.
*	!
* 
*/
	declare cnt integer default 0;
    
	SELECT COUNT(*) 
	FROM information_schema.COLUMNS
	INTO cnt;
    
	RETURN cnt;
END$$

When I check task log i see all the SQL code unformatted, on one line, which is exactly the same as I see using SHOW CREATE

Log:

2020-12-09 12:47:30.119 - -----------------> Execute query
CREATE DEFINER=`labadmin`@`%` FUNCTION `tst`.`git_tst`() RETURNS int(11)
BEGIN
/*
* 	Multile comments works.
*	!
* 
*/
	declare cnt integer default 0;      	SELECT COUNT(*) 	FROM information_schema.COLUMNS 	INTO cnt;      	RETURN cnt; END
2020-12-09 12:47:30.122 - -----------------> Time: 2ms, updated 0 row(s)

What should I do to persist line breaks?

[filip-cz]

I found the issue, it is caused by mix of Carrige Return and Line Feed in the script, CRLF works, but CR does not.

See link

[filip-cz]

Resolved