× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
SachinPrakash reported 2017-05-04T13:04:49Z  · tariqrahiman last modified 2017-05-15T03:55:13Z

Sybase ASE Visual Explain XML : Incomplete Plan when using "Declare" or "Set"


customer request
Priority Major
Complexity Unknown
Component Q Analyzer - Visual Explain Plan
Version 17.0

Failure scenario

Success scenario

Connection info: Sybase ASE 15.7; 10.1.1.92. Queries:

CREATE TABLE dbo.xml_test  ( 
   artist             varchar(20) NOT NULL,
   library            varchar(30) NOT NULL,
   composer           varchar(30) NOT NULL,
   created           datetime NOT NULL,
   updated             datetime NULL 
   )
GO
ALTER TABLE dbo.xml_test
   ADD CONSTRAINT PK_xml_test
   UNIQUE (created, artist, library)
   WITH max_rows_per_page = 0, reservepagegap = 0
GO

declare @period_dt varchar(10)
set @period_dt='05/03/2017 12:00:00.000 AM'
SELECT * FROM dbo.xml_test xt
WHERE xt.created < dateadd(dd, 1, @period_dt)
GROUP BY xt.artist
go
SELECT * FROM dbo.xml_test xt
WHERE xt.created < dateadd(dd, 1, '05/03/2017 12:00:00.000 AM')
GROUP BY xt.artist

 

4 attachments

Issue #15204

Closed
Fixed
Resolved 2017-05-08T17:21:44Z
 
 
Completion
No due date
Fixed Build v19.0.0-alpha-3, v18.0.12, v17.0.12-6
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017