InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples

CVS Repositories

Who We Are
News, Articles & Events
Getting Involved
Contact Us

Case Studies
On The Edge! -NEW-
Commercial Vendors

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

InstantDB: Re: like bugs ?...

Christophe -

Specifically in regard to #4 below. If I understand correctly that you are
offering a possible code improvement in InstantDB to help solve the
problems you've seen -- then you are right on track with what Open Source
is all about. You should communicate with the Chair of the InstantDB
Project and see what the right steps are so you could become a committer on
that project.

Go Open Source !


At 11:21 PM 3/22/01 +0000, Christophe NIGAUD wrote:
>Firstly thanks for your great work on instantDB. It's really kind to have an 
>easy-to-install database like this.
>i notice some problems using 3.26 idb...
>1) Between : between clause doesn't work very kindly with negative numbers. 
>"select myvalue from mytable where myvalue between -1 and 2" generate an 
>we must put single quote like this :
>"select myvalue from mytable where myvalue between '-1' and 2"
>but its not really the right syntax for a integer value, isn't it ?
>2) null values : relating to general comportment of any database like
>oracle or my sql
>doing such sql in an empty table
>"select max(id) from mytable" 
>should return null value. and instantDB does it. ok.
>but doing such sql with the same empty table
>"select max(id)+1 from mytable"
>should although return a null value to.
>but instantDB return -2147483647 !
>3) again null values :
>we can't do this : "select null from mytable"  (generate SQLException)
>that would be fine if we could.
>4) i give you a sql function ifnull(int, int, int) i made. Work's like 
>isNull(int, int) sybase function but with an added 3rd parameters.
>i think this is usefull in managing identity columns like the following sql :
>select ifnull(max(id), 1, max(id)+1) from mytable
>to use it like isnull(int, int) sybase function, put the 1rst param into the 
>3rd param, like
>select ifnull(max(id), 1, max(id)) from mytable
>if you want, extends it with long values fonctionality.
>5) your management of 'sql' function doesn't really work with aggregate 
>example on a table with n rows (n>=2):
>"select mod(6,2) from mytable" return n rows with a value of 0. ok
>"select max(id) from mytable"   return one row with a value of 5 for
>"select mod(max(id),2) from mytable" return n rows with a value of 1. which 
>is wrong.
>it should return me one row with a value of 1.
>Again, thanks for your work.
>yours faithfully.
To unsubscribe from this mailing list, send email to
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at