[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 User atjensen changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from atjen...@openoffice.org Sun Oct 25 19:55:23 + 2009 --- Checked w/ OOO320m_2, Ubuntu 9.04 Closing this issue - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from m...@openoffice.org Mon Oct 12 09:11:08 + 2009 --- no problem when check with the description from oj Fri Sep 11 11:54:32 + 2009. In DEV300_m60 an error occurr in the CWS not. So it's fixed and I set it to verified - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 User clu changed the following: What|Old value |New value Assigned to|clu |msc --- Additional comments from c...@openoffice.org Wed Oct 7 15:07:54 + 2009 --- clu-msc: now i get an 'syntax error in sql expression' error message after executing the query = not sure if it is really fixed with this - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 User oj changed the following: What|Old value |New value Assigned to|oj|clu --- Additional comments from o...@openoffice.org Mon Sep 28 10:30:49 + 2009 --- Please verify. Have a look at the SQL statement I pasted above to reproduce it. - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 User oj changed the following: What|Old value |New value Attachment is patch| |Created an attachment (id= | |64806) Patch --- Additional comments from o...@openoffice.org Thu Sep 17 07:03:33 + 2009 --- Created an attachment (id=64806) Patch - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 --- Additional comments from erem...@openoffice.org Wed Sep 16 20:12:04 + 2009 --- The error does not only occur when changing the default value, but also when changing the format of a field, the type of a field, etc. An other workaround is to execute the statement: ALTER TABLE bookmark ALTER COLUMN ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 2) This workaround does not work with out ', INCREMENT BY n' or with ',INCREMENT BY 1' After the above statement and the one mentioned above the error does not occure any more. - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from o...@openoffice.org Fri Sep 11 11:54:32 + 2009 --- Fixed in cws dba32h -Open any new hsqldb -Tools-SQL And execute the following CREATE CACHED TABLE Tabelle1(id INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,dtText VARCHAR(50) NOT NULL,dtNumber DECIMAL(15),dtDatum DATE,dtOld BOOLEAN); INSERT INTO Tabelle1 ( dtOld,dtText) VALUES ( 0,'a'); INSERT INTO Tabelle1 ( dtOld,dtText) VALUES ( 0,'b'); INSERT INTO Tabelle1 ( dtOld,dtText) VALUES ( 0,'c'); INSERT INTO Tabelle1 ( dtOld,dtText) VALUES ( 0,'d'); ALTER TABLE Tabelle1 ALTER COLUMN id INTEGER NOT NULL IDENTITY; INSERT INTO Tabelle1 ( dtOld,dtText) VALUES ( 0,'d'); == Violation of unique constraint SYS_PK_47: duplicate value(s) for column(s) id Now the error message should appear anymore. - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 User oj changed the following: What|Old value |New value CC|'helgekraak,mhatheoo' |'helgekraak,mhatheoo,rene' --- Additional comments from o...@openoffice.org Fri Sep 11 11:56:11 + 2009 --- The sources for hsqldb have been patched in this cws. - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 --- Additional comments from o...@openoffice.org Thu Sep 10 08:53:23 + 2009 --- As work around you execute this sql statement in the menu Tools-SQL ALTER TABLE tabelle1 ALTER COLUMN id RESTART WITH value you need I sent the developer of hsqldb a patch, which he has to check first before integrating it into OOo. - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 --- Additional comments from mhath...@openoffice.org Thu Sep 10 13:28:57 + 2009 --- ==fs since a couple of days I think about fileing an issue about, that OO.o is tempering HSQL-data-files. seeing this issue, I send you these infos, with the special remark, that you need to find out yourself, what had happend: BORG is an calendar-application using the HSQL-engine. Trying to use these data-files reading by using the OO-build-in HSQL-engine worked for a couple of time, but final the data-structur and the skript-file where corrupted and the data where lost - you can find my complaint in the BORG-forum. Right now I am not sure about the reasons, but the guess it is more a problem of OO.o. Please have a look. Martin - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 User mhatheoo changed the following: What|Old value |New value CC|'helgekraak' |'helgekraak,mhatheoo' - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 User fs changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW Priority|P3|P2 Target milestone|--- |OOo 3.2 --- Additional comments from f...@openoffice.org Wed Sep 9 07:54:25 + 2009 --- confirming, assigning, promoting to P2 - it effectively corrupts the DB -, targeting to OOo 3.2. @ud: Thanks for this excellent bug description @oj: This sounds like a combination of an OOo and HSQL bug to me. First, changing the column default should not touch the HSQL table at all - the default value is a mere client-side property, isn't it? That's the OOo part. Second, even if we tell HSQL to change a column definition, it shouldn't implicitly reset the auto-increment value sequence. Please investigate whether you find the reason/fix for this in the HSQL sources. - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 User fs changed the following: What|Old value |New value OtherIssuesDependingOnTh| |9 is| | - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 User helgekraak changed the following: What|Old value |New value CC|''|'helgekraak' - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 Issue #|104901 Summary|After changing default values in tables the Primarykey | Autoincrement starts at 0 Component|Database access Version|OOo 3.1.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ud --- Additional comments from u...@openoffice.org Tue Sep 8 19:06:44 + 2009 --- After changing default values in tables, the Primarykeyfield with an Autoincrement starts at 0. I used the hsqldb on WinXp. Please open attached database -open Tabelle1 in design view -set default value dtNumber to 1 -set default value dtOld to no -save Tabelle1 and close -open Tabelle1 by doubleclick -insert a new dataset, and leave the row by using the TAB-key = Error message = klick Ok - leave the row by using the TAB-key = Error message = klick Ok After 6 Times to leave the row by TAB-key and klick OK, the Autoincrement is back to 6 and can work proper. But if you change -set default value dtOld to yes, the game will start from beginn. But if there where more datasets (e.g. 500) in the table it is no fun, to get the autoincrement to work again. It could be also, to get wrong data. - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 104901] After changing default va lues in tables the Primarykey Autoincrement st arts at 0
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 --- Additional comments from u...@openoffice.org Tue Sep 8 19:08:57 + 2009 --- Created an attachment (id=64623) Example - 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 - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
