[ANN] Vserver, V4MD, V4RB, VCOM, VNET 2.2 b4

[Ruslan Zasukhin]

Hi All,

    http://paradigmasoft.com/en/products/download/beta

kernel - 2.2 b4
===============
- 0001266: [API] Allow temporary methods (Ivan Smahin)
- 0001286: [SQL nodes] ORDER BY - exception on trying to use field which is
not mentioned in the select-list. (Ivan Smahin)
- 0001285: [Fields] Functions StarWith(), Endswith, Contains() sometimes
glitches for TEXT fields. (Ruslan Zasukhin)
- 0001268: [SQL nodes] Crash on GROUP BY if aliases used in select list.
(Ivan Smahin)
- 0001283: [SQL nodes] Some subqueries (FROM clause) don't work. (Ivan
Smahin)
- 0001282: [SQL nodes] Group By query crash if select-list does not contain
all items mentioned in group-by list. (Ivan Smahin)


By human words :-)

* Now you can do ORDER BY and GROUP BY on field
    which is NOT in SELECT clause.
    this is extension of SQL92


* Now you can create in Table Temporary Methods.
    This means that info about such method will NOT be stored in
    system table, so if system failure happens, your database structure
    is clean.

    You need drop tmp methods when you do not need any more.

    For now you cannot create tmp fields.


* Now indexing of Varchar field (and probably others) work about 3 times
faster. 
    My bench that have take 100 seconds, now work in 32 seconds.

* there is expectations that Aggregate methods also will work faster.
    there was no made benches on this to get exact numbers.

* Now work such aggregate functions as
        SELECT max( length(fld) )


* Kim, Ivan have fix that simple inline FROM-subquery, but more complex
queries 
still not work.  So please do not expect for this feature in nearest time.


* Eric, you can check this build on your issue. Note update both Vserver and
V4MD.



Note: uploaded also Vserver demo license files for next month.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina-beta/attachments/20060130/d9c052bd/attachment.html