| 1 |
--- a/mysql-test/suite/sys_vars/r/sysvars_aria.result |
| 2 |
+++ b/mysql-test/suite/sys_vars/r/sysvars_aria.result |
| 3 |
@@ -5,7 +5,7 @@ |
| 4 |
SESSION_VALUE NULL |
| 5 |
DEFAULT_VALUE 8192 |
| 6 |
VARIABLE_SCOPE GLOBAL |
| 7 |
-VARIABLE_TYPE BIGINT UNSIGNED |
| 8 |
+VARIABLE_TYPE INT UNSIGNED |
| 9 |
VARIABLE_COMMENT Block size to be used for Aria index pages |
| 10 |
NUMERIC_MIN_VALUE 4096 |
| 11 |
NUMERIC_MAX_VALUE 32768 |
| 12 |
@@ -17,7 +17,7 @@ |
| 13 |
SESSION_VALUE NULL |
| 14 |
DEFAULT_VALUE 30 |
| 15 |
VARIABLE_SCOPE GLOBAL |
| 16 |
-VARIABLE_TYPE BIGINT UNSIGNED |
| 17 |
+VARIABLE_TYPE INT UNSIGNED |
| 18 |
VARIABLE_COMMENT Interval between tries to do an automatic checkpoints. In seconds; 0 means 'no automatic checkpoints' which makes sense only for testing |
| 19 |
NUMERIC_MIN_VALUE 0 |
| 20 |
NUMERIC_MAX_VALUE 4294967295 |
| 21 |
@@ -29,7 +29,7 @@ |
| 22 |
SESSION_VALUE NULL |
| 23 |
DEFAULT_VALUE 1048576 |
| 24 |
VARIABLE_SCOPE GLOBAL |
| 25 |
-VARIABLE_TYPE BIGINT UNSIGNED |
| 26 |
+VARIABLE_TYPE INT UNSIGNED |
| 27 |
VARIABLE_COMMENT Number of bytes that the transaction log has to grow between checkpoints before a new checkpoint is written to the log |
| 28 |
NUMERIC_MIN_VALUE 0 |
| 29 |
NUMERIC_MAX_VALUE 4294967295 |
| 30 |
@@ -53,7 +53,7 @@ |
| 31 |
SESSION_VALUE NULL |
| 32 |
DEFAULT_VALUE 0 |
| 33 |
VARIABLE_SCOPE GLOBAL |
| 34 |
-VARIABLE_TYPE BIGINT UNSIGNED |
| 35 |
+VARIABLE_TYPE INT UNSIGNED |
| 36 |
VARIABLE_COMMENT Number of consecutive log recovery failures after which logs will be automatically deleted to cure the problem; 0 (the default) disables the feature |
| 37 |
NUMERIC_MIN_VALUE 0 |
| 38 |
NUMERIC_MAX_VALUE 255 |
| 39 |
@@ -77,7 +77,7 @@ |
| 40 |
SESSION_VALUE NULL |
| 41 |
DEFAULT_VALUE 0 |
| 42 |
VARIABLE_SCOPE GLOBAL |
| 43 |
-VARIABLE_TYPE BIGINT UNSIGNED |
| 44 |
+VARIABLE_TYPE INT UNSIGNED |
| 45 |
VARIABLE_COMMENT Interval between commits in microseconds (1/1000000 sec). 0 stands for no waiting for other threads to come and do a commit in "hard" mode and no sync()/commit at all in "soft" mode. Option has only an effect if aria_group_commit is used |
| 46 |
NUMERIC_MIN_VALUE 0 |
| 47 |
NUMERIC_MAX_VALUE 4294967295 |
| 48 |
@@ -101,7 +101,7 @@ |
| 49 |
SESSION_VALUE NULL |
| 50 |
DEFAULT_VALUE 1073741824 |
| 51 |
VARIABLE_SCOPE GLOBAL |
| 52 |
-VARIABLE_TYPE BIGINT UNSIGNED |
| 53 |
+VARIABLE_TYPE INT UNSIGNED |
| 54 |
VARIABLE_COMMENT Limit for transaction log size |
| 55 |
NUMERIC_MIN_VALUE 8388608 |
| 56 |
NUMERIC_MAX_VALUE 4294967295 |
| 57 |
@@ -137,10 +137,10 @@ |
| 58 |
SESSION_VALUE NULL |
| 59 |
DEFAULT_VALUE 300 |
| 60 |
VARIABLE_SCOPE GLOBAL |
| 61 |
-VARIABLE_TYPE BIGINT UNSIGNED |
| 62 |
+VARIABLE_TYPE INT UNSIGNED |
| 63 |
VARIABLE_COMMENT This characterizes the number of hits a hot block has to be untouched until it is considered aged enough to be downgraded to a warm block. This specifies the percentage ratio of that number of hits to the total number of blocks in the page cache |
| 64 |
NUMERIC_MIN_VALUE 100 |
| 65 |
-NUMERIC_MAX_VALUE 18446744073709551615 |
| 66 |
+NUMERIC_MAX_VALUE 4294967295 |
| 67 |
NUMERIC_BLOCK_SIZE 100 |
| 68 |
ENUM_VALUE_LIST NULL |
| 69 |
READ_ONLY NO |
| 70 |
@@ -161,7 +161,7 @@ |
| 71 |
SESSION_VALUE NULL |
| 72 |
DEFAULT_VALUE 100 |
| 73 |
VARIABLE_SCOPE GLOBAL |
| 74 |
-VARIABLE_TYPE BIGINT UNSIGNED |
| 75 |
+VARIABLE_TYPE INT UNSIGNED |
| 76 |
VARIABLE_COMMENT The minimum percentage of warm blocks in key cache |
| 77 |
NUMERIC_MIN_VALUE 1 |
| 78 |
NUMERIC_MAX_VALUE 100 |
| 79 |
@@ -173,7 +173,7 @@ |
| 80 |
SESSION_VALUE NULL |
| 81 |
DEFAULT_VALUE 512 |
| 82 |
VARIABLE_SCOPE GLOBAL |
| 83 |
-VARIABLE_TYPE BIGINT UNSIGNED |
| 84 |
+VARIABLE_TYPE INT UNSIGNED |
| 85 |
VARIABLE_COMMENT Number of hash buckets for open and changed files. If you have a lot of Aria files open you should increase this for faster flush of changes. A good value is probably 1/10 of number of possible open Aria files |
| 86 |
NUMERIC_MIN_VALUE 128 |
| 87 |
NUMERIC_MAX_VALUE 16384 |
| 88 |
@@ -209,7 +209,7 @@ |
| 89 |
SESSION_VALUE 1 |
| 90 |
DEFAULT_VALUE 1 |
| 91 |
VARIABLE_SCOPE SESSION |
| 92 |
-VARIABLE_TYPE BIGINT UNSIGNED |
| 93 |
+VARIABLE_TYPE INT UNSIGNED |
| 94 |
VARIABLE_COMMENT Number of threads to use when repairing Aria tables. The value of 1 disables parallel repair |
| 95 |
NUMERIC_MIN_VALUE 1 |
| 96 |
NUMERIC_MAX_VALUE 128 |
| 97 |
@@ -224,7 +224,7 @@ |
| 98 |
VARIABLE_TYPE BIGINT UNSIGNED |
| 99 |
VARIABLE_COMMENT The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE |
| 100 |
NUMERIC_MIN_VALUE 16352 |
| 101 |
-NUMERIC_MAX_VALUE 1152921504606846975 |
| 102 |
+NUMERIC_MAX_VALUE 268435455 |
| 103 |
NUMERIC_BLOCK_SIZE 1 |
| 104 |
ENUM_VALUE_LIST NULL |
| 105 |
READ_ONLY NO |