{"action":"closed","issue":{"url":"https://api.github.com/repos/querydsl/querydsl/issues/1250","labels_url":"https://api.github.com/repos/querydsl/querydsl/issues/1250/labels{/name}","comments_url":"https://api.github.com/repos/querydsl/querydsl/issues/1250/comments","events_url":"https://api.github.com/repos/querydsl/querydsl/issues/1250/events","html_url":"https://github.com/querydsl/querydsl/issues/1250","id":60522512,"number":1250,"title":"Different results in a query if I add offset(0)","user":{"login":"edual16","id":8244569,"avatar_url":"https://avatars.githubusercontent.com/u/8244569?v=3","gravatar_id":"","url":"https://api.github.com/users/edual16","html_url":"https://github.com/edual16","followers_url":"https://api.github.com/users/edual16/followers","following_url":"https://api.github.com/users/edual16/following{/other_user}","gists_url":"https://api.github.com/users/edual16/gists{/gist_id}","starred_url":"https://api.github.com/users/edual16/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edual16/subscriptions","organizations_url":"https://api.github.com/users/edual16/orgs","repos_url":"https://api.github.com/users/edual16/repos","events_url":"https://api.github.com/users/edual16/events{/privacy}","received_events_url":"https://api.github.com/users/edual16/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-03-10T15:56:55Z","updated_at":"2015-03-14T12:42:37Z","closed_at":"2015-03-14T12:42:37Z","body":"Hello.\r\n\r\nFirst of all, I want to say that the following issue is a problem with my query but it is strange.\r\n\r\nI have a view with a OneToOne relation with an entity and this entity has left joins with other different entities.\r\n\r\nWhen I launch the regular query with that structure, I get the results duplicate because of the left joins (Hibernate should organize the entities but don't). If I launch the same query but adding offset(0), nothing else, everything is working well.\r\n\r\nI think the behaviour is wrong (the offset statement shouldn't change the result) but, maybe, my query is wrong too.\r\n\r\nIf you think it could be an issue, I can try to make an example (simpler than my code) where the problem can be replicated.\r\n\r\nThank you.\r\n\r\nBest regards, Eduardo."}}