Re: Update on the status of Mckoi SQL

Hendrik Schwachenwalde <[email protected]> Wed, 20 Dec 2006 13:11:02 -0500 (EST)
Newsgroups gmane.comp.db.mckoi
Message-ID <[email protected]>
Hi Toby,

 I am glad to hear there will be another release of
McKoi!

 Recently I've stumbled over a little "feature" for
which there is an easy workaround. I would like to
bring this to your attention now in the hope you can
include a fix in your next release.

 Please try the following:

CREATE TABLE nums (a INT, b INT, c INT)
INSERT INTO nums VALUES ( 5, 3, 2 )
SELECT *,a+b-c-1,a+(b-c)-1 FROM nums

 If I am not mistaken the result for "a+b-c-1" should
be identical to "a+(b-c)-1" but isn't.

 Secondly, about two years ago I inquired about scalar
subqueries in McKoi. I still find them a very useful
feature that I would love to have available in
McKoi;-)    Maybe you could add that also, if not in
the upcoming release then maybe in a later one?

Thanks alot for all the work you have put into McKoi.

Hendrik


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]