https://bugs.documentfoundation.org/show_bug.cgi?id=117527
Bug ID: 117527
Summary: Firebird: don't changes field properties "AutoValue"
to "Yes" for auto created field ID
Product: LibreOffice
Version: 6.1.0.0.alpha1+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
In Firebird BD don't changes field properties "AutoValue" to "Yes" for auto
created field ID
Steps to Reproduce:
1. Create new Firebird BD
2. Create new table uses "Create table in Design view"
3. Create one or more field
4. Save your table
5. Base asks you "Should a primary key be created now?", Push button "Yes"
6. In table will add field ID with type Integer, but its field properties
AutoValue will equal "No" (see bug 108057)
7. Save table else one (do not close!)
8. Try change ID's field properties "AutoValue" to "Yes". You look warning
dialogue with "The column "ID" could not be changed. Should the column instead
be deleted and the new format appended?", push button "Yes"
9. You look new dialogue with error "Error while saving the table design"
firebird_sdbc error:
*unsuccessful metadata update
*ALTER TABLE 34 failed
*SQL error code = -607
*Invalid command
*Specified domain or source column SQL_LONG does not exist
caused by
'ALTER TABLE "34" ADD "ID" SQL_LONG NOT NULL' (see screenshot)
10. If you push button "No", then field ID will be remove from table.
If i use master for create a table, then i can't change field properties
"AutoValue" to "Yes" in table design view
Actual Results:
i can't create unique field with auto increment for my table in data base
Expected Results:
i can create unique field with auto increment for my table in data base
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101
Firefox/59.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
