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

Truncated SQL commands #290

Closed
rfreire opened this issue Aug 22, 2016 · 5 comments
Closed

Truncated SQL commands #290

rfreire opened this issue Aug 22, 2016 · 5 comments

Comments

@rfreire
Copy link

rfreire commented Aug 22, 2016

SQL commands get truncated for SQL dependencies at 1024 characters. There should be some way to customize the max length to avoid this issue.

@rfreire
Copy link
Author

rfreire commented Aug 22, 2016

Sorry, but why is this just an 'enhancement'?
Currently what I get from AI is:
SELECT [column_list] .... {truncated}

To be honest, this is completely useless for me... just like not having the command at all. It seems to be an important issue as the full sql command is required to figure it out what's going on.
Besides, I'm using EF (code first) which generates large sql commands that I don't (and don't want to) have control on.

Thanks!

@dnduffy
Copy link
Member

dnduffy commented Aug 22, 2016

The current schema has 1024 bytes for storing that field.
There is a schema update coming which will increase it to 8192.
If you can't wait for the schema update to be deployed you can store your queries in a custom property which can currently handle 8K.

@rfreire
Copy link
Author

rfreire commented Aug 22, 2016

Great!
Can I ask you for an approx. time frame for the schema update?
I'd like to have an idea to plan accordingly.

Thanks!

@abaranch
Copy link
Contributor

It should be out with the next beta for which we do not have strict timelines right now. I would expect it to be end of September, begging of October.

@cijothomas
Copy link
Contributor

Closing this as the schema is already updated.

TimothyMothra added a commit that referenced this issue Oct 25, 2019
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

4 participants