a specific subquery sql cause an unexpected error

[XuHuaiyu]

1. What did you do?

CREATE TABLE t1 (a INT) ENGINE=INNODB;
INSERT INTO t1 VALUES (0);
CREATE TABLE t2 (d BINARY(2), PRIMARY KEY (d(1)), UNIQUE KEY (d)) ENGINE=INNODB;

SELECT 1 FROM t1, t2 WHERE 1 = (SELECT t2.d FROM t2 WHERE t1.a >= 1) and t2.d = 1;
ERROR 1052 (23000): Column 'd' in field list is ambiguous

2. What version of TiDB are you using (tidb-server -V)?

+-----------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version()                                                                                                                          |
+-----------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: 0.9.0
Git Commit Hash: 83ace4f748018857a365b64aed59bb3cf6116bd0
Git Branch: master
UTC Build Time: 2017-10-15 01:58:48 |
+-----------------------------------------------------------------------------------------------------------------------------------------+

[winoros]

fixed by #4770