[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Update on the status of Mckoi SQL
- To: mckoidb@xxxxxxxxx
- Subject: Re: Update on the status of Mckoi SQL
- From: Hendrik Schwachenwalde <come2los@xxxxxxxx>
- Date: Wed, 20 Dec 2006 13:11:02 -0500 (EST)
- Delivered-To: mailing list mckoidb@mckoi.com
- DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.ca; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=PtKgNYOu/9fVQJm0HRX/9h9IQhfkMO5IIJsRaitkKOgHhDKK0w1TFutAEyiT42qm1HXp0RPGl5k/ZA4Z27Abucyp9QNuZXlTScskSmeXF7cp5joCOBpAhY0XBqCTmEn5uz2nzYQCssng6iTw/aR/8Sj8wjeXX0SEDo8jr0M0/0A=;
- In-Reply-To: <4585B83E.4040108@mckoi.com>
- Mailing-List: contact mckoidb-help@mckoi.com; run by ezmlm
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