[Firebird-net-provider] [FB-Tracker] Created: (DNET-861) FbConnection.GetSchema getting column information does not bring the column_size on varchar columns

[Fabricio A. (JIRA) <tr...@fi...>]

FbConnection.GetSchema getting column information does not bring the column_size on varchar columns
---------------------------------------------------------------------------------------------------

                 Key: DNET-861
                 URL: http://tracker.firebirdsql.org/browse/DNET-861
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 6.4.0.0, 6.3.0.0
         Environment: Visual Studio 2017 
ASP.NET Core
NET Standard libraries
            Reporter: Fabricio Araujo
            Assignee: Jiri Cincura


I have my own way to generate SQL to use with Dapper (Dapper.Contrib does not fit well 
in what I'm doing) and I need to get column information to do so.

When I'm working with database tables directly, all works wonders when I use this call:
DataTable dtb = conn.GetSchema("COLUMNS", new string[] { null, null, ParamTableName });

When I use a view, things gets weird. Views (is not a trivial view, it has a few joins) with varchar columns comes with COLUMN_TYPE correct but COLUMN_SIZE comes NULL.
I traced the executed SQL of GetSchema but while it does not bring the type of the column (only the reference to the domain) it DOES BRING 
the COLUMN_SIZE correctly

The other columns comes correctly (all those are INTEGER columns though).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira