 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
Serious $$..$$ macro issues in 6.3.168!!! |
|
The latest update (6.3.168) has some serious issues when $$..$$ type macros are involved. Many (most) of those I've created are broken. Even those simple ones like this:
 |
 |
$$
DECLARE
@fixed_drives TABLE (
drive CHAR(1) NOT NULL UNIQUE
,[MB free] INT NOT NULL
,[GB free] AS CAST([MB free] / 1000.0 as DECIMAL(18,2))
)
INSERT INTO @fixed_drives (drive, [MB free])
EXEC [master].sys.xp_fixeddrives
SELECT * FROM @fixed_drives ORDER BY drive
$$
|
When triggering it I get the following error message:
 |
 |
Msg 102, Level 15, State 1, Incorrect syntax near 'T'.
The command(s) completed with errors (93.01 ms).
|
Or:
 |
 |
$$
SELECT
cl.ID
,cl.DatabaseName
,cl.Command
,cl.CommandType
,cl.StartTime
,cl.JobTime
,cl.EndTime
,cl.ErrorNumber
,cl.ErrorMessage
,cl.SchemaName
,cl.ObjectName
,cl.ObjectType
,cl.IndexName
,cl.IndexType
,cl.StatisticsName
,cl.PartitionNumber
,cl.ExtendedInfo
FROM
gemdba.dbo.CommandLog AS cl
WHERE 1 = 1
AND cl.ErrorNumber <> 0
ORDER BY
cl.ID DESC
$$
|
Result:
 |
 |
Msg 207, Level 16, State 1, Invalid column name 'Commandcl'.
The command(s) completed with errors (81.37 ms).
|
... and so on.
Could you provide a download link to the previous version, please?
|
|
Mon Dec 03, 2012 5:17 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Thank you for your continues and valuable feedback. We have sent you a link for the private build 6.3.170. Please let us know if you can reproduce the same issue in that build.
|
|
Mon Dec 03, 2012 1:32 pm |
|
 |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
|
|
 |
 |
Thank you for your continues and valuable feedback. We have sent you a link for the private build 6.3.170. Please let us know if you can reproduce the same issue in that build. |
I cannot reproduce them. $$...$$ macros back to normal. Thank you very much for the quick fix.
|
|
Tue Dec 04, 2012 4:34 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|