I have a new table I created using SQL back-end with a "select * [TableName]" query and there are no results coming back. The result set is about 2.2 million records.

I found a number of articles stating that there are issues when using VIEWS or any special characters in the query, however mind is very basic and returns all records. 

Please advise on what I can try.

Try adding

SELECT * FROM (
    "select * from [TableName]"
) tmp

That gives this error.  I tried every combination of the string, same error every time.

Screenshot 2 is missing the FROM after the *.

Disregard my other message.

Daniel, same thing.  As I mentioned, I tried EVERY possible iteration I could think of.  This one has the from and still same error.

try removing the quotes "

When I do that it says there are no entries (filtered from NaN total entries). For some reason it thinks it's filtered as well, but it's not.

What does the nested select statement do?  Or what is it supposed to do?  A single one at least returns all the records.  Adding the TMP after it doesn't make a difference when trying to search.

There was a bug in server-side processing. Looks like it might is a different issue.

I use MySQL in the setup I manage. I am having a play with mssql now.

Could you try the following (please check the spelling):

select * from MAOCWDEV.EDI_ASOSCOLON_ProductMIDFinalNoduplicate

Doesn't work.

Can you try getting data from MSSQL that has only one row?

That way we can rule out server-side processing and access to the database.

I use the same database and have 3 other table pages. All work fine but have many less records. Maybe 5000 at most. This one with 2.6 million Just doesn't seem to filter when using the search. 

I really need this for a project that's was supposed to start Monday. Are there any workarounds??   I even limited all the columns I don't need to search and it doesn't help. I really only need three columns to be searchable 

Ok, For the search thing.
put the following around your query:

select * from (                            ) tmp

^ that is what I do to fix the search in MySQL.

That gives the below error

Even though it gives that error, it appears to work on the front end so this might work for what I need.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

^ the above is the issue the fix fixes.

Side note
Where is the order by coming from?

It must be inserted by your code somehow because I'm not putting that in.  I just assumed it put the query inside some other call to the database. 

Thank you. If you need access again let me know and I can send a new link as that one is expired now. 

I believe the original issue was there was some code being inserted to the query by your plugin and Daniel didn't know where it was coming from.  In addition when doing just a simple select on the entire table the results were not searchable.   It's working now so that's fine with me but not sure why it would need nesting or anything else to make it work.  

Since it's working now we can close the request.