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

select field content omit bug #2283

Closed
wubinhong opened this Issue Oct 12, 2015 · 4 comments

Comments

Projects
None yet
3 participants
@wubinhong

wubinhong commented Oct 12, 2015

When I query a select clause in the Query tab, I found that I can only select a part of content for some field with long text.
For example:

SELECT imgsrc FROM `cm_salon_itemcomment` WHERE `order_ticket_id`=85;

I got the field imgsrc content like this:

[{"img":"http:\/\/newapi.choumei.cn\/Uploads\/choumeicomment\/2015-01-01\/54a546bb65006.jpg","thumbimg":"http:\/\/newapi.choumei.cn\/Uploads\/choumeic...

What I expect is:

[{"img":"http:\/\/newapi.choumei.cn\/Uploads\/choumeicomment\/2015-01-01\/54a546bb65006.jpg","thumbimg":"http:\/\/newapi.choumei.cn\/Uploads\/choumeicomment\/2015-01-01\/s_54a546bb65006.jpg","width":640,"height":854,"thumbwidth":200,"thumbheight":200},{"img":"http:\/\/newapi.choumei.cn\/Uploads\/choumeicomment\/2015-01-01\/54a546bb65d9b.jpg","thumbimg":"http:\/\/newapi.choumei.cn\/Uploads\/choumeicomment\/2015-01-01\/s_54a546bb65d9b.jpg","width":640,"height":854,"thumbwidth":200,"thumbheight":200},{"img":"http:\/\/newapi.choumei.cn\/Uploads\/choumeicomment\/2015-01-01\/54a546bb66b09.jpg","thumbimg":"http:\/\/newapi.choumei.cn\/Uploads\/choumeicomment\/2015-01-01\/s_54a546bb66b09.jpg","width":640,"height":854,"thumbwidth":200,"thumbheight":200},{"img":"http:\/\/newapi.choumei.cn\/Uploads\/choumeicomment\/2015-01-01\/54a546bb675af.jpg","thumbimg":"http:\/\/newapi.choumei.cn\/Uploads\/choumeicomment\/2015-01-01\/s_54a546bb675af.jpg","width":640,"height":854,"thumbwidth":200,"thumbheight":200},{"img":"http:\/\/newapi.choumei.cn\/Uploads\/choumeicomment\/2015-01-01\/54a546bb680d8.jpg","thumbimg":"http:\/\/newapi.choumei.cn\/Uploads\/choumeicomment\/2015-01-01\/s_54a546bb680d8.jpg","width":640,"height":854,"thumbwidth":200,"thumbheight":200}]

By the way, My sequelpro version is 1.1 Build 4499, I never encounter this problem before I upgrade the software to version 1.1.

@dmoagx

This comment has been minimized.

Show comment
Hide comment
@dmoagx

dmoagx Oct 12, 2015

Member

To clarify:

  • This happens only in the Query editor results table
  • The edit has to start in an inline field
  • Then use tab to go to a TEXT/BLOB field
  • Use cmd+C to copy the value without opening the field editor
  • Value is truncated after 150 bytes
Member

dmoagx commented Oct 12, 2015

To clarify:

  • This happens only in the Query editor results table
  • The edit has to start in an inline field
  • Then use tab to go to a TEXT/BLOB field
  • Use cmd+C to copy the value without opening the field editor
  • Value is truncated after 150 bytes

dmoagx added a commit that referenced this issue Oct 12, 2015

Fix an issue where copying the contents of a TEXT/BLOB field from a c…
…ustom query result would not contain all data if keyboard navigation was used (#2283)
@wubinhong

This comment has been minimized.

Show comment
Hide comment
@wubinhong

wubinhong Oct 15, 2015

Thanks for your reply, for my situation(v1.1), there is no editor pop up
when I click the field in the Query editor results table, so I can copy the
entire content for the TEXT/BLOB field. Would you please fix this up in the
next version?

Thank you very much!

On Mon, Oct 12, 2015 at 11:25 PM, Max Lohrmann notifications@github.com
wrote:

To clarify:

  • This happens only in the Query editor results table
  • The edit has to start in an inline field
  • Then use tab to go to a TEXT/BLOB field
  • Use cmd+C to copy the value without opening the field editor
  • Value is truncated after 150 bytes


Reply to this email directly or view it on GitHub
#2283 (comment)
.

wubinhong commented Oct 15, 2015

Thanks for your reply, for my situation(v1.1), there is no editor pop up
when I click the field in the Query editor results table, so I can copy the
entire content for the TEXT/BLOB field. Would you please fix this up in the
next version?

Thank you very much!

On Mon, Oct 12, 2015 at 11:25 PM, Max Lohrmann notifications@github.com
wrote:

To clarify:

  • This happens only in the Query editor results table
  • The edit has to start in an inline field
  • Then use tab to go to a TEXT/BLOB field
  • Use cmd+C to copy the value without opening the field editor
  • Value is truncated after 150 bytes


Reply to this email directly or view it on GitHub
#2283 (comment)
.

@mifz

This comment has been minimized.

Show comment
Hide comment
@mifz

mifz Feb 10, 2016

Same for me.

select CONCAT("it's very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very long string");

In results: "it's very very very very very very very very very very very very very very very very very very very very very very very very very very very very very ..."

Version: 1.1.0.1 Build 4500 (2d9145d)

mifz commented Feb 10, 2016

Same for me.

select CONCAT("it's very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very long string");

In results: "it's very very very very very very very very very very very very very very very very very very very very very very very very very very very very very ..."

Version: 1.1.0.1 Build 4500 (2d9145d)

dmoagx added a commit that referenced this issue Feb 10, 2016

Fix an issue where copying the contents of a TEXT/BLOB field from a c…
…ustom query result would not contain all data if keyboard navigation was used (#2283)

backport of 8c7fc9d

@dmoagx dmoagx added this to the 1.1.1 milestone Feb 10, 2016

@dmoagx

This comment has been minimized.

Show comment
Hide comment
@dmoagx
Member

dmoagx commented Feb 20, 2016

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