https://bugs.documentfoundation.org/show_bug.cgi?id=100254
--- Comment #22 from [email protected] ---
Have tested it a little bit.
1. Opened the database
https://bugs.documentfoundation.org/attachment.cgi?id=125563
2. Executed there in Tools > SQL:
CREATE TEXT TABLE "Csv" ("ID" BIGINT PRIMARY KEY);
(creates a text-table with BIGINT)
SET TABLE "Csv" SOURCE "new.csv;ignore_first=true;encoding=UTF-8";
(creates a connection to the first attached *.csv-file)
SELECT * FROM "Csv";
(shows the correct numbers)
3. Opened the same table in the GUI - couldn't display the right number, shows
12345678912345700 instead of 12345678912345678
Displaying numbers with more than 16 digit seems to be impossible in the GUI.
But this numbers were saved in the database.
4. Now I created a query:
SELECT CAST("ID" AS VARCHAR(18)) FROM "Csv"
Shows the right value.
The bug for Base and Calc has nothing to do with DECIMAL or BIGINT, but with
displaying the right value inside the GUI.
--
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
