The error message of QueryFailedError cannot be located to the source code position.

[wcldyx]

Issue description

SQL error cannot be pinpointed to the source code location.

Expected Behavior

I hope the error message can accurately pinpoint the location in the source code.

Actual Behavior

PS E:\geng_shen\Final_Salvation\ts> ts-node .\index.ts
query failed: select * from notable
error: QueryFailedError: Error: Invalid object name 'notable'.
E:\geng_shen\Final_Salvation\ts\node_modules\mssql\lib\tedious\request.js:492
callback(error, recordsets, output, rowsAffected, recordsetcolumns)
^
QueryFailedError: Error: Invalid object name 'notable'.
at E:\geng_shen\Final_Salvation\ts\node_modules\typeorm\src\driver\sqlserver\SqlServerQueryRunner.ts:282:30
at E:\geng_shen\Final_Salvation\ts\node_modules\mssql\lib\base\request.js:440:25
at Request.userCallback (E:\geng_shen\Final_Salvation\ts\node_modules\mssql\lib\tedious\request.js:492:15)
at Request.callback (E:\geng_shen\Final_Salvation\ts\node_modules\tedious\src\request.ts:379:14)
at Parser.onEndOfMessage (E:\geng_shen\Final_Salvation\ts\node_modules\tedious\src\connection.ts:3713:22)
at Object.onceWrapper (node:events:631:28)
at Parser.emit (node:events:517:28)
at Parser.emit (node:domain:489:12)
at Readable. (E:\geng_shen\Final_Salvation\ts\node_modules\tedious\src\token\token-stream-parser.ts:30:12)
at Readable.emit (node:events:517:28) {
query: 'select * from notable',
parameters: undefined,
driverError: RequestError: Invalid object name 'notable'.
at handleError (E:\geng_shen\Final_Salvation\ts\node_modules\mssql\lib\tedious\request.js:384:15)
at Connection.emit (node:events:517:28)
at Connection.emit (node:domain:489:12)
at Connection.emit (E:\geng_shen\Final_Salvation\ts\node_modules\tedious\src\connection.ts:1902:18)
at RequestTokenHandler.onErrorMessage (E:\geng_shen\Final_Salvation\ts\node_modules\tedious\src\token\handler.ts:388:21)
at Readable. (E:\geng_shen\Final_Salvation\ts\node_modules\tedious\src\token\token-stream-parser.ts:22:55)
at Readable.emit (node:events:517:28)
at Readable.emit (node:domain:489:12)
at addChunk (node:internal/streams/readable:368:12)
at readableAddChunk (node:internal/streams/readable:341:9) {
code: 'EREQUEST',
originalError: Error: Invalid object name 'notable'.
at handleError (E:\geng_shen\Final_Salvation\ts\node_modules\mssql\lib\tedious\request.js:382:19)
at Connection.emit (node:events:517:28)
at Connection.emit (node:domain:489:12)
at Connection.emit (E:\geng_shen\Final_Salvation\ts\node_modules\tedious\src\connection.ts:1902:18)
at RequestTokenHandler.onErrorMessage (E:\geng_shen\Final_Salvation\ts\node_modules\tedious\src\token\handler.ts:388:21)
at Readable. (E:\geng_shen\Final_Salvation\ts\node_modules\tedious\src\token\token-stream-parser.ts:22:55)
at Readable.emit (node:events:517:28)
at Readable.emit (node:domain:489:12)
at addChunk (node:internal/streams/readable:368:12)
at readableAddChunk (node:internal/streams/readable:341:9) {
info: [ErrorMessageToken]
},
number: 208,
lineNumber: 1,
state: 1,
class: 16,
serverName: 'DESKTOP-RKK5N9M',
procName: '',
precedingErrors: []
},
code: 'EREQUEST',
originalError: Error: Invalid object name 'notable'.
at handleError (E:\geng_shen\Final_Salvation\ts\node_modules\mssql\lib\tedious\request.js:382:19)
at Connection.emit (node:events:517:28)
at Connection.emit (node:domain:489:12)
at Connection.emit (E:\geng_shen\Final_Salvation\ts\node_modules\tedious\src\connection.ts:1902:18)
at RequestTokenHandler.onErrorMessage (E:\geng_shen\Final_Salvation\ts\node_modules\tedious\src\token\handler.ts:388:21)
at Readable. (E:\geng_shen\Final_Salvation\ts\node_modules\tedious\src\token\token-stream-parser.ts:22:55)
at Readable.emit (node:events:517:28)
at Readable.emit (node:domain:489:12)
at addChunk (node:internal/streams/readable:368:12)
at readableAddChunk (node:internal/streams/readable:341:9) {
info: ErrorMessageToken {
name: 'ERROR',
handlerName: 'onErrorMessage',
number: 208,
state: 1,
class: 16,
message: "Invalid object name 'notable'.",
serverName: 'DESKTOP-RKK5N9M',
procName: '',
lineNumber: 1
}
},
number: 208,
lineNumber: 1,
state: 1,
class: 16,
serverName: 'DESKTOP-RKK5N9M',
procName: '',
precedingErrors: []
}

Steps to reproduce

// index.ts
import { DataSource } from "typeorm";

const dataSource = new DataSource({
  type: 'mssql',
  host: "192.168.101.27",
  port: 1433,
  username: 'sa',
  password: 'sql',
  database: 'shanxi',
  logging: ['error'],
  entities: [],
  synchronize: false,
  pool: {
    max: 50,
    min: 10,
    idleTimeoutMillis: 3000,
  },
  requestTimeout: 30000,
  options: {
    encrypt: false,
  },
})

async function main () {
 await dataSource.initialize();
 //Intentionally creating errors.
 const list = await dataSource.query('select * from notable')
 console.log(list)
}

main();

My Environment

Dependency	Version
Operating System
Node.js version	v18.19.0
Typescript version	^4.7.4
TypeORM version	^0.3.20

Additional Context

No response

Relevant Database Driver(s)

• aurora-mysql
• aurora-postgres
• better-sqlite3
• cockroachdb
• cordova
• sqlite
• expo
• mongodb
• mysql
• nativescript
• sqljs
• oracle
• postgres
• react-native
• sqlite-abstract
• sap
• spanner
• sqlserver

Are you willing to resolve this issue by submitting a Pull Request?

Yes, I have the time, and I know how to start.

[code95278]

Me too