@@ -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() |