503
# BUG#23404 - ROW_FORMAT=FIXED option is lost is an index is added to the
506
CREATE TABLE t1(a INT) ROW_FORMAT=FIXED;
507
CREATE INDEX i1 ON t1(a);
508
SHOW CREATE TABLE t1;
510
SHOW CREATE TABLE t1;
503
514
# Bug#24219 - ALTER TABLE ... RENAME TO ... , DISABLE KEYS leads to crash
505
516
--disable_warnings
518
529
DROP TABLE bug24219_2;
532
# Bug#24562 (ALTER TABLE ... ORDER BY ... with complex expression asserts)
536
drop table if exists table_24562;
539
create table table_24562(
544
insert into table_24562 values
545
(1, 0, "Introduction"),
547
(1, 2, "Acknowledgements"),
552
(3, 0, "Intermediate"),
553
(3, 1, "Complex queries"),
554
(3, 2, "Stored Procedures"),
555
(3, 3, "Stored Functions"),
557
(4, 1, "Replication"),
558
(4, 2, "Load balancing"),
559
(4, 3, "High availability"),
560
(5, 0, "Conclusion");
562
select * from table_24562;
564
alter table table_24562 add column reviewer varchar(20),
567
select * from table_24562;
569
update table_24562 set reviewer="Me" where section=2;
570
update table_24562 set reviewer="You" where section=3;
572
alter table table_24562
573
order by section ASC, subsection DESC;
575
select * from table_24562;
577
alter table table_24562
578
order by table_24562.subsection ASC, table_24562.section DESC;
580
select * from table_24562;
582
--error ER_PARSE_ERROR
583
alter table table_24562 order by 12;
584
--error ER_PARSE_ERROR
585
alter table table_24562 order by (section + 12);
586
--error ER_PARSE_ERROR
587
alter table table_24562 order by length(title);
588
--error ER_PARSE_ERROR
589
alter table table_24562 order by (select 12 from dual);
591
--error ER_BAD_FIELD_ERROR
592
alter table table_24562 order by no_such_col;
594
drop table table_24562;
520
596
# End of 4.1 tests