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

<hr>

<p>In <a href="https://github.com/dbsrgits/sql-translator/pull/87#discussion_r110699383">lib/SQL/Translator/Parser/MySQL.pm</a>:</p>
<pre style='color:#555'>&gt; @@ -332,6 +332,13 @@ create : CREATE or_replace(?) create_view_option(s?) /view/i NAME parens_field_l
         my $view_name   = $item{&#39;NAME&#39;};
         my $select_sql  = $item{&#39;view_select_statement&#39;};
         my $options     = $item{&#39;create_view_option(s?)&#39;};
+        my $field_list  = $item{&#39;parens_field_list(?)&#39;};
+
+        # Map fields as aliases on the select columns
+        my @fields = ( $field_list-&gt;[0] ) ? @{ $field_list-&gt;[0] } : ();
+        map { $select_sql-&gt;{&#39;columns&#39;}-&gt;[$_]-&gt;{&#39;alias&#39;} = $fields[$_] }
+            ( 0 .. $#fields )
+            if (@fields);
</pre>
<p>More importantly, this is unnecessary if you instead store <code>$item{'parens_field_list(?)'}</code> in <code>$views{$view_name}{fields}</code> and use that in preference to the select aliases the <code>-&gt;add_view</code> call.</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_r110699383">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AASeAs5HsnPckIdG7PV2c8nO9AExJG0Aks5rulZKgaJpZM4Mw61A">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AASeAmnnnC1Ve9V87YTsErsxEJirxdNoks5rulZKgaJpZM4Mw61A.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_r110699383"></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":"@ilmari commented on #87"}],"action":{"name":"View Pull Request","url":"https://github.com/dbsrgits/sql-translator/pull/87#discussion_r110699383"}}}</script>