-
Notifications
You must be signed in to change notification settings - Fork 4
Open
Description
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 320Metadata
Metadata
Assignees
Labels
No labels