Return
-
Title
SQL Parser throws a syntax error during the parsing of an internal query that contains 'OPENROWSET(TABLE' keywords in conjunction -
Description
SQL Parser throws a syntax error during the parsing of an internal query that contains 'OPENROWSET(TABLE' keywords in conjunction
In the log files was founded:
2024-05-08 12:07:05.622 DEBUG [QDQ6X6Y2]: SQL Parser exited with code 1
2024-05-08 12:07:05.623 DEBUG [QDQ6X6Y2]: syntax error, state:1410(10101) near: TABLE(14,19)
2024-05-08 12:07:05.623 DEBUG [QDQ6X6Y2]: SQL Query: insert @tab
select database_id,
file_id,
sample_ms,
num_of_reads,
num_of_bytes_read,
io_stall_read_ms,
num_of_writes,
num_of_bytes_written,
io_stall_write_ms,
io_stall,
size_on_disk_bytes,
file_handle
from OpenRowset(TABLE VIRTUALFILESTATS, @DatabaseId, @FileId) -
Resolution
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of ApexSQL Audit. -
Defect ID
232405