https://bugs.freedesktop.org/show_bug.cgi?id=77154
Priority: medium
Bug ID: 77154
Assignee: [email protected]
Summary: Other: Autovalue does not work with .csv files
imported read/write
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.2.1 release
Component: Database
Product: LibreOffice
Created attachment 97048
--> https://bugs.freedesktop.org/attachment.cgi?id=97048&action=edit
Example.csv
Problem description:
Steps to reproduce:
1. Create a new folder.
2. Create a dummy Example.csv files in this folder with Calc inserting an ID
column (integers from 1 to x) and a second Data column containing associated
data (text)
3. Create a new Database and save it into the same folder as the Example.csv
file
4. Tools/SQL:
CREATE TEXT TABLE "Example" ("ID" INTEGER PRIMARY KEY, "Data" VARCHAR(20));
5. View/Refresh Tables
6. Tools/SQL:
SET TABLE "Example" SOURCE "Example.csv;ignore_first=true;encoding=UTF-8";
7. Edit the table Example
8. Set Autovalue Yes for ID and save
Current behavior: A warning "The column "ID" could not be changed. Should the
column instead be deleted and the new format appended?" appears
Clicking more the Error is "SQL Status: S1000
Error code: -73
This operation is not supported in statement [ALTER TABLE "Example" ALTER
COLUMN "ID" INTEGER NOT NULL IDENTITY]"
If you click on yes, it says Error: This operation is not supported in
statement [ALTER TABLE "Example" DROP "ID"]
Expected behavior:
The column is saved with Autovalue Yes.
Operating System: Debian
Version: 4.2.2.1 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
