alter-lock option is not generating proper queries
General
Escalation
General
Escalation
Description
When using the option --alter-lock=NONE|SHARED|EXCLUSIVE, pstress is generating incorrect queries as:
ALTER TABLE tt_1 DROP INDEX tt_1i0, LOCK=NONE|SHARED|EXCLUSIVE, ALGORITHM=COPY
ErrorYou have an error in your SQL syntax; check the manual that corresponds toyourMySQL server version for the right syntax touse near '|SHARED|EXCLUSIVE, ALGORITHM=COPY' at line 1S COMMIT rows:0
Environment
None
Activity
Show:
mohit.joshi
January 17, 2022 at 10:27 AM
(edited)
Hi @Manish Chawla, The supported option in pstress are
--alter-lock DEFAULT
--alter-lock NONE
--alter-lock SHARED
--alter-lock EXCLUSIVE
--alter-lock all
Default value is all. This will randomly pick all 4 types of lock mode. As I can see, you are passing --alter-lock DEFAULT|NONE|SHARED|EXCLUSIVE which is not the supported format
When using the option --alter-lock=NONE|SHARED|EXCLUSIVE, pstress is generating incorrect queries as:
ALTER TABLE tt_1 DROP INDEX tt_1i0, LOCK=NONE|SHARED|EXCLUSIVE, ALGORITHM=COPY Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '|SHARED|EXCLUSIVE, ALGORITHM=COPY' at line 1 S COMMIT rows:0