{"action":"created","issue":{"url":"https://api.github.com/repos/pingcap/tidb/issues/36","labels_url":"https://api.github.com/repos/pingcap/tidb/issues/36/labels{/name}","comments_url":"https://api.github.com/repos/pingcap/tidb/issues/36/comments","events_url":"https://api.github.com/repos/pingcap/tidb/issues/36/events","html_url":"https://github.com/pingcap/tidb/issues/36","id":105158807,"number":36,"title":"Duplicate column name 'id' when select count(*) from ...","user":{"login":"lunny","id":81045,"avatar_url":"https://avatars.githubusercontent.com/u/81045?v=3","gravatar_id":"","url":"https://api.github.com/users/lunny","html_url":"https://github.com/lunny","followers_url":"https://api.github.com/users/lunny/followers","following_url":"https://api.github.com/users/lunny/following{/other_user}","gists_url":"https://api.github.com/users/lunny/gists{/gist_id}","starred_url":"https://api.github.com/users/lunny/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lunny/subscriptions","organizations_url":"https://api.github.com/users/lunny/orgs","repos_url":"https://api.github.com/users/lunny/repos","events_url":"https://api.github.com/users/lunny/events{/privacy}","received_events_url":"https://api.github.com/users/lunny/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-09-07T07:01:49Z","updated_at":"2015-09-07T16:04:55Z","closed_at":null,"body":"```\r\ngo get github.com/go-xorm/tidb\r\n```\r\nand run `go test`, then it panic. Then we open the db use interpreter, and the result is below.\r\n```\r\n➜  tidb git:(master) ✗ interpreter -dbpath=./tidb -store=goleveldb\r\nWelcome to the TiDB.\r\nVersion:\r\nGit Commit Hash: None\r\nUTC Build Time:  None\r\n\r\ntidb> show tables;\r\n+----------------+\r\n| Tables_in_tidb |\r\n+----------------+\r\n| numeric        |\r\n| picture        |\r\n| userdetail     |\r\n| userinfo       |\r\n+----------------+\r\ntidb> select * from userinfo;\r\n2015/09/07 14:58:22 main.go:202: [error] github.com/pingcap/tidb/rset/rsets/join.go:210: Duplicate column name 'id'\r\ngithub.com/pingcap/tidb/rset/rsets/join.go:104:\r\ngithub.com/pingcap/tidb/rset/rsets/join.go:225:\r\ngithub.com/pingcap/tidb/tidb.go:160:\r\ngithub.com/pingcap/tidb/session.go:133:\r\ngithub.com/pingcap/tidb/driver.go:309:\r\ngithub.com/pingcap/tidb/interpreter/main.go:60:\r\ntidb> desc userinfo;\r\n+------------+---------------+------+-----+---------+----------------+\r\n| Field      | Type          | Null | Key | Default | Extra          |\r\n+------------+---------------+------+-----+---------+----------------+\r\n| id         | BIGINT (20)   | NO   | PRI | NULL    | auto_increment |\r\n| username   | VARCHAR (255) | YES  | UNI | NULL    |                |\r\n| departname | VARCHAR (255) | YES  |     | NULL    |                |\r\n| created    | DATETIME      | YES  |     | NULL    |                |\r\n| detail_id  | INT (11)      | YES  |     | NULL    |                |\r\n| height     | DOUBLE        | YES  |     | NULL    |                |\r\n| avatar     | BLOB          | YES  |     | NULL    |                |\r\n| is_man     | TINYINT (1)   | YES  |     | NULL    |                |\r\n| id         | BIGINT (20)   | NO   | PRI | NULL    | auto_increment |\r\n| username   | VARCHAR (255) | YES  |     | NULL    |                |\r\n| departname | VARCHAR (255) | YES  |     | NULL    |                |\r\n| created    | DATETIME      | YES  |     | NULL    |                |\r\n| detail_id  | INT (11)      | YES  |     | NULL    |                |\r\n| height     | DOUBLE        | YES  |     | NULL    |                |\r\n| avatar     | BLOB          | YES  |     | NULL    |                |\r\n| is_man     | TINYINT (1)   | YES  |     | NULL    |                |\r\n+------------+---------------+------+-----+---------+----------------+\r\n```"},"comment":{"url":"https://api.github.com/repos/pingcap/tidb/issues/comments/138332587","html_url":"https://github.com/pingcap/tidb/issues/36#issuecomment-138332587","issue_url":"https://api.github.com/repos/pingcap/tidb/issues/36","id":138332587,"user":{"login":"lunny","id":81045,"avatar_url":"https://avatars.githubusercontent.com/u/81045?v=3","gravatar_id":"","url":"https://api.github.com/users/lunny","html_url":"https://github.com/lunny","followers_url":"https://api.github.com/users/lunny/followers","following_url":"https://api.github.com/users/lunny/following{/other_user}","gists_url":"https://api.github.com/users/lunny/gists{/gist_id}","starred_url":"https://api.github.com/users/lunny/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lunny/subscriptions","organizations_url":"https://api.github.com/users/lunny/orgs","repos_url":"https://api.github.com/users/lunny/repos","events_url":"https://api.github.com/users/lunny/events{/privacy}","received_events_url":"https://api.github.com/users/lunny/received_events","type":"User","site_admin":false},"created_at":"2015-09-07T16:04:55Z","updated_at":"2015-09-07T16:04:55Z","body":"Why the auto increment id is not start from 1 but 1001? I think this is the problem."}}