Maximum number of rows in the SQL Editor response

1

Do queries made directly in the editor and place the result in temp tables have a maximum limit of rows in the answers? For example
select * into #table1 from tabla
select * from #table1
only show up to 2000 records?

2

Hey ErnestoGlez

Have a look at setting environment variables to change the maximum.

MB_AGGREGATED_QUERY_ROW_LIMIT
MB_UNAGGREGATED_QUERY_ROW_LIMIT

Thanks

3

I'm using the free version and can't modify lMB_AGGREGATED_QUERY_ROW_LIMIT
MB_UNAGGREGATED_QUERY_ROW_LIMIT
Not booting with Java, either with Windows Shell or cmd.exe, nor with the API/Docs either.
I need a tutorial on the subject.

Thanks