list_limit for domain doesn't work correct

[wangxiyuan]

This bug is found during adding FK for test: https://review.openstack.org/#/c/558029/

Reproduce:
1. suppose there are 4 domain in your openstack env.
2. set the config option list_limit in [resource] section to 3. Then restart Keystone.
   [resource] list_limit = 3
3. try to list domain.
   openstack domain list

Expect result: three domains should return.

Actual result only two domains returned.

reproduce step: http://paste.openstack.org/show/718138/

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/558150

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/558151

[Lance Bragstad (lbragstad)]

I was able to recreate this locally [0].

[0] http://paste.openstack.org/show/718197/

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/558150
Committed: https://git.openstack.org/cgit/openstack/keystone/commit/?id=c522fc3bb728eed1838aadc708bbd59763544cfe
Submitter: Zuul
Branch: master

commit c522fc3bb728eed1838aadc708bbd59763544cfe
Author: wangxiyuan <email address hidden>
Date: Mon Apr 2 10:42:47 2018 +0800

    Expose a bug that list_limit doesn't work correctly

    The list_limit for domain list doesn't work
    correctly. The return count will less than
    list_limit if the sql query contains root domain

    This patch expose this bug and it will be fixed
    in the following patch.

    Co-Authored-By: Lance Bragstad<email address hidden>

    Partial-bug: #1760521

    Change-Id: Ib28793c97f1b730cb3b83b046e653a7b660af875

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/558151
Committed: https://git.openstack.org/cgit/openstack/keystone/commit/?id=245a0c718b0a82419a2d34311d3a2b5c19021fa9
Submitter: Zuul
Branch: master

commit 245a0c718b0a82419a2d34311d3a2b5c19021fa9
Author: wangxiyuan <email address hidden>
Date: Mon Apr 2 10:00:50 2018 +0800

    Fix list_limit doesn't work correctly for domain

    This patch changed the sql query for domain list
    to ensure the return count is correct if list_limit
    is set for resource.

    Closes-bug: #1760521

    Change-Id: I690a9815fe2c35e6191ab3ac789e34736e0d637c

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/keystone 14.0.0.0b1 development milestone.