View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0007581 | VALENTINA STUDIO | Tool - Schema Editor | public | 2016-03-28 14:47 | 2016-04-27 16:11 |
Reporter | Mikey | Assigned To | yuriy_velichko | ||
Priority | normal | Severity | minor | Reproducibility | have not tried |
Status | resolved | Resolution | fixed | ||
Platform | INTEL | OS | MAC OS | OS Version | * |
Product Version | 6.3.x | ||||
Target Version | 6.5.x | Fixed in Version | 6.5.x | ||
Summary | 0007581: Modify Table Name Causes Column Comments To Disappear | ||||
Description | I added column comments to a table Then I renamed the table Now the comments on the columns are gone | ||||
Additional Information | Table name transition "CRON"->"cron "->"cron" (I wanted to change the name from uppercase to lowercase. First transition was to add a space and change the name from upper to lowercase, then I removed the space) | ||||
Tags | No tags attached. | ||||
Working with DB: | SQLite Local DB | ||||
Version of your DB: | |||||
Hi Mikey. I can not reproduce bug at this time. I have added the table with field and comment on the field. Then I have performed renaming of the table as you mentioned. Comment stays on the field. What exactly version of Valentina Studio do you use? Did you move the database file after comment was added? |
|
6.4, and I just did it, again, with a brand new DB 1. Create sqlite db 2. Create table CRON, fields a (text), 1 (text), 2 (text) 3. In the schema editor, select a field, and in the Object panel, click on the pencil for the comment. Edit the comment. 4. Do this for each of the fields. 5. Verify that comments are set for each field. 6. Right-click on the table, pick "Design..." 7. Rename from "CRON" to "cron " (that's a space on the end of lower-case "cron" 8. Right-click the table, pick "Design..." 9. Rename from "cron " to "cron" (remove the space from the name 10. Pick one of the fields and notice that the comments are now gone. |
|
Yes, this issue is related to using Design Table dialog. If to change name via Property Inspector of the table then comments of fields do not disappear. |
|
Do you mean the far-right "object" panel? At least we have a confirmed recipe for the issue, now. | |
1 - Yes. 2 - Yes. |
|
fixed in version 6.5.2 | |
Date Modified | Username | Field | Change |
---|---|---|---|
2016-03-28 14:47 | Mikey | New Issue | |
2016-03-28 16:54 | yuriy_velichko | Note Added: 0008936 | |
2016-03-28 17:40 | Mikey | Note Added: 0008937 | |
2016-03-28 17:55 | yuriy_velichko | Note Added: 0008938 | |
2016-03-28 17:58 | Mikey | Note Added: 0008939 | |
2016-03-28 18:46 | yuriy_velichko | Note Added: 0008940 | |
2016-04-27 13:56 | yuriy_velichko | Assigned To | => yuriy_velichko |
2016-04-27 13:56 | yuriy_velichko | Status | new => assigned |
2016-04-27 16:10 | yuriy_velichko | Target Version | => 6.5.x |
2016-04-27 16:11 | yuriy_velichko | Note Added: 0009021 | |
2016-04-27 16:11 | yuriy_velichko | Status | assigned => resolved |
2016-04-27 16:11 | yuriy_velichko | Fixed in Version | => 6.5.x |
2016-04-27 16:11 | yuriy_velichko | Resolution | open => fixed |