@Test public void update_limit() { SQLUpdateClause clause = new SQLUpdateClause(null, createTemplates(), survey1); clause.set(survey1.name, "Bob"); clause.limit(5); assertEquals("update top 5 SURVEY\n" + "set NAME = ?", clause.toString()); }
@Test @IncludeIn({CUBRID, H2, MYSQL, ORACLE, SQLSERVER}) public void update_limit() { assertEquals(1, insert(survey).values(2, "A","B").execute()); assertEquals(1, insert(survey).values(3, "B","C").execute()); assertEquals(2, update(survey).set(survey.name, "S").limit(2).execute()); }