search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.56k stars 899 forks source link

ADS Query window does not show hidden incompatible characters #4382

Closed jrowlandjones closed 3 years ago

jrowlandjones commented 5 years ago

Issue Type: Bug

Use the following code to create an external table: CREATE EXTERNAL TABLE [dbo].[helloORC_HDP3_0] ([name] varchar(20) )   WITH ( LOCATION='/',            DATA_SOURCE = AzureStorage,           FILE_FORMAT = OrcFileFormat,         REJECT_TYPE = VALUE,         REJECT_VALUE = 0  ) ;

Error message is: Msg 103010, Level 16, State 1, Line 1 Parse error at line: 3, column: 3: Incorrect syntax near ' '.

image

Azure Data Studio version: azuredatastudio 1.4.5 (887f4e8985023602e599cf86bdb44df48bb28569, 2019-02-12T06:20:08.633Z) OS version: Windows_NT x64 10.0.17763

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-6700 CPU @ 3.40GHz (8 x 3408)| |GPU Status|2d_canvas: enabled
checker_imaging: disabled_off
flash_3d: enabled
flash_stage3d: enabled
flash_stage3d_baseline: enabled
gpu_compositing: enabled
multiple_raster_threads: enabled_on
native_gpu_memory_buffers: disabled_software
rasterization: enabled
video_decode: enabled
video_encode: enabled
webgl: enabled
webgl2: enabled| |Memory (System)|63.92GB (42.15GB free)| |Process Argv|C:\Program Files\Azure Data Studio\azuredatastudio.exe| |Screen Reader|no| |VM|0%|
Extensions (3) Extension|Author (truncated)|Version ---|---|--- ssmskeymap|kev|1.1.0 sql-dw|Mic|0.0.1 sql-vnext|Mic|0.10.2
kevcunnane commented 5 years ago

Can you clarify, what's the incompatible character here? Just trying to understand where to assign this.

jrowlandjones commented 5 years ago

Actually I couldn't tell what it was @kevcunnane

I am reporting it as the error shows.

kburtram commented 3 years ago

Closing out this older issue. We haven't seen similar repros so not sure what we can do in this case. Please let us know if you're still impacted by this issue.