Bug #43923 | Create Table - Partition | ||
---|---|---|---|
Submitted: | 27 Mar 2009 20:51 | Modified: | 27 Mar 2009 21:21 |
Reporter: | Leandro Concon | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Partitions | Severity: | S5 (Performance) |
Version: | MySQL 5.1.30-community | OS: | Windows (2003 Server) |
Assigned to: | CPU Architecture: | Any |
[27 Mar 2009 20:51]
Leandro Concon
[27 Mar 2009 21:21]
MySQL Verification Team
Thank you for the bug report. Following instructions according the error message: c:\dbs>c:\dbs\5.1\bin\mysql -uroot --port=3510 --prompt="mysql 5.1 >" Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.1.34-Win X64 revno: 2772-log Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql 5.1 >CREATE DATABASE BI_MKT_NDDD_DW; Query OK, 1 row affected (0.16 sec) mysql 5.1 >CREATE TABLE IF NOT EXISTS BI_MKT_NDDD_DW.FT_SALES -> ( -> CD_DISTRIBUTION_CHANNEL INT(6) NOT NULL, -> CD_FCC_CUSTOM INT(10) NOT NULL, -> CD_DIVISION INT(2) NOT NULL DEFAULT '999999999', -> CD_STRUCT_ORG INT(10) NOT NULL, -> CD_BRICK INT(10) NOT NULL, -> CD_BUSINESS_UNIT INT(10) NOT NULL, -> CD_THERAPEUTIC_CLASS INT(6) NOT NULL, -> CD_PRODUCT_TYPE INT(2) NOT NULL, -> CD_MARKET_TYPE INT(2) NOT NULL, -> CD_PHARMACEUTICAL_FORM INT(6) NOT NULL, -> CD_TIME DATE NOT NULL, -> CD_MOLECULE INT(10) NOT NULL, -> MONTHLY_REAL NUMERIC(15,2) NOT NULL, -> MONTHLY_DOLAR NUMERIC(15,2) NOT NULL, -> MONTHLY_UNITS BIGINT(15) NOT NULL, -> PRIMARY KEY (CD_DISTRIBUTION_CHANNEL, CD_FCC_CUSTOM, CD_DIVISION, CD_STRUCT_ORG, -> CD_BRICK, CD_BUSINESS_UNIT, CD_THERAPEUTIC_CLASS, CD_PRODUCT_TYPE, CD_MARKET_TYPE, -> CD_PHARMACEUTICAL_FORM, CD_TIME, CD_MOLECULE) -> ) -> ENGINE = MyISAM -> COMMENT = 'Tabela Fato' -> PARTITION BY RANGE ( EXTRACT(YEAR_MONTH FROM CD_TIME) ) -> ( -> -> PARTITION F1 VALUES LESS THAN (200912), -> PARTITION F2 VALUES LESS THAN (200911), -> PARTITION F3 VALUES LESS THAN (200910), -> PARTITION F4 VALUES LESS THAN (200909), -> PARTITION F5 VALUES LESS THAN (200908), -> PARTITION F6 VALUES LESS THAN (200907), -> PARTITION F7 VALUES LESS THAN (200906), -> PARTITION F8 VALUES LESS THAN MAXVALUE -> ); ERROR 1493 (HY000): VALUES LESS THAN value must be strictly increasing for each partition mysql 5.1 >CREATE TABLE IF NOT EXISTS BI_MKT_NDDD_DW.FT_SALES -> ( -> CD_DISTRIBUTION_CHANNEL INT(6) NOT NULL, -> CD_FCC_CUSTOM INT(10) NOT NULL, -> CD_DIVISION INT(2) NOT NULL DEFAULT '999999999', -> CD_STRUCT_ORG INT(10) NOT NULL, -> CD_BRICK INT(10) NOT NULL, -> CD_BUSINESS_UNIT INT(10) NOT NULL, -> CD_THERAPEUTIC_CLASS INT(6) NOT NULL, -> CD_PRODUCT_TYPE INT(2) NOT NULL, -> CD_MARKET_TYPE INT(2) NOT NULL, -> CD_PHARMACEUTICAL_FORM INT(6) NOT NULL, -> CD_TIME DATE NOT NULL, -> CD_MOLECULE INT(10) NOT NULL, -> MONTHLY_REAL NUMERIC(15,2) NOT NULL, -> MONTHLY_DOLAR NUMERIC(15,2) NOT NULL, -> MONTHLY_UNITS BIGINT(15) NOT NULL, -> PRIMARY KEY (CD_DISTRIBUTION_CHANNEL, CD_FCC_CUSTOM, CD_DIVISION, CD_STRUCT_ORG, -> CD_BRICK, CD_BUSINESS_UNIT, CD_THERAPEUTIC_CLASS, CD_PRODUCT_TYPE, CD_MARKET_TYPE, -> CD_PHARMACEUTICAL_FORM, CD_TIME, CD_MOLECULE) -> ) -> ENGINE = MyISAM -> COMMENT = 'Tabela Fato' -> PARTITION BY RANGE ( EXTRACT(YEAR_MONTH FROM CD_TIME) ) -> ( -> PARTITION F7 VALUES LESS THAN (200906), -> PARTITION F6 VALUES LESS THAN (200907), -> PARTITION F5 VALUES LESS THAN (200908), -> PARTITION F4 VALUES LESS THAN (200909), -> PARTITION F3 VALUES LESS THAN (200910), -> PARTITION F2 VALUES LESS THAN (200911), -> PARTITION F1 VALUES LESS THAN (200912), -> PARTITION F8 VALUES LESS THAN MAXVALUE -> ); Query OK, 0 rows affected (0.09 sec) mysql 5.1 >