{"action":"created","issue":{"url":"https://api.github.com/repos/sheldon/sequel-pro/issues/1","repository_url":"https://api.github.com/repos/sheldon/sequel-pro","labels_url":"https://api.github.com/repos/sheldon/sequel-pro/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/sheldon/sequel-pro/issues/1/comments","events_url":"https://api.github.com/repos/sheldon/sequel-pro/issues/1/events","html_url":"https://github.com/sheldon/sequel-pro/issues/1","id":172864490,"number":1,"title":"Modify table structure in GUI directly cause table info lose connection when using sphinx","user":{"login":"X-Bird","id":1308295,"avatar_url":"https://avatars.githubusercontent.com/u/1308295?v=3","gravatar_id":"","url":"https://api.github.com/users/X-Bird","html_url":"https://github.com/X-Bird","followers_url":"https://api.github.com/users/X-Bird/followers","following_url":"https://api.github.com/users/X-Bird/following{/other_user}","gists_url":"https://api.github.com/users/X-Bird/gists{/gist_id}","starred_url":"https://api.github.com/users/X-Bird/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/X-Bird/subscriptions","organizations_url":"https://api.github.com/users/X-Bird/orgs","repos_url":"https://api.github.com/users/X-Bird/repos","events_url":"https://api.github.com/users/X-Bird/events{/privacy}","received_events_url":"https://api.github.com/users/X-Bird/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-08-24T04:56:54Z","updated_at":"2016-08-24T05:05:41Z","closed_at":"2016-08-24T05:04:47Z","body":"### Reproduce Problem;\r\n\r\n1. create table using sphinx connection like this\r\n```mysql\r\nCREATE TABLE `search_source`\r\n(\r\n    id          INTEGER UNSIGNED NOT NULL,\r\n    weight      INTEGER NOT NULL,\r\n    query       VARCHAR(3072) NOT NULL,\r\n    INDEX(query)\r\n) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx://127.0.0.1:9312/source';\r\n```\r\nnow the GUI'S Table Info panel likes this. Pay attention on `Create syntax` filed's . It shows the connection using sphinx.\r\n![the first step](https://cloud.githubusercontent.com/assets/1308295/17918582/d7e718ec-69f8-11e6-9843-7de583d1642a.png)\r\n\r\n2. Alter table structure to add a column like `name`  through `Structure` panel directly .\r\n![second step](https://cloud.githubusercontent.com/assets/1308295/17918621/3e6a0840-69f9-11e6-9427-2e35921336df.png)\r\n\r\n3. Open up `Table Info` panel again. Pay attention on `Create syntax` filed's . It lost the connection ~!\r\n![thrid step](https://cloud.githubusercontent.com/assets/1308295/17918645/73f0a686-69f9-11e6-9286-c3336dca1e1d.png)\r\n\r\n\r\n### Cause Problems\r\n* query result should return in `name` field will bot return any more instead of value `0`.\r\n\r\n### Confirming the problem is this app causes\r\n* create table using sphinx connection like this `add name column in the script`\r\n```mysql\r\nCREATE TABLE `search_source`\r\n(\r\n    id              INTEGER UNSIGNED NOT NULL,\r\n    weight      INTEGER NOT NULL,\r\n    query       VARCHAR(3072) NOT NULL,\r\n    name       VARCHAR(255),\r\n    INDEX(query)\r\n) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx://127.0.0.1:9312/source';\r\n\r\n```\r\n* open up `Table Info` panel , it shows the connection still. Now i can get the result should return.\r\n![fourth step](https://cloud.githubusercontent.com/assets/1308295/17918739/30e36738-69fa-11e6-9622-13ca24b15531.png)\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/sheldon/sequel-pro/issues/comments/241958424","html_url":"https://github.com/sheldon/sequel-pro/issues/1#issuecomment-241958424","issue_url":"https://api.github.com/repos/sheldon/sequel-pro/issues/1","id":241958424,"user":{"login":"X-Bird","id":1308295,"avatar_url":"https://avatars.githubusercontent.com/u/1308295?v=3","gravatar_id":"","url":"https://api.github.com/users/X-Bird","html_url":"https://github.com/X-Bird","followers_url":"https://api.github.com/users/X-Bird/followers","following_url":"https://api.github.com/users/X-Bird/following{/other_user}","gists_url":"https://api.github.com/users/X-Bird/gists{/gist_id}","starred_url":"https://api.github.com/users/X-Bird/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/X-Bird/subscriptions","organizations_url":"https://api.github.com/users/X-Bird/orgs","repos_url":"https://api.github.com/users/X-Bird/repos","events_url":"https://api.github.com/users/X-Bird/events{/privacy}","received_events_url":"https://api.github.com/users/X-Bird/received_events","type":"User","site_admin":false},"created_at":"2016-08-24T05:05:41Z","updated_at":"2016-08-24T05:05:41Z","body":"### move the\r\n[Modify table structure in GUI directly cause table info lose connection when using sphinx #2549](https://github.com/sequelpro/sequelpro/issues/2549)"}}
{"actor":{"display_login":"X-Bird"}}