[Libreoffice-bugs] [Bug 42400] Query designer: numeric literal in condition on (VAR)CHAR column destructively transformed into string

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Tue Aug 7 12:54:54 CEST 2012


https://bugs.freedesktop.org/show_bug.cgi?id=42400

sasha.libreoffice at gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
                 CC|                            |sasha.libreoffice at gmail.com
     Ever Confirmed|0                           |1

--- Comment #1 from sasha.libreoffice at gmail.com 2012-08-07 10:54:54 UTC ---
in 3.5.5 on Fedora 64 bit, internal hsqldb:
> SELECT col FROM tbl WHERE col = 8
no problem found
> SELECT col FROM tbl WHERE col = 8.5
Switching from SQL view to design view results in 8,5. Switching to SQL view
results in message "SQL syntax error".

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Libreoffice-bugs mailing list