There is a change in behavior with nuget package System.Data.SQLite.Core between version 1.0.117 and 1.0.118.

See the sample. With version 1.0.117 the type of ResultTable.ResultColumn is REAL (which seems to be correct), but with version 1.0.118 the type is NUM.

Is this a bug or intended change? It this was intended is there a way to force REAL type on the resulting column?

Here is the sample code (C#/.NET 8):

using System.Data.SQLite;

var db = new SQLiteConnection("Data Source=:memory:");
db.Open();
var cmd = db.CreateCommand();
cmd.CommandText = """
    CREATE TABLE SourceTable1 (ColumnName REAL); 

    CREATE TABLE SourceTable2 (ColumnName REAL);     

    CREATE TABLE ResultTable AS
        SELECT CAST(ColumnName AS REAL) as ResultColumn FROM SourceTable1
        UNION ALL 
        SELECT CAST(ColumnName AS REAL) as ResultColumn FROM SourceTable2;

    """;
cmd.ExecuteNonQuery();

cmd = db.CreateCommand();
cmd.CommandText = """
    PRAGMA table_info(ResultTable);
    """;

var reader = cmd.ExecuteReader();
while (reader.Read())
    Console.WriteLine(string.Join(' ', reader[0], reader[1], reader[2], reader[3]));