Changeset 23378 for branches/version-2_13-dev/data/class/SC_Product.php

Timestamp:

2014/04/29 17:33:46 (10 years ago)

Author:

Seasoft

Message:

#2531 (DBMS に依存したサブクエリー内の LIMIT OFFSET を排除する)

File:

• branches/version-2_13-dev/data/class/SC_Product.php (modified) (1 diff)

branches/version-2_13-dev/data/class/SC_Product.php

@@ -82 +82 @@
             $o_table = $this->arrOrderData['table'];
             $o_order = $this->arrOrderData['order'];
-            $order = <<< __EOS__
-                    (
-                        SELECT $o_col
-                        FROM
-                            $o_table as T2
-                        WHERE T2.product_id = alldtl.product_id
-                        ORDER BY T2.$o_col $o_order
-                        LIMIT 1
-                    ) $o_order, product_id
-__EOS__;
-            $objQuery->setOrder($order);
+            $objQuery->setOrder("T2.$o_col $o_order");
+            $objQuery->setLimit(1);
+            $sub_sql = $objQuery->getSqlWithLimitOffset($o_col, "$o_table AS T2", 'T2.product_id = alldtl.product_id');
+
+            $objQuery->setOrder("($sub_sql) $o_order, product_id");
         }
         $arrReturn = $objQuery->getCol('alldtl.product_id', $table, '', $arrVal);