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

Request #3842 Inner/outter join
Submitted: 2005-03-16 08:38 UTC Modified: 2005-04-22 10:02 UTC
From: fabio at bs2 dot com dot br Assigned: quipo
Status: Closed Package: MDB_QueryTool
PHP Version: Irrelevant OS:
Roadmaps: (Not assigned)    
Subscription  


 [2005-03-16 08:38 UTC] fabio at bs2 dot com dot br
Description: ------------ in MDB_QueryTool when class build the select, the function don't build with an inner/outer join, why?

Comments

 [2005-03-17 13:12 UTC] quipo
can you further explain the issue you're experiencing? I didn't understand what you mean exactly...
 [2005-03-18 06:39 UTC] fabio at bs2 dot com dot br
I'm trying to use inner join on a select $obj->setJoin(...); // here I dont have problem but in $res = $obj->get/getAll/getCol...(...);// result unexpected $obj->getQueryString();//get the select query without inner Join
 [2005-03-18 10:09 UTC] quipo
You are using ibase, right? Then the join implementation triggered an "invalid token" error, because the joined table columns were aliased as "_tablename_colname" but it looks like ibase aliases can't start with a "_" character. With ibase, now they are aliased as "t_tablename_colname" (notice the leading "t_"). Can you try the latest CVS version, please?
 [2005-03-18 15:19 UTC] fabio at bs2 dot com dot br
the function getJoin don't return inner/outer join.
 [2005-03-26 09:35 UTC] quipo
I've added some testcases and everything works as expected. Last time I forgot to commit the changes to MDB_QueryTool (only to DB_QueryTool), sorry. Can you try the latest CVS version, please?
 [2005-04-21 08:32 UTC] quipo
By chance, have you tried the latest CVS version? Is it working for you too?
 [2005-04-22 09:10 UTC] fabio at bs2 dot com dot br
don't working all rigth with me $qt = &new MDB_QueryTool($dsn); $qt->setTable('bug'); $qt->setJoin('bug_host' ,'fk_host = id_host' ,'inner'); $qt->getAll(); var_dump($qt->getQueryString()); //in this line the query returned is without inner join
 [2005-04-22 09:38 UTC] quipo
aha! Now I understand what you mean. INNER JOINs were not supported (we had 'default' joins), I just added them. What about now?
 [2005-04-22 09:51 UTC] fabio at bs2 dot com dot br
Now that all right. thank's
 [2005-04-22 10:02 UTC] quipo
This bug has been fixed in CVS. In case this was a documentation problem, the fix will show up at the end of next Sunday (CET) on pear.php.net. In case this was a pear.php.net website problem, the change will show up on the website in short time. Thank you for the report, and for helping us make PEAR better.