[ANN] 3.6b20 Change log from Mantis.

Mon Jun 16 06:56:42 CDT 2008

kernel - 3.6
============
- 0003188: [SQL] Slow SQL search (ivan) - resolved.
- 0003165: [SQL] GROUP BY WITH ROLLUP on empty cursor gets to crash (ivan) -
resolved.
- 0003014: [Join of Tables] if more than 5 rows need to be returned from a
join query, 0 are returned (ivan) - resolved.
- 0003105: [Stored Procedures] when assigning a sql-statement to a var using
() gives null result (ivan) - resolved.
- 0003022: [SQL Dump] identity fields fail upon restore because the
method(RecId) is not recognised (ivan) - resolved.
- 0003157: [Utilities Functions] Add a UUID function (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.
- 0003116: [Feature Request] GROUP_CONCAT Function (ruslan) - 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.
- 0003118: [Stored Procedures] Cursor declaration in SP wrongfully ignores
ORDER BY clause. (ivan) - 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.
- 0003111: [Indexes] Wrongfully chosen not tmp volume for SortMap case
database is RO. (ivan) - resolved.
- 0003002: [SQL] Use of objectptrs in Datefunctions crashes VStudio with
local & VServer (vStudio b10) (ivan) - resolved.
- 0000810: [SQL] support for correlated subqueries (ivan) - resolved.
- 0001872: [SQL] Correlated subqueries don't work. (ruslan) - resolved.
- 0002996: [SQL] "SHOW COLUMN" do not show the "DefaultValue" of fields.
(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.
- 0003094: [Tables] UpdateRecord() called to the empty table yelds to
infinite SegmentMap growth. (ivan) - resolved.
- 0003085: [SQL] "Order by" subquery gets wrong result. (ivan) - resolved.
- 0003080: [Encryption] Some delete-record operation on encrypted database
may bring garbage into the rest records. (ivan) - resolved.
- 0003069: [Feature Request] objptr->* (ivan) - resolved.
- 0003021: [Database] "Segment map corrupted" appears VERY often (ivan) -
resolved.
- 0003072: [SQL] inable to take variable into 'link record' command in
Stored Procedures (ivan) - resolved.
- 0002995: [Values] Default field values not being used when creating a new
record (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.
- 0003073: [NEW] stored procedure caches values from first call (ivan) -
resolved.
- 0003045: [Other] VServer crashes without log entry (ruslan) - resolved.
 

VStudio - 3.6
=============
- 0003225: [Import/Export] smart mapping must ignore capitalization of the
names (igor_nikita) - resolved.
- 0003221: [Diagrams] Importing diagrams is not really import (igor_nikita)
- resolved.
- 0003220: [Diagrams] Exported diagrams on OSX cannot be imported (without
manual intervention) (igor_nikita) - resolved.
- 0003219: [Diagrams] Print Option always disabled (igor_nikita) - resolved.
- 0003216: [Schema Editor] Table popup in Create New Field dialog is not
sorted (igor_nikita) - resolved.
- 0003215: [VServer Connection] On Connect VStudio send command SELECT *
FROM (SHOW USERS) WHERE Name = 'xxx' for EACH USER ???? (igor_nikita) -
resolved.
- 0003214: [VServer Connection] FEW commands "SHOW VIDENTS" ... why ?
(igor_nikita) - resolved.
- 0003209: [Diagrams] Adding an objectpointer field to a table glyph in a
diagram does not draw the link line to the linked table (igor_nikita) -
resolved.
- 0003201: [Diagrams] Deleting a table (with objptr) from a diagram crashes
VStudio (igor_nikita) - resolved.
- 0003206: [Diagrams] Renaming a table in a diagram removes it from the
diagram (igor_nikita) - resolved.
- 0003196: [Feature] Add import/export functionality for bookmarks
(igor_nikita) - resolved.
- 0003200: [Application Menu] Three problems when making new database file
(igor_nikita) - resolved.
- 0003199: [Import/Export] When you dump SQL it makes file without the
".sql" extension (igor_nikita) - resolved.
- 0002930: [Feature] Save Password (igor_nikita) - resolved.
- 0003192: [Diagrams] Adding a field to a table in a diagram resizes the
table (igor_nikita) - resolved.
- 0003154: [SQL Editor] "copy" by CTRL+C not working in the error window
(igor_nikita) - resolved.
- 0002318: [Schema Editor] "delete all data..." is missing (igor_nikita) -
resolved.
- 0003182: [Views] creating fields with 2 window open show "funny" things
(igor_nikita) - resolved.
- 0003181: [Other] Running diagnose on a (specific) local db crashes VStudio
(igor_nikita) - resolved.
- 0003114: [Import/Export] some files crashes ASCII import when not setting
options before opening file (igor_nikita) - resolved.
- 0003112: [Import/Export] ASCII import - when "have header" then the header
is not visible anymore! (igor_nikita) - resolved.
- 0003161: [Reports - Printing] Add feature for print or export to PDF start
from specified page number (igor_nikita) - resolved.
- 0003163: [Report Editor] Object Inspector at the right side often displays
wrong size of controls and report (igor_nikita) - resolved.
- 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.


VServer - 3.6
=============
- 0003106: [SQL] Running an update query corrupts the index of a method
field (ivan) - resolved.
- 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.


VPHP - 3.6
==========
- 0003208: [API] [NEW] bool valentina_trace_mode( [bool] ) (Kirill) -
resolved.
- 0003207: [API] [NEW] bool valentina_throw_exceptions( [bool] ) (Kirill) -
resolved.
- 0003197: [Feature] Add php exception handling (Kirill) - resolved.
- 0003168: [Webpage] VPHP Error (Kirill) - resolved.
- 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/20080616/8898a787/attachment-0001.html