PEAR Bug Search Results

SQL_Parser: Bug 19210 [Open] [needs patch] Does not recognize nested SELECT statements

2012-01-10T07:06:19+00:00

SQL_Parser Bug
Reported by nestor
2012-01-09T23:23:17+00:00
PHP: 5.3.1 OS:  Package Version: 0.6.0

Description:
------------
The parser does not recognize syntacticaly correct nested SELECT statements

Test script:
---------------
$parser = new SQL_Parser();
$str ="SELECT e.fld_id AS fid, e.fld_name, e.fld_vorname, e.fld_gebdat, e.fld_eintritt, e.fld_austritt, vp.fld_name AS vpname,
(SELECT fld_id FROM tbl_bf_beitraege as b WHERE b.tbl_kinder_fld_id=e.fld_id) AS fld_editable ,
vp.fld_id AS fld_syncable 
FROM tbl_kinder AS e
LEFT JOIN tbl_v_kinder_vertragspartner AS v ON v.tbl_kinder_fld_id = e.fld_id
LEFT JOIN tbl_vertragspartner AS vp ON vp.fld_id = v.tbl_vertragspartner_fld_id
WHERE (e.tbl_tagesheim_fld_id='1')
ORDER BY  e.fld_vorname DESC, e.fld_name ASC LIMIT '100' OFFSET '100'";
$struct = $parser->parse($str);

Expected result:
----------------
parsing the string $str

Actual result:
--------------
Caught exception: Parse error: Expected ")" on line 2
(SELECT fld_id FROM tbl_bf_beitraege as b WHERE b.tbl_kinder_fld_id=e.fld_id) AS fld_editable ,
        ^ found: "fld_id"
in: C:\xampp\php\PEAR\SQL\Parser.php#318
from: 
#0 C:\xampp\php\PEAR\SQL\Parser.php(662): SQL_Parser->raiseError('Expected ")"')
#1 C:\xampp\php\PEAR\SQL\Parser.php(1486): SQL_Parser->parseCondition()
#2 C:\xampp\php\PEAR\SQL\Parser.php(1714): SQL_Parser->parseSelect()
#3 C:\xampp\php\PEAR\SQL\Parser.php(1792): SQL_Parser->parseQuery()
#4 C:\xampp\htdocs\parsit.php(29): SQL_Parser->parse('SELECT e.fld_id...')
#5 {main}

SQL_Parser: Bug 17920 [Open] PATCH NEEDED - subselect parsing error

m dot hello at gmail dot com — 2011-02-14T10:24:05+00:00

SQL_Parser Bug
Reported by mayo2000
2010-10-01T00:19:08+00:00
PHP: 5.2.12 OS: CentOS Package Version: 0.5

Description:
------------
parser cannot handle subselect:

SELECT COUNT(*) FROM (SELECT * FROM DATACFI) t

Test script:
---------------
$sql = 'SELECT COUNT(*) FROM (SELECT * FROM DATACFI) t';
$parser = new SQL_Parser();
echo $parser->parse($sql);

Expected result:
----------------
number of rows

Actual result:
--------------
Parse error: Unexpected clause: on line 1 SELECT COUNT(*) 
FROM (SELECT * FROM DATACFI) t ^ found: "("

SQL_Parser: Bug 17118 [Open] PATCH NEEDED - Unit tests fail

daniel dot oconnor at gmail dot com — 2011-02-14T10:23:31+00:00

SQL_Parser Bug
Reported by doconnor
2010-02-16T17:05:20+00:00
PHP: 5.3.1 OS:  Package Version: CVS

Description:
------------
http://test.pear.php.net/unit-test-results/phpunit_results.txt

Actual result:
--------------
php -c ../php.ini -f /home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php
PHPUnit 3.4.10 by Sebastian Bergmann.

...................F.F......................................  60 / 116
.................F...........F..........................

Time: 2 seconds, Memory: 11.00Mb

There were 4 failures:

1) PHPUnit_Framework_TestCase_Sql_Parser::create #4

