[ANN] Valentina 3.6b34 uploaded. NAC WIN LINUX

[Ruslan Zasukhin]

Hi All

    http://www.valentina-db.com/download/beta/3.6b34

For all platforms uploaded.

Here is the list of all 3.6 issues

kernel - 3.6
============
- 0003381: [Stored Procedures] Error when using NULL as sp argument (ivan) -
resolved.
- 0003368: [Triggers] Crash on before insert trigger (ivan) - resolved.
- 0003382: [Relation Algebra] RANDOM() is working wrong (ivan) - resolved.
- 0003367: [SQL] SHOW TRIGGERS bug (ruslan) - resolved.
- 0003379: [SQL] Crash on empty SQL (Kirill) - resolved.
- 0003380: [Feature Request] [NEW] get_fields_as_string() SQL-function to
concat all fields values to the string. (ivan) - resolved.
- 0003377: [SQL Dump] Literals using in SET PROPERTY clause should be quoted
(ivan) - resolved.
- 0003348: [SQL] DATEADD function problem (ivan) - resolved.
- 0003262: [SQL Dump/Load] Load Dump crashes VStudio Pro (ruslan) -
resolved.
- 0003346: [SQL] [NEW] SQL command "REGISTER/UNREGISTER DATABASE db_name".
(ivan) - resolved.
- 0003345: [Feature Request] "DROP CONNECTIONS FOR db_name" syntax for
server admin purpose (ivan) - resolved.
- 0003332: [Feature Request] [NEW] CREATE DATABASE extended syntax (ivan) -
resolved.
- 0003178: [Tables] Crash when delete record in debug mode (ivan) -
resolved.
- 0003333: [Stored Procedures] VStudio crash on RETURN (ivan) - resolved.
- 0003312: [SQL] Update on empty table reduce to crash (ivan) - resolved.
- 0003327: [Feature Request] [NEW] Ability to execute any statement inside
stored procedure/function. (ivan) - resolved.
- 0003304: [Indexes] FindValueAsArraySet() return wrong result on unique
nullable ulong field. (ivan) - resolved.
- 0003303: [Database] Unique violation exception cloning unique method on
ObjectPtr (ivan) - resolved.
- 0003302: [Database] Either NULL or 0 ObjectPtr values become NULL ones
after database clone. (ivan) - resolved.
- 0003288: [Fields] Crash of field convert to new type (ivan) - resolved.
- 0003269: [Feature] Add Random function (ivan) - resolved.
- 0002394: [Triggers] Compound SQL statement creating multiple triggers sets
trigger text wrong (ivan) - resolved.
- 0003109: [Stored Procedures] Creation of several SPs something went really
wrong (ivan) - resolved.
- 0003263: [SQL Dump] Crash creating sql-dump for table contained some
ObjectPtr and zero records (ivan) - resolved.
- 0003252: [Links] Using ALTER Table to create links does not work (ivan) -
resolved.
- 0003254: [SQL] Cannot set property for view with "SET PROPERTY" (ivan) -
resolved.
- 0003185: [Stored Procedures] After a failure in a SP the used cursor stays
open (ivan) - resolved.
- 0003232: [Stored Procedures] Trying to execute SP with complex cursors
results in crash (ivan) - resolved.
- 0003227: [SQL Editor] Miss calculation when using aggregate functions
(ivan) - resolved.
- 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 recognized (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 Date functions 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 crashes. (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
=============
- 0003373: [Import/Export] Join buttons Copy Al Tables and Copy Table(s)
(igor_nikita) - resolved.
- 0003372: [Import/Export] Few fixes of texts in the import wizard.
(igor_nikita) - resolved.
- 0003378: [Toolbar (Main)] there is no way to show toolbar palete after
close it. (igor_nikita) - resolved.
- 0003374: [Import/Export] Import Wizard: Use an existing database option
improvements (igor_nikita) - resolved.
- 0003375: [Dialogs] Splash screen corrections (igor_nikita) - resolved.
- 0003364: [Report Editor] VStudio often corrupts reports inside report
project (igor_nikita) - resolved.
- 0003363: [ODBC Import] Mapping Page of Importer Wizard is done from
scratch: a lot of new features and bug fixes provided. (igor_nikita) -
resolved.
- 0003357: [ODBC Import] Now Edit Toolbar correctly works for Import Wizard.
(igor_nikita) - resolved.
- 0003356: [ODBC Import] [NEW] Now more info about import results is shown:
the number of imported records per table and ttotal count of imported
records (igor_nikita) - resolved.
- 0003358: [Toolbar (Main)] [FIXED] Sometimes( for example for import wizard
) toolbars( Edit, File... ) have unused space between it (igor_nikita) -
resolved.
- 0003355: [ODBC Import] Now GUID fields will imported as String[32]
(igor_nikita) - resolved.
- 0003354: [ODBC Import] [FIXED] Before all imported values with 'String'
type was limited to 20 chars (igor_nikita) - resolved.
- 0003352: [ODBC Import] [FIXED] Now ODBC fields with not supported TYPE
created as VarChar[256]. (igor_nikita) - resolved.
- 0003351: [ODBC Import] Now database is flushed after import. (igor_nikita)
- resolved.
- 0003349: [Import/Export] Database created on ODBC import now is shown in
the SchemaEditor. (igor_nikita) - resolved.
- 0003350: [ODBC Import] Fixed bug when sometimes fields of new table did
not show (igor_nikita) - resolved.
- 0003340: [Dialogs] "Create Field..." dialog can grow now to show long
names of Tables. (igor_nikita) - resolved.
- 0003330: [Application Menu] "Preference..." item now shown at bottom of
"Edit..." menu when SchemaEditor opened (igor_nikita) - resolved.
- 0003210: [Diagrams] Adding white space to a diagram is inconvenient
(igor_nikita) - resolved.
- 0003316: [Schema Editor] Add reference to Database in the Tooltip on
DataEditor and SQL Editor TAB panels. (igor_nikita) - resolved.
- 0003317: [Application Menu] Menu Edit -> Preferences should be as
"Preferences..." (igor_nikita) - resolved.
- 0003315: [Triggers] Link SQL editor as default Trigger editor
(igor_nikita) - resolved.
- 0002966: [Schema Editor - Tree View] Sometimes we have graphical glitches
for groups title (igor_nikita) - resolved.
- 0003026: [Data Editor] Working with FILTER we should get help PROMPTS in
the status bar. (igor_nikita) - resolved.
- 0003162: [Report Editor] Unable to remove watermark from the report
(igor_nikita) - resolved.
- 0003110: [SQL Editor] changing current DB in one SQL Editor pane changes
the current DB of all ONLY with local DBs (igor_nikita) - resolved.
- 0003120: [SQL Editor] [NEW] Display cursor position in the Editor
(igor_nikita) - resolved.
- 0003018: [XML Dump/Load] Unable to load XML dump in client mode.
(igor_nikita) - resolved.
- 0003191: [Diagrams] Tables in diagrams do not redraw properly
(igor_nikita) - resolved.
- 0003300: [Schema Editor] connect tobookmarks are not remeberred
(igor_nikita) - resolved.
- 0002907: [Feature] print preview in diagram editor doesn't work properly
(igor_nikita) - resolved.
- 0003067: [Data Editor] Screen redraw when browsing data (igor_nikita) -
resolved.
- 0002818: [Diagrams] Scrolling inside a diagram pushes tables around
(VStudio 3.5b6) (igor_nikita) - resolved.
- 0002523: [Property Inspector] Change of some property in Inspector should
show confirmation dialog. (igor_nikita) - resolved.
- 0002641: [Localization] VStudio Crash LinkNames with ä,ö,ü (igor_nikita) -
resolved.
- 0001971: [Other] Inspector window improvements (igor_nikita) - resolved.
- 0002633: [XML Dump/Load] Add the ability to load tables (previously
exported as XML) in the create table window (igor_nikita) - resolved.
- 0003000: [VServer Connection] b10: VStudio crashes after long idle period
when brought to the foreground (igor_nikita) - resolved.
- 0003301: [VServer Connection] keep vstudio connected to vserver
(igor_nikita) - resolved.
- 0003267: [Diagrams] We must be able switch to other diagrams while we are
inside of some diagram. (igor_nikita) - resolved.
- 0003266: [Diagrams] Automatic adding of links to diagrams. (igor_nikita) -
resolved.
- 0002968: [Contextual Menu] Need to make submenu Create->.... instead of
Create Table, Create Foreign Key, Create Trigger etc (igor_nikita) -
resolved.
- 0002758: [Schema Editor] Copy Table - Context Menu / "Template Table"
Option in Table Creation Dialog (igor_nikita) - resolved.
- 0002171: [SQL Editor] feedback when executing large scripts (igor_nikita)
- resolved.
- 0003023: [Data Editor] In the FILTER row do not works keys from the
NUMERIC Keypad (igor_nikita) - resolved.
- 0003272: [Diagrams] printing of diagram is not complete (igor_nikita) -
resolved.
- 0003238: [SQL Editor] SQL Editor should use native OS X tab panel inside.
(igor_nikita) - resolved.
- 0003237: [Diagrams] Diagram Editor should use OS X native TAB panel
(igor_nikita) - resolved.
- 0003246: [Dialogs] Dialog CREATE VIEW should have COMMENT field.
(igor_nikita) - resolved.
- 0003242: [Dialogs] Dialog CREATE TABLE should have one more button "Create
Table & Go To Fields". (igor_nikita) - resolved.
- 0003213: [Feature] Comment property (igor_nikita) - resolved.
- 0003241: [Dialogs] Dialog CREATE TABLE should get new Text Field "Comment"
(igor_nikita) - resolved.
- 0003244: [Dialogs] Dialog CREATE LINK should have COMMENT field.
(igor_nikita) - resolved.
- 0003243: [Dialogs] Dialog CREATE FIELDS should have COMMENT field.
(igor_nikita) - resolved.
- 0003248: [Schema Editor - Tree View] Selecting Diagram in the tree we
should see its Editor in the Middle-Bottom panel (igor_nikita) - resolved.
- 0003239: [Schema Editor] Icons of Diagram Editor should be first in the
trio (igor_nikita) - resolved.
- 0003240: [Diagrams] In the diagram RENAME tool "Comments" to "Notes".
(igor_nikita) - resolved.
- 0003247: [Diagrams] List of buttons with actions is not updated correctly.
(igor_nikita) - resolved.
- 0003249: [Diagrams] Non consistent contextual menu and Action menu in the
Diagram Editor. (igor_nikita) - resolved.
- 0003226: [Diagrams] making new diagram is difficult (igor_nikita) -
resolved.
- 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.
- 0002777: [Data Editor] After try do add a NULL record in a not nullable
field DateTime got error and new record was added. - closed.
- 0003231: [Installation] just installed new build and opened it and it said
serial number expired (it isn't) and chose register product under help menu
(igor_nikita) - closed.


VServer - 3.6
=============
- 0003324: [Database] unregister db (ruslan) - resolved.
- 0002233: [Feature] VConnection.Isconnected NOT resetting Clienttimeout
(ivan) - resolved.
- 0003308: [Webpage] If SQL command has umlauts then parser produces not
expected console output (Kirill) - 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.


V4RB - 3.6
==========
- 0003180: [Docs] Mistake in documentation (user25) - resolved.
- 0003195: [SQL] V4RB - False in the Where Condition of a Join Query returns
all linked records (ivan) - resolved.
- 0003174: [RBDB API] RBDB_API table.UpdateRecord does not TRIGGER (although
3.6 beta) in local DB (ivan) - resolved.
- 0003230: [API] V4RB plugin seems to use Oldstyle Constructors (Kirill) -
resolved.


V4REV - 3.6
===========
- 0003177: [Installation] V4REV / Docs (ruslan) - resolved.
- 0003179: [Webpage] German online shop misprogrammed (jochen) - resolved.


VClient - 3.6
=============
- 0003360: [Reports] VC_VReport_imp::PreviewPage() always return NULL.
(ivan) - resolved.
- 0002178: [Client-Side Cache] Cursor->get_Table() return NULL (ivan) -
resolved.

VODBC - 3.6
===========
- 0003341: [API] In some cases ODBC Manager crashed when testing connection
fail (Kirill) - resolved.
- 0003291: [Feature Request] ODBC not available on x64 (Kirill) - resolved.


VPHP - 3.6
==========
- 0003314: [API] Functions return garbage from string field if it is empty,
but not nullable (Kirill) - resolved.
- 0003313: [API] Work with more then one connection reduce to unexpected
results (Kirill) - resolved.
- 0003251: [Localization] Mistake in phpinfo() for b20 (Kirill) - resolved.
- 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.







-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina-studio/attachments/20080828/3393477c/attachment-0001.html