[Solar-svn] Revision 3180

[pmjones at solarphp.com]

Solar_Sql_Select: [CHG] When building original/alias names for "from", "join", and "select", **do not** use AS, because it conflicts with Oracle.  Thanks, James Kilbride.


Modified: trunk/Solar/Sql/Select.php
===================================================================
--- trunk/Solar/Sql/Select.php	2008-05-27 16:41:45 UTC (rev 3179)
+++ trunk/Solar/Sql/Select.php	2008-05-28 01:50:16 UTC (rev 3180)
@@ -1539,7 +1539,7 @@
         if ($name == $orig) {
             $this->_parts['from'][] = $name;
         } else {
-            $this->_parts['from'][] = "$orig AS $name";
+            $this->_parts['from'][] = "$orig $name";
         }
     }
     
@@ -1569,7 +1569,7 @@
         if ($name == $orig) {
             $tmp['name'] = $name;
         } else {
-            $tmp['name'] = "$orig AS $name";
+            $tmp['name'] = "$orig $name";
         }
         
         $this->_parts['join'][] = $tmp;
@@ -1588,6 +1588,6 @@
      */
     protected function _buildSelect($name, $orig)
     {
-        $this->_parts['from'][] = "($orig) AS $name";
+        $this->_parts['from'][] = "($orig) $name";
     }
 }