https://bugs.freedesktop.org/show_bug.cgi?id=61203
Priority: medium
Bug ID: 61203
Assignee: [email protected]
Summary: SQL syntax error inserting new record into empty table
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.1.0.0.alpha0+ Master
Component: Database
Product: LibreOffice
Created attachment 75224
--> https://bugs.freedesktop.org/attachment.cgi?id=75224&action=edit
odbc trace
Steps to reproduce
(1) Download and open the database file attached to bug 61198
<https://bugs.freedesktop.org/attachment.cgi?id=75216>.
LibreOffice displays window "New Database1.odb".
(2) In left pane click <Tables>.
Program displays table name OneColumn in the lower right pane.
(3) In lower right pane, right-click OneColumn and in the pop-up menu
select Open.
Program displays window Table Data View. The cursor is in the
empty cell at the top left.
(4) In Table Data View, type 1<TAB>.
Actual program action is to display error message ...
Error inserting the new record
Unexpected token: ( in statement [INSERT INTO ("ID") VALUES (?)]
Expected program action is to add the record to the table an to
move the caret to the second row in preparation for the entry of
another record.
The problem is not restricted to embedded databases. In a test
against an odbc connection, the second line of the error message
read ...
[unixODBC][SQLite]near "(": syntax error (1)
and the attached ODBC trace file at line 2583 shows a call to
SQLPrepare with missing table name ...
SQL = [INSERT INTO ( "ID") VALUES ( ?)][length = 32]
It follows naturally that the call to SQLExecute at line 2616 fails
with ...
DIAG [HY000] [SQLite]near "(": syntax error (1)
I observed this in master commit 2e367c0, pulled 2012-02-17, built and
running on ubuntu-natty 32-bit. The configuration options are ...
--enable-dbgutil
--enable-crashdump
--disable-build-mozilla
--without-system-postgresql
--without-myspell-dicts
--without-help
--with-extra-buildid
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