Caught exception: Parse error: Unexpected token ident: "production" on line 9
    CONSTRAINT production UNIQUE(date_prod)
               ^ found: "production"
in: /home/clockwerx/packages-all/SQL_Parser/SQL/Parser.php#318
from: 
#0 /home/clockwerx/packages-all/SQL_Parser/SQL/Parser.php(610): SQL_Parser->raiseError('Unexpected toke...')
#1 /home/clockwerx/packages-all/SQL_Parser/SQL/Parser.php(1017): SQL_Parser->parseFieldOptions()
#2 /home/clockwerx/packages-all/SQL_Parser/SQL/Parser.php(1079): SQL_Parser->parseFieldList()
#3 /home/clockwerx/packages-all/SQL_Parser/SQL/Parser.php(1726): SQL_Parser->parseCreate()
#4 /home/clockwerx/packages-all/SQL_Parser/SQL/Parser.php(1792): SQL_Parser->parseQuery()
#5 /home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php(60): SQL_Parser->parse('?CREATE TABLE f...')
#6 /usr/local/lib/php/pear/PHPUnit/Framework/TestCase.php(705): PHPUnit_Framework_TestCase_Sql_Parser->runTest()
#7 /usr/local/lib/php/pear/PHPUnit/Framework/TestResult.php(686): PHPUnit_Framework_TestCase->runBare()
#8 /usr/local/lib/php/pear/PHPUnit/Framework/TestCase.php(652): PHPUnit_Framework_TestResult->run(Object(PHPUnit_Framework_TestCase_Sql_Parser))
#9 /usr/local/lib/php/pear/PHPUnit/Framework/TestSuite.php(770): PHPUnit_Framework_TestCase->run(Object(PHPUnit_Framework_TestResult))
#10 /usr/local/lib/php/pear/PHPUnit/Framework/TestSuite.php(745): PHPUnit_Framework_TestSuite->runTest(Object(PHPUnit_Framework_TestCase_Sql_Parser), Object(PHPUnit_Framework_TestResult))
#11 /usr/local/lib/php/pear/PHPUnit/TextUI/TestRunner.php(349): PHPUnit_Framework_TestSuite->run(Object(PHPUnit_Framework_TestResult), false, Array, Array, false)
#12 /usr/local/lib/php/pear/PHPUnit/TextUI/TestRunner.php(120): PHPUnit_TextUI_TestRunner->doRun(Object(PHPUnit_Framework_TestSuite), Array)
#13 /home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php(14): PHPUnit_TextUI_TestRunner::run(Object(PHPUnit_Framework_TestSuite))
#14 /home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php(135): SQL_Parser_AllTests::main()
#15 {main}


/home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php:85
/home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php:14
/home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php:135

2) PHPUnit_Framework_TestCase_Sql_Parser::create #6
SQL seems to run fine now, please update the expected test result!

/home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php:82
/home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php:14
/home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php:135

3) PHPUnit_Framework_TestCase_Sql_Parser::select #9
SQL still fails to be parsed
SQL: 
select a as b, min(a) as baz from foo;



Expected:
 [array with parsed SQL]
Result:

Caught exception: Parse error: Expected EOQ on line 2
select a as b, min(a) as baz from foo;
                      ^ found: "as"
