select count(t.*) as counts ,sum(t.size) from table t error

[flyingandrunning]

执行以下查询时
select count(t.*) as counts ,sum(t.size) from table t

result is

null, null

返回值都是null,

[eliranmoyal]

Can you try without the "t"

[allwefantasy]

@flyingandrunning The query you mentioned is wrong cause table is keyword . you can try

select count(t.*) as counts ,sum(t.size) from your_table_name t

instead of

select count(t.*) as counts ,sum(t.size) from table t

you can also try run your query in http://www.nlpcn.org:9999/web/ which provides a convenient way to explain your sql.

[satapsa]

This doesnot work
select count(t.*) as counts,sum(t.size) from xxx/locs t

[ansjsun]

to。count（*）
发自我的 iPhone

在 2016年8月25日，21:37，satapsa notifications@github.com 写道：

This doesnot work
select count(t.*) as counts,sum(t.size) from xxx/locs t

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub, or mute the thread.

[satapsa]

Got a result for count , but not for size

select count(*) as counts,sum(t.size) from xxx/locs t

[allwefantasy]

Yes ,this is a bug . query like select count(*) as counts,sum(t.size) from xxx/locs t group by t.field do not handle table alias. We will fix later .

[allwefantasy]

@satapsa @eliranmoyal @ansjsun New pull request ( #271 ) have already fix this bug.