hi Singlestore team,
You have GitHub - memsql/SingleStoreNETConnector: Async Connector for .NET and .NET Core made available, but there is no option to report issues on GitHub. We are using this connector in a dotnet console app and getting “Invalid DATE/TIME in type conversion”. Our table has over 30 date/timestamp columns. So we are unable to figureout which column has the issue. Can you please help to report this issue to the Github repo so that the error logging can be enhanced to indicate the column having the error? Below is the stack trace. We are using .Net 6.0
SingleStoreConnector.SingleStoreException (0x80004005): Invalid DATE/TIME in type conversion
at SingleStoreConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in C:\\Users\\circleci\\project\\src\\SingleStoreConnector\\Core\\ServerSession.cs:line 964
at SingleStoreConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in C:\\Users\\circleci\\project\\src\\SingleStoreConnector\\Core\\ResultSet.cs:line 44
at SingleStoreConnector.SingleStoreDataReader.ActivateResultSet(CancellationToken cancellationToken) in C:\\Users\\circleci\\project\\src\\SingleStoreConnector\\SingleStoreDataReader.cs:line 133
at SingleStoreConnector.SingleStoreDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, ISingleStoreCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in C:\\Users\\circleci\\project\\src\\SingleStoreConnector\\SingleStoreDataReader.cs:line 474
at SingleStoreConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in C:\\Users\\circleci\\project\\src\\SingleStoreConnector\\Core\\CommandExecutor.cs:line 56
at SingleStoreConnector.SingleStoreCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in C:\\Users\\circleci\\project\\src\\SingleStoreConnector\\SingleStoreCommand.cs:line 295
at SingleStoreConnector.SingleStoreBulkLoader.LoadAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in C:\\Users\\circleci\\project\\src\\SingleStoreConnector\\SingleStoreBulkLoader.cs:line 213
at SingleStoreConnector.SingleStoreBulkCopy.WriteToServerAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in C:\\Users\\circleci\\project\\src\\SingleStoreConnector\\SingleStoreBulkCopy.cs:line 335
at SingleStoreConnector.SingleStoreBulkCopy.WriteToServerAsync(DataTable dataTable, CancellationToken cancellationToken) in C:\\Users\\circleci\\project\\src\\SingleStoreConnector\\SingleStoreBulkCopy.cs:line 129