[dba-issues] [Issue 111143] Certain Column names can cause silent errors during data posting causin g data to written to wrong columns
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43 User oj changed the following: What|Old value |New value Assigned to|oj|msc --- Additional comments from o...@openoffice.org Tue Nov 30 12:36:11 + 2010 --- Please verify. Thanks. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org
[dba-issues] [Issue 111143] Certain Column names can cause silent errors during data posting causin g data to written to wrong columns
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED Target milestone|--- |OOo 3.4 --- Additional comments from o...@openoffice.org Thu Nov 25 11:44:20 + 2010 --- Fixed in cws dba34b. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org
[dba-issues] [Issue 111143] Certain Column names can cause silent errors during data posting causin g data to written to wrong columns
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43 Issue #|43 Summary|Certain Column names can cause silent errors during da |ta posting causing data to written to wrong columns Component|Database access Version|OOO320m15 Platform|Unknown URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen --- Additional comments from atjen...@openoffice.org Sun Apr 25 22:31:30 + 2010 --- Could reproduce with OO.o 3.1.1 onwards (probably before) For example if a user creates 2 columns with names that differ only in case: T-Pain and T-PAIN This is valid for HSQLdb, and Base data controls will appear to work these columns, but during an update to the table the data is shifted to erroneous columns, for columns following the second instance of case insensitive string. If the data types of the misaligned data write are compatible, no error is given to the user - with one exception. There is a hint in the GUI when this is about to happen, the record number in the navigation bar will become inaccurate (always changing to 1) when a new value is written to a controls attached to one of these 'special' columns. NOTE - it appears that other strings can cause this also 'some:thing' and 'some/thing' may trigger it. To see this in action download the attached file, open the SOAP table in a dataview window - now near go to the end of the record, you will find the columns: Dx1, Dx2...Dx6 - write a value into these controls and update the table, you will see that the data moves to the right...on a forum with a lot of CHECKBOX controls this silent change can go on without catching the users attention. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org
[dba-issues] [Issue 111143] Certain Column names can cause silent errors during data posting causin g data to written to wrong columns
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43 --- Additional comments from atjen...@openoffice.org Sun Apr 25 22:32:31 + 2010 --- Created an attachment (id=69104) example file with single table - bad column names - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org
[dba-issues] [Issue 111143] Certain Column names can cause silent errors during data posting causin g data to written to wrong columns
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43 User atjensen changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj --- Additional comments from atjen...@openoffice.org Sun Apr 25 22:35:10 + 2010 --- assign to developer - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org
