Seems like data type information not stored with QueryManager

[ingted]

For insert query like

INSERT INTO testSch (COL1, COL2) VALUES (1,2), ("A", "B")

The collapsedValue saved to page content is always string...

var collapsedValue = insertValue.Expression.CollapseScalerQueryField(
    transactionReference.Transaction, preparedQuery, new(preparedQuery.Batch), new());

keyValuePairs.Add(insertValue.Alias, collapsedValue);

Is this by design that when querying all rows in testSch, the user should choose the correct type T for MapTo by himself/herself?

ExecuteQuery<T>
return results.Collection[0].MapTo<T>()

So far these queries work fine

    type TwoColumnString () =
        member val COL1 = "" with get, set
        member val COL2 = "" with get, set

    type TwoColumnInt () =
        member val COL1 = 0 with get, set
        member val COL2 = 0 with get, set

    type TwoColumnDouble () =
        member val COL1 = 0.0 with get, set
        member val COL2 = 0.0 with get, set

        let rString = 
            _core.Query.ExecuteQuery<TwoColumnString>(preLogin, "SELECT * FROM testSch", Unchecked.defaultof<KbInsensitiveDictionary<string>>)
            |> Seq.toArray

        let rInt = 
            _core.Query.ExecuteQuery<TwoColumnInt>(preLogin, "SELECT * FROM testSch where COL1 = 1", Unchecked.defaultof<KbInsensitiveDictionary<string>>)
            |> Seq.toArray

        let rDouble = 
            _core.Query.ExecuteQuery<TwoColumnDouble>(preLogin, "SELECT * FROM testSch where COL1 = 1", Unchecked.defaultof<KbInsensitiveDictionary<string>>)
            |> Seq.toArray

But if we removed the where condition for the second and third queries, exception thrown...

System.FormatException: The input string 'A' was not in a correct format.
   at System.Number.ThrowFormatException[TChar](ReadOnlySpan`1 value)
   at System.String.System.IConvertible.ToDouble(IFormatProvider provider)
   at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
   at NTDLS.Katzebase.Client.KbExtensions.MapTo[T](KbQueryDocumentListResult result)
   at NTDLS.Katzebase.Engine.Interactions.Management.QueryManager.ExecuteQuery[T](SessionState session, String queryText, Object userParameters) in G:\coldfar_py\NTDLS.Katzebase.Server\NTDLS.Katzebase.Engine\Interactions\Management\QueryManager.cs:line 68
   at FSI_0030.staticInitialization@() in G:\coldfar_py\NTDLS.Katzebase.Server\TestApplications\NTDLS.Katzebase.UnitTests\Scripts\Engine\DMLExecution\BasicTest.DMLExecution.ver.0.0.1.fsx:line 112
   at <StartupCode$FSI_0030>.$FSI_0030.main@()
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Stopped due to error

[ingted]

Will finish the unit test cases once I got to know if this is by design or not^___^

[ingted]

PS. I know type of Expression property could help to do more delicate processing.

match i0v0.Expression with
| :? Fields.QueryFieldConstantNumeric as num -> 
    equals "$n_2$" num.Value

match i0v1.Expression with
| :? Fields.QueryFieldConstantNumeric as num -> 
    equals "$n_3$" num.Value

match i1v0.Expression with
| :? Fields.QueryFieldConstantString as str -> 
    equals "$s_0$" str.Value

match i1v1.Expression with
| :? Fields.QueryFieldConstantString as str -> 
    equals "$s_1$" str.Value

[ingted]

test case

[NTDLS]

This makes sense, when mapping to a class object, the type are going to be strict. I'll add scaler functions for IsNumeric() and IsString() so users can do some sanity checks on their own data. The real answer here is that if you are storing various data types, then you should deserialize to string properties.

The mapping for the query results in red should fail.

[ingted]

I will add the unit test using KbClient!!

[NTDLS]

Added IsString, IsInteger and IsDouble scaler functions.

[ingted]

Will add related tests later.