search

jordansavant / ncmysql

An ncurses explorer and client for MySQL databases written in C
7 stars 3 forks source link

Sorting results has side effects. #4

Open stanholzendorf opened 4 years ago

stanholzendorf commented 4 years ago

Sort I think is a bit funky, too. It seems it resets the LIMIT once it executes it. Like say one changes the LIMIT to 500 and hit enter to execute. Tab down to the results frame and pageDown and pageUP verifies the LIMIT is correct. But once one hits sort (on ID for example) it reverts the LIMIT back to the default 100 and re-renders the results accordingly.

jordansavant commented 3 years ago

This will be interesting because it begins to wade into the concept that we are manipulating the existing query which the result sets have no data for. IE we would need to inspect the SQL query and do string replacement on portions.

I think it breaks down the issue further by thinking about if we wrote a SELECT on a JOIN. If you are to sort a field on that result set it actually would just run a select on the table that was related to the field, not a select on the join already written.

There is definitely merit here for quality of life improvement, but I am going to put this a little further down the list while I work on other things.