On Mon, Aug 19, 2019 at 1:55 PM Erik Rijkers <e...@xs4all.nl> wrote: > Another little thing, not sure it's a bug: > > limit interprets its argument by rounding up or down as one would > expect: > > table onek limit 10.4; --> gives 10 rows > table onek limit 10.6; --> gives 11 rows > > but FETCH count PERCENT does not do that; it rounds always up. > > select * from (table onek limit 100) f fetch first 10.4 percent rows > only; --> gives 11 rows > select * from (table onek limit 100) f fetch first 10.6 percent rows > only; --> gives 11 rows > > I see that it's documented in the .sgml to behave as it does, but it > seems wrong to me; > shouldn't that 10.4-percent-query yield 10 rows instead of 11? > >
According to sql standard we have to use the result ceiling value regards Surafel