UPDATES and FIXES in VSTAR 2.1RC1.33

0 views
Skip to first unread message

danakil

unread,
Jun 19, 2009, 1:28:08 AM6/19/09
to vectorstar
2.1 RC1.33
==========
bug fixes:
REFERENCES with multiple source/destination columns now works
correctly, e.g.:
'T1.[C1,C2]' REFERENCES 'T2.[C1,C2]'

JOIN with multiple columns (e.g. 'T1' JOIN 'T2' USING
'[C1,C2]')
Toggle type display in VUI
NEW_COLUMN in a non-empty table
OPEN 'Sys.Column'
added:
HAVING
DECODE
LEFT_JOIN
LIMIT X === PAGESIZE X PAGE 0
Alias support in CREATE_TABLE and DESCRIBE_TABLE
Default support in CREATE_TABLE
changed:
JOIN_DISTINCT renamed to SEMI_JOIN
improved error handling for initialization, GET_OPTION,
SET_OPTION, WHERE

danakil

unread,
Jun 19, 2009, 1:30:29 AM6/19/09
to vectorstar
>        OPEN 'Sys.Column'

This was the problem reported by Dan Guerrero last Friday. it is now
fixed.

Sys.Database, Sys.Table, Sys.Column, and Sys.Procedure, will all be
fully implemented in the final release.

danakil

unread,
Jun 19, 2009, 1:43:15 AM6/19/09
to vectorstar

ADDED:
> LEFT_JOIN
We have now implemented LEFT_JOIN in addition to JOIN (which is a
standard INNER_JOIN).

> LIMIT N === PAGESIZE N PAGE 0
We now have LIMIT N which is equivalent to its MySQL counterpart (it
provides the first N result rows).
It is implemented as PAGESIZE N PAGE 0 combination (Note how the
PAGESIZE N PAGE M is a more powerful scheme)

CHANGED:
> JOIN_DISTINCT renamed to SEMI_JOIN
As Wolfgang Sakuler correctly pointed out the last time we had our
VectorStar meeting in Vienna, JOIN_DISTINCT is really a SEMI_JOIN. IBM
DB2 refers to it as "SEMI_JOIN" too.
We have thus renamed it so. Thanks Wolfgang, your comments are always
very well thought-of and quite insightful.
Reply all
Reply to author
Forward
0 new messages