{"action":"opened","issue":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12221","repository_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12221/labels{/name}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12221/comments","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12221/events","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/12221","id":151384315,"number":12221,"title":"Bad table export in case of generated columns","user":{"login":"glintik","id":2947475,"avatar_url":"https://avatars.githubusercontent.com/u/2947475?v=3","gravatar_id":"","url":"https://api.github.com/users/glintik","html_url":"https://github.com/glintik","followers_url":"https://api.github.com/users/glintik/followers","following_url":"https://api.github.com/users/glintik/following{/other_user}","gists_url":"https://api.github.com/users/glintik/gists{/gist_id}","starred_url":"https://api.github.com/users/glintik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/glintik/subscriptions","organizations_url":"https://api.github.com/users/glintik/orgs","repos_url":"https://api.github.com/users/glintik/repos","events_url":"https://api.github.com/users/glintik/events{/privacy}","received_events_url":"https://api.github.com/users/glintik/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-04-27T13:23:46Z","updated_at":"2016-04-27T13:23:46Z","closed_at":null,"body":"### Steps to reproduce\r\nAssume we have generated column idGenerated in table1 and phpmyadmin 4.6.0 exports it as:\r\n```\r\nCREATE TABLE `table1` (\r\n  `id` int(11) NOT NULL,\r\n  `idGenerated` int(11) GENERATED ALWAYS AS ((`id` > 10)) STORED\r\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;\r\n\r\nINSERT INTO `table1` (`id`, `idGenerated`) VALUES\r\n(1, 0),\r\n(11, 1);\r\n```\r\nWhen importing the data, database says:\r\n`#3105 - The value specified for generated column 'idGenerated' in table 'table1' is not allowed.`\r\n\r\nLooks very close to #11909.\r\n\r\n**MySQL 5.7.11**\r\n\r\n"}}