[limb-svn] r6832 - 3.x/trunk/limb/dbal/src/drivers/pgsql

[svn at limb-project.com]

Author: svk
Date: 2008-03-12 17:13:09 +0300 (Wed, 12 Mar 2008)
New Revision: 6832
URL: http://fisheye.limb-project.com/changelog/limb/?cs=6832

Modified:
   3.x/trunk/limb/dbal/src/drivers/pgsql/lmbPgsqlRecordSet.class.php
Log:
-- lmbPgsqlRecordSet::count() fixed

Modified: 3.x/trunk/limb/dbal/src/drivers/pgsql/lmbPgsqlRecordSet.class.php
===================================================================
--- 3.x/trunk/limb/dbal/src/drivers/pgsql/lmbPgsqlRecordSet.class.php	2008-03-06 15:29:09 UTC (rev 6831)
+++ 3.x/trunk/limb/dbal/src/drivers/pgsql/lmbPgsqlRecordSet.class.php	2008-03-12 14:13:09 UTC (rev 6832)
@@ -131,7 +131,7 @@
 
   function count()
   {
-    if(!(preg_match("/^\s*SELECT\s+DISTINCT/is", $this->query) || preg_match('/\s+GROUP\s+BY\s+/is',$this->query)))
+    if(!(preg_match("/^\s*SELECT\s+DISTINCT/is", $this->query) || preg_match('/\s+GROUP\s+BY\s+/is',$this->query)) && stripos($this->query, 'from') !== false)
     {
       $rewritesql = preg_replace('/^\s*SELECT\s.*\s+FROM\s/Uis','SELECT COUNT(*) FROM ', $this->query);
       $rewritesql = preg_replace('/(\sORDER\s+BY\s.*)/is', '', $rewritesql);