https://bugs.documentfoundation.org/show_bug.cgi?id=130595
--- Comment #11 from Lionel Elie Mamane <lio...@mamane.lu> --- (In reply to Julien Nabet from comment #10) > Just rethinking about all this. > I'm more accustomed to this kind of request: > SELECT * FROM "Table1" WHERE "Name" = :name OR "Name" IS NULL > putting "Rob", I got 2 lines (the one with "Rob" + the one with nothing) > putting nothing, I got only the line which contains nothing. > Seems ok to me. > 1) I noticed LO considers there 2 parameters (whereas there's only 1) as > this part of bt shows: LibreOffice "should" map the _one_ named parameter called :name to _two_ unnamed ? parameters and fill in the same thing for both unnamed parameters. See the documentation of FirebirdSQL that you gave a link to in your commit message (or was it a comment in the code or in gerrit) https://www.firebirdsql.org/file/documentation/html/en/refdocs/fblangref25/firebird-25-language-reference.html#fblangref25-datatypes-special-sqlnull User has supplied a value First parameter (value compare): set *sqldata to the supplied value and *sqlind to 0 (for NOT NULL) Second parameter (NULL test): set sqldata to null (null pointer, not SQL NULL) and *sqlind to 0 (for NOT NULL) User has left the field blank Both parameters: set sqldata to null (null pointer, not SQL NULL) and *sqlind to -1 (indicating NULL) -- You are receiving this mail because: You are the assignee for the bug.
