Details
- 
    
Bug
 - 
    Status: Closed (View Workflow)
 - 
    
Major
 - 
    Resolution: Fixed
 - 
    N/A
 - 
    None
 
Description
bb-10.3-MDEV-11371  commit 5626786b055a5990a8913e92e41550f5fea974ec
exchange partition returns ERROR 1736 (HY000): Tables have different definitions
if a column is just varchar(), then query is executed without errors. 
					CREATE TABLE t1 (i int, a VARCHAR(1000) COMPRESSED)
			 | 
		
						PARTITION BY RANGE COLUMNS (a)(
			 | 
		
					    PARTITION p0 VALUES LESS THAN ('g'),
			 | 
		
					    PARTITION p1 VALUES LESS THAN ('m'),
			 | 
		
					    PARTITION p2 VALUES LESS THAN ('t'),
			 | 
		
					    PARTITION p3 VALUES LESS THAN ('w'));
			 | 
		
					Â  | 
		
					 CREATE TABLE t2 like t1;
			 | 
		
					 ALTER TABLE t2  REMOVE PARTITIONING;
			 | 
		
					 ALTER TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t2;
			 | 
		
Attachments
Issue Links
- is part of
 - 
                    
        
        MDEV-13342
        Testing for MDEV-11371 (Big column compressed)
    
-         
 - Closed
 
 -