Limit 設置0的問題 #1514

New Issue

KennyChenFight · 2020-01-21T05:13:06Z

KennyChenFight commented

我使用db.Limit函式，在limit的參數上寫0，秀出來的SQL語法並沒有LIMIT的keyword，因此就會變成拿到全部的record
而我用db.SQL來寫raw SQL語句，將LIMIT設0，可以拿到0個資料達到我要的效果
這是個例外情況嗎?

我使用db.Limit函式，在limit的參數上寫0，秀出來的SQL語法並沒有LIMIT的keyword，因此就會變成拿到全部的record 而我用db.SQL來寫raw SQL語句，將LIMIT設0，可以拿到0個資料達到我要的效果這是個例外情況嗎?

lunny commented

Which xorm version are you using?

KennyChenFight commented

v0.7.9

lunny commented

Could you try the recent version, I just merged #1119 tha should fix your problem.

Could you try the recent version, I just merged https://gitea.com/xorm/xorm/pulls/1119 tha should fix your problem.

KennyChenFight commented

I try v0.8.1, but still no LIMIT keyword in SQL statement when setting limit = 0.
it should get 0 record when I set LIMIT = 0.

I try v0.8.1, but still no LIMIT keyword in SQL statement when setting limit = 0. it should get 0 record when I set LIMIT = 0.

KennyChenFight commented

Sorry my fault, I try 0.8.2 version. It Works!
Thank you!

Sorry my fault, I try 0.8.2 version. It Works! Thank you!

KennyChenFight closed this issue

KennyChenFight reopened this issue

KennyChenFight closed this issue

Sign in to join this conversation.

No Milestone

No Assignees

2 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: xorm/xorm#1514