search

tediousjs / node-mssql

Microsoft SQL Server client for Node.js
https://tediousjs.github.io/node-mssql
MIT License
2.23k stars 465 forks source link

Invalid object name 'VIEW_NAME' when query View #1493

Closed ItsHeart closed 1 year ago

ItsHeart commented 1 year ago

Expected behaviour:

when I query a view, I get errors like "Invalid object name 'VIEW_NAME'". the error sql like "select top 1 * from [dbo].[view_name]".It should be noted that this SQL can be run in navicat. and I tried using msSQL to query another SQL statement like "select 1" without any error.

Actual behaviour:

i can correctly query view

Configuration:

{
  user: "",
  password: "",
  database: "",
  server: "",
  options: {
    connectTimeout: 15000,
    requestTimeout: 60000,
    encrypt: false,
    trustServerCertificate: false,
  },
}

Software versions