# Check that hash join work in type edge cases
---
- CreateTable: t1(n INT, s VARCHAR(8), t VARCHAR(128) COLLATE en_us_ci)
---
- Statement: INSERT INTO t1 VALUES(1, 'abc', 'abc'),(2, 'def', 'Def')
---
- CreateTable: t2(n BIGINT, s VARCHAR(16), t VARCHAR(128) COLLATE en_us_ci)
---
- Statement: INSERT INTO t2 VALUES(1, 'abc', 'ABC'),(2, 'xyz', 'XYZ')
---
# Key comparable
- Statement: SELECT t1.s, t2.s FROM t1, t2 WHERE t1.n = t2.n
- output: [['abc', 'abc'],['def', 'xyz']]
---
# String size mismatch
- Statement: SELECT t1.n, t2.n FROM t1, t2 WHERE t1.s = t2.s
- output: [[1, 1]]
---
# Case independent collation
- Statement: SELECT t1.n, t2.n FROM t1, t2 WHERE t1.t = t2.t
- output: [[1, 1]]
...
Add tests for the several type-related problem cases.
Add tests for the several type-related problem cases.
