search

penberg / limbo

Limbo is a work-in-progress, in-process OLTP database management system, compatible with SQLite.
MIT License
896 stars 49 forks source link

Fixes EXPLAIN to indent loops like SQLite does #111

Closed Ramkarthik closed 1 month ago

Ramkarthik commented 1 month ago

Fixes #108

With this change, the EXPLAIN output looks like below:

> EXPLAIN SELECT id FROM users;

addr  opcode         p1    p2    p3    p4             p5  comment
----  -------------  ----  ----  ----  -------------  --  -------
0    Init           0     10    0       0   Start at 10
1    OpenReadAsync  0     2     0       0   root=2
2    OpenReadAwait  0     0     0       0
3    RewindAsync    0     0     0       0
4    RewindAwait    0     9     0       0
5      RowId          0     0     0       0
6      ResultRow      0     1     0       0   output=r[0..1]
7    NextAsync      0     0     0       0
8    NextAwait      0     4     0       0
9    Halt           0     0     0       0
10   Transaction    0     0     0       0
11   Goto           0     1     0       0
penberg commented 1 month ago

Thanks @Ramkarthik!

pereman2 commented 1 month ago

https://github.com/penberg/limbo/issues/112 follow up