| @@ 215-224 (lines=10) @@ | ||
| 212 | $query->sql($parameters)); |
|
| 213 | } |
|
| 214 | ||
| 215 | public function testNullLimit() { |
|
| 216 | $query = new SQLSelect(); |
|
| 217 | $query->setFrom("MyTable"); |
|
| 218 | $query->setLimit(null); |
|
| 219 | ||
| 220 | $this->assertSQLEquals( |
|
| 221 | 'SELECT * FROM MyTable', |
|
| 222 | $query->sql($parameters) |
|
| 223 | ); |
|
| 224 | } |
|
| 225 | ||
| 226 | public function testZeroLimit() { |
|
| 227 | $query = new SQLSelect(); |
|
| @@ 226-235 (lines=10) @@ | ||
| 223 | ); |
|
| 224 | } |
|
| 225 | ||
| 226 | public function testZeroLimit() { |
|
| 227 | $query = new SQLSelect(); |
|
| 228 | $query->setFrom("MyTable"); |
|
| 229 | $query->setLimit(0); |
|
| 230 | ||
| 231 | $this->assertSQLEquals( |
|
| 232 | 'SELECT * FROM MyTable', |
|
| 233 | $query->sql($parameters) |
|
| 234 | ); |
|
| 235 | } |
|
| 236 | ||
| 237 | public function testZeroLimitWithOffset() { |
|
| 238 | if(!(DB::get_conn() instanceof MySQLDatabase || DB::get_conn() instanceof SQLite3Database |
|