https://bugs.freedesktop.org/show_bug.cgi?id=50575
--- Comment #3 from Lionel Elie Mamane <[email protected]> 2012-06-07 09:57:57 PDT --- (In reply to comment #2) > (In reply to comment #1) >> In this bug the situation is much simpler. The timestamps in my tables are >> have >> no fractions of seconds, so the fraction structure element is always 0. My >> guess is, that Base is failing in translating ODBC timestamps to Base >> timestamps and/or vice versa. > Oh, your timestamps have no fractional part? Then indeed, there is another > bug > somewhere. I'll try to take a look. That's *definitely* a sqlite or sqliteodbc bug. LibreOffice calls SQLBindParameter with a buffer that contains the right structure with the right values. Then in gdb I traced the calls to the SQLite3 API. I see that sqliteodbc calls: Breakpoint 12, sqlite3_bind_text (pStmt=0x169e088, i=2, zData=0x1a33a10 "2012-04-06 12:34:56.000", nData=-1, xDel=0) at sqlite3.c:59141 *but* compare the following in sqlite3 command-line interface: sqlite> SELECT * FROM byTs WHERE ts='2012-04-05 13:45:57.000'; sqlite> SELECT * FROM byTs WHERE ts='2012-04-05 13:45:57'; nr ts word ---- ------------- ---- 2 2012-04-05 13:45:57 Thursday See? SQLite seems not to support the fractions (subsecond) syntax, but sqliteodbc uses it *anyway*. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- 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
