ClickHouseClient
ClickHouseClient copied to clipboard
Octonica
ClickHouse .NET Core driver
ClickHouse 22.8 extended value range for Date32 and DateTime64 types to [1900-01-01, 2299-12-31] : https://github.com/ClickHouse/ClickHouse/pull/39425 Currently provider gives following errors: Date32: ``` ClickHouseHandledException : The value must be in range...
A `foreach` loop uses the non-generic ` IEnumerator GetEnumerator()`. This currently uses `_parameters.GetEnumerator()` which returns the enumerator of the dictionary, which returns `KeyValuePair`'s rather than `ClickHouseParameter`'s. This causes an error...
``` Octonica.ClickHouseClient.Exceptions.ClickHouseHandledException Message=Value cannot be null. (Parameter 'key') StackTrace: at Octonica.ClickHouseClient.ClickHouseTcpClient.Session.d__17.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.ValueTaskAwaiter.GetResult() at Octonica.ClickHouseClient.ClickHouseColumnWriter.d__31.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task...
```sql CREATE TABLE IF NOT EXISTS TypeTable ( Id Int32 NOT NULL, Column Date32 NOT NULL, ) ENGINE = Memory() INSERT INTO TypeTable ( Id, Column ) VALUES (toInt32(1),toDate32('1925-01-01')) ```...
``` Octonica.ClickHouseClient.Exceptions.ClickHouseException Message=The connection is closed. Source=Octonica.ClickHouseClient StackTrace: at Octonica.ClickHouseClient.ClickHouseConnection.ConnectionSession..ctor(ClickHouseConnection connection, IClickHouseSessionExternalResources externalResources) at Octonica.ClickHouseClient.ClickHouseCommand.d__85.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Octonica.ClickHouseClient.ClickHouseCommand.d__85.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Octonica.ClickHouseClient.ClickHouseCommand.d__57.MoveNext() at...
`Decimal256(S)` is an alias for `Decimal(76, S)`. Currently all values of type `Decimal(P, S)` are converted to `decimal` and there is no intention to change it. But `Decimal256` and `Decimal128`...
From error it looks like values read as UInt64 instead of Int64 ``` System.OverflowException Message=The value 0xFFCD8C88F2850000 is greater than the maximal value of the type "System.DateTime". It is only...
``` ClickHouseException: The type "Bool" is not supported. at Octonica.ClickHouseClient.ClickHouseCommand.ExecuteDbDataReader(CommandBehavior behavior, Boolean ignoreProfileEvents, Boolean async, CancellationToken cancellationToken) at Octonica.ClickHouseClient.Utils.TaskHelper.WaitNonAsyncTask[T](ValueTask`1 task) at Octonica.ClickHouseClient.ClickHouseCommand.ExecuteDbDataReader(CommandBehavior behavior) ```
I've been testing handling of multiple open queries per single connection functionality for provider and discovered that provider hangs instead of one of two options: 1. executing second query (I...