NPE in window function with partition by clause

[puzpuzpuz]

To reproduce

May be seen on demo:

SELECT  pickup_datetime, avg(total_amount) OVER (PARTITION BY avg(total_amount)
             ORDER BY pickup_datetime
             RANGE BETWEEN '7' PRECEDING AND CURRENT ROW) moving_average_1w
FROM trips WHERE pickup_datetime >= '2018-12-30' and pickup_datetime <= '2018-12-31'  SAMPLE BY 1d

2024-05-15T20:45:23.924718Z E i.q.c.h.HttpConnectionContext internal error [fd=103, e=`
java.lang.NullPointerException: Cannot invoke "java.lang.CharSequence.length()" because "cs" is null
	at io.questdb.std.str.Utf8Sink.escapeJsonStr(Utf8Sink.java:34)
	at io.questdb.cutlass.http.processors.JsonQueryProcessorState.prepareExceptionJson(JsonQueryProcessorState.java:871)
	at io.questdb.cutlass.http.processors.JsonQueryProcessor.sendException(JsonQueryProcessor.java:792)
	at io.questdb.cutlass.http.processors.JsonQueryProcessor.internalError(JsonQueryProcessor.java:656)
	at io.questdb.cutlass.http.processors.JsonQueryProcessor.execute0(JsonQueryProcessor.java:222)
	at io.questdb.cutlass.http.processors.JsonQueryProcessor.onRequestComplete(JsonQueryProcessor.java:262)
	at io.questdb.cutlass.http.HttpConnectionContext.handleClientRecv(HttpConnectionContext.java:919)
	at io.questdb.cutlass.http.HttpConnectionContext.handleClientOperation(HttpConnectionContext.java:260)

	at io.questdb.cutlass.http.HttpServer.handleClientOperation(HttpServer.java:274)
	at io.questdb.cutlass.http.HttpServer$1.lambda$$0(HttpServer.java:87)
	at io.questdb.network.AbstractIODispatcher.processIOQueue(AbstractIODispatcher.java:199)
	at io.questdb.cutlass.http.HttpServer$1.run(HttpServer.java:91)
	at io.questdb.mp.Worker.run(Worker.java:148)
`]

QuestDB version:

7.4.2

OS, in case of Docker specify Docker and the Host OS:

Linux

File System, in case of Docker specify Host File System:

ext4

Full Name:

Andrei Pechkurov

Affiliation:

QuestDB

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context

No response