Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community Forums60 row max displayed in sql results window
https://www.eclipse.org/forums/index.php/mv/msg/204526/654072/#msg_654072
Kurt Harless2011-02-14T01:35:58-00:00Re: 60 row max displayed in sql results window
https://www.eclipse.org/forums/index.php/mv/msg/204526/654450/#msg_654450
Brian Fitzpatrick2011-02-15T20:20:09-00:00Re: 60 row max displayed in sql results window
https://www.eclipse.org/forums/index.php/mv/msg/204526/655020/#msg_655020
in the SQL Results view is set in the Preferences. The default is 500 rows.
By any chance are you doing a "Sample Contents" action on the table?
(Right click, Data -> Sample Contents). That is limited to 50 returned
rows. If you want to see all the rows you need to run a query against
the table, or edit the table (Data -> Edit).
On 2/13/2011 5:36 PM, Kurt Harless wrote:
> Have a 1000+ row table that is only displaying the first 60 rows in the
> sql results window. Nothing constraining the rows from the sql
> perspective, check preferences, Changed max row count to 0 (unlimited?)
> and max display row row count to 1000000. No help. MYSQL workbench is
> able to query the table fine using the same sql. What am I doing wrong?]]>Brian Payton2011-02-18T01:15:30-00:00Re: 60 row max displayed in sql results window
https://www.eclipse.org/forums/index.php/mv/msg/204526/655024/#msg_655024
My stupidity. My loaded .csv had some missing dates that apparently prevent the query from running if you include that row. Interestingly, its stops the entire result set, not just the records with invalid dates. I have worked through my date issues using something like; date_closed = if(strcmp(@date_closed,''),STR_TO_DATE(trim(@date_closed), '%m/%d/%Y'),NULL). Setting it to NULL, which is what I thought STR_TO_DATE did if you found invalid dates, fixed this issue. Go figure. I am now working an EXPORT issue from the legacy DB that creates .CSV's that wrap if a new line or carriage return is embedded in a text field. I plan on exporting it in HEX and then converting it back to VARCHAR to keep the desire formatting. Ohhh what fun! Thanks for all the ideas!]]>Kurt Harless2011-02-18T02:24:44-00:00