Getting "The filename, directory name, or volume label syntax is incorrect." trying to run Python commands

[gitmadness]

Issue Type: Bug

Updated Python and ADS and now Python commands like %pip install Kqlmagic fail with "The filename, directory name, or volume label syntax is incorrect.".

Azure Data Studio version: azuredatastudio 1.31.1 (65fb22c, 2021-07-28T21:03:21.018Z)
OS version: Windows_NT x64 10.0.22000

System Info

Item	Value
CPUs	Intel(R) Core(TM) i7-9700K CPU @ 3.60GHz (8 x 3600)
GPU Status	2d_canvas: enabled gpu_compositing: enabled multiple_raster_threads: enabled_on oop_rasterization: enabled opengl: enabled_on rasterization: enabled skia_renderer: enabled_on video_decode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled
Load (avg)	undefined
Memory (System)	63.85GB (55.06GB free)
Process Argv
Screen Reader	no
VM	0%

Extensions: none

[Charles-Gagnon]

@lucyzhang929 Could you check this out?

[lucyzhang929]

Hi @gitmadness, I am able to repro and will look into the issue. In the meantime, could you try using the following to install Kqlmagic?

import sys
!{sys.executable} -m pip install Kqlmagic

[gitmadness]

@lucyzhang929, the below command works

import sys
!{sys.executable} -m pip install Kqlmagic

[gitmadness]

@lucyzhang929, just to clarify, do you plan to restore the original behavior or do I need to add "import sys..." everywhere?

[lucyzhang929]

@gitmadness I will investigate the issue for our September release but in the meantime I would suggest using the code snippet above.

[gitmadness]

Using the code snippet means updating all the code cells in all the notebooks, right? That is inconvenient. Is there another workaround which require less updates?

…

________________________________ From: Lucy Zhang ***@***.***> Sent: Thursday, August 12, 2021 6:20 AM To: microsoft/azuredatastudio ***@***.***> Cc: Tom Wu ***@***.***>; Mention ***@***.***> Subject: Re: [microsoft/azuredatastudio] Getting "The filename, directory name, or volume label syntax is incorrect." trying to run Python commands (#16656) @gitmadness<https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fgitmadness&data=04%7C01%7CTom.Wu%40microsoft.com%7C2104eec286c1467c457208d95d93eb8f%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637643712170066884%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=Oa78NqbBga6It57R5OtDD9ZCpwv5p%2BCrGgYv%2BGQHS38%3D&reserved=0> I will investigate the issue for our September release but in the meantime I would suggest using the code snippet above. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fazuredatastudio%2Fissues%2F16656%23issuecomment-897633972&data=04%7C01%7CTom.Wu%40microsoft.com%7C2104eec286c1467c457208d95d93eb8f%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637643712170066884%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=mCDrvovIMjWJFfj1czddT37qWxWlrVrR8e4bcYCtbog%3D&reserved=0>, or unsubscribe<https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAHUFIEN7UB4F64N5LTLORJLT4PDA3ANCNFSM5B4ELVKA&data=04%7C01%7CTom.Wu%40microsoft.com%7C2104eec286c1467c457208d95d93eb8f%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637643712170076839%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=Jd55y1h78yUXGdELleFlqCWH%2FUWYODfnd586BYvdTo0%3D&reserved=0>. Triage notifications on the go with GitHub Mobile for iOS<https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapps.apple.com%2Fapp%2Fapple-store%2Fid1477376905%3Fct%3Dnotification-email%26mt%3D8%26pt%3D524675&data=04%7C01%7CTom.Wu%40microsoft.com%7C2104eec286c1467c457208d95d93eb8f%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637643712170076839%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=6k8Zh01kIbmVKMzUHaaPqiS56tmbU%2FRVzxhqY9ltY5M%3D&reserved=0> or Android<https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fplay.google.com%2Fstore%2Fapps%2Fdetails%3Fid%3Dcom.github.android%26utm_campaign%3Dnotification-email&data=04%7C01%7CTom.Wu%40microsoft.com%7C2104eec286c1467c457208d95d93eb8f%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637643712170076839%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=CJAoF2Dze%2FCOeSuilUSI4WwzBgPm7BKhR8gkZqYXVxM%3D&reserved=0>.

[lucyzhang929]

It looks like this is a known issue with IPython 7.26: ipython/ipython#13084. You can mitigate the issue by downgrading to 7.25.

To install IPython 7.25 in ADS, open the Manage Packages wizard,

search for IPython and choose 7.25 in the package version dropdown. You may need to restart ADS after the installation is complete.

I will close this issue for now. Feel free to re-open if you have any other questions!