[MCOL-1210] columnstore_info procedures can only be used from within columnstore_info Created: 2018-02-09  Updated: 2018-02-13  Resolved: 2018-02-13

Status: Closed
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: None
Fix Version/s: 1.1.3

Type: Bug Priority: Major
Reporter: Andrew Hutchings (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2018-03, 2018-04

 Description   

The format_filesize function calls assume we are in columnstore_info.

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-02-09 ]

Workaround is to do "use columnstore_info" before using the procedures.

Comment by Andrew Hutchings (Inactive) [ 2018-02-09 ]

For QA:

1. Connect to MariaDB using 'test' as the default database.
2. Execute:

call columnstore_info.total_usage();

Before this would error stating it was missing the format_filesize() function.

Comment by Daniel Lee (Inactive) [ 2018-02-13 ]

Build verified: Github source 1.1.3-1

/root/columnstore/mariadb-columnstore-server
commit e5499e513d88a3dfefbe9a356e20a1bceb1bde38
Merge: 99cdb0a 4840a43
Author: david hill <david.hill@mariadb.com>
Date: Wed Jan 31 16:53:52 2018 -0600

Merge pull request #92 from mariadb-corporation/MCOL-1152

MCOL-1152: Change the debian package names.

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit d45dc5f33e9d14c845aab0c586eb7280a537d3d5
Merge: d0ceeaa 9cb9934
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Mon Feb 12 14:04:38 2018 -0600

Merge pull request #403 from mariadb-corporation/MCOL-1190

MCOL-1190 - code fix, mysql not being monitored on seperate um/pm sys…
MariaDB [mytest]> call columnstore_info.total_usage();
---------------------------------+

TOTAL_DATA_SIZE TOTAL_DISK_USAGE

---------------------------------+

143.69 MB 920.19 MB

---------------------------------+
1 row in set (0.39 sec)

Query OK, 0 rows affected (0.39 sec)

Generated at Thu Feb 08 02:27:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.