mirror of
				https://github.com/MariaDB/server.git
				synced 2025-10-31 02:46:29 +01:00 
			
		
		
		
	 9ea02a1c09
			
		
	
	
	9ea02a1c09
	
	
	
		
			
			FAILING ASSERTION: FLEN == LEN
Problem:
       Broken invariant triggered when building a unique index on a
binary column and the input data contains duplicate keys. This was broken
in debug builds only.
Fix:
       Fixed length of the binary datatype can be greater than length of
the shorter prefix on which index is being created.
		
	
			
		
			
				
	
	
		
			9 lines
		
	
	
	
		
			283 B
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			9 lines
		
	
	
	
		
			283 B
		
	
	
	
		
			Text
		
	
	
	
	
	
| #
 | |
| # Bug #18010711	UNIQUE PREFIX INDEX ON BINARY COLUMN: FAILING
 | |
| # ASSERTION: FLEN == LEN
 | |
| #
 | |
| create table t1 (f1 binary(5)) engine=innodb;
 | |
| insert into t1 values ('w'), ('w');
 | |
| create unique index index_t1 on t1(f1(4));
 | |
| ERROR 23000: Duplicate entry 'w' for key 'index_t1'
 | |
| drop table t1;
 |