Hello, is the following supported in 5.6.2 ?
START TRANSACTION; SELECT * FROM tableName FOR UPDATE SKIP LOCKED;
I think you can use the IndexHint support for this: https://www.llblgen.com/Documentation/5.6/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/QuerySpec/gencode_queryspec_generalusage.htm#index-hint-example-mysql-specific
(so specify FOR UPDATE SKIP LOCKED instead of an index hint)
If FOR UPDATE SKIP LOCKED is a query directive, you can also use query hints: https://www.llblgen.com/Documentation/5.6/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/QuerySpec/gencode_queryspec_generalusage.htm#specifying-query--optimizer-hints-sql-server-mysql-oracle
Thanks, I will experiment with it and let you guys know how it went.