To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=115581
Issue #|115581
Summary|SQL exported with SCRIPT _MUST HAVE_ semicolon at line
| ends!!!
Component|Database access
Version|OOo 3.2.1
Platform|Macintosh
URL|
OS/Version|Mac OS X, 10.5
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|rohdef
------- Additional comments from roh...@openoffice.org Mon Nov 15 09:05:14
+0000 2010 -------
When I export a database with SCRIPT to get the SQL I get SQL without semicolons
at the end of each SQL statement.
This is VERY CRITICAL due to two reasons:
1. It makes sure that the SQL won't work with most other databases. One of the
nice things with SQL is that it's "relatively" portable and usually only need
few edits to actually work in other databases.
2. This renders invalid SQL. An SQL statement followed by more statements must
end with an semicolon, since it's otherwise impossible for a parser to see the
difference between multiline sql containing combined sql statements.
3. Come on guys, you're not Microsoft, and today even they to a better work at
compatible, even though they still have a lot of legacy.
A little snippet of an export:
INSERT INTO "postnumre" VALUES('0899','Kommuneservice')
INSERT INTO "postnumre" VALUES('0900','K\u00f8benhavn C')
INSERT INTO "postnumre" VALUES('0910','K\u00f8benhavn C')
INSERT INTO "postnumre" VALUES('0929','K\u00f8benhavn C')
INSERT INTO "postnumre" VALUES('0999','K\u00f8benhavn C')
---------------------------------------------------------------------
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
