SQLite Forum

Possible Bug - View behaves differently to Table in SELECT
Login
Hi Richard,

Yes, this is precisely my use-case.  SQLite is doing the heavy lifting building and analysing trees and tracing dependencies through a directed acyclic graph.

The query flow graph is [here]( https://www.dropbox.com/s/0s3pbi4yjdn6qj9/Query%20Data%20Flow.png?dl=0)

(This was generated as a graphviz.dot by the view __dotViewDependencies__ interrogating sqlite_master)

David