633
633
DROP TABLE t1,t2;
636
--echo # Bug#54606 innodb fast alter table + pack_keys=0
637
--echo # prevents adding new indexes
640
CREATE TABLE t1 (a INT, b CHAR(9), c INT, key(b))
643
CREATE INDEX a ON t1 (a);
644
CREATE INDEX c on t1 (c);
649
# Bug#56862 Execution of a query that uses index merge returns a wrong result
653
pk int NOT NULL AUTO_INCREMENT PRIMARY KEY,
659
INSERT INTO t1(a,b) VALUES
660
(11, 1100), (2, 200), (1, 100), (14, 1400), (5, 500),
661
(3, 300), (17, 1700), (4, 400), (12, 1200), (8, 800),
662
(6, 600), (18, 1800), (9, 900), (10, 1000), (7, 700),
663
(13, 1300), (15, 1500), (19, 1900), (16, 1600), (20, 2000);
664
INSERT INTO t1(a,b) SELECT a+20, b+2000 FROM t1;
665
INSERT INTO t1(a,b) SELECT a+40, b+4000 FROM t1;
666
INSERT INTO t1(a,b) SELECT a+80, b+8000 FROM t1;
667
INSERT INTO t1(a,b) SELECT a,b FROM t1;
668
INSERT INTO t1(a,b) SELECT a,b FROM t1;
669
INSERT INTO t1(a,b) SELECT a,b FROM t1;
670
INSERT INTO t1(a,b) SELECT a,b FROM t1;
671
INSERT INTO t1(a,b) SELECT a,b FROM t1;
672
INSERT INTO t1(a,b) SELECT a,b FROM t1;
673
INSERT INTO t1(a,b) SELECT a,b FROM t1;
674
INSERT INTO t1(a,b) SELECT a,b FROM t1;
675
INSERT INTO t1 VALUES (1000000, 0, 0);
677
SET SESSION sort_buffer_size = 1024*36;
681
(SELECT * FROM t1 FORCE INDEX (idx,PRIMARY)
682
WHERE a BETWEEN 2 AND 7 OR pk=1000000) AS t;
685
(SELECT * FROM t1 FORCE INDEX (idx,PRIMARY)
686
WHERE a BETWEEN 2 AND 7 OR pk=1000000) AS t;
688
SET SESSION sort_buffer_size = DEFAULT;
694
--echo # Test for bug #11762012 - "54553: INNODB ASSERTS IN HA_INNOBASE::
695
--echo # UPDATE_ROW, TEMPORARY TABLE, TABLE LOCK".
698
DROP TABLE IF EXISTS t1;
700
CREATE TEMPORARY TABLE t1 (c int) ENGINE = InnoDB;
701
INSERT INTO t1 VALUES (1);
703
--echo # Even though temporary table was locked for READ we
704
--echo # still allow writes to it to be compatible with MyISAM.
705
--echo # This is possible since due to fact that temporary tables
706
--echo # are specific to connection and therefore locking for them
707
--echo # is irrelevant.
710
DROP TEMPORARY TABLE t1;
635
712
--echo End of 5.1 tests