| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] |
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0001033 | Sqlite Developer | SQL Editor | public | 2010-05-17 20:54 | 2010-05-18 09:37 |
|
| Reporter | Gillissie | |
| Assigned To | sharpplus | |
| Priority | normal | Severity | tweak | Reproducibility | always |
| Status | assigned | Resolution | open | |
| Platform | Windows | OS | Vista 64 bit | OS Version | Home edition |
| Product Version | 3.5.x | |
| Target Version | | Fixed in Version | | |
|
| Summary | 0001033: SQL editor autocomplete |
| Description | Actually my version is 3.6.5 but the Product Version select list doesn't show that.
The autocomplete "feature" in the SQL Editor is more unhelpful than helpful. Primarily, it automatically changes case of my object names as I type. Sometimes it ends up all lower case, sometimes it ends up all upper case. I name all of my tables and columns with proper casing and expect the autocomplete to use the exact casing I specified. The strangest part is that the autocomplete suggestions show the objects in the correct case, but when choosing them, it changes in the editor.
Also, it is very common for a huge empty white box to appear while typing something. It looks like it's trying to suggest something but instead just shows an empty white box that just covers most of what I'm trying to type.
While on the subject, it is annoying that the cursor in the editor doesn't start on the first column when clicking on an empty line. |
| Steps To Reproduce | Create a table named Proper_Case with a column named Proper_Case.
Try entering this in the SQL editor:
SELECT *
FROM Proper_Case
Curiously, it appears that if you type up to the underscore then use the autocomplete, the correct case is preserved. Why wouldn't it preserve it no matter how far you type into the object name? |
| Tags | No tags attached. |
|
| Attached Files | |
|
Relationships 
Relationships 