Re: Puzzle: What should this query return?

It doesn't seem different with the newest version (file date 6/16/2002). I might have gotten the results backwards in my first post, that's all.

Ocelot returns 0 for the query

  select case when 1=0 then 12 else count(0) end as X from T where 1=0

For the query

  select case when 1=0 then count(0) else 12 end as X from T where 1=0

Ocelot says

  [OCELOT][OCELOT]CLI specific: Overflow while allocating RC, table size = <768> stmt count = <51>

Steve

Peter Gulutzan wrote:

> Steve Kass <skass_at_drew.edu> wrote in message news:<3D1CC3BC.203279AC@drew.edu>...
>
> > Ocelot says:
> > [OCELOT][OCELOT]CLI specific: Overflow while allocating RC ...
>
> No, it does not. Anyone who wants to know what THE OCELOT SQL DBMS actually
> returns can download the package (it's free open source) from
> ourworld.compuserve.com/homepages/ocelotsql/download.htm
> or
> sourceforge.net/projects/ocelot
> Perhaps you are using an obsolete version, Mr Kass?
>
> However, I'll cheerily admit that what Ocelot actually returns
> -- 0 instead of 12 -- is disputable. We'll look at this sometime.
>
> Peter Gulutzan
> Ocelot Computer Services Inc.
Received on Sat Jun 29 2002 - 18:34:13 CEST