{"action":"created","issue":{"url":"https://api.github.com/repos/HeidiSQL/HeidiSQL/issues/44","repository_url":"https://api.github.com/repos/HeidiSQL/HeidiSQL","labels_url":"https://api.github.com/repos/HeidiSQL/HeidiSQL/issues/44/labels{/name}","comments_url":"https://api.github.com/repos/HeidiSQL/HeidiSQL/issues/44/comments","events_url":"https://api.github.com/repos/HeidiSQL/HeidiSQL/issues/44/events","html_url":"https://github.com/HeidiSQL/HeidiSQL/issues/44","id":282138093,"number":44,"title":"Problem with doublequotes in column names","user":{"login":"swbr","id":8761881,"avatar_url":"https://avatars1.githubusercontent.com/u/8761881?v=4","gravatar_id":"","url":"https://api.github.com/users/swbr","html_url":"https://github.com/swbr","followers_url":"https://api.github.com/users/swbr/followers","following_url":"https://api.github.com/users/swbr/following{/other_user}","gists_url":"https://api.github.com/users/swbr/gists{/gist_id}","starred_url":"https://api.github.com/users/swbr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/swbr/subscriptions","organizations_url":"https://api.github.com/users/swbr/orgs","repos_url":"https://api.github.com/users/swbr/repos","events_url":"https://api.github.com/users/swbr/events{/privacy}","received_events_url":"https://api.github.com/users/swbr/received_events","type":"User","site_admin":false},"labels":[{"id":738308823,"url":"https://api.github.com/repos/HeidiSQL/HeidiSQL/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-12-14T15:26:11Z","updated_at":"2017-12-14T19:38:43Z","closed_at":"2017-12-14T19:37:54Z","author_association":"NONE","body":"I have a software which automatically creates a MySQL table with doublequotes in the column name, and I can't change this behavior.\r\n\r\nHeidiSQL has problems to handle those columns correctly. \r\n\r\nUsing the MySQL command line client, it is no problem to run this code:\r\n<pre>\r\n CREATE TABLE TestLog (\r\n  `myInt` INT,\r\n  `\"myFunnyFloat\"` FLOAT,\r\n  `\"myFunnyString\"` VARCHAR(30),\r\n  `\"myFunnyInt\"` INT,\r\n  `\"myFunnyDateTime\"` DATETIME\r\n) ENGINE=InnoDB\r\n\r\nINSERT INTO TestLog VALUES ('42', '3.141', 'Hello Heidi', '21', '2017-12-14 10:00:00');\r\n\r\nSELECT * FROM testlog;\r\n+-------+----------------+-----------------+--------------+---------------------+\r\n| myInt | \"myFunnyFloat\" | \"myFunnyString\" | \"myFunnyInt\" | \"myFunnyDateTime\"   |\r\n+-------+----------------+-----------------+--------------+---------------------+\r\n|    42 |          3.141 | Hello Heidi     |           21 | 2017-12-14 10:00:00 |\r\n+-------+----------------+-----------------+--------------+---------------------+\r\n1 row in set (0.00 sec)\r\n</pre>\r\n\r\nIn HeidiSQL, one can create the table this way, too, but inserting the data fails.\r\nFurther more,  all columns are displayed blue like integers in the data tab, and apart from the first column, there is no column name. The data itself is displayed as\r\n\r\n    42 | 3.141 | He.llo. He.idi | 21 | 2.017.-12.-14. 10.:00.:00\r\n\r\nwhich is somewhat weird.\r\n\r\n(I'd insert a screenshot here, but Github doesn't let me)\r\n\r\nHeidiSQL indeed thinks those columns are INTs without names, as its own CREATE-code shows:\r\n\r\n<pre>\r\nCREATE TABLE `testlog` (\r\n\t`myInt` INT(11) NULL DEFAULT NULL,\r\n\t`` INT NULL,\r\n\t`` INT NULL,\r\n\t`` INT NULL,\r\n\t`` INT NULL\r\n)\r\nCOLLATE='latin1_swedish_ci'\r\nENGINE=InnoDB;\r\n</pre>\r\n\r\nPlaying with this issue shows that for each row _with doublequotes_ in its column name, HeidiSQL deletes the column name and assigns the data type of the last row _without doublequotes_.  "},"comment":{"url":"https://api.github.com/repos/HeidiSQL/HeidiSQL/issues/comments/351814258","html_url":"https://github.com/HeidiSQL/HeidiSQL/issues/44#issuecomment-351814258","issue_url":"https://api.github.com/repos/HeidiSQL/HeidiSQL/issues/44","id":351814258,"user":{"login":"ansgarbecker","id":7986591,"avatar_url":"https://avatars2.githubusercontent.com/u/7986591?v=4","gravatar_id":"","url":"https://api.github.com/users/ansgarbecker","html_url":"https://github.com/ansgarbecker","followers_url":"https://api.github.com/users/ansgarbecker/followers","following_url":"https://api.github.com/users/ansgarbecker/following{/other_user}","gists_url":"https://api.github.com/users/ansgarbecker/gists{/gist_id}","starred_url":"https://api.github.com/users/ansgarbecker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ansgarbecker/subscriptions","organizations_url":"https://api.github.com/users/ansgarbecker/orgs","repos_url":"https://api.github.com/users/ansgarbecker/repos","events_url":"https://api.github.com/users/ansgarbecker/events{/privacy}","received_events_url":"https://api.github.com/users/ansgarbecker/received_events","type":"User","site_admin":false},"created_at":"2017-12-14T19:38:43Z","updated_at":"2017-12-14T19:38:43Z","author_association":"COLLABORATOR","body":"Please update to the latest build in a few minutes and check if it works now."}}
{"actor":{"display_login":"ansgarbecker"}}