Too many "OR" expression cause "Tree struct based executor must have executor id" error
Open
Nobody has claimed this yet.
affects-6.0
affects-6.1
component/compute
component/expression
severity/moderate
type/bug
- Dominant language
- C++
- Stars
- 1k
- Forks
- 423
- Avg merge
- 1d 15h
- Merged PRs (30d)
- 24
Description
mysql> create table t (a int);
mysql> alter table t set tiflash replica 1;
mysql> insert into t (1), (2);
mysql> select count(*) from t where
a >= 1 and a <= 1 or
a >= 2 and a <= 2 or
a >= 3 and a <= 3 or
a >= 4 and a <= 4 or
a >= 5 and a <= 5 or
a >= 6 and a <= 6 or
a >= 7 and a <= 7 or
a >= 8 and a <= 8 or
a >= 9 and a <= 9 or
a >= 10 and a <= 10 or
a >= 11 and a <= 11 or
a >= 12 and a <= 12 or
a >= 13 and a <= 13 or
a >= 14 and a <= 14 or
a >= 15 and a <= 15 or
a >= 16 and a <= 16 or
a >= 17 and a <= 17 or
a >= 18 and a <= 18 or
a >= 19 and a <= 19 or
a >= 20 and a <= 20 or
a >= 21 and a <= 21 or
a >= 22 and a <= 22 or
a >= 23 and a <= 23 or
a >= 24 and a <= 24 or
a >= 25 and a <= 25 or
a >= 26 and a <= 26 or
a >= 27 and a <= 27 or
a >= 28 and a <= 28 or
a >= 29 and a <= 29 or
a >= 30 and a <= 30 or
a >= 31 and a <= 31 or
a >= 32 and a <= 32 or
a >= 33 and a <= 33 or
a >= 34 and a <= 34 or
a >= 35 and a <= 35 or
a >= 36 and a <= 36 or
a >= 37 and a <= 37 or
a >= 38 and a <= 38 or
a >= 39 and a <= 39 or
a >= 40 and a <= 40 or
a >= 41 and a <= 41 or
a >= 42 and a <= 42 or
a >= 43 and a <= 43 or
a >= 44 and a <= 44 or
a >= 45 and a <= 45 or
a >= 46 and a <= 46 or
a >= 47 and a <= 47 or
a >= 48 and a <= 48 or
a >= 49 and a <= 49 or
a >= 50 and a <= 50 or
a >= 51 and a <= 51 or
a >= 52 and a <= 52 or
a >= 53 and a <= 53 or
a >= 54 and a <= 54 or
a >= 55 and a <= 55 or
a >= 56 and a <= 56 or
a >= 57 and a <= 57 or
a >= 58 and a <= 58 or
a >= 59 and a <= 59 or
a >= 60 and a <= 60 or
a >= 61 and a <= 61 or
a >= 62 and a <= 62 or
a >= 63 and a <= 63 or
a >= 64 and a <= 64 or
a >= 65 and a <= 65 or
a >= 66 and a <= 66 or
a >= 67 and a <= 67 or
a >= 68 and a <= 68 or
a >= 69 and a <= 69 or
a >= 70 and a <= 70 or
a >= 71 and a <= 71 or
a >= 72 and a <= 72 or
a >= 73 and a <= 73 or
a >= 74 and a <= 74 or
a >= 75 and a <= 75 or
a >= 76 and a <= 76 or
a >= 77 and a <= 77 or
a >= 78 and a <= 78 or
a >= 79 and a <= 79 or
a >= 80 and a <= 80 or
a >= 81 and a <= 81 or
a >= 82 and a <= 82 or
a >= 83 and a <= 83 or
a >= 84 and a <= 84 or
a >= 85 and a <= 85 or
a >= 86 and a <= 86 or
a >= 87 and a <= 87 or
a >= 88 and a <= 88 or
a >= 89 and a <= 89 or
a >= 90 and a <= 90 or
a >= 91 and a <= 91 or
a >= 92 and a <= 92 or
a >= 93 and a <= 93 or
a >= 94 and a <= 94 or
a >= 95 and a <= 95 or
a >= 96 and a <= 96 or
a >= 97 and a <= 97 or
a >= 98 and a <= 98 or
a >= 99 and a <= 99 or
a >= 100 and a <= 10 or
a >= 101 and a <= 10 or
a >= 102 and a <= 10 or
a >= 103 and a <= 10 or
a >= 104 and a <= 10 or
a >= 105 and a <= 10 or
a >= 106 and a <= 10 or
a >= 107 and a <= 10 or
a >= 108 and a <= 10 or
a >= 109 and a <= 10 or
a >= 110 and a <= 11 or
a >= 111 and a <= 11 or
a >= 112 and a <= 11 or
a >= 113 and a <= 11 or
a >= 114 and a <= 11 or
a >= 115 and a <= 11 or
a >= 116 and a <= 11 or
a >= 117 and a <= 11 or
a >= 118 and a <= 11 or
a >= 119 and a <= 11 or
a >= 120 and a <= 12 or
a >= 121 and a <= 12 or
a >= 122 and a <= 12 or
a >= 123 and a <= 12 or
a >= 124 and a <= 12 or
a >= 125 and a <= 12 or
a >= 126 and a <= 12 or
a >= 127 and a <= 12 or
a >= 128 and a <= 12 or
a >= 129 and a <= 12 or
a >= 130 and a <= 13 or
a >= 131 and a <= 13 or
a >= 132 and a <= 13 or
a >= 133 and a <= 13 or
a >= 134 and a <= 13 or
a >= 135 and a <= 13 or
a >= 136 and a <= 13 or
a >= 137 and a <= 13 or
a >= 138 and a <= 13 or
a >= 139 and a <= 13 or
a >= 140 and a <= 14 or
a >= 141 and a <= 14 or
a >= 142 and a <= 14 or
a >= 143 and a <= 14 or
a >= 144 and a <= 14 or
a >= 145 and a <= 14 or
a >= 146 and a <= 14 or
a >= 147 and a <= 14 or
a >= 148 and a <= 14 or
a >= 149 and a <= 14 or
a >= 150 and a <= 15 or
a >= 151 and a <= 15 or
a >= 152 and a <= 15 or
a >= 153 and a <= 15 or
a >= 154 and a <= 15 or
a >= 155 and a <= 15 or
a >= 156 and a <= 15 or
a >= 157 and a <= 15 or
a >= 158 and a <= 15 or
a >= 159 and a <= 15 or
a >= 160 and a <= 16 or
a >= 161 and a <= 16 or
a >= 162 and a <= 16 or
a >= 163 and a <= 16 or
a >= 164 and a <= 16 or
a >= 165 and a <= 16 or
a >= 166 and a <= 16 or
a >= 167 and a <= 16 or
a >= 168 and a <= 16 or
a >= 169 and a <= 16 or
a >= 170 and a <= 17 or
a >= 171 and a <= 17 or
a >= 172 and a <= 17 or
a >= 173 and a <= 17 or
a >= 174 and a <= 17 or
a >= 175 and a <= 17 or
a >= 176 and a <= 17 or
a >= 177 and a <= 17 or
a >= 178 and a <= 17 or
a >= 179 and a <= 17 or
a >= 180 and a <= 18 or
a >= 181 and a <= 18 or
a >= 182 and a <= 18 or
a >= 183 and a <= 18 or
a >= 184 and a <= 18 or
a >= 185 and a <= 18 or
a >= 186 and a <= 18 or
a >= 187 and a <= 18 or
a >= 188 and a <= 18 or
a >= 189 and a <= 18 or
a >= 190 and a <= 19 or
a >= 191 and a <= 19 or
a >= 192 and a <= 19 or
a >= 193 and a <= 19 or
a >= 194 and a <= 19 or
a >= 195 and a <= 19 or
a >= 196 and a <= 19 or
a >= 197 and a <= 19 or
a >= 198 and a <= 19 or
a >= 199 and a <= 19 or
a >= 200 and a <= 20 or
a >= 201 and a <= 20 or
a >= 202 and a <= 20 or
a >= 203 and a <= 20 or
a >= 204 and a <= 20 or
a >= 205 and a <= 20 or
a >= 206 and a <= 20 or
a >= 207 and a <= 20 or
a >= 208 and a <= 20 or
a >= 209 and a <= 20 or
a >= 210 and a <= 21 or
a >= 211 and a <= 21 or
a >= 212 and a <= 21 or
a >= 213 and a <= 21 or
a >= 214 and a <= 21 or
a >= 215 and a <= 21 or
a >= 216 and a <= 21 or
a >= 217 and a <= 21 or
a >= 218 and a <= 21 or
a >= 219 and a <= 21 or
a >= 220 and a <= 22 or
a >= 221 and a <= 22 or
a >= 222 and a <= 22 or
a >= 223 and a <= 22 or
a >= 224 and a <= 22 or
a >= 225 and a <= 22 or
a >= 226 and a <= 22 or
a >= 227 and a <= 22 or
a >= 228 and a <= 22 or
a >= 229 and a <= 22 or
a >= 230 and a <= 23 or
a >= 231 and a <= 23 or
a >= 232 and a <= 23 or
a >= 233 and a <= 23 or
a >= 234 and a <= 23 or
a >= 235 and a <= 23 or
a >= 236 and a <= 23 or
a >= 237 and a <= 23 or
a >= 238 and a <= 23 or
a >= 239 and a <= 23 or
a >= 240 and a <= 24 or
a >= 241 and a <= 24 or
a >= 242 and a <= 24 or
a >= 243 and a <= 24 or
a >= 244 and a <= 24 or
a >= 245 and a <= 24 or
a >= 246 and a <= 24 or
a >= 247 and a <= 24 or
a >= 248 and a <= 24 or
a >= 249 and a <= 24 or
a >= 250 and a <= 25 or
a >= 251 and a <= 25 or
a >= 252 and a <= 25 or
a >= 253 and a <= 25 or
a >= 254 and a <= 25 or
a >= 255 and a <= 25 or
a >= 256 and a <= 25 or
a >= 257 and a <= 25 or
a >= 258 and a <= 25 or
a >= 259 and a <= 25 or
a >= 260 and a <= 26
;
ERROR 1105 (HY000): [FLASH:Coprocessor:BadRequest] Tree struct based executor must have executor id
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No source file, test, or entry point is named. Start by running the provided TiFlash SQL reproduction and trace where the "Tree struct based executor must have executor id" error is produced; done means the query executes successfully without that error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, mysql
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100