To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=58140
Issue #:|58140
Summary:|IT: Incorrect translation in Base produces invalid
|SQL ("Somma")
Component:|Database access
Version:|OOo 2.0
Platform:|PC
URL:|
OS/Version:|All
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|iano
Reported by:|pescetti
------- Additional comments from [EMAIL PROTECTED] Fri Nov 18 13:44:30 -0800
2005 -------
Base IT translates the SQL SUM function into SOMMA, thus producing invalid SQL.
Steps to reproduce:
1. Create a new database in Base IT.
2. Create a new table with a numeric named "quantity".
3. Insert two records: "10"; "15".
4. Create a query in Design View (this problem only affects Design View).
5. Drag and drop "quantity" in the first column.
6. Select Somma ("Sum") as the function for "quantity".
7. Save and run the query.
8. You get the error
"Termine inaspettato: SOMMA in statement [SELECT Somma("quantity") FROM
"Tabella1" "Tabella1"]" ("Unexpected term: SOMMA"...)
SOMMA is indeed unexpected because it should be left as SUM and there is no
reason to translate it into Italian.
[Reported by Marco Caresia and Filippo Cerulo to the Italian QA team]
---------------------------------------------------------------------
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]
