On 01/04/2014 12:08 AM, Ann Harrison wrote:
> Obviously,
> at least to me, if you've got to sort the data, you have to read all
> of it.
> Furthermore, despite the everyone's instinct, it's a good deal faster in
> the general case to read a table in an optimal order and sort the data
> in memory
On 01/03/2014 01:47 PM, Claudio Valderrama C. wrote:
> Hello, I know security3.fdb is not in place because I'm using the Debug dir:
>
> F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebird>isql -user sysdba
> -pass masterkey
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> create dat
Error "Attempt to reopen an open cursor" may be raised if the query handle is
reused in a different transaction
---
Key: CORE-4313
URL: http://tracker.fire
Alex,
> > Furthermore, despite the everyone's instinct, it's a good deal faster in
> > the general case to read a table in an optimal order and sort the data
> > in memory that to read the data in index order - random order relative
> > to storage.
> >
>
> Ann, from server POV you are definitely
On Sun, Jan 5, 2014 at 3:39 AM, Alex wrote:
> O
> >
> > I thought we would allow PASS as a shortcut for PASSWORD.
>
> Can you provide a sample where shortcuts are present in SQL? It's
> trivial to add PASS shortcut, but for me it looks like something out of
> SQL style.
>
BIN (Binary), DEC (Deci
