<HTML>
<HEAD>
<TITLE>[ANN] Vserver, V4MD, V4RB, VCOM, VNET 2.2 b4 </TITLE>
</HEAD>
<BODY>
<FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>Hi All,<BR>
<BR>
<a href="http://paradigmasoft.com/en/products/download/beta">http://paradigmasoft.com/en/products/download/beta</a> <BR>
<BR>
</SPAN></FONT><FONT SIZE="4"><FONT FACE="Courier, Courier New"><SPAN STYLE='font-size:13.0px'>kernel - 2.2 b4<BR>
===============<BR>
- <FONT COLOR="#1700EE"><U>0001266</U></FONT>: <B>[API]</B> Allow temporary methods (Ivan Smahin)<BR>
- <FONT COLOR="#55198B"><U>0001286</U></FONT>: <B>[SQL nodes]</B> ORDER BY - exception on trying to use field which is not mentioned in the select-list. (Ivan Smahin)<BR>
- <FONT COLOR="#55198B"><U>0001285</U></FONT>: <B>[Fields]</B> Functions StarWith(), Endswith, Contains() sometimes glitches for TEXT fields. (Ruslan Zasukhin)<BR>
- <FONT COLOR="#55198B"><U>0001268</U></FONT>: <B>[SQL nodes]</B> Crash on GROUP BY if aliases used in select list. (Ivan Smahin)<BR>
- <FONT COLOR="#55198B"><U>0001283</U></FONT>: <B>[SQL nodes]</B> Some subqueries (FROM clause) don't work. (Ivan Smahin)<BR>
- <FONT COLOR="#55198B"><U>0001282</U></FONT>: <B>[SQL nodes]</B> Group By query crash if select-list does not contain all items mentioned in group-by list. (Ivan Smahin)<BR>
</SPAN></FONT></FONT><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'><BR>
<BR>
By human words :-)<BR>
<BR>
* Now you can do ORDER BY and GROUP BY on field <BR>
which is NOT in SELECT clause.<BR>
this is extension of SQL92<BR>
<BR>
<BR>
* Now you can create in Table Temporary Methods.<BR>
This means that info about such method will NOT be stored in <BR>
system table, so if system failure happens, your database structure<BR>
is clean.<BR>
<BR>
You need drop tmp methods when you do not need any more.<BR>
<BR>
For now you cannot create tmp fields.<BR>
<BR>
<BR>
* Now indexing of Varchar field (and probably others) work about 3 times faster. <BR>
My bench that have take 100 seconds, now work in 32 seconds.<BR>
<BR>
* there is expectations that Aggregate methods also will work faster.<BR>
there was no made benches on this to get exact numbers.<BR>
<BR>
* Now work such aggregate functions as<BR>
SELECT max( length(fld) )<BR>
<BR>
<BR>
* Kim, Ivan have fix that simple inline FROM-subquery, but more complex queries <BR>
still not work. So please do not expect for this feature in nearest time. <BR>
<BR>
<BR>
* Eric, you can check this build on your issue. Note update both Vserver and V4MD.<BR>
<BR>
<BR>
<BR>
Note: uploaded also Vserver demo license files for next month.<BR>
<BR>
<BR>
-- <BR>
Best regards,<BR>
<BR>
Ruslan Zasukhin<BR>
VP Engineering and New Technology<BR>
Paradigma Software, Inc<BR>
<BR>
Valentina - Joining Worlds of Information <BR>
<a href="http://www.paradigmasoft.com">http://www.paradigmasoft.com</a><BR>
<BR>
[I feel the need: the need for speed]<BR>
</SPAN></FONT>
</BODY>
</HTML>