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

MySQL 5.5+ truncate and quoted table name #209

Open
mloskot opened this issue Oct 9, 2013 · 0 comments
Open

MySQL 5.5+ truncate and quoted table name #209

mloskot opened this issue Oct 9, 2013 · 0 comments

Comments

@mloskot
Copy link
Contributor

mloskot commented Oct 9, 2013

This has been reported on soci-users (see soci error thread) where Aleksander responded:

It seems that MySQL starting with 5.5 stopped accepting

truncate 'test_table'

instead of

truncate test_table

since the variant with soci::use() escapes and quotes the string.
I don't see any way of fixing it since I can hardly stop quoting the all strings passed to use(), and it would be very hard to parse the queries to decide whether the string is a table name or something else.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant