I think it would be nice that we use Dolibarr with Doctrine or any ORM so that way we won't have compatibility problems with different database drivers...
What do you think? Regards, *Marcos García* [email protected] 2013/4/25 Florian Henry <[email protected]> > Dear developpers, > > I'm currently experiement lot's of problem with PostgreSQL only > due to non SQL respect standard. > > As reminder with an agregate SQL function you must put in GROUP BY > all field that are not in the agreate > > For example : SELECT t.name,t.id, SUM(t.cost) FROM llx_table > GROUP BY t.id > That's WRONG ! MySQL let it go, but PgSQL no ! > > Correct version is SELECT* t.name,t.id*, SUM(t.cost) FROM > llx_table GROUP BY *t.name,t.id > > *** This kind of problem cannot be detected by UnitTest because > most of the time the are on list, not in object method, but in list SQL. > > Other common problem is into insert or update method > If your field is an integer, you must have this to build the > request : > $sql.= " ".(! > empty($this->fk_fourn)?"'".$this->fk_fourn."'":"null"); > and NOT > $sql.= " '".(! > empty($this->fk_fourn)?$this->fk_fourn:"null")."'"; > > Try to sent update or insert request UPDATE llx_table SET > fk_fourn='' WHERE ... in PgSQL it will say '' is not a valid inter, and is > right. > Once again MySQL let it go but insert 0 instead of NULL.... > > > Regards > > -- > Florian [email protected]+33 6 03 76 48 > 07http://www.open-concept.pro > Twitter : @_Open_Concept_ > > > _______________________________________________ > Dolibarr-dev mailing list > [email protected] > https://lists.nongnu.org/mailman/listinfo/dolibarr-dev > >
_______________________________________________ Dolibarr-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
