Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy
SQL

SQL Server: Fix a Graph Table Query Returning Duplicate Edges

- 21.11.26 - ErcanOPAK

🗄️ SQL Server: Fix a Graph Table Query Returning Duplicate Edges

SQL Server’s graph database features let you traverse relationships with a MATCH clause, but a pattern that checks for a relationship in both directions using two separate MATCH clauses joined with OR can match the same underlying edge row twice — once satisfying each half of the OR — so the result set returns what looks like two distinct relationships when it’s actually one edge counted from both traversal directions.

🔎 The Problem

SELECT Person1.Name, Person2.Name
FROM Person Person1, Connection, Person Person2
WHERE MATCH(Person1-(Connection)->Person2)
   OR MATCH(Person2-(Connection)->Person1);
-- a single bidirectional-looking edge can satisfy BOTH halves
-- of the OR, so it's returned twice in the result set

✅ Fix: Deduplicate by Edge Identity, Not by Row Shape

  • Use SELECT DISTINCT on the edge’s own identity column ($edge_id) when a query’s pattern could plausibly match the same edge from more than one direction, rather than assuming each returned row is a unique relationship.
  • Where the relationship is inherently bidirectional (a “connected to” edge), model it with a single directionless edge table and query it once, instead of relying on two opposite-direction MATCH clauses combined with OR.
  • Test traversal queries against a small, manually-verified graph where you know the exact expected edge count, since duplicate-looking results from a bidirectional OR pattern are easy to miss when eyeballing a larger result set.

🚨 Why This Is Dangerous

  • Code that aggregates or counts relationships from a graph query without deduplicating by edge identity can silently double-count connections in anything built on top of it — a mutual-connections feature or a relationship-strength score — producing numbers that look plausible but are systematically inflated.

A MATCH pattern tells SQL Server how to walk the graph, not how many times it’s allowed to arrive at the same edge from a different direction — that part is still on you to deduplicate.

— Database Engineer

Related posts:

SQL Server: Why Rebuilding a Clustered Index Doesn't Fix Fragmented Non-Clustered Indexes

SQL Server: Why Rebuilding a Clustered Index Doesn't Fix Fragmented Non-Clustered Indexes

SQL: Use GROUP BY to Aggregate Data

SQL: Use GROUP BY to Aggregate Data

SQL Window Functions: Revolutionizing Reporting Without Subqueries

SQL Window Functions: Revolutionizing Reporting Without Subqueries

Views: 4

Post navigation

Asp.Net Core: Fix gRPC Streaming Hanging After a Client Cancels
Windows 11: Fix File Explorer Tabs Forgetting Their Pinned Order

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,068)
  • Get the User Name and Domain Name from an Email Address in SQL (990)
  • How to add default value for Entity Framework migrations for DateTime and Bool (986)
  • Get the First and Last Word from a String or Sentence in SQL (865)
  • How to select distinct rows in a datatable in C# (859)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (661)
  • Add Constraint to SQL Table to ensure email contains @ (619)
  • Average of all values in a column that are not zero in SQL (576)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (553)
  • Find numbers with more than two decimal places in SQL (481)

Recent Posts

  • Network Speed Monitor Windows Application v2.5.1
  • Ağ Hızı İzleyici Windows Uygulaması v2.5.1
  • How to make theater mode the default for Youtube
  • The AI Prompt That Audits a Function for Thread-Safety Gaps
  • Ajax: Fix a Fetch Request Caching a Response Despite No-Store
  • WordPress: Fix a Navigation Block Losing Submenu Items After Sync
  • Visual Studio: Fix CodeLens Reference Counts Stuck at Stale Numbers
  • C#: Fix a UTF-8 String Literal Behaving Differently in a Switch
  • Photoshop: Fix a Liquify Mesh Snapping Back on a Smart Object
  • The AI Prompt That Turns a Crash Dump Into a Short Repro Script

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,068)
  • Get the User Name and Domain Name from an Email Address in SQL (990)
  • How to add default value for Entity Framework migrations for DateTime and Bool (986)
  • Get the First and Last Word from a String or Sentence in SQL (865)
  • How to select distinct rows in a datatable in C# (859)

Recent Posts

  • Network Speed Monitor Windows Application v2.5.1
  • Ağ Hızı İzleyici Windows Uygulaması v2.5.1
  • How to make theater mode the default for Youtube
  • The AI Prompt That Audits a Function for Thread-Safety Gaps
  • Ajax: Fix a Fetch Request Caching a Response Despite No-Store

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com