<p><b>@adherzog</b> commented on this pull request.</p>

<hr>

<p>In <a href="https://github.com/dbsrgits/sql-translator/pull/87#discussion_r111737897">lib/SQL/Translator/Parser/MySQL.pm</a>:</p>
<pre style='color:#555'>&gt; @@ -326,7 +326,7 @@ create : CREATE PROCEDURE NAME not_delimiter &quot;$delimiter&quot;
 PROCEDURE : /procedure/i
     | /function/i
 
-create : CREATE or_replace(?) create_view_option(s?) /view/i NAME /as/i view_select_statement &quot;$delimiter&quot;
+create : CREATE or_replace(?) create_view_option(s?) /view/i NAME parens_field_list(?) /as/i view_select_statement &quot;$delimiter&quot;
</pre>
<p>If we store the fields in the <code>%views</code> hash instead of setting the column aliases, then the generated SQL won't include the aliases. So I'm continuing to set the aliases, and both the generated SQL and the fields attribute are returning the correct results. (At least, according to the tests I added.)</p>
<p>I've used your simplified code (though I'm using <code>$item{'parens_field_list(?)'}[0]</code> instead of <code>$item{'parens_field_list(?)'}</code>, since it seems to be an arrayref within an arrayref) and left the rest the same.</p>
<p><a href="https://github.com/ilmari" class="user-mention">@ilmari</a> - Please review again when you have a chance.</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/dbsrgits/sql-translator/pull/87#discussion_r111737897">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AASeAnuKX2fP7QFp7ZbHBZgF3-fkEQjgks5rw2CcgaJpZM4Mw61A">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AASeAo7T2ngBBGCJIE7fgU-wuNaX0uNRks5rw2CcgaJpZM4Mw61A.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
  <link itemprop="url" href="https://github.com/dbsrgits/sql-translator/pull/87#discussion_r111737897"></link>
  <meta itemprop="name" content="View Pull Request"></meta>
</div>
<meta itemprop="description" content="View this Pull Request on GitHub"></meta>
</div>

<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/dbsrgits/sql-translator","title":"dbsrgits/sql-translator","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/dbsrgits/sql-translator"}},"updates":{"snippets":[{"icon":"PERSON","message":"@adherzog commented on #87"}],"action":{"name":"View Pull Request","url":"https://github.com/dbsrgits/sql-translator/pull/87#discussion_r111737897"}}}</script>