k.1.0.0-M01.source-code.JoinAcceptance.feature Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of tck Show documentation

openCypher Technology Compliance Kit

The newest version!

#
# Copyright 2016 "Neo Technology",
# Network Engine for Objects in Lund AB (http://neotechnology.com)
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#

Feature: ValueHashJoinAcceptance

  Scenario: Find friends of others
    Given an empty graph
    And having executed:
      """
      CREATE (:A {id: 1}),
             (:A {id: 2}),
             (:B {id: 2}),
             (:B {id: 3})
      """
    When executing query:
      """
      MATCH (a:A), (b:B)
      WHERE a.id = b.id
      RETURN a, b
      """
    Then the result should be:
      | a            | b            |
      | (:A {id: 2}) | (:B {id: 2}) |
    And no side effects

  Scenario: Should only join when matching
    Given an empty graph
    And having executed:
      """
      UNWIND range(0, 1000) AS i
      CREATE (:A {id: i})
      MERGE (:B {id: i % 10})
      """
    When executing query:
      """
      MATCH (a:A), (b:B)
      WHERE a.id = b.id
      RETURN a, b
      """
    Then the result should be:
      | a            | b            |
      | (:A {id: 0}) | (:B {id: 0}) |
      | (:A {id: 1}) | (:B {id: 1}) |
      | (:A {id: 2}) | (:B {id: 2}) |
      | (:A {id: 3}) | (:B {id: 3}) |
      | (:A {id: 4}) | (:B {id: 4}) |
      | (:A {id: 5}) | (:B {id: 5}) |
      | (:A {id: 6}) | (:B {id: 6}) |
      | (:A {id: 7}) | (:B {id: 7}) |
      | (:A {id: 8}) | (:B {id: 8}) |
      | (:A {id: 9}) | (:B {id: 9}) |
    And no side effects