Query with 3 or 4 fields with DISTICNT crashes AOO

[ypersyntelykos]

hello

i create some queries with 3 or 4 or more fields when i put SELECT DISTICNT ( because i need not double or triple records) crashing all the database
and not recovery
how i can create these queries without problems because i need them to produce special reports

thanks

[Villeroy]

In Writer or Calc hit F4
RIght-click Bibliography>Edit Database ...
The status bar indicates that this is a dBase database. What type of database is your database?
Add new query

Code: Select all

SELECT DISTINCT "Identifier", "Author", "Title", "ISBN", "Publisher", "Year" FROM "biblio"

Crash?
Does your database crash with LO5 (which is experimental)? >> File a bug report.
Does it crash with OpenOffice? >> Try resetting your user profile.

P.S. Databases should never store any duplicates. Add a unique index after deleting the duplicates.

[ypersyntelykos]

In Writer or Calc hit F4
RIght-click Bibliography>Edit Database ...
The status bar indicates that this is a dBase database. What type of database is your database?
Add new query

Code: Select all

SELECT DISTINCT "Identifier", "Author", "Title", "ISBN", "Publisher", "Year" FROM "biblio"

Crash?
Does your database crash with LO5 (which is experimental)? >> File a bug report.
Does it crash with OpenOffice? >> Try resetting your user profile.

P.S. Databases should never store any duplicates. Add a unique index after deleting the duplicates.

thanks for your fast answer/help
i create and use in open office base 4.1.1
when crashing i find in my disk the half size of KBytes the odb file

[Villeroy]

I can not confirm any crashes. Not with the "Bibliography" database and not with HSQL databases.

Try resetting your user profile:
Shut down the office completely
Rename directory ~/.config/libreoffice/4/user/ [Windows: %APPDATA%\LibreOffice\4\user\]
Restart the office and see if the crashes persist.