Retest all table checks with partitioned tables

[mfvanek]

See relkind
We need to make sure that the appropriate checks work for partitioned tables

[asharan2buff]

Hello!! I can take this up

[mfvanek]

Hi @asharan2buff
I've assigned issue to you

[mfvanek]

@asharan2buff please provide here sql queries to create a database for testing and then retest each query that retrieves information about tables

[asharan2buff]

@mfvanek could you expand a bit more on how to proceed. From what I understood so far, Do we need to add relkind ='p' check in all tests?

[mfvanek]

Do we need to add relkind ='p' check in all tests?

No, we don't, not right now.

Sample scenario:

1. Search for sql queries with relkind == 'r'
   https://github.com/search?q=repo%3Amfvanek%2Fpg-index-health-sql%20relkind%20&type=code

2. For each found check prepare a test with partitioned table.
   See https://github.com/mfvanek/pg-index-health-demo/tree/master/db-migrations/src/main/resources/db/changelog/sql
   or tests in https://github.com/mfvanek/pg-index-health/tree/master/pg-index-health-core/src/testFixtures/java/io/github/mfvanek/pg/support/statements

3. We need to figure out whether current implementation able to find problems with partitioned tables or not.

4. After that we can discuss the results and further steps.

[asharan2buff]

Got it...

[mfvanek]

@asharan2buff any updates?