DB2:
Bugs:
- VARCHAR & CHAR - editing a NULL column now requires that I delete "[NULL]" from the text box IIRC that used to auto-clear when the text box was clicked
- TIMESTAMP & DATE - Set pattern of "YYYY-MM-DD" under Prefs. -> DB Cfg. -> Data Formats and strangely formatted dates / times as a result (field editor calendar widget still uses the correct data)
EX: For December 16th 2011 the table view shows "2011-00-16 05:00:00"
June 23rd, 2010 shows as "2010-32-23" - time values still appear correctly, also the example under "Data Formats" is also incorrectly displaying
- TIMESTAMP, DATE, TIME - Field editor "Set NULL" changes the table view to "[NULL]" as expected, but on DB commit error of "SQL Error [42815]: [jcc][10143][10845][3.59.81] Invalid parameter 1: Parameter is not set nor registered. ERRORCODE=-4461, SQLSTATE=42815"
Feature Request:
On the Result Set Order/Filter Settings" window instead of the bottom two text boxes have tabs with full size text boxes for extended editing of complex WHERE and ORDER BY filters and sorting