Skip to content

[sqlite views] SQLite views show no rows. #1222

Closed
@frosencrantz

Description

Small description
VisiData shows no rows in a view. The index sheet shows the zero rows in views.

Expected result
VisiData shows all the rows in a view. The index sheet shows the correct count of rows in views.

Actual result with screenshot
Sorry no screenshot, but this will look the same as #1111

Steps to reproduce with sample data and a .vd
It is easy to create sample data with the steps below, using the sample_data/employees.sqlite file.

cp sample_data/employees.sqlite employees_view.sqlite
vd
gCtrl-X, Import library: sqlite3
exec-expr: sqlite3.connect('employees_view.sqlite'); con.cursor().execute('create view emp_view as select * from emp'): con.commit()
Ctrl-O: open the file: employees_view.sqlite

VisiData should show that the emp and emp_view sheets have the same columns and rows, but it will show that emp_view is empty and has no rows.

Additional context
Latest develop branch version of VisiData.

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions