|
@@ 1167-1170 (lines=4) @@
|
| 1164 |
|
} |
| 1165 |
|
// Find ORDER BY |
| 1166 |
|
$reg = []; |
| 1167 |
|
if (preg_match('/^(.*)[[:space:]]+ORDER[[:space:]]+BY[[:space:]]+([[:alnum:][:space:],._]+)$/is', $foreignTableClause, $reg)) { |
| 1168 |
|
$foreignTableClauseArray['ORDERBY'] = QueryHelper::parseOrderBy(trim($reg[2])); |
| 1169 |
|
$foreignTableClause = $reg[1]; |
| 1170 |
|
} |
| 1171 |
|
// Find GROUP BY |
| 1172 |
|
$reg = []; |
| 1173 |
|
if (preg_match('/^(.*)[[:space:]]+GROUP[[:space:]]+BY[[:space:]]+([[:alnum:][:space:],._]+)$/is', $foreignTableClause, $reg)) { |
|
@@ 1173-1176 (lines=4) @@
|
| 1170 |
|
} |
| 1171 |
|
// Find GROUP BY |
| 1172 |
|
$reg = []; |
| 1173 |
|
if (preg_match('/^(.*)[[:space:]]+GROUP[[:space:]]+BY[[:space:]]+([[:alnum:][:space:],._]+)$/is', $foreignTableClause, $reg)) { |
| 1174 |
|
$foreignTableClauseArray['GROUPBY'] = QueryHelper::parseGroupBy(trim($reg[2])); |
| 1175 |
|
$foreignTableClause = $reg[1]; |
| 1176 |
|
} |
| 1177 |
|
// Rest is assumed to be "WHERE" clause |
| 1178 |
|
$foreignTableClauseArray['WHERE'] = QueryHelper::stripLogicalOperatorPrefix($foreignTableClause); |
| 1179 |
|
|