add full sql test case for transactions
@@ -124,6 +124,21 @@ public class RemoteTransactionSupportTest {
}
+ @Test
+ public void testQueryUpdateCreatedInTxSQLTransaction() {
+ database.begin();
+
+ database.command("insert into SomeTx set name ='Jane' ");
+
+ OResultSet result = database.command("update SomeTx set name='July' where name = 'Jane' ");
+ assertTrue(result.hasNext());
+ assertEquals((long) result.next().getProperty("count"), 1L);
+ OResultSet result1 = database.query("select from SomeTx where name='July'");
+ assertTrue(result1.hasNext());
+ assertEquals(result1.next().getProperty("name"), "July");
+ assertFalse(result.hasNext());
+ }
+
@After
public void after() {
database.close();
