Skip to content

Partial execution of the SQL query #332

@gryumov

Description

@gryumov

When executing the query, indexes for the test_log table were not created

using SQLite

const SQLite_CREATE =  """
    create table if not exists test_log (
        var_time       integer not null
       ,var_updated_at integer not null
       ,var_publisher  text    not null
       ,var_name       text    not null
       ,var_value      float   null
       ,var_count      integer null
    );

    create index if not exists idx_test_log_var_name
        on test_log (var_name);

    create index if not exists idx_test_log_var_time_var_name
        on test_log (var_time, var_name);
"""

connection = SQLite.DB("test.sqlite")

DBInterface.execute(connection, SQLite_CREATE)
sqlite> EXPLAIN QUERY PLAN select * from test_log where var_name = 'test';
QUERY PLAN
`--SCAN test_log

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions