I'm assuming, you were referring to this: https://help.labkey.org/wiki/home/Documentation/page.view?name=labkeySql

Using INTEGER like you suggested does not produce an error, while parsing the query.
(I used INT in my schema declaration and it worked fine, so was not expecting that I should use INTEGER here.)

BUT, the LABKEY.ext.Store is behaving really weird in this case: it only gets populated with one last row of the query result, whereas in the schema browser one can see that the result of the query is correct -- can someone reproduce this behavior and if yes, then this is definitely a bug, no?