Commented by: @pavel-zotov

Should NTILE() allow to use EXPRESSION or only literal ?

DDL:
recreate table test(id int, x int);
commit;
insert into test values(null, 100);
insert into test values(null, 101);
insert into test values(null, 102);
insert into test values(2000, 200);
insert into test values(2001, 201);
insert into test values(2002, 300);
insert into test values(2003, 301);
commit;

Now try:

select id,x,ntile( 2+3 )over(order by http://t.id) from test t order by http://t.id,t.x;

Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 21
-+

select id,x,ntile( (2+5)/3 )over(order by http://t.id) from test t order by http://t.id,t.x;

Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 20
-(

PS. MS SQL works fine with such query (i.e. when argument for ntile is expression).

Commented by: @pavel-zotov

PS.

select x,y,ntile(2.718)over(order by x,y) from test order by x,y;

- should this raise error about positive int/bigint as the only allowed type ? (MS SQL "The function 'ntile' takes only a positive int or bigint expression as its input.")

Commented by: @asfernandes

Pavel, I committed inprovements: 01c131b

Not everything can be in the NTILE parameter. I did now what the sql spec. says.