Bug 74682 - Other: IS NOT NULL
Summary: Other: IS NOT NULL
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: possibleRegression
Depends on:
Blocks:
 
Reported: 2014-02-07 16:13 UTC by tiju72@gmx.de
Modified: 2015-12-15 10:53 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description tiju72@gmx.de 2014-02-07 16:13:39 UTC 
Problem description: in the new version 4.2.0.4 of Libreoffice Base the criterion  "IS NOT NULL" in any query doesn't work any longer. Error : "The syntax is too complex".

Steps to reproduce:
1. using new or existent reports....
2. ....
3. ....

Current behavior:

Expected behavior:

              
Operating System: Debian
Version: 4.2.0.4 release
Last worked in: 4.1.4.2 release
Comment 1 Julien Nabet 2014-02-08 16:53:33 UTC 
tiju72: which DB do you use? (embedded hsqldb, Firebird Mysql, ...)
Comment 2 Julien Nabet 2014-02-08 16:58:04 UTC 
On pc Debian x86-64 with 4.2 sources updated some days ago, I gave a try with a brand new hsqldb embedded db, it was ok.
Comment 3 Robert Großkopf 2014-02-08 20:41:00 UTC 
(In reply to comment #0)
> Problem description: in the new version 4.2.0.4 of Libreoffice Base the
> criterion  "IS NOT NULL" in any query doesn't work any longer. Error : "The
> syntax is too complex".
> 
> Steps to reproduce:
> 1. using new or existent reports....

What do you mean: a query or a report?
I can't confirm this behavior for a query. Have tested with an old test-database. Works as expected.
My system: OpenSUSE 12.3 64bit rpm with LO 4.2.0.4.
Comment 4 Julien Nabet 2014-08-27 21:38:58 UTC 
No feedback since months, I put WFM following Robert's comment and mine.

Don't hesitate to reopen this tracker as soon as you bring more information.
Comment 5 Robinson Tryon (qubit) 2015-12-15 10:53:42 UTC 
Migrating Whiteboard tags to Keywords: (possibleRegression)
[NinjaEdit]