FindAndCount, 生成的count语句有问题? #1398

New Issue

lunny · 2019-08-20T03:24:29Z

a7505553 commented

2019-08-20 03:24:29 +00:00

(Migrated from github.com)

SELECT  * FROM `orders` WHERE (merchant_id IN (?,?)) AND (`delete_at` IS NULL OR `deleted_at`=?) LIMIT 10 []interface {}{"1", "2", "0001-01-01 00:00:00"} 


SELECT count(*) FROM `orders` WHERE (merchant_id IN (?,?)) AND (`delete_at` IS NULL OR `deleted_at`=?) AND (`deleted_at` IS NULL OR `deleted_at`=?) []interface {}{"1", "2", "0001-01-01 00:00:00", "0001-01-01 00:00:00"}

count语句多了一个 (deleted_at IS NULL OR deleted_at=?)

``` SELECT * FROM `orders` WHERE (merchant_id IN (?,?)) AND (`delete_at` IS NULL OR `deleted_at`=?) LIMIT 10 []interface {}{"1", "2", "0001-01-01 00:00:00"} SELECT count(*) FROM `orders` WHERE (merchant_id IN (?,?)) AND (`delete_at` IS NULL OR `deleted_at`=?) AND (`deleted_at` IS NULL OR `deleted_at`=?) []interface {}{"1", "2", "0001-01-01 00:00:00", "0001-01-01 00:00:00"} ``` count语句多了一个 (`deleted_at` IS NULL OR `deleted_at`=?)

lunny commented

2019-08-20 12:40:03 +00:00

If you have deleted column, the condition will be added automatically.

If you have `deleted` column, the condition will be added automatically.

kisesy referenced this issue

2020-03-23 09:02:33 +00:00

FindAndCount 生成的SQL语句会多判断一次 deleted #1617

lunny closed this issue

2020-03-23 12:35:28 +00:00

Sign in to join this conversation.