Bug 58842

Summary:	EDITING\QUERY: deleted distinct in sql view comes back when switch to design view
Product:	LibreOffice	Reporter:	Tamás Zolnai <zolnaitamas2000>
Component:	Base	Assignee:	Tamás Zolnai <zolnaitamas2000>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	medium
Version:	4.1.0.0.alpha0+ Master
Hardware:	All
OS:	All
Whiteboard:	target:4.1.0
Crash report or crash signature:		Regression By:

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":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=9f82a20777b6d16b2ea541619c3ad270e08e258c

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:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.