@@ 246-257 (lines=12) @@ | ||
243 | self::assertEquals(sprintf(self::$selectFromCtePattern, $alteredSql, 1, 10), $sql); |
|
244 | } |
|
245 | ||
246 | public function testModifyLimitQueryWithSubSelectAndOrder() |
|
247 | { |
|
248 | $querySql = 'SELECT * FROM (SELECT u.id as uid, u.name as uname ORDER BY u.name DESC) dctrn_result'; |
|
249 | $alteredSql = 'SELECT TOP 10 * FROM (SELECT u.id as uid, u.name as uname) dctrn_result'; |
|
250 | $sql = $this->_platform->modifyLimitQuery($querySql, 10); |
|
251 | self::assertEquals(sprintf(self::$selectFromCtePattern, $alteredSql, 1, 10), $sql); |
|
252 | ||
253 | $querySql = 'SELECT * FROM (SELECT u.id, u.name ORDER BY u.name DESC) dctrn_result'; |
|
254 | $alteredSql = 'SELECT TOP 10 * FROM (SELECT u.id, u.name) dctrn_result'; |
|
255 | $sql = $this->_platform->modifyLimitQuery($querySql, 10); |
|
256 | self::assertEquals(sprintf(self::$selectFromCtePattern, $alteredSql, 1, 10), $sql); |
|
257 | } |
|
258 | ||
259 | public function testModifyLimitQueryWithSubSelectAndMultipleOrder() |
|
260 | { |
|
@@ 1350-1361 (lines=12) @@ | ||
1347 | ); |
|
1348 | } |
|
1349 | ||
1350 | public function testModifyLimitQueryWithTopNSubQueryWithOrderBy() |
|
1351 | { |
|
1352 | $querySql = 'SELECT * FROM test t WHERE t.id = (SELECT TOP 1 t2.id FROM test t2 ORDER BY t2.data DESC)'; |
|
1353 | $alteredSql = 'SELECT TOP 10 * FROM test t WHERE t.id = (SELECT TOP 1 t2.id FROM test t2 ORDER BY t2.data DESC)'; |
|
1354 | $sql = $this->_platform->modifyLimitQuery($querySql, 10); |
|
1355 | self::assertEquals(sprintf(static::$selectFromCtePattern, $alteredSql, 1, 10), $sql); |
|
1356 | ||
1357 | $querySql = 'SELECT * FROM test t WHERE t.id = (SELECT TOP 1 t2.id FROM test t2 ORDER BY t2.data DESC) ORDER BY t.data2 DESC'; |
|
1358 | $alteredSql = 'SELECT TOP 10 * FROM test t WHERE t.id = (SELECT TOP 1 t2.id FROM test t2 ORDER BY t2.data DESC) ORDER BY t.data2 DESC'; |
|
1359 | $sql = $this->_platform->modifyLimitQuery($querySql, 10); |
|
1360 | self::assertEquals(sprintf(static::$selectFromCtePattern, $alteredSql, 1, 10), $sql); |
|
1361 | } |
|
1362 | ||
1363 | /** |
|
1364 | * @group DBAL-2436 |