diff options
Diffstat (limited to 'modules/simpletest/tests/database_test.test')
-rw-r--r-- | modules/simpletest/tests/database_test.test | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/modules/simpletest/tests/database_test.test b/modules/simpletest/tests/database_test.test index 16199c345..10afff465 100644 --- a/modules/simpletest/tests/database_test.test +++ b/modules/simpletest/tests/database_test.test @@ -2216,6 +2216,43 @@ class DatabaseSelectPagerDefaultTestCase extends DatabaseTestCase { ->fetchCol(); $this->assertEqual($ages, array('George', 'Ringo'), t('Pager query with having expression returned the correct ages.')); } + + /** + * Confirm that every pager gets a valid non-overlaping element ID. + */ + function testElementNumbers() { + $_GET['page'] = '3, 2, 1, 0'; + + $name = db_select('test', 't')->extend('PagerDefault') + ->element(2) + ->fields('t', array('name')) + ->orderBy('age') + ->limit(1) + ->execute() + ->fetchField(); + $this->assertEqual($name, 'Paul', t('Pager query #1 with a specified element ID returned the correct results.')); + + // Setting an element smaller than the previous one + // should not overwrite the pager $maxElement with a smaller value. + $name = db_select('test', 't')->extend('PagerDefault') + ->element(1) + ->fields('t', array('name')) + ->orderBy('age') + ->limit(1) + ->execute() + ->fetchField(); + $this->assertEqual($name, 'George', t('Pager query #2 with a specified element ID returned the correct results.')); + + $name = db_select('test', 't')->extend('PagerDefault') + ->fields('t', array('name')) + ->orderBy('age') + ->limit(1) + ->execute() + ->fetchField(); + $this->assertEqual($name, 'John', t('Pager query #3 with a generated element ID returned the correct results.')); + + unset($_GET['page']); + } } |