aboutsummaryrefslogtreecommitdiffhomepage
path: root/src/Wallabag/AnnotationBundle/Repository
diff options
context:
space:
mode:
authorJeremy Benoist <jeremy.benoist@gmail.com>2016-03-12 10:45:14 +0100
committerJeremy Benoist <jeremy.benoist@gmail.com>2016-03-12 10:45:14 +0100
commitb95ffda2a105af4c6f4f86aca025a0bf967bc86a (patch)
tree864a97443092ed854a61c91b6655a2628f4618fa /src/Wallabag/AnnotationBundle/Repository
parent09d8bb6fa26b881da478df4c7b97620cb7aea0d0 (diff)
downloadwallabag-b95ffda2a105af4c6f4f86aca025a0bf967bc86a.tar.gz
wallabag-b95ffda2a105af4c6f4f86aca025a0bf967bc86a.tar.zst
wallabag-b95ffda2a105af4c6f4f86aca025a0bf967bc86a.zip
Fix hazardous bug with Postgres
Instead of retrieving a random annotation, sort them to be sure they are all the same no matter the database used
Diffstat (limited to 'src/Wallabag/AnnotationBundle/Repository')
-rw-r--r--src/Wallabag/AnnotationBundle/Repository/AnnotationRepository.php1
1 files changed, 1 insertions, 0 deletions
diff --git a/src/Wallabag/AnnotationBundle/Repository/AnnotationRepository.php b/src/Wallabag/AnnotationBundle/Repository/AnnotationRepository.php
index 7f35373f..5f7da70e 100644
--- a/src/Wallabag/AnnotationBundle/Repository/AnnotationRepository.php
+++ b/src/Wallabag/AnnotationBundle/Repository/AnnotationRepository.php
@@ -101,6 +101,7 @@ class AnnotationRepository extends EntityRepository
101 return $this->createQueryBuilder('a') 101 return $this->createQueryBuilder('a')
102 ->leftJoin('a.user', 'u') 102 ->leftJoin('a.user', 'u')
103 ->where('u.username = :username')->setParameter('username', $username) 103 ->where('u.username = :username')->setParameter('username', $username)
104 ->orderBy('a.id', 'DESC')
104 ->setMaxResults(1) 105 ->setMaxResults(1)
105 ->getQuery() 106 ->getQuery()
106 ->getSingleResult(); 107 ->getSingleResult();