sqlite - Query Plans

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 47,53 ****
  
      foreach n1 where n1.name='alice' do:
        foreach e where e.orig=n1.id do:
!         foreach n2 where n2.id=e.dest do:
            return n1.*, n2.*, e.*
          end
        end
--- 47,53 ----
  
      foreach n1 where n1.name='alice' do:
        foreach e where e.orig=n1.id do:
!         foreach n2 where n2.id=e.dest and n2.name='bob' do:
            return n1.*, n2.*, e.*
          end
        end