Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.7.0

Bug #16215 Compiler doesn't support "null" type.
Submitted: 2009-05-11 14:23 UTC
From: mcmic Assigned: cybot
Status: Closed Package: SQL_Parser (version CVS)
PHP Version: 5.2.5 OS: irrelevant
Roadmaps: (Not assigned)    

 [2009-05-11 14:23 UTC] mcmic (MCMic)
Description: ------------ The compiler fail to compile request who include null-typed variables. Test script: --------------- <?php require_once 'SQL/Parser.php'; require_once 'SQL/Compiler.php'; $parser = new SQL_Parser(); $compiler = new SQL_Compiler(); $parser->setDialect("MySQL"); $query = "INSERT INTO table VALUES (1,'coucou',NULL)"; $req_parse = $parser->parse($query); $req_compile = $compiler->compile($req_parse); echo "result : $req_compile"; ?> Expected result: ---------------- insert into table values (1,'coucou',NULL) Actual result: -------------- Fatal error: Cannot use object of type PEAR_Error as array in /usr/share/php/SQL/Compiler.php on line 295


 [2009-05-11 14:52 UTC] mcmic (MCMic)
The following patch has been added/updated: Patch Name: patch Revision: 1242035569 URL:
 [2009-05-11 14:53 UTC] mcmic (MCMic)
-Package Version: 0.5 +Package Version: CVS
 [2009-05-13 20:39 UTC] doconnor (Daniel O'Connor)
-Assigned To: +Assigned To: cybot
Hey thanks for the patch! LGTM.
 [2011-02-14 10:23 UTC] alan_k (Alan Knowles)
-Status: Assigned +Status: Closed
This bug has been fixed in SVN. If this was a documentation problem, the fix will appear on by the end of next Sunday (CET). If this was a problem with the website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.