Bug 58842 - EDITING\QUERY: deleted distinct in sql view comes back when switch to design view
Summary: EDITING\QUERY: deleted distinct in sql view comes back when switch to design ...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) Master
Hardware: All All
: medium normal
Assignee: Tamás Zolnai
Whiteboard: target:4.1.0
Depends on:
Reported: 2012-12-28 21:26 UTC by Tamás Zolnai
Modified: 2012-12-29 10:52 UTC (History)
0 users

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Tamás Zolnai 2012-12-28 21:26:39 UTC
Switching between sql and design view don't handle distinct as expected.

Steps to reproduce the bug:
1. Create a non-empty query in design view
2. Push distinct button on toolbar
3. Switch to sql view
4. Delete distinct from select statment
5. Switch back to design view

Recent bevahiour:
Distinct button is still active. If we switch to sql view again, then distinct will appear in select.

Expected behaviour:
Distinct button would be inactive and in case of switching to sql view, distinct would not be put back into select.
Comment 1 Not Assigned 2012-12-28 22:49:31 UTC
Zolnai Tamas committed a patch related to this issue.
It has been pushed to "master":


fdo#58842 Handle case of non-distinct statment

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.