| Summary: | Other: IS NOT NULL | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | tiju72 <tiju72> |
| Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | robert, serval2412 |
| Priority: | medium | Keywords: | possibleRegression |
| Version: | 4.2.0.4 release | ||
| Hardware: | Other | ||
| OS: | Linux (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
tiju72: which DB do you use? (embedded hsqldb, Firebird Mysql, ...) 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. (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. 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. Migrating Whiteboard tags to Keywords: (possibleRegression) [NinjaEdit] |
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