{"comment":{"created_at":"2011-10-13T22:51:07Z","body":"yes.","updated_at":"2011-10-13T22:51:07Z","url":"https://api.github.com/repos/mapbox/tilemill/issues/comments/2401266","id":2401266,"user":{"avatar_url":"https://secure.gravatar.com/avatar/edd0be6c7c035b58bb2712284da41f1f?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"edd0be6c7c035b58bb2712284da41f1f","url":"https://api.github.com/users/springmeyer","id":20300,"login":"springmeyer"}},"action":"created","issue":{"number":696,"created_at":"2011-09-01T22:21:16Z","pull_request":{"diff_url":null,"patch_url":null,"html_url":null},"body":"I try to attach a sqlite DB and use the following query:\r\n\r\n    (SELECT * FROM counties INNER JOIN blss ON blss.geoid = counties.geoid10)\r\n\r\nThe layer settings window saves, but when I try to inspect the layer, I get a silent crash and see 'no response from server'. There is nothing the console except an acknowledgement that server restarted.\r\n\r\nI try doing this exact same thing via sqlite3 in Terminal and get the expected result:\r\n\r\n        $ sqlite3 counties.sqlite \r\n    SQLite version 3.6.12\r\n    Enter \".help\" for instructions\r\n    Enter SQL statements terminated with a \";\"\r\n    sqlite> ATTACH DATABASE \"blss.sqlite\" AS \"blss\";\r\n    sqlite> SELECT * FROM counties INNER JOIN blss ON blss.geoid = counties.geoid10; \r\n    2114||01|005|00161528|01005|Barbour|Barbour County|06|H1|G4020||21640||A|-2147483648.0|50864716.0|+31.8706701|-085.4054562|LAUCN01005003|2000|M13|4.9||CN010050|F|01005|1\r\n    2135||01|019|00161535|01019|Cherokee|Cherokee County|06|H1|G4020||||A|1434075952.0|119858898.0|+34.0695153|-085.6542417|LAUCN01019003|2000|M13|4.0||CN010190|F|01019|7\r\n    2150||01|007|00161529|01007|Bibb|Bibb County|06|H1|G4020|142|13820||A|1612480789.0|9289057.0|+33.0158929|-087.1271475|LAUCN01007003|2000|M13|4.7||CN010070|F|01007|2\r\n    2151||01|013|00161532|01013|Butler|Butler County|06|H1|G4020||||A|2011976894.0|2726814.0|+31.7516670|-086.6819689|LAUCN01013003|2000|M13|6.9||CN010130|F|01013|5\r\n","comments":7,"title":"Silent crash in .5 when inspecting data of SQLite DB with attached db","updated_at":"2011-10-13T22:51:07Z","url":"https://api.github.com/repos/mapbox/tilemill/issues/696","id":1546607,"assignee":null,"milestone":null,"closed_at":"2011-09-02T00:59:37Z","user":{"avatar_url":"https://secure.gravatar.com/avatar/978d888946a1a76b403a8303be8d85f0?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"978d888946a1a76b403a8303be8d85f0","url":"https://api.github.com/users/dhcole","id":170641,"login":"dhcole"},"html_url":"https://github.com/mapbox/tilemill/issues/696","labels":[],"state":"closed"},"legacy":{"issue_id":1546607,"comment_id":2401266}}