sql查询，属性=参数和参数=属性的区别

结果1，查询结果集不一样，78条数据
select t.* from task_info t where  
        ( plan_start_date between  '2022-02-01' and '2022-02-28') and 
        ( plan_end_date between   '2022-02-01' and '2022-02-28')

结果2，代码逻辑 ，50条数据
select t.* from task_info t where
 ('2022-02-01' between t.plan_start_date and t.plan_end_date) and 
 ('2022-02-28' between t.plan_start_date and t.plan_end_date)

结果1和结果2，数据相差38条
结果1：属性=参数，查询是范围，两个时间必须在参数范围内
结果2：参数=属性，查询是固定值，between和and失去意义
         '2022-02-01' between t.plan_start_date and t.plan_end_date
         等价于：plan_start_date或plan_end_date等于2022-02-01