DateTime Parameters Cause Query Execution to Hang Indefinitely

[pnquest]

Describe the bug A Query including 2 DateTime input parameters hangs indefinitely. Removing the parameters from the query and hard-coding test values results in the query returning almost instantly.

To Reproduce Please provide C#/SQL necessary to reproduce the issue, and steps to follow: Sample SQL:

SELECT v1 AS col1,
            v2 As col2,
FROM table
WHERE v2 between @StartDate and @EndDate

Sample C#

using (var connection = new AseConnection(_connectionString))
{
    connection.Open();

    using (AseCommand command = connection.CreateCommand())
    {
        command.CommandText = _pmStartTimeSql;
        AseParameter startDateParam = command.Parameters.Add("@StartDate", AseDbType.DateTime);
        startDateParam.Value = date.Date;
        AseParameter endDateParameter = command.Parameters.Add("@EndDate", AseDbType.DateTime);
         endDateParameter.Value = new DateTime(date.Year, date.Month, date.Day, 23, 59, 59);
         //This is where we hang forever
         using(DbDataReader r = await command.ExecuteReader().ConfigureAwait(false))
         {
             while(await r.ReadAsync().ConfigureAwait(false))
             {
                 //Do stuff here
             }
         }
    }
}

Expected behavior Execution should be successful. (unless I am doing something wrong, in which case an exception should be thrown).

Environment

• .net core 2.1.12
• package version 0.14.0

Additional context The Sybase instance I am connecting to is version 12.5.3.

[senseibaka]

Hi @pnquest we'll have a look at reproducing this, however I should point out that we only aim to support ASE versions 15 and 16.

[senseibaka]

hi @pnquest I've tried to reproduce your issue, but have not succeeded.

Can you review this change and tell me what's missing? I had to make a couple of small changes to your sample to get it to compile/run. https://github.com/DataAction/AdoNetCore.AseClient/commit/9f61f4e6577577a4fb54d29bfd08679cae5491fa

Thanks.