{"action":"created","issue":{"url":"https://api.github.com/repos/sequelize/sequelize/issues/3333","labels_url":"https://api.github.com/repos/sequelize/sequelize/issues/3333/labels{/name}","comments_url":"https://api.github.com/repos/sequelize/sequelize/issues/3333/comments","events_url":"https://api.github.com/repos/sequelize/sequelize/issues/3333/events","html_url":"https://github.com/sequelize/sequelize/issues/3333","id":60917573,"number":3333,"title":"query() returning duplicate data","user":{"login":"CGavrila","id":5712534,"avatar_url":"https://avatars.githubusercontent.com/u/5712534?v=3","gravatar_id":"","url":"https://api.github.com/users/CGavrila","html_url":"https://github.com/CGavrila","followers_url":"https://api.github.com/users/CGavrila/followers","following_url":"https://api.github.com/users/CGavrila/following{/other_user}","gists_url":"https://api.github.com/users/CGavrila/gists{/gist_id}","starred_url":"https://api.github.com/users/CGavrila/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CGavrila/subscriptions","organizations_url":"https://api.github.com/users/CGavrila/orgs","repos_url":"https://api.github.com/users/CGavrila/repos","events_url":"https://api.github.com/users/CGavrila/events{/privacy}","received_events_url":"https://api.github.com/users/CGavrila/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-03-12T22:09:49Z","updated_at":"2015-05-11T20:13:22Z","closed_at":"2015-03-13T08:20:11Z","body":"I have a Node application running on two separate machines. Both use Sequelize 2.0.4.\r\n\r\n**Machine #1:**\r\n```\r\nUbuntu 14.04\r\nmysql  Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (i686) using readline 6.3\r\n```\r\n**Machine #2:**\r\n```\r\nUbuntu 14.04\r\nmysql  Ver 14.14 Distrib 5.5.41, for debian-linux-gnu (x86_64) using readline 6.3\r\n```\r\n\r\nThey both access the same sort of data, just in different databases, with the query being a simple SELECT statement (no JOINS or anything too fancy).\r\n\r\nWhen I run it on Machine #1 I get:\r\n```\r\n[ { id: 1, title: 'Title 1', language_id: 1 },\r\n  { id: 2, title: 'Title 2', language_id: 1 },\r\n  { id: 3, title: 'Title 3', language_id: 1 } ]\r\n```\r\n\r\nWhen I run on Machine #2 I get:\r\n```\r\n[[ { id: 1, title: 'Title 1', language_id: 1 },\r\n   { id: 2, title: 'Title 2', language_id: 1 },\r\n   { id: 3, title: 'Title 3', language_id: 1 } ],\r\n[  { id: 1, title: 'Title 1', language_id: 1 },\r\n   { id: 2, title: 'Title 2', language_id: 1 },\r\n   { id: 3, title: 'Title 3', language_id: 1 } ] ]\r\n```\r\n\r\nBasically the same data, but duplicated within the result. I don't know what else to include other than Sequelize version, OS version and MySQL version that might be of any relevance.\r\n\r\nIs there anyone that has an idea as to what this might be caused by? The only difference among what I have provided is the mysql version."},"comment":{"url":"https://api.github.com/repos/sequelize/sequelize/issues/comments/101034810","html_url":"https://github.com/sequelize/sequelize/issues/3333#issuecomment-101034810","issue_url":"https://api.github.com/repos/sequelize/sequelize/issues/3333","id":101034810,"user":{"login":"janmeier","id":1210224,"avatar_url":"https://avatars.githubusercontent.com/u/1210224?v=3","gravatar_id":"","url":"https://api.github.com/users/janmeier","html_url":"https://github.com/janmeier","followers_url":"https://api.github.com/users/janmeier/followers","following_url":"https://api.github.com/users/janmeier/following{/other_user}","gists_url":"https://api.github.com/users/janmeier/gists{/gist_id}","starred_url":"https://api.github.com/users/janmeier/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/janmeier/subscriptions","organizations_url":"https://api.github.com/users/janmeier/orgs","repos_url":"https://api.github.com/users/janmeier/repos","events_url":"https://api.github.com/users/janmeier/events{/privacy}","received_events_url":"https://api.github.com/users/janmeier/received_events","type":"User","site_admin":false},"created_at":"2015-05-11T20:13:22Z","updated_at":"2015-05-11T20:13:22Z","body":"@ayushmaanbhav And the fix is the same - the raw query api has been slightly refactored, look at the link mick posted above\r\n"}}