SQLGeneration icon indicating copy to clipboard operation
SQLGeneration copied to clipboard

numericLiteral is always integer

Open marnun opened this issue 10 years ago • 1 comments

when using: builder.AddProjection(new Function("AVG", new Multiplication(new NumericLiteral(1.0), new Column("col1"))), metric); i'm getting : SELECT AVG((1 * col1)) instead of : SELECT AVG((1.0 * col1))

marnun avatar Sep 07 '15 14:09 marnun

NumericLiteral has a Format property that you can use to force how the number is converted back to a string. On Sep 7, 2015 10:06 AM, "erez l" [email protected] wrote:

when using: builder.AddProjection(new Function("AVG", new Multiplication(new NumericLiteral(1.0), new Column("col1"))), metric); i'm getting : SELECT AVG((1 * col1)) instead of : SELECT AVG((1.0 * col1))

— Reply to this email directly or view it on GitHub https://github.com/jehugaleahsa/SQLGeneration/issues/23.

jehugaleahsa avatar Sep 07 '15 14:09 jehugaleahsa