@@ -149,7 +149,7 @@ discard block |
||
| 149 | 149 | |
| 150 | 150 | $this->assertEquals(4, count($result)); |
| 151 | 151 | $this->assertEquals(316, round($result[0]['sqrtsalary'])); |
| 152 | - $this->assertEquals(447, round($result[1]['sqrtsalary'])); |
|
| 152 | + $this->assertEquals(447, round($result[1]['sqrtsalary'])); |
|
| 153 | 153 | $this->assertEquals(632, round($result[2]['sqrtsalary'])); |
| 154 | 154 | $this->assertEquals(894, round($result[3]['sqrtsalary'])); |
| 155 | 155 | } |
@@ -368,12 +368,12 @@ discard block |
||
| 368 | 368 | */ |
| 369 | 369 | public function testBitOrComparison() |
| 370 | 370 | { |
| 371 | - $dql = 'SELECT m, ' . |
|
| 372 | - 'BIT_OR(4, 2) AS bit_or,' . |
|
| 373 | - 'BIT_OR( (m.salary/100000) , 2 ) AS salary_bit_or ' . |
|
| 374 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ' . |
|
| 375 | - 'ORDER BY ' . |
|
| 376 | - 'm.id ' ; |
|
| 371 | + $dql = 'SELECT m, '. |
|
| 372 | + 'BIT_OR(4, 2) AS bit_or,'. |
|
| 373 | + 'BIT_OR( (m.salary/100000) , 2 ) AS salary_bit_or '. |
|
| 374 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m '. |
|
| 375 | + 'ORDER BY '. |
|
| 376 | + 'm.id '; |
|
| 377 | 377 | $result = $this->_em->createQuery($dql)->getArrayResult(); |
| 378 | 378 | |
| 379 | 379 | $this->assertEquals(4 | 2, $result[0]['bit_or']); |
@@ -381,10 +381,10 @@ discard block |
||
| 381 | 381 | $this->assertEquals(4 | 2, $result[2]['bit_or']); |
| 382 | 382 | $this->assertEquals(4 | 2, $result[3]['bit_or']); |
| 383 | 383 | |
| 384 | - $this->assertEquals(($result[0][0]['salary']/100000) | 2, $result[0]['salary_bit_or']); |
|
| 385 | - $this->assertEquals(($result[1][0]['salary']/100000) | 2, $result[1]['salary_bit_or']); |
|
| 386 | - $this->assertEquals(($result[2][0]['salary']/100000) | 2, $result[2]['salary_bit_or']); |
|
| 387 | - $this->assertEquals(($result[3][0]['salary']/100000) | 2, $result[3]['salary_bit_or']); |
|
| 384 | + $this->assertEquals(($result[0][0]['salary'] / 100000) | 2, $result[0]['salary_bit_or']); |
|
| 385 | + $this->assertEquals(($result[1][0]['salary'] / 100000) | 2, $result[1]['salary_bit_or']); |
|
| 386 | + $this->assertEquals(($result[2][0]['salary'] / 100000) | 2, $result[2]['salary_bit_or']); |
|
| 387 | + $this->assertEquals(($result[3][0]['salary'] / 100000) | 2, $result[3]['salary_bit_or']); |
|
| 388 | 388 | } |
| 389 | 389 | |
| 390 | 390 | /** |
@@ -392,12 +392,12 @@ discard block |
||
| 392 | 392 | */ |
| 393 | 393 | public function testBitAndComparison() |
| 394 | 394 | { |
| 395 | - $dql = 'SELECT m, ' . |
|
| 396 | - 'BIT_AND(4, 2) AS bit_and,' . |
|
| 397 | - 'BIT_AND( (m.salary/100000) , 2 ) AS salary_bit_and ' . |
|
| 398 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ' . |
|
| 399 | - 'ORDER BY ' . |
|
| 400 | - 'm.id ' ; |
|
| 395 | + $dql = 'SELECT m, '. |
|
| 396 | + 'BIT_AND(4, 2) AS bit_and,'. |
|
| 397 | + 'BIT_AND( (m.salary/100000) , 2 ) AS salary_bit_and '. |
|
| 398 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m '. |
|
| 399 | + 'ORDER BY '. |
|
| 400 | + 'm.id '; |
|
| 401 | 401 | $result = $this->_em->createQuery($dql)->getArrayResult(); |
| 402 | 402 | |
| 403 | 403 | $this->assertEquals(4 & 2, $result[0]['bit_and']); |
@@ -405,10 +405,10 @@ discard block |
||
| 405 | 405 | $this->assertEquals(4 & 2, $result[2]['bit_and']); |
| 406 | 406 | $this->assertEquals(4 & 2, $result[3]['bit_and']); |
| 407 | 407 | |
| 408 | - $this->assertEquals(($result[0][0]['salary']/100000) & 2, $result[0]['salary_bit_and']); |
|
| 409 | - $this->assertEquals(($result[1][0]['salary']/100000) & 2, $result[1]['salary_bit_and']); |
|
| 410 | - $this->assertEquals(($result[2][0]['salary']/100000) & 2, $result[2]['salary_bit_and']); |
|
| 411 | - $this->assertEquals(($result[3][0]['salary']/100000) & 2, $result[3]['salary_bit_and']); |
|
| 408 | + $this->assertEquals(($result[0][0]['salary'] / 100000) & 2, $result[0]['salary_bit_and']); |
|
| 409 | + $this->assertEquals(($result[1][0]['salary'] / 100000) & 2, $result[1]['salary_bit_and']); |
|
| 410 | + $this->assertEquals(($result[2][0]['salary'] / 100000) & 2, $result[2]['salary_bit_and']); |
|
| 411 | + $this->assertEquals(($result[3][0]['salary'] / 100000) & 2, $result[3]['salary_bit_and']); |
|
| 412 | 412 | } |
| 413 | 413 | |
| 414 | 414 | public function testIdentity() |