SQL Error [1938] [HY000]: Target lists can have at most 1664 entries in 6.8.13 release

Help
1

While running a query encountered below issue, however i have less columns in select statement.
** SQL Error [1938] [HY000]: Target lists can have at most 1664 entries.**
is there any maximum limit in memsql for query

2

Is thats MemSQL database engine error or is it coming from a client API or elsewhere?

3

How many columns did your SELECT have?

4

There are 1248 columns in select and group by on all those 1248 column. The error in SQL.workbench.

5

This limit was increased in 6.8.18 (I believe to 32K or 64k columns).

-Adam

6

Hi Adam,

I am interested in this limit. Where is this documented?

Thanks

–Josep

7

Hi Josep,

The limit is currently 12800 entries in a SELECT project list (of “target list”). I expected to see it documented here with the other system limits (System Limits · SingleStore Documentation), but its not there. I opened a doc task to update the docs.

-Adam