in: /home/clockwerx/packages-all/SQL_Parser/SQL/Parser.php#318
from: 
#0 /home/clockwerx/packages-all/SQL_Parser/SQL/Parser.php(1794): SQL_Parser->raiseError('Expected EOQ')
#1 /home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php(60): SQL_Parser->parse('?select a as b,...')
#2 /usr/local/lib/php/pear/PHPUnit/Framework/TestCase.php(705): PHPUnit_Framework_TestCase_Sql_Parser->runTest()
#3 /usr/local/lib/php/pear/PHPUnit/Framework/TestResult.php(686): PHPUnit_Framework_TestCase->runBare()
#4 /usr/local/lib/php/pear/PHPUnit/Framework/TestCase.php(652): PHPUnit_Framework_TestResult->run(Object(PHPUnit_Framework_TestCase_Sql_Parser))
#5 /usr/local/lib/php/pear/PHPUnit/Framework/TestSuite.php(770): PHPUnit_Framework_TestCase->run(Object(PHPUnit_Framework_TestResult))
#6 /usr/local/lib/php/pear/PHPUnit/Framework/TestSuite.php(745): PHPUnit_Framework_TestSuite->runTest(Object(PHPUnit_Framework_TestCase_Sql_Parser), Object(PHPUnit_Framework_TestResult))
#7 /usr/local/lib/php/pear/PHPUnit/TextUI/TestRunner.php(349): PHPUnit_Framework_TestSuite->run(Object(PHPUnit_Framework_TestResult), false, Array, Array, false)
#8 /usr/local/lib/php/pear/PHPUnit/TextUI/TestRunner.php(120): PHPUnit_TextUI_TestRunner->doRun(Object(PHPUnit_Framework_TestSuite), Array)
#9 /home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php(14): PHPUnit_TextUI_TestRunner::run(Object(PHPUnit_Framework_TestSuite))
#10 /home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php(135): SQL_Parser_AllTests::main()
#11 {main}

*********************


/home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php:78
/home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php:14
/home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php:135

4) PHPUnit_Framework_TestCase_Sql_Parser::select #21
SQL still fails to be parsed
SQL: 
select a, max(b) as x, sum(c) as y, min(d) as z from e;



Expected:
 [array with parsed SQL]
Result:

Caught exception: Parse error: Expected EOQ on line 2
select a, max(b) as x, sum(c) as y, min(d) as z from e;
                 ^ found: "as"
in: /home/clockwerx/packages-all/SQL_Parser/SQL/Parser.php#318
from: 
#0 /home/clockwerx/packages-all/SQL_Parser/SQL/Parser.php(1794): SQL_Parser->raiseError('Expected EOQ')
#1 /home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php(60): SQL_Parser->parse('?select a, max(...')
#2 /usr/local/lib/php/pear/PHPUnit/Framework/TestCase.php(705): PHPUnit_Framework_TestCase_Sql_Parser->runTest()
#3 /usr/local/lib/php/pear/PHPUnit/Framework/TestResult.php(686): PHPUnit_Framework_TestCase->runBare()
#4 /usr/local/lib/php/pear/PHPUnit/Framework/TestCase.php(652): PHPUnit_Framework_TestResult->run(Object(PHPUnit_Framework_TestCase_Sql_Parser))
#5 /usr/local/lib/php/pear/PHPUnit/Framework/TestSuite.php(770): PHPUnit_Framework_TestCase->run(Object(PHPUnit_Framework_TestResult))
#6 /usr/local/lib/php/pear/PHPUnit/Framework/TestSuite.php(745): PHPUnit_Framework_TestSuite->runTest(Object(PHPUnit_Framework_TestCase_Sql_Parser), Object(PHPUnit_Framework_TestResult))
#7 /usr/local/lib/php/pear/PHPUnit/TextUI/TestRunner.php(349): PHPUnit_Framework_TestSuite->run(Object(PHPUnit_Framework_TestResult), false, Array, Array, false)
#8 /usr/local/lib/php/pear/PHPUnit/TextUI/TestRunner.php(120): PHPUnit_TextUI_TestRunner->doRun(Object(PHPUnit_Framework_TestSuite), Array)
#9 /home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php(14): PHPUnit_TextUI_TestRunner::run(Object(PHPUnit_Framework_TestSuite))
#10 /home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php(135): SQL_Parser_AllTests::main()
#11 {main}

*********************


/home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php:78
/home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php:14
/home/clockwerx/packages-all/SQL_Parser/tests/AllTests.php:135

FAILURES!
Tests: 116, Assertions: 99, Failures: 4.

SQL_Parser: Feature/Change Request 11469 [Analyzed] CLARIFICATION NEEDED - unify line endings

pear at sebastianmendel dot de — 2011-02-14T10:17:32+00:00

SQL_Parser Feature/Change Request
Reported by cybot
2007-06-28T11:59:16+00:00
PHP: 5.2.3 OS:  Package Version: CVS

Description:
------------
unify line endings once - save resources to not always check for all types of line endings

SQL_Parser: Bug 11466 [Open] PATCH NEEDED - 1a is not treated as single string

pear at sebastianmendel dot de — 2011-02-14T10:13:31+00:00

SQL_Parser Bug
Reported by cybot
2007-06-28T09:50:31+00:00
PHP: 5.2.3 OS:  Package Version: CVS

Description:
------------
1a is not treated as single string or identifier

Test script:
---------------
echo SELECT 1a > test.sql
php generate_testcases.php test.sql

Expected result:
----------------
 'SELECT 1a',
'expect' => array(
        'command' => 'select',
        'column_names' => array(
            0 => '1a',
            ),
        'column_tables' => array(
            0 => '',
            ),
        'column_aliases' => array(
            0 => '',
            )
        )
),
);
?>

Actual result:
--------------
 'SELECT 1a',
'expect' => array(
        'command' => 'select',
        'column_values' => array(
            0 => '1'
            ),
        'column_names' => array(
            0 => '1',
            1 => 'a'
            ),
        'column_tables' => array(
            0 => '',
            1 => ''
            ),
        'column_aliases' => array(
            0 => '',
            1 => ''
            )
        )
),
);
?>

SQL_Parser: Bug 8388 [Open] PATCH NEEDED - Between statements not recognized

denis at denismayer dot com — 2011-02-14T10:13:05+00:00

SQL_Parser Bug
Reported by denis@...
2006-08-08T13:43:26+00:00
PHP: 5.1.4 OS: Windows Package Version: CVS

Description:
------------
The following sql statement is not recognized by the SQL Parser:

SELECT AVG(CUSTOMER.AGE)
FROM CUSTOMER
WHERE CUSTOMER.AGE BETWEEN 21 AND 35
GROUP BY CUSTOMER.AGE

The parser says that GROUP token is not an operator.

I believe the parser is not recognizing the BETWEEN statement properly.

SQL_Parser: Feature/Change Request 7416 [Open] PATCH NEEDED - Pound Sign Breaking Legal Field Names

maps at servangle dot net — 2011-02-14T10:25:19+00:00

SQL_Parser Feature/Change Request
Reported by maps@...
2006-04-18T12:22:09+00:00
PHP: all OS: Solaris & DB2 Package Version: 0.5

Description:
------------
Pound sign's (#) are breaking the SQL parsing. The pound sign is a legal character representation in DB2 field names. Example:
SELECT * FROM DB2TEST.MYTABLE WHERE TOT#CUST = '1'


Test script:
---------------
Recommended patches:

Lexer.php (line:246)
if (ctype_alpha(ord($c))) { // keyword or ident
--change to--
if (ctype_alpha(ord($c)) || ($c == '#'  )) { // keyword or ident

Lexer.php (line:304)
if (ctype_alnum(ord($c)) || ($c == '_') || ($c == '.')) {
--change to--
if (ctype_alnum(ord($c)) || ($c == '_') || ($c == '.') || ($c == '#')) {

Expected result:
----------------
Successfully parsed SQL statement.

Actual result:
--------------
Partially parsed SQL statement. The parser seems to jump out of parsing when a # sign is encountered.

SQL_Parser: Feature/Change Request 6209 [Verified] PATCH NEEDED - Tables like [cat/dog] not recognized

not at wgpower dot net — 2011-02-14T10:11:06+00:00

SQL_Parser Feature/Change Request
Reported by not@...
2005-12-09T13:37:12+00:00
PHP: Irrelevant OS: Irrelevant Package Version: 

Description:
------------
SQL writted with MS ACCESS allows to name tables with '/' symbols , like 'cats/dogs' , and to access to them we should use [] symbols, for exemple SELECT * FROM [cats/dogs] , the parse don't recognize [] and / symbols in table names.