SQL PowerShell provider - Set-Location to FullTextIndex yields an error - by Teofil Cobzaru

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 793570 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 7/11/2013 12:34:27 PM
Access Restriction Public

Description

I am using the SQLPS PowerShell module. Navigating down to the level of a database table, and listing the child items, will display the FullTextIndex among the items.

cd  SQLSERVER:\sql\MY_MACHINE\SQL2008R2\Databases\MY_DB\Tables\dbo.MY_TABLE

Then:

dir 

will yield these results:

Checks
Columns
ExtendedProperties
ForeignKeys
FullTextIndex
Indexes
PartitionSchemeParameters
PhysicalPartitions
Statistics
Triggers

Then:

cd FullTextIndex

will yield the error:

cd : Cannot find path 'SQLSERVER:\sql\MY_MACHINE\SQL2008R2\Databases\MY_DB\Tables\dbo.MY_TABLE\FullTextIndex' because it does not exist.

Another weird thing is that I use the Test-Path cmdlet with its default PathType of Any (or explicitly specifying Any as PathType) it returns False (the path does not exist, which is consistent with the cd error). If I am using Test-Path with PathType set to container, it returns True, which is consistent with the dir cmdlet displaying the item.

Test-Path FullTextIndex
False

Test-Path FullTextIndex -PathType Container
True

Sign in to post a comment.
Posted by Microsoft on 7/30/2013 at 9:24 AM
Hello Teofil. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you.

-Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Posted by Teofil Cobzaru on 7/16/2013 at 3:06 AM
I did that, and it behaves the same.
Posted by Sethu Srinivasan on 7/15/2013 at 11:55 AM
Can you please update to SQL 2012 SP1 and let us know if you still see this issue?

Microsoft® SQL Server® 2012 Service Pack 1 (SP1) - http://www.microsoft.com/en-us/download/details.aspx?id=35575


Thanks
Sethu Srinivasan [MSFT]
SQL Server