ClickHouseClient icon indicating copy to clipboard operation
ClickHouseClient copied to clipboard

BulkCopy cannot insert `NULL` into nullable `Enum8` and `Enum16` columns

Open MaceWindu opened this issue 3 years ago • 1 comments

Octonica.ClickHouseClient.Exceptions.ClickHouseHandledException
  Message=Value cannot be null. (Parameter 'key')
  StackTrace:
   at Octonica.ClickHouseClient.ClickHouseTcpClient.Session.<SendTable>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.<SendTable>d__31.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.ClickHouseColumnWriter.<WriteTable>d__30.MoveNext()
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Octonica.ClickHouseClient.Utils.TaskHelper.WaitNonAsyncTask(ValueTask task)

  This exception was originally thrown at this call stack:
    System.ThrowHelper.ThrowArgumentNullException(System.ExceptionArgument)
    Octonica.ClickHouseClient.ClickHouseTcpClient.Session.WriteTable.AnonymousMethod__0(System.Memory<byte>)
    Octonica.ClickHouseClient.ClickHouseBinaryProtocolWriter.WriteRaw(System.Func<System.Memory<byte>, Octonica.ClickHouseClient.Protocol.SequenceSize>)
    Octonica.ClickHouseClient.ClickHouseTcpClient.Session.WriteTable(Octonica.ClickHouseClient.Protocol.IClickHouseTableWriter)
    Octonica.ClickHouseClient.ClickHouseTcpClient.Session.SendTable(Octonica.ClickHouseClient.Protocol.IClickHouseTableWriter, bool, System.Threading.CancellationToken)

Inner Exception 1:
ArgumentNullException: Value cannot be null. (Parameter 'key')

MaceWindu avatar Jul 10 '22 11:07 MaceWindu

I also see this null value check https://github.com/Octonica/ClickHouseClient/blob/master/src/Octonica.ClickHouseClient/Types/Enum8TypeInfo.cs#L74-L75, which doesn't look correct - nullable enums supported by ClickHouse

MaceWindu avatar Jul 10 '22 11:07 MaceWindu

Closing, fixed long time ago

MaceWindu avatar Mar 18 '24 15:03 MaceWindu