[MDEV-32753] Spider engine does not load in ORACLE mode Created: 2023-11-09 Updated: 2024-01-16 Resolved: 2023-11-21 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - Spider |
| Affects Version/s: | 10.10, 10.11, 11.0, 11.1, 11.2 |
| Fix Version/s: | 10.11.7, 11.0.5, 11.1.4, 11.2.3 |
| Type: | Bug | Priority: | Critical |
| Reporter: | Elena Stepanova | Assignee: | Yuchen Pei |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | regression | ||
| Issue Links: |
|
||||||||||||||||||||||||||||
| Description |
|
Spider does not load if the server is running with sql_mode=ORACLE. It is true both when the server is started in ORACLE mode and plugin-load-add=ha_spider or when they are set/loaded at runtime. I didn't check, but it must have started around the same time as other similar issues, with
|
| Comments |
| Comment by Yuchen Pei [ 2023-11-10 ] | ||||||||
|
Hi holyfoot, ptal thanks:
| ||||||||
| Comment by Sergei Golubchik [ 2023-11-12 ] | ||||||||
|
wouldn't it be simpler to reset MODE_ORACLE bit before executing your init queries? | ||||||||
| Comment by Yuchen Pei [ 2023-11-14 ] | ||||||||
|
Good point serg. I updated my patch, holyfoot ptal thanks
| ||||||||
| Comment by Alexey Botchkov [ 2023-11-20 ] | ||||||||
|
ok to push. | ||||||||
| Comment by Yuchen Pei [ 2023-11-21 ] | ||||||||
|
Pushed 45fadb64c1c4ad7c71fea874d51c83b1d11b4e63 to 10.11 |