[MCOL-649] stored procedures only work in current database Created: 2017-03-30 Updated: 2019-07-10 Resolved: 2019-07-10 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | MariaDB Server |
| Affects Version/s: | 1.0.8 |
| Fix Version/s: | Icebox |
| Type: | Bug | Priority: | Major |
| Reporter: | David Thompson (Inactive) | Assignee: | Unassigned |
| Resolution: | Won't Fix | Votes: | 1 |
| Labels: | None | ||
| Epic Link: | ColumnStore Compatibility Improvements |
| Description |
|
If you have a stored procedeure querying a columnstore table without fully qualified table names as below, then it fails with no database set and fails differently if a different database is set. This does not happen if you have a similar proc referencing an innodb table. setup conditions:
now exit and start mcsmysql without selecting a database:
|
| Comments |
| Comment by Andrew Hutchings (Inactive) [ 2017-03-30 ] |
|
We appear to parse stored procs in idb_vtable_process() without taking into account the DB... |
| Comment by Andrew Hutchings (Inactive) [ 2019-07-10 ] |
|
Goes away in 1.4 |