Skip to content

[BUG] Pagination in V2 doesn't track mapping change #1569

@Yury-Fridlyand

Description

@Yury-Fridlyand

What is the bug?

Columns added to the table (index) aren't queried.

How can one reproduce the bug?

Steps to reproduce the behavior:

  1. Create an empty index
PUT http://localhost:9200/pmtest
  1. Add few docs
POST http://localhost:9200/pmtest/_doc?refresh=true
{
    "age": 30
}
POST http://localhost:9200/pmtest/_doc?refresh=true
{
    "age": 32
}

  1. Starting paging
POST http://localhost:9200/_plugins/_sql
{
    "query": "SELECT * from pmtest",
    "fetch_size": 1
}
  1. Add a doc with another field
POST http://localhost:9200/pmtest/_doc?refresh=true
{
    "name": "pewpew"
}
  1. Keep paging till the end

What is the expected behavior?

Last doc should be returned as well

What is your host/environment?

feature/pagination/P1 @ 7dd445c

Do you have any additional context?

Project list should be refreshed on every request

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingpaginationPagination feature, ref #656

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions