kodus/sql-split

Split MySQL/PostgreSQL files into individual queries

sql-split's Issues

Fatal error on SQL with DELIMITER statements

Hi.

The parser throw fatal error on SQL with DELIMITER statements.
Test code:

<?php

use Kodus\SQLSplit\Splitter;

require 'vendor/autoload.php';

$sql = <<<SQL
	DELIMITER $$

	CREATE OR REPLACE FUNCTION `someFunc`(`percent` INT UNSIGNED) RETURNS double(15,2)
		NO SQL
	BEGIN
		IF percent = 100 THEN
			RETURN 0.00;
		END IF;

		RETURN 100;
	END
	$$

	DELIMITER ;
SQL;

$statements = Splitter::split($sql);
var_dump($statements);

Output:

PHP Fatal error:  Uncaught RuntimeException: unexpected input: expected delimiter character(s), at: 201, got: ";" in /home/kvt/Dev/tmp/tst/testSQL/vendor/kodus/sql-split/src/Tokenizer.php:320
Stack trace:
#0 /home/kvt/Dev/tmp/tst/testSQL/vendor/kodus/sql-split/src/Tokenizer.php(93): Kodus\SQLSplit\Tokenizer->fail()
#1 /home/kvt/Dev/tmp/tst/testSQL/vendor/kodus/sql-split/src/Tokenizer.php(50): Kodus\SQLSplit\Tokenizer->statement()
#2 /home/kvt/Dev/tmp/tst/testSQL/vendor/kodus/sql-split/src/Tokenizer.php(34): Kodus\SQLSplit\Tokenizer->statements()
#3 /home/kvt/Dev/tmp/tst/testSQL/vendor/kodus/sql-split/src/Splitter.php(18): Kodus\SQLSplit\Tokenizer::tokenize()
#4 /home/kvt/Dev/tmp/tst/testSQL/test.php(24): Kodus\SQLSplit\Splitter::split()
#5 {main}
  thrown in /home/kvt/Dev/tmp/tst/testSQL/vendor/kodus/sql-split/src/Tokenizer.php on line 320

Parser stops on empty statement ""

The parser seems to stop as soon as he reach an empty statement (";;"):

<?php

require 'vendor/autoload.php';

$sql = 'SELECT * FROM `table1`;;SELECT * FROM `table2`';

$result = \Kodus\SQL\Splitter::split($sql);

var_dump($result);

Output :

array(1) {
  [0] =>
  string(22) "SELECT * FROM `table1`"
}

Do you think that you can fix this issue ? Do you want me to submit a PR ?