Skip to content

Fatal error on SQL with DELIMITER statements #8

@ktarasov

Description

@ktarasov

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions