94895 – INSERT statement generated by base does not insert a row of data, the INSERT statement is too long

Bug 94895 - INSERT statement generated by base does not insert a row of data, the INSERT statement is too long

Summary: INSERT statement generated by base does not insert a row of data, the INSERT ...

Status:	RESOLVED WORKSFORME

Alias:	None

Product:	LibreOffice
Classification:	Unclassified
Component:	Base (show other bugs)
Version: (earliest affected)	5.0.0.5 release
Hardware:	Other All

Importance:	medium normal
Assignee:	Not Assigned

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2015-10-08 20:35 UTC by Jonathan Camilleri
Modified:	2016-10-09 17:19 UTC (History)
CC List:	1 user (show)

See Also:
Crash report or crash signature:

Attachments
screenshot (odt) (81.64 KB, application/vnd.oasis.opendocument.text) 2015-10-08 20:35 UTC, Jonathan Camilleri	Details
credit reference (odb) (50.91 KB, application/vnd.sun.xml.base) 2015-10-08 20:36 UTC, Jonathan Camilleri	Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Jonathan Camilleri 2015-10-08 20:35:05 UTC

Created attachment 119439 [details]
screenshot (odt)

Generated INSERT statement reports an error when I try to update information within the table indicated in the attached screenshot.

Comment 1 Jonathan Camilleri 2015-10-08 20:36:35 UTC

Created attachment 119440 [details]
credit reference (odb)

Comment 2 Buovjaga 2015-10-09 15:45:44 UTC

I went to Tables and double clicked PEP. I inputted data roughly the same as in your screenshot.
What do I have to do to produce the error message?
If it is Insert - Record, then there was no error for me.

I tested using 5.0.2, while you use 5.0.0.5

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the information.

Win 7 Pro 64-bit, Version: 5.0.2.2 (x64)
Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe
Locale: fi-FI (fi_FI)

Comment 3 Robert Großkopf 2015-10-11 08:54:10 UTC

(In reply to Jonathan Camilleri from comment #0)
> Created attachment 119439 [details]
> screenshot (odt)
> 
> Generated INSERT statement reports an error when I try to update information
> within the table indicated in the attached screenshot.

Hi Jonathan,

the column "Source" is set to a length of 8 characters. But you try to insert 'Online - htt' (might be a little bit longer, but the characters I could see are 12).

Error only says there is a value too long to insert. So have a look at your table-definition.

Regards

Robert

Comment 4 Xisco Faulí 2016-09-11 20:40:42 UTC Comment hidden (obsolete)

Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INVALID
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
 
Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team

Sun, 11 Sep 2016 21:43:24 +0200

Comment 5 Robert Großkopf 2016-10-09 17:19:27 UTC

Following commet3 I will set this bug to WORKSFORME.