wow, that's really interesting. Thanks for saving my time.
On 16 August 2014 20:56, DuyHai Doan <doanduy...@gmail.com> wrote: > You're running into funny results due to the way CQL3 handles statements > in batches. Read this: > https://github.com/doanduyhai/Achilles/wiki/Batch-Mode#statements-ordering > > There is already a JIRA opened but according to the developers this is the > expected behavior. > > In your example, largest value for column "count" is 9 and largest value > for "text" is "123" (sorted by lexicographic order) > > > On Sat, Aug 16, 2014 at 1:45 PM, 廖欽啟 <missionaryl...@gmail.com> wrote: > >> Hi, >> >> I'm trying this cql against cassandra 2.0.9: >> BEGIN BATCH >> INSERT INTO cqlengine_test_lwt.test_if_not_exists_model (id, count, >> text) VALUES (1, 8, '123'); >> INSERT INTO cqlengine_test_lwt.test_if_not_exists_model (id, count, >> text) VALUES (1, 9, '111'); >> APPLY BATCH; >> >> In this case, id is the primary key. >> And when querying the record with id=1, the result I got is (id=1, >> count=9, text='123'), while I expect >> the result should be (id=1, count=9, text='111'). >> >> Did I miss anything or is this result expected? >> >> B.R, >> Mission. >> > >