Forum: Building VoltDB Applications

Post: 'FOR' clause in VoltDB

'FOR' clause in VoltDB
sanket
Nov 18, 2016
Does VoltDB sqlcmd supports FOR cluase like Mysql? If not, is there any alternative such that the particular SELECT query should be executed non concurrently in multi-threaded environment.
jhugg
Nov 18, 2016
I'm not sure I 100% follow. All VoltDB queries are executed (effectively) serially, across any needed partitions. There is no (current) way to change that behavior.

What kind of thing are you trying to accomplish with this feature? Maybe we can help more with some context?
sanket
Nov 21, 2016
I am evaluating TPCC queries. I am fetching one parameter from one table, increment it by one and insert it into another table. I am using SELECT to fetch the parameter. In multi-threaded environment, two or more threads can read the same value of the parameter and try to insert that same value serially into another table. As this parameter value is belonging to primary key, it throws an error of 'Constrains Violation'. Hence I want that the particular SELECT has to be executed serially among multiple threads.