[Kexi-devel] Workaround for lack of SQL DISTINCT and UNIQUE

[Jaroslaw Staniek]

On 26 January 2015 at 23:10, Karol Pawłowski
<karol.pawlowski89 at gmail.com> wrote:
> If it's not an urgent task, I can handle it.

Thanks. The task can be splitted to parts that include:

- additions to the SQL parser
- additions to KexiDB (or Pedicate) -- not decided but we closed
feature window for 2.9 and 3.0 will be predicate-based
- update unit tests/autotests for Predicate accordingly
- additions to the SQL visual designer; this can be delayed and made
as separate task; we tend to do with SQL features, recently with
BETWEEN...AND.

Extra note, synchronize with Qt 5 porting, otherwise patches may start
to conflict.

> Please note, that only SELECT
> DISTINCT is in SQL standard
> (http://stackoverflow.com/questions/336268/difference-between-select-unique-and-select-distinct_)

Probably yes, although UNIQUE is one of popular keywords of Create
Table for some db engines, it just declares an index implicitly and we
have Unique property supported in table designer and GUIs (form view,
table view).
I just mentioned UNIQUE since the user did so.

>
> On 26 Jan 2015, at 15:43, Jaroslaw Staniek <staniek at kde.org> wrote:
>
> Hi,
> Here's how lack of SQL DISTINCT and UNIQUE is addressed by clever users :)
>
> https://forum.kde.org/viewtopic.php?f=220&t=124628
>
> Anyone interested in implementing the feature properly for queries?
>
> --
> regards, Jaroslaw Staniek
>
> KDE:
> : A world-wide network of software engineers, artists, writers, translators
> : and facilitators committed to Free Software development - http://kde.org
> Calligra Suite:
> : A graphic art and office suite - http://calligra.org
> Kexi:
> : A visual database apps builder - http://calligra.org/kexi
> Qt Certified Specialist:
> : http://www.linkedin.com/in/jstaniek
> _______________________________________________
> Kexi-devel mailing list
> Kexi-devel at kde.org
> https://mail.kde.org/mailman/listinfo/kexi-devel
>
>



-- 
regards, Jaroslaw Staniek

KDE:
: A world-wide network of software engineers, artists, writers, translators
: and facilitators committed to Free Software development - http://kde.org
Calligra Suite:
: A graphic art and office suite - http://calligra.org
Kexi:
: A visual database apps builder - http://calligra.org/kexi
Qt Certified Specialist:
: http://www.linkedin.com/in/jstaniek