Skip to content

Duplicate SQL query name "" found, please rename other one. #32

@Finomosec

Description

@Finomosec

When importing form a sql file and there are too many empty lines between the queries, this error happens:
Duplicate SQL query name "" found, please rename other one.

I prepared a little demo, to show this here:
https://github.com/Finomosec/yesql-demo

Here is its output:

npm run start

> yesql-demo@1.0.0 start
> node src/server.js

Loading: ok.sql ...
[ 'ok.sql', 'Q1', 'Q2', 'Q3', 'Q4' ]
Loading: broken.sql ...
yesql-demo\node_modules\yesql\yesql.js:32
            throw new Error('Duplicate SQL query name "' + sqlName + '" found, please rename other one.')
            ^

Error: Duplicate SQL query name "" found, please rename other one.
    at yesql-demo\node_modules\yesql\yesql.js:32:19
    at Array.forEach (<anonymous>)
    at yesql-demo\node_modules\yesql\yesql.js:28:8
    at Array.reduce (<anonymous>)
    at readSqlFiles (yesql-demo\node_modules\yesql\yesql.js:17:6)
    at Object.<anonymous> (yesql-demo\src\server.js:6:39)
    at Module._compile (node:internal/modules/cjs/loader:1469:14)
    at Module._extensions..js (node:internal/modules/cjs/loader:1548:10)
    at Module.load (node:internal/modules/cjs/loader:1288:32)
    at Module._load (node:internal/modules/cjs/loader:1104:12)

Node.js v20.18.0

Process finished with exit code 1

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions