View Issue Details

IDProjectCategoryView StatusLast Update
0007581VALENTINA STUDIOTool - Schema Editorpublic2016-04-27 16:11
ReporterMikey Assigned Toyuriy_velichko  
PrioritynormalSeverityminorReproducibilityhave not tried
Status resolvedResolutionfixed 
PlatformINTELOSMAC OS OS Version*
Product Version6.3.x 
Target Version6.5.xFixed in Version6.5.x 
Summary0007581: Modify Table Name Causes Column Comments To Disappear
DescriptionI added column comments to a table
Then I renamed the table
Now the comments on the columns are gone
Additional InformationTable 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)
TagsNo tags attached.
Working with DB:SQLite Local DB
Version of your DB:

Activities

yuriy_velichko

yuriy_velichko

2016-03-28 16:54

reporter   ~0008936

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?
Mikey

Mikey

2016-03-28 17:40

reporter   ~0008937

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.
yuriy_velichko

yuriy_velichko

2016-03-28 17:55

reporter   ~0008938

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.
Mikey

Mikey

2016-03-28 17:58

reporter   ~0008939

Do you mean the far-right "object" panel? At least we have a confirmed recipe for the issue, now.
yuriy_velichko

yuriy_velichko

2016-03-28 18:46

reporter   ~0008940

1 - Yes.
2 - Yes.
yuriy_velichko

yuriy_velichko

2016-04-27 16:11

reporter   ~0009021

fixed in version 6.5.2

Issue History

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