[MDEV-30903] accessing user variables in views Created: 2023-03-22 Updated: 2023-05-19 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Views |
| Affects Version/s: | 10.4, 10.10.3 |
| Fix Version/s: | 10.4 |
| Type: | Bug | Priority: | Minor |
| Reporter: | Jan | Assignee: | Oleksandr Byelkin |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | Question | ||
| Environment: |
Windows |
||
| Description |
|
According to documentation, regarding Views: "Within a stored program, the definition cannot refer to program parameters or local variables". Apparently in practice that does not work, following code completely bypass that rule:
Honestly, I am not complaining for that particular inconsistency, I however wonder if you intend to keep it or fix it, in future releases? |
| Comments |
| Comment by Sergei Golubchik [ 2023-05-19 ] |
|
At the moment there are no plans to disallow such functions in views. This limitation is a very old one, it was there since the view support was first implemented, and, frankly, I personally don't see the reason for it. May be I'm wrong and there is a reason. Or may be it'll be relaxed. |