summaryrefslogtreecommitdiff
path: root/storage/myisammrg/mysql-test/storage_engine/index_type_hash.rdiff
blob: 1b57afe5b643edeefa78936471dc7a78dae373f7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
7c7
< t1	1	a	1	a	#	#	NULL	NULL	#	HASH		
---
> t1	1	a	1	a	#	#	NULL	NULL	#	BTREE		
15,16c15,16
< t1	1	a_b	1	a	#	#	NULL	NULL	#	HASH		a_b index
< t1	1	a_b	2	b	#	#	NULL	NULL	#	HASH		a_b index
---
> t1	1	a_b	1	a	#	#	NULL	NULL	#	BTREE		a_b index
> t1	1	a_b	2	b	#	#	NULL	NULL	#	BTREE		a_b index
25,26c25,26
< t1	1	a	1	a	#	#	NULL	NULL	#	HASH		
< t1	1	b	1	b	#	#	NULL	NULL	#	HASH		
---
> t1	1	a	1	a	#	#	NULL	NULL	#	BTREE		
> t1	1	b	1	b	#	#	NULL	NULL	#	BTREE		
34c34
< t1	0	a	1	a	#	#	NULL	NULL	#	HASH		
---
> t1	0	a	1	a	#	#	NULL	NULL	#	BTREE		
46c46
< t1	1	a	1	a	#	#	NULL	NULL	#	HASH		simple index on a
---
> t1	1	a	1	a	#	#	NULL	NULL	#	BTREE		simple index on a
55c55
< t1	0	a	1	a	#	#	NULL	NULL	#	HASH		
---
> t1	0	a	1	a	#	#	NULL	NULL	#	BTREE		
64,66c64
< ERROR 23000: Duplicate entry '1' for key 'a'
< # Statement ended with one of expected results (ER_DUP_ENTRY,ER_DUP_KEY). 
< # If you got a difference in error message, just add it to rdiff file
---
> # ERROR: Statement succeeded (expected results: ER_DUP_ENTRY,ER_DUP_KEY)