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

[Wojciech Kosowicz]

Hi Karol,

What’s the current status of the task? : )


Best Regards,
Wojtek
> Wiadomość napisana przez Jaroslaw Staniek <staniek at kde.org> w dniu 27 sty 2015, o godz. 08:52:
> 
> 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
> _______________________________________________
> Kexi-devel mailing list
> Kexi-devel at kde.org
> https://mail.kde.org/mailman/listinfo/kexi-devel