[MDEV-4885] When performance schema is disabled, autosized parameters show 18446744073709551615 instead of -1 Created: 2013-08-10  Updated: 2013-08-12  Resolved: 2013-08-12

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: 10.0.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Timour Katchaounov (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-4873 Tasks before 10.0.4-release Closed

 Description   

Value of an autosized parameter in performance schema is supposed to be -1 when the performance schema is disabled. It works in MySQL 5.6.10, but not in 10.0 tree:

MySQL [test]> select @@performance_schema_max_table_instances;
 
+------------------------------------------+
 
| @@performance_schema_max_table_instances |
 
+------------------------------------------+
 
|                                       -1 |
 
+------------------------------------------+
 
1 row in set (0.00 sec)
 
 
 
MySQL [test]> select @@performance_schema;
 
+----------------------+
 
| @@performance_schema |
 
+----------------------+
 
|                    0 |
 
+----------------------+
 
1 row in set (0.00 sec)
 
 
 
MySQL [test]> select @@version;
 
+-----------+
 
| @@version |
 
+-----------+
 
| 5.6.10    |
 
+-----------+
 
1 row in set (0.00 sec)
 

MariaDB [test]> select @@performance_schema_max_table_instances;
 
+------------------------------------------+
 
| @@performance_schema_max_table_instances |
 
+------------------------------------------+
 
|                     18446744073709551615 |
 
+------------------------------------------+
 
1 row in set (0.00 sec)
 
 
 
MariaDB [test]> select @@performance_schema;
 
+----------------------+
 
| @@performance_schema |
 
+----------------------+
 
|                    0 |
 
+----------------------+
 
1 row in set (0.00 sec)
 
 
 
MariaDB [test]> select @@version;
 
+----------------------+
 
| @@version            |
 
+----------------------+
 
| 10.0.3-MariaDB-debug |
 
+----------------------+
 
1 row in set (0.00 sec)



 Comments   
Comment by Timour Katchaounov (Inactive) [ 2013-08-12 ]

Got patch from Serg in the end.

Generated at Thu Feb 08 06:59:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.