[Kexi] LIMIT 1 in Select Clause

[Jarosław Staniek]

Sharan Rao said the following, On 2007-12-05 15:33:
> On Tuesday 04 Dec 2007 7:17:42 pm Jarosław Staniek wrote:
>> Sharan Rao said the following, On 2007-12-01 21:17:
>>>  I was facing problems with the function Connection::querySingleString()
>>> in Sybase, as the " LIMIT " clause is not supported.
>> Sharan, thanks for your time; here's the patch you can apply for LIMIT 1
>> ussue. I am looking forward your opinion on it.
>>
> 
> well, now I observed that problem arises when Connection::querySingleString() 
> function is called from within kexidb ( that is,  not by some driver code ).
> 
> Take for example, the function,
>  Connection::loadDataBlock()
> 
> Functions like above, which mostly query the system tables created by kexi, 
> use querySingleString() function too !! And they use it without changing the 
> default value of the  flag  -- addLimitTo1. :(. So they are sent with 
> the "LIMIT 1".

IIRC, This is intentional behaviour. See below to discover why ;)

> As row limiting is implemented differently in different databases, ( not sure 
> whether adherence to SQL:2003 window functions would help ?), do you think it 
> would be better if the responsibility of adding the "LIMIT" clause ( whatever 
> it may be ) to the drivers ?

It is already added. See Driver::addLimitTo1() in my patch. Just reimplement 
this method.

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org