Yuancheng Jiang

### Describe the bug ``` java.lang.NullPointerException: Cannot read field "type" because "op" is null at io.questdb.griffin.SqlOptimiser.rewriteAggregate(SqlOptimiser.java:3300) at io.questdb.griffin.SqlOptimiser.rewriteSelectClause0(SqlOptimiser.java:3945) at io.questdb.griffin.SqlOptimiser.rewriteSelectClause(SqlOptimiser.java:3865) at io.questdb.griffin.SqlOptimiser.rewriteSelectClause(SqlOptimiser.java:3852) at io.questdb.griffin.SqlOptimiser.rewriteSelectClause(SqlOptimiser.java:3852) at io.questdb.griffin.SqlOptimiser.optimise(SqlOptimiser.java:4707) at io.questdb.griffin.SqlCompiler.compileExecutionModel0(SqlCompiler.java:1192) at io.questdb.griffin.SqlCompiler.compileExecutionModel(SqlCompiler.java:1181)...

### Describe the bug ``` QuestDB Exception: timeout, query aborted ``` ``` i.q.g.e.t.AsyncFilteredRecordCursor unexpected error [ex= io.questdb.cairo.CairoException: [-1] Invalid timestamp: INTC ] ``` ### To reproduce ``` create table test(time...

### Describe the bug ``` java.lang.ArrayIndexOutOfBoundsException: Index -1 out of bounds for length 0 at io.questdb.std.LongList.extendAndSet(LongList.java:232) at io.questdb.griffin.engine.functions.bool.InLongFunctionFactory.parseToLong(InLongFunctionFactory.java:89) at io.questdb.griffin.engine.functions.bool.InLongFunctionFactory.newInstance(InLongFunctionFactory.java:80) at io.questdb.griffin.FunctionParser.checkAndCreateFunction(FunctionParser.java:386) at io.questdb.griffin.FunctionParser.createFunction(FunctionParser.java:779) at io.questdb.griffin.FunctionParser.visit(FunctionParser.java:311) at io.questdb.griffin.PostOrderTreeTraversalAlgo.traverse(PostOrderTreeTraversalAlgo.java:86) at io.questdb.griffin.FunctionParser.parseFunction(FunctionParser.java:239)...

### Describe the bug Previous fix seems not complete: ``` QuestDB Exception: consuming input failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while...

### Describe the bug ``` java.lang.NullPointerException: Cannot read field "type" because "column" is null at io.questdb.griffin.SqlOptimiser.isSimpleIntegerColumn(SqlOptimiser.java:2071) at io.questdb.griffin.SqlOptimiser.pushOperationOutsideAgg(SqlOptimiser.java:3026) at io.questdb.griffin.SqlOptimiser.rewriteAggregate(SqlOptimiser.java:3314) at io.questdb.griffin.SqlOptimiser.rewriteSelectClause0(SqlOptimiser.java:3945) at io.questdb.griffin.SqlOptimiser.rewriteSelectClause(SqlOptimiser.java:3865) at io.questdb.griffin.SqlOptimiser.rewriteSelectClause(SqlOptimiser.java:3852) at io.questdb.griffin.SqlOptimiser.rewriteSelectClause(SqlOptimiser.java:3852) at io.questdb.griffin.SqlOptimiser.optimise(SqlOptimiser.java:4707)...

Hi, I notice one difference by applying differential testing with urllib.parse. Case 1: ``` URL = "https://@david:[email protected]" f = furl(URL) ``` Error: ValueError: Invalid port '[email protected]'. However, it should access...

### Describe the bug It does not show in the previous version (before 7.3.4). The sum result of float data sometimes is inaccurate. I understand floating calculation may have approximated...

Inconsistent results

1

Version: redisgraph:2.10.3 ``` 127.0.0.1:6379> GRAPH.QUERY Movies "MATCH (a)--(b:Genre)--(c) RETURN count(a)" 1) 1) "count(a)" 2) 1) 1) (integer) 87997 3) 1) "Cached execution: 1" 2) "Query internal execution time: 35.806160 milliseconds"...

Inconsistent results

2

RedisGraph 2.4.14, 2.8.24, 2.10.7 I would expect all the following queries to return the same result. But they output differently. ``` 127.0.0.1:6379> GRAPH.QUERY Test "MATCH (s1:A)--(s0:B)--(s2:A)

Inconsistent results when querying a symmetric path

4

RedisGraph 2.4.14, 2.8.24, 2.10.7 Query 1: **MATCH (s1:B)-[\*1..2]-(s3:A) RETURN count(s1)** Query 2: **MATCH (s3:A)-[\*1..2]-(s1:B) RETURN count(s1)** To reproduce: ``` GRAPH.QUERY g "CREATE (n1: A{name:56,id:2,undefined:18}), (n2: A{name:61,id:61}), (n3: A{name:49,id:92,undefined:16}), (n4: B{name:79,id:47}),...