Comments (9)
It's a command in mysql protocol and I really don't want to implement it. You can always change database with sql query: query('use someNewDb', cb)
. I don't mind to have changeUser as a wrapper to query - would it solve your problem? Do you want to create PR with this change?
from node-mysql2.
I wouldn't worry how it's actually implemented, wrapper or protocol. I was just trying to drop in mysql2 to compare the speeds in our test framework, and hit this error :)
from node-mysql2.
I agree that if I advertise it to be drop in replacement I need to add changeUser. Will do as a wrapper :)
from node-mysql2.
I believe changeUser is also used to reset a connection fully before returning it to a pool (ends all transactions, etc.) Does the connection pooling functionality already do that?
from node-mysql2.
@doug65536 No, not for node-mysql2 currently. Might be not a good idea in some cases (I don't want to loose all prepared statements when I return connection to pool)
from node-mysql2.
next in my queue. link to protocol doco: http://dev.mysql.com/doc/internals/en/com-change-user.html
from node-mysql2.
also make sure that code from mysqljs/mysql#806 is backported
from node-mysql2.
and mysqljs/mysql@5e43c5c as well ( or better, pull all latest Pool / PoolCluster changes from node-mysql )
from node-mysql2.
landed, soon to be published as 0.15.0
from node-mysql2.
Related Issues (20)
- bigNumberStrings: true is not return type number
- namedPlaceholders: "ER_WRONG_ARGUMENTS" in data object with property number type for LIMIT clause. HOT 2
- 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
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.