Yuancheng Jiang

Version: 0.6.2 Query 1: ``` g.V().as('cccccccc').hasLabel('A').emit(__.loops().is(gte(1))).repeat(__.outE().inV()).times(2).emit(__.loops().is(gte(1))).repeat(__.outE().inV()).times(2).as('hketwcbf').hasLabel('B').bothE().dedup().by(__.path()).otherV().as('test').where(__.select('test').where(eq('cccccccc'))).select('hketwcbf').count() ``` Query 2: ``` g.V().as('cccccccc').hasLabel('A').bothE().dedup().by(__.path()).otherV().as('hketwcbf').hasLabel('B').emit(__.loops().is(gte(1))).repeat(__.inE().outV()).times(2).emit(__.loops().is(gte(1))).repeat(__.inE().outV()).times(2).as('test').where(__.select('test').where(eq('cccccccc'))).select('hketwcbf').count() ``` They are equivalent queries that have symmetric graph pattern. They would look like these in Cypher: ``` Q1:...

Seems to be an unexpected error

1

Version: v2.13.0 ``` postgres=# MATCH (a)-[]->(b) RETURN count(a); count ------- 100 (1 row) postgres=# MATCH (a)-[*1..1]->(b) RETURN count(a); count ------- 100 (1 row) postgres=# MATCH (a),(a)-[]->(b) RETURN count(a); count -------...

Inconsistent results in equivalent queries

1

### Bug Type (问题类型) gremlin (结果不合预期) ### Before submit - [X] 我已经确认现有的 [Issues](https://github.com/apache/hugegraph/issues) 与 [FAQ](https://hugegraph.apache.org/docs/guides/faq/) 中没有相同 / 重复问题 (I have confirmed and searched that there are no similar problems in...

[Bug] Inconsistent results when executing equivalent queries

5

### Bug Type (问题类型) gremlin (结果不合预期) ### Before submit - [x] 我已经确认现有的 [Issues](https://github.com/apache/hugegraph/issues) 与 [FAQ](https://hugegraph.apache.org/docs/guides/faq/) 中没有相同 / 重复问题 (I have confirmed and searched that there are no similar problems in...

Range: from 186950 to 296808 (296808 in total) [186950] 0x7efd48347a13: 48 63 d0 movslq %eax,%rdx [186951] 0x7efd48347a16: 48 8d 05 43 28 20 00 lea 0x202843(%rip),%rax # 0x000000000020284a [186952] 0x7efd48347a1d:...

Incorrect result with window function and table joins

2

### To reproduce ``` DROP TABLE IF EXISTS test; CREATE TABLE test (c0 int, c1 symbol); INSERT INTO test (1, 'a'); INSERT INTO test (2, 'b'); INSERT INTO test (1,...

Incorrect result when having NULL within the CASE...WHEN clause

3

### To reproduce ``` CREATE TABLE test (c0 INT); INSERT INTO test VALUES (NULL); SELECT CASE WHEN c0 IS NULL THEN NULL ELSE c0 IN (0) END FROM test; ```...

Unexpected Result with `null` in equality operator.

1

**Bug Description** Unexpected Result with `null` in equality operator: **To Reproduce** ``` select null=null; ``` Result: `False` **Expected Behavior** I guess the result should be `None` according to SQL standards...

Incorrect result with `ORDER BY` in `OVER(PARTITION BY ...)`

3

### Describe the bug The result is not expected. ### Error message/log ```text Actual result: [(1,),(2,)] ``` ### To Reproduce ``` CREATE TABLE test (c_0 INT); INSERT INTO test VALUES...