description: In the Employee database, there is a column in the JOB table declared as

LANGUAGE\_REQ VARCHAR\(15\) \[5\]

When loading the metadata of the database using FbConnection.GetSchema("Columns"), the last value of the collection is called "IS_ARRAY", but this value is incorrectly returned as false for the LANGUAGE_REQ column. As far as I can see, there is nothing that indicates that the column is an array column, or how big the array is.

Also, when looking at the values found in GetSchemaTable from a datareader;

        command\.CommandText = "SELECT LANGUAGE\_REQ FROM JOB";
        DbDataReader reader = command\.ExecuteReader\(\);
        DataTable dt = reader\.GetSchemaTable\(\);
        Type t = dt\.Rows\[0\]\["DataType"\]

the type returned is "System.Array", but the actual value from the query is a System.String[]

=>

In the Employee database, there is a column in the JOB table declared as

LANGUAGE\_REQ VARCHAR\(15\) \[5\]

When loading the metadata of the database using FbConnection.GetSchema("Columns"), the last value of the collection is called "IS_ARRAY", but this value is incorrectly returned as false for the LANGUAGE_REQ column.

The reason turns out to be an invalid comparison in FirebirdSql.Data.Schema.FbColumns.ProcessResult:

            row\["IS\_ARRAY"\]     = \(row\["COLUMN\_ARRAY"\] == DBNull\.Value\);

should be:

            row\["IS\_ARRAY"\]     = \(row\["COLUMN\_ARRAY"\] \!= DBNull\.Value\);

Also, when looking at the values found in GetSchemaTable from a datareader;

        command\.CommandText = "SELECT LANGUAGE\_REQ FROM JOB";
        DbDataReader reader = command\.ExecuteReader\(\);
        DataTable dt = reader\.GetSchemaTable\(\);
        Type t = dt\.Rows\[0\]\["DataType"\]

the type returned is "System.Array", but the actual value from the query is a System.String[]

Version: 2.5.0 Alpha 2 [ 10240 ]

status: Open [ 1 ] => In Progress [ 3 ]

status: In Progress [ 3 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5.0. Alpha 3 [ 10261 ]

Fix Version: 2.5.0 [ 10170 ]

Fix Version: 2.5.0 [ 10170 ] =>