| Bug #10056 | PACK_KEYS option take values greater than 1 while creating table | ||
|---|---|---|---|
| Submitted: | 21 Apr 2005 9:31 | Modified: | 31 Aug 2005 19:58 |
| Reporter: | Disha | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.0.4 Beta-standard | OS: | Linux (Redhat Linux 9.0) |
| Assigned to: | Ingo Strüwing | CPU Architecture: | Any |
[8 Aug 2005 17:38]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/28008
[29 Aug 2005 15:24]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/28984
[30 Aug 2005 12:41]
Ingo Strüwing
Pushed to 5.0.12.
[31 Aug 2005 19:58]
Paul DuBois
Noted in 5.0.12 changelog.
Description: When we create a table with 'PACK_KEYS' value greater than '1', we are able to create the table. As 'PACK_KEYS' accepts only values 0 and 1 ,it should not accept value greter than 1, and while creating the table, if the value is greater than '1' , it should give an error message or warning. How to repeat: 1. Set delimiter ie execute the following SQL statement: Delimiter // 2. Use database 'test' i.e. execute the following SQL statement: use test// 3. Create table 't1' ie execute the following SQL statement: create table t1 (f1 int) pack_keys = 789// 4. Execute 'show' statement: show create table t1// 5. Observe that the 'show create table' gives the following output: +-------+-------------------------------------------------------------------+ | Table | Create Table | +-------+-------------------------------------------------------------------+ | t1 | CREATE TABLE `t1` ( `f1` int(11) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 PACK_KEYS=1 | +-------+-------------------------------------------------------------------+ 1 row in set (0.00 sec) Expected Results: Pack_key accept values ie DEFAULT, 0 and 1. Actual Results : Pack_key accept the value greater than 1 during table creation 't1'.It does not give any error message or warning.