superichmann

I am using webui for my tests so same as [demo.questdb.com](demo.questdb.com). I have noticed your fix suggestion but the problem starts when I need to compare and convert all kinds...

to be honest I have no idea I just showing something I saw on WEBUI. As far as I see it if a value is not null then it should...

Hi, Maybe I am still missing something but the main thing I am trying to say is that functions like `AVG` or `SUM` ignore nulls - _ignoring missing data_ I...

I mean, you really don't think its weird? try this query on [https://demo.questdb.io/](url) `SELECT extra, extra/0,CASE WHEN extra/0 > 1 THEN 99999 ELSE -111 END from trips` Can you please...

there is as well different behavior for number sent through query and numbers retrieved from columns. when sending numbers division by zero is always null but when data is retrieved...

now if COUNT(*) would have worked in all calculated queries and not only in top level query I could have circumvent this count only non nulls behavior.. `SELECT COUNT(*)/AVG(dropoff_longitude)+COUNT(*)*SUM(dropoff_longitude) from...

Error: Failed to load kernel extension "AutoMLMonitorKernelExtension" from assembly C:\Users\x\.nuget\packages\microsoft.ml.automl\0.21.0-preview.23406.1\interactive-extensions\dotnet\Microsoft.ML.AutoML.Interactive.dll Error: Microsoft.DotNet.Interactive.KernelExtensionLoadException: Failure loading Kernel Extension ---> System.MissingMethodException: Method not found: 'Void Microsoft.DotNet.Interactive.Commands.SubmitCode..ctor(System.String, System.String, Microsoft.DotNet.Interactive.Commands.SubmissionType)'. at Microsoft.ML.AutoML.AutoMLMonitorKernelExtension.LoadExtensionApiAsync(Kernel cSharpKernel) at System.Runtime.CompilerServices.AsyncMethodBuilderCore.Start[TStateMachine](TStateMachine&...

oh and clicking stop does not actually stop the execution

Error: Microsoft.DotNet.Interactive.NoSuitableKernelException: No kernel found for Microsoft.DotNet.Interactive.Commands.RequestHoverText with target kernel '.NET'. at Microsoft.DotNet.Interactive.Commands.KernelCommand.InvokeAsync(KernelInvocationContext context) in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\Commands\KernelCommand.cs:line 184 at Microsoft.DotNet.Interactive.Kernel.HandleAsync(KernelCommand command, KernelInvocationContext context) in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\Kernel.cs:line 323 at Microsoft.DotNet.Interactive.CompositeKernel.HandleAsync(KernelCommand command, KernelInvocationContext context)...

so many bugs...