[ANN] 3.6 BETA 15 uploaded

Wed May 21 04:10:56 CDT 2008

Hi All,

    http://www.valentina-db.com/download/beta2/3.6b15

We have prepare our first big beta release of 3.6.
    uploaded most products for MAC WI N and Linux.

Please find time to test this betas against of your projects.
    for MAC was significant changes in the installer scripts.
    because of Leopard...So please test it as much as possible.

Now what we have new:

    * Support of correlated sub-queries
    * GRANT/REVOKE commands for VSERVER on db level.
    * new aggr function GROUP_CONCAT
    * support of objectPtr->* syntax
    * UUID() function

FULL LIST is here:

kernel - 3.6
============
- 0003116: [Feature Request] GROUP_CONCAT Function (ruslan) - resolved.
- 0003069: [Feature Request] objptr->* (ivan) - resolved.

- 0003098: [NEW] [NEW] Correlated subqueries implemented. (ruslan) -
resolved.

- 0003077: [Database] Advanced User Management - restrict user to specific
databases (ivan) - resolved.
 - 0003100: [SQL] [NEW] GRANT/REVOKE commands (ivan) - resolved.
 - 0003101: [SQL] [NEW] SHOW GRANTS command. (ivan) - resolved.
 - 0003099: [SQL] [NEW] CREATE/DROP USER command. (ivan) - resolved.

- 0003157: [Utilities Functions][NEW] Add a UUID function (ivan) - resolved.

- 0003073: [NEW] stored procedure caches values from first call (ivan) -
resolved.
- 0003105: [Stored Procedures] when assigning a sql-statement to a var using
() gives null result (ivan) - resolved.
- 0003118: [Stored Procedures] Cursor declaration in SP wrongfully ignores
ORDER BY clause. (ivan) - resolved.

- 0003021: [Database] "Segment map corrupted" appears VERY often (ivan) -
resolved.
- 0003080: [Encryption] Some delete-record operation on encrypted database
may bring garbage into the rest records. (ivan) - resolved.
- 0003111: [Indexes] Wrongfully chosen not tmp volume for SortMap case
database is RO. (ivan) - resolved.

- 0003014: [Join of Tables] if more than 5 rows need to be returned from a
join query, 0 are returned (ivan) - resolved.

- 0003022: [SQL Dump] identity fields fail upon restore because the
method(RecId) is not recognised (ivan) - resolved.

- 0003165: [SQL] GROUP BY WITH ROLLUP on empty cursor gets to crash (ivan) -
resolved.
- 0003159: [SQL] SUBSTRING('Valentina' FROM 2) return wrong result (ivan) -
resolved.
- 0003132: [SQL] Unknown function PI() (ivan) - resolved.
- 0003123: [SQL] IFNULL() return wrong result if second parameter is a
string (ivan) - resolved.
- 0003122: [SQL] ISNULL() should be a synonym of IFNULL() (ivan) - resolved.
- 0003121: [SQL] Error when compare NULL's (ivan) - resolved.
- 0003126: [SQL] LOG(B,X) return garbage with B=1 and X=100 (ivan) -
resolved.
- 0003128: [SQL] SIGN(0) return wrong result (ivan) - resolved.
- 0003136: [SQL] BIT_AND() not working (ivan) - resolved.
- 0003138: [SQL] BIT_XOR( ) is not working (ivan) - resolved.
- 0003137: [SQL] BIT_OR() is not working (ivan) - resolved.
- 0003129: [SQL] TRUNCATE() return wrong result (ivan) - resolved.
- 0003143: [SQL] String function REVERSE( param ) not working. (ivan) -
resolved.
- 0003149: [SQL] GETDATE() should be a synonym of NOW() (ivan) - resolved.
- 0003119: [SQL] Can't create field with DECIMAL type (ruslan) - resolved.
- 0003117: [SQL] Can't create primary key field with INT type (ivan) -
resolved.
- 0003108: [SQL] SHOW COLUMNS display not SQL-like type of field (ivan) -
resolved.
- 0003002: [SQL] Use of objectptrs in Date functions crashes VStudio with
local & VServer (vStudio b10) (ivan) - resolved.
- 0002996: [SQL] "SHOW COLUMN" do not show the "DefaultValue" of fields.
(ivan) - resolved.
- 0003085: [SQL] "Order by" subquery gets wrong result. (ivan) - resolved.
- 0003072: [SQL] inable to take variable into 'link record' command in
Stored Procedures (ivan) - resolved.
- 0003075: [SQL Nodes] Long method on string field may return wrong result.
(ivan) - resolved.
- 0003074: [SQL] Second assign to user variable craches. (ivan) - resolved.

- 0003045: [Other] VServer crashes without log entry (ruslan) - resolved.

- 0003094: [Tables] UpdateRecord() called to the empty table yields to
infinite SegmentMap growth. (ivan) - resolved.
- 0002995: [Values] Default field values not being used when creating a new
record (ivan) - resolved.

VServer - 3.6
=============
- 0003092: [Import/Export] When trying to do an ASCII import through VStudio
- VServer goes in endless loop (ivan) - resolved.
- 0003079: [LOG] Server crashes on databse import when VerboseLevel = 3
(ivan) - resolved.
- 0003078: [SQL] Use database command produces no error case database is not
opened by current user. (ivan) - resolved.
- 0003070: [LOG] Log massage about destroyed object on verbose level should
be changed (ivan) - resolved.

VStudio - 3.6
=============
- 0003125: [SQL Editor] Rounding double value in the result. (igor_nikita) -
resolved.
- 0003076: [Import/Export] Several issues when working with ASCII import (on
Mac) (igor_nikita) - resolved.
- 0003052: [VServer Connection] VStudio crashes on trying to connect to SSL
port on non-running server (igor_nikita) - resolved.
- 0003066: [Preferences] No start of application with preferences file from
3.5.2 (igor_nikita) - resolved.
- 0001295: [Data Editor] Crash in (igor_nikita) - resolved.
- 0003029: [TAB-Panels] If close e.g. SchemaEditor panel, then you cannot
open it back via Tools menu. (igor_nikita) - resolved.
- 0003103: [Schema Editor - Column View] After selecting ALL items, you
can't select only one! (igor_nikita) - resolved.

VPHP - 3.6
==========
- 0003158: [SQL] VPHP 5 [linux] : valentina_fetch_assoc() truncates values
in DateTime fields (Kirill) - resolved.

-- 
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://edison.macserve.net/pipermail/valentina-beta/attachments/20080521/c638b991/attachment-0001.html