Bug #82882 Field types not working for queries where schema is specified
Submitted: 7 Sep 2016 1:57 Modified: 23 Mar 2017 22:21
Reporter: Javier Treviño Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Visual Studio Integration Severity:S3 (Non-critical)
Version:2.0.2-M8S2-IR0 OS:Any
Assigned to: Jose Ramirez Ruiz CPU Architecture:Any

[7 Sep 2016 1:57] Javier Treviño 
Description:
A statement like

SELECT * FROM sakila.actor

where the schema is explicitly specified causes the Field Types view to be empty; whereas something like

SELECT * FROM actor

works correctly.

How to repeat:
1. Open Visual Studio
2. On Server Explorer Right click on a valid MySQL Server Connection and select "New MySQL Script"->"SQL"
3. Run a select query where the schema is specified along with the table name (like "SELECT * FROM sakila.actor")
4. Go to the Field Types view and note it's empty
[23 Mar 2017 20:59] Rafael Antonio Bedoy Torres 
Posted by developer:
 
Fixed on 2.0.5
[23 Mar 2017 22:21] Christine Cole 
Posted by developer:
 
Fixed as of the upcoming MySQL for Visual Studio 2.0.5 release, and here's the changelog entry:

The Field Type view in the result tab of an executed SQL query did not
display field information correctly when the query included a schema name
explicitly.

Thank you for the bug report.