@Test public void delete_limit() { SQLDeleteClause clause = new SQLDeleteClause(null, createTemplates(), survey1); clause.where(survey1.name.eq("Bob")); clause.limit(5); assertEquals("delete top 5 from SURVEY\n" + "where SURVEY.NAME = ?", clause.toString()); }
@Test @IncludeIn({CUBRID, H2, MYSQL, ORACLE, SQLSERVER}) public void delete_limit() { insert(survey).values(2, "A","B").execute(); insert(survey).values(3, "B","C").execute(); insert(survey).values(4, "D","E").execute(); assertEquals(2, delete(survey).limit(2).execute()); }