Description:
mysql> create table tt(c1 year);
Query OK, 0 rows affected (0.05 sec)
mysql> insert into tt values("2155"),("2069"),("1901"),("2001");
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> set @L=2147483647;
Query OK, 0 rows affected (0.00 sec)
mysql> prepare stmt from "select distinct c1 from tt where c1 > ? order by c1";
Query OK, 0 rows affected (0.00 sec)
Statement prepared
mysql> select @L;
+------------+
| @L |
+------------+
| 2147483647 |
+------------+
1 row in set (0.00 sec)
mysql> execute stmt using @L;
+------+
| c1 |
+------+
| 1901 |
| 2001 |
| 2069 |
| 2155 |
+------+
4 rows in set (0.00 sec)
mysql> select distinct c1 from tt where c1 > 2147483647 order by c1;
Empty set (0.00 sec)
How to repeat:
1.create table and insert data
create table tt(c1 year);
2.Prepare query
insert into tt values("2155"),("2069"),("1901"),("2001");
set @L=2147483647;
prepare stmt from "select distinct c1 from tt where c1 > ? order by c1";
select @L;
execute stmt using @L;
3.Non-prepare query
select distinct c1 from tt where c1 > 2147483647 order by c1;
Description: mysql> create table tt(c1 year); Query OK, 0 rows affected (0.05 sec) mysql> insert into tt values("2155"),("2069"),("1901"),("2001"); Query OK, 4 rows affected (0.00 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql> set @L=2147483647; Query OK, 0 rows affected (0.00 sec) mysql> prepare stmt from "select distinct c1 from tt where c1 > ? order by c1"; Query OK, 0 rows affected (0.00 sec) Statement prepared mysql> select @L; +------------+ | @L | +------------+ | 2147483647 | +------------+ 1 row in set (0.00 sec) mysql> execute stmt using @L; +------+ | c1 | +------+ | 1901 | | 2001 | | 2069 | | 2155 | +------+ 4 rows in set (0.00 sec) mysql> select distinct c1 from tt where c1 > 2147483647 order by c1; Empty set (0.00 sec) How to repeat: 1.create table and insert data create table tt(c1 year); 2.Prepare query insert into tt values("2155"),("2069"),("1901"),("2001"); set @L=2147483647; prepare stmt from "select distinct c1 from tt where c1 > ? order by c1"; select @L; execute stmt using @L; 3.Non-prepare query select distinct c1 from tt where c1 > 2147483647 order by c1;