Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

node-mysql can not handle longtext fields with > 250 chars #8

Closed
saschagehlich opened this issue Aug 24, 2010 · 2 comments
Closed

node-mysql can not handle longtext fields with > 250 chars #8

saschagehlich opened this issue Aug 24, 2010 · 2 comments

Comments

@saschagehlich
Copy link

Hello there,

I created a table with one longtext column and put in the following string (just for testing)

http://pastie.org/1112094

It is 250 characters long.
This is my node.js code for selecting the data from the database:

this.client.query('SELECT * FROM tickets LIMIT 1', function(err, results, fields) {
  console.log("ticket available");
  return null;
});

Works fine for the 250 character string. As soon as I add another 0 the query will not load and be stuck in a kind of infinite loop.

@felixge
Copy link
Collaborator

felixge commented Aug 24, 2010

Thanks for the details, I think this issue is identical to #7. I have already started to look into it, the parser is screwing up here for sure. Hopefully I'll have a fix soon.

@felixge
Copy link
Collaborator

felixge commented Aug 25, 2010

This should be fixed in f0ce2e3. Let me know if it works for you!

dveeden pushed a commit to dveeden/mysql that referenced this issue Jan 31, 2023
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

2 participants