Comments (13)
Can you post full query text where error can be reproduced?
from node-mysql2.
also, what happens when you prepare & execute your query from the command line client? See examples how to use PREPARE
here - http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-prepared-statements.html
from node-mysql2.
You can find attached my query, and what happens with it executing from the command line client. It works.
from node-mysql2.
create a gist please so I can copy&pasete text
from node-mysql2.
I know that the problem is with NOT IN clause, because I've subdivied the query until get where is the error, and if I execute the simplified query:
SELECT D.ID_DATO FROM DATOS D WHERE ID_DATO NOT IN(?,?)
It fails, but the same query in positive works perfectly
SELECT D.ID_DATO FROM DATOS D WHERE ID_DATO IN(?,?)
Both of them works from the command line.
from node-mysql2.
https://gist.github.com/brooly/6544575
from node-mysql2.
Thanks! On it :)
from node-mysql2.
Can't reproduce on a simple example. The ER_WRONG_ARGUMENTS
indicates that number of arguments you are passing to prepared statement is different from what it actually expect. My example - https://gist.github.com/sidorares/6545549
from node-mysql2.
You're right, your example works for me too, I don't know what's happening with my query because the number of arguments is right (If I remove the "NOT" it works). Anyway it's clear that is my fault, sorry for the inconvenience.
Thanks crack!
from node-mysql2.
if you set breakpoint (or dump with console.log) here - https://github.com/sidorares/node-mysql2/blob/master/lib/commands/execute.js#L48 - you'll be able to see expected number of parameters.
from node-mysql2.
or, even better - here - https://github.com/sidorares/node-mysql2/blob/master/lib/commands/execute.js#L60
See parameterDefinitions
array with parameter types etc
from node-mysql2.
I'll probably add some way to access parameterDefinitions
from response and error, same way you can access field definitions
from node-mysql2.
I'll try, once I solve it I will tell you 👍
from node-mysql2.
Related Issues (20)
- Read ECONNRESET after a few minutes idle HOT 1
- Typescript conversion HOT 9
- bigint will lose precision when it is larger than Number.MAX_SAFE_INTEGER HOT 2
- Performance Monitoring
- Add support for auth_gssapi_client MariaDB authentication plugin HOT 4
- Connection Timeout on ubuntu 22.04 (works fine on windows) HOT 2
- Decimals
- Error: Can't add new command when connection is in closed state HOT 1
- awsCaBundle not working as intended for import RDS cert HOT 5
- idleTimeout doenst work in lambda environment?
- `connection.stream` does not close in Bun HOT 6
- Issue with `sha256_password` auth plugin for `MySQL v8.0.35-27` HOT 1
- Connection.end() not compatible with mysql HOT 1
- deleted: Buffer(1) [ 0 ], HOT 7
- Probably -VE Testcase: TypeError: cb is not a function at C:\Development\YADAMU\src\node_modules\mysql2\lib\pool.js:64:18 HOT 1
- Probably -VE Testcase : Error: Cannot read properties of undefined (reading 'on') at PromisePoolConnection.query (C:\Development\YADAMU\src\node_modules\mysql2\promise.js:94:22) HOT 6
- Compatibility issue - Possible corruption of values with min and max values for a double. HOT 2
- Pool does not detect nor recover from failover
- Graceful poolcluster management with AWS Aurora
- [Bug?] node-mysql2 seems to swap `x` and `y` values of a geographic Point (SRID 4326) stored in mysql8 HOT 5
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from node-mysql2.