[dba-issues] [Issue 70160] Table created with SELECT INTO TABLE command is not visible
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70160 User atjensen changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from [EMAIL PROTECTED] Tue Jan 15 21:49:20 + 2008 --- Test with 680M_242, xp - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 70160] Table created with SELECT INTO TABLE command is not visible
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70160 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from [EMAIL PROTECTED] Mon Oct 15 12:21:51 + 2007 --- verified in CWS dba24b find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba24b - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 70160] Table created with SELECT INTO TABLE command is not visible
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70160 User oj changed the following: What|Old value |New value Assigned to|oj|msc Target milestone|OOo 2.x |OOo 2.4 --- Additional comments from [EMAIL PROTECTED] Tue Oct 2 10:16:41 + 2007 --- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 70160] Table created with SELECT INTO TABLE command is not visible
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70160 User oj changed the following: What|Old value |New value Status|NEW |STARTED --- Additional comments from [EMAIL PROTECTED] Mon Aug 13 06:36:14 + 2007 --- It's a failure in the hqldb parser. I'll apply the fix for it from hsqldb source cvs as pacth to the OOo tree. - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 70160] Table created with SELECT INTO TABLE command is not visible
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70160 User oj changed the following: What|Old value |New value Status|STARTED |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Mon Aug 13 07:27:28 + 2007 --- Fixed in cws dba24b - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 70160] Table created with SELECT INTO TABLE command is not visible
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70160 --- Additional comments from [EMAIL PROTECTED] Fri Mar 9 09:21:03 + 2007 --- Tested this under 2.2RC2. The issue still exists. If you open the example database and enter SELECT * INTO foo FROM abc in the SQL window you can then create a query in designer of select * from foo, all of the data is retrieved. Close the database file and open it again, the table is now visible but all of the data is gone. Open the SQL window and enter this command instead. SELECT * INTO CACHED foo_c FROM abc Now, ViewRefresh Tables will list the table. One more time open the SQL window and enter CREATE TEMPORARY TABLE bar ( ID INTEGER, NAME VARCHAR(50) ) ON COMMIT PRESERVE ROWS; INSERT INTO bar VALUES( 0, 'Drew' ); SELECT COUNT( ID ) FROM bar; The commands execute successfully. Again the table can not be seen, even after table refresh. In a query design window enter SELECT * from bar, you will get back 1 record. Close and reopen the database file in the SQL window enter the CREATE statement again..this time it fails. The table bar still exist in the database, but it is still invisible. OK, one last oddity here. When the table is created with the Select into command it is initialy invisible, all of the data is available however. Close and open the database and the table is now visible, but the data is gone. Add some data to the table now, using an insert statement in the SQL window (since the table has no PK), close and open the database and voila the data is now retained. ??? - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 70160] Table created with SELECT INTO TABLE command is not visible
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70160 User fs changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |39681) document to reprodu | |ce the bug case --- Additional comments from [EMAIL PROTECTED] Wed Oct 11 03:07:46 -0700 2006 --- Created an attachment (id=39681) document to reproduce the bug case - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 70160] Table created with SELECT INTO TABLE command is not visible
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70160 User fs changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW Priority|P3|P4 Target milestone|not determined|OOo 2.x --- Additional comments from [EMAIL PROTECTED] Wed Oct 11 03:09:41 -0700 2006 --- confirmed, targeted, priorized, assigned To reproduce - choose Tools/SQL in the attched database - execute SELECT * INTO foo FROM abc - choose View/Refresh Tables = the newly created table foo is not visible. fs-oj: please check (with Fred) whether this is an HSQL or a OOo 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 70160] Table created with SELECT INTO TABLE command is not visible
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70160 Issue #|70160 Summary|Table created with SELECT INTO TABLE command is not vi |sible Component|Database access Version|OOo 2.0.4 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen --- Additional comments from [EMAIL PROTECTED] Fri Oct 6 08:01:42 -0700 2006 --- When the standard DML comamnd SELECT INTO TABLE is used to create a new table in an embedded Base database the newly created table is not visible. Using 'ViewRefresh Tables' will not show the table. Interestingly using the variant SELECT INTO TEXT will show the newly created table - after doing 'ViewRefresh Tables' - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]