| | 144 | // Ticket #668 |
| | 145 | public function testKeywordUsageInStringParam() |
| | 146 | { |
| | 147 | $this->assertSqlGeneration( |
| | 148 | "SELECT u.name FROM CmsUser u WHERE u.name LIKE '%foo OR bar%'", |
| | 149 | "SELECT cu.name AS cu__name FROM cms_user cu WHERE cu.name LIKE '%foo OR bar%'" |
| | 150 | ); |
| | 151 | } |
| | 152 | |
| | 153 | |
| | 154 | // Ticket #973 |
| | 155 | public function testSingleInValueWithoutSpace() |
| | 156 | { |
| | 157 | $this->assertSqlGeneration( |
| | 158 | "SELECT u.name FROM CmsUser u WHERE u.id IN(46)", |
| | 159 | "SELECT cu.name AS cu__name FROM cms_user cu WHERE cu.id IN (46)" |
| | 160 | ); |
| | 161 | } |
| | 162 | |
| | 163 | |
| | 164 | // Ticket 894 |
| | 165 | public function testBetweenDeclarationWithInputParameter() |
| | 166 | { |
| | 167 | $this->assertSqlGeneration( |
| | 168 | "SELECT u.name FROM CmsUser u WHERE u.id BETWEEN ? AND ?", |
| | 169 | "SELECT cu.name AS cu__name FROM cms_user cu WHERE cu.id BETWEEN ? AND ?" |
| | 170 | ); |
| | 171 | } |
| | 172 | |
| | 173 | |
