[Libreoffice-bugs] [Bug 130672] base sql query parameter with negative value fails

2022-02-15 Thread bugzilla-daemon 
https://bugs.documentfoundation.org/show_bug.cgi?id=130672

Robert Großkopf  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=86
   ||852

--- Comment #4 from Robert Großkopf  ---
Bug still exists in LO 7.3.1.1 on OpenSUSE 64bit rpm Linux.

Seems the parser sets negative values to "VARCHAR". Its a typical bug of the
dialog for the parameter. In older versions before LO 4.4 it also set empty
strings instead of NULL. See bug 86852

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 130672] base sql query parameter with negative value fails

2020-02-16 Thread bugzilla-daemon 
https://bugs.documentfoundation.org/show_bug.cgi?id=130672

--- Comment #2 from Robert Großkopf  ---
(In reply to Robert Großkopf from comment #1)
> 
> With internal Firebird the bug appears also, but there is no known
> workaround.

Workaround with Firebird:

SELECT * FROM "table1" WHERE CAST("aid" AS VARCHAR(10)) = :P1

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 130672] base sql query parameter with negative value fails

2020-02-15 Thread bugzilla-daemon 
https://bugs.documentfoundation.org/show_bug.cgi?id=130672

Robert Großkopf  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1
 CC||rob...@familiegrosskopf.de

--- Comment #1 from Robert Großkopf  ---
Could confirm the buggy behavior with the internal database HSQLDB. Seems the
parameter isn't set as Integer.

SELECT * FROM "table1" WHERE "aid" = CAST(:P1 AS INTEGER)
will work. Multiplication with '1' will do the same.
SELECT "aid", :P1 AS "T" FROM "table1" WHERE "aid" = :P1
will work also.

With internal Firebird the bug appears also, but there is no known workaround.

Tested with LO 6.4.0.3 on OpenSUSE 15.1 64bit rpm Linux

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs