Copy All Rows Data To Clipboard In 5.2 Beta 3

[mkysoft]

I run this SQL

Code:

show variables like '%character%';

then I right-click to result and select “Copy All Rows Data to Clipboard”. I check Fixed length option then press to OK button. Then SQLyog terminate.

[peterlaursen]

edit:

reproduced with beta4!

[mkysoft]

I am sorry I can't see BETA Discussions header before.

[peterlaursen]

no issue …

.. but I can move it!

Manoj is working on a fix for this now. I hope I can put a link here to a 'pre-beta-5' in 1-2 hours.

[peterlaursen]

The 'pre-beta5' with the fix:

http://www.webyog.com/downloads/betas/not_…SQLyog52Ent.exe

we only compiled the REGISTERED ENTERPRISE version.

[TomBez]

There seems to be another problem with copy all rows data to clipboard.

in beta 4, when use that function, only the first row is taken. when you select

rows and use 'copy selected cell data to clipboard' also only the first row is

taken.

might be fixed with that update mentioned, had no time to check it out.

[peterlaursen]

A few examples form here that are both OK:

Select * from a TABLE .. copy all to clipboard

Code:

“5” “a” “b” N
“6” “c” “d” N
“7” “a” “q” N

SELECT … from a VIEW .. copy all to clipboard

Code:

## “Kunstner” “Genre” “Albumtitel”
9 “'Papa' John DeFrancesco” “Jazz” “Hip Cake Walk”
1 “12 Apostles Church Choir” “World” “The Rough Guide to South African Gospel”
17 “3eme concours flamenco” “Flamenco” “Nimes”
1 “A Falta De Pan” “Folk/Fusion” “Rough Guide to the Music of Spain”
12 “Aaron Neville” “Jazz” “Nature Boy: The Standards Album”
1 “Abaji” “Afrikansk/Vest” “Rêves d'Oasis: Desert Blues 2 (1 of 2)”
16 “Abaji” “Folk/Fusion” “Oriental Voyage”
11 “Abbey Lincoln” “Jazz” “A Turtle's Dream”
10 “Abbey Lincoln” “Jazz” “Abbey Is Blue”
10 “Abbey Lincoln” “Jazz” “Over the Years”

and three rows randomly selected from the last query:

Code:

## “Kunstner” “Genre” “Albumtitel”
9 “'Papa' John DeFrancesco” “Jazz” “Hip Cake Walk”
1 “A Falta De Pan” “Folk/Fusion” “Rough Guide to the Music of Spain”
11 “Abbey Lincoln” “Jazz” “A Turtle's Dream”

.. if there there is an issue then we will ned a 'reproducable test case'

[TomBez]

peterlaursen wrote on Sep 25 2006, 04:24 PM:

.. if there there is an issue then we will ned a 'reproducable test case'

I'm sorry, but it is still an issue with Beta 5.

Code (that produces 900 rows):

Code:

select concat('delete from ss_members where memberid=', s1.memberid,';') from ss_members s1 where s1.listid=104 and s1.status=1;

Result (no matter if copy all rows or copy selected, even if only 1 row is selected:

Code:

“delete from ss_members where memberid=112687

notice the quote at the start of the line (that comes from fields enclosed by [“] (x) optionally). without that there is no quote but also only 1 line.

Notice:

It DOES work if you use fixed length for the fields but it DOESNOT if you use variable length.

cheers

[peterlaursen]

sorry Tom but we do not understand you here:

do you complain about a crash or a missing ” ??

We

Code:

CREATE TABLE `tt` (
`memberid` int(11) NOT NULL default '0',
`lastid` int(11) default NULL,
`status` int(11) default NULL,
PRIMARY KEY (`memberid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

next insert some rows and execute like

Code:

select concat('delete from ss_members where memberid=', s1.memberid,';') from tt s1 where s1.lastid=5 and s1.status=6;

copy the returned row(s) to clipboard. paste into Notepad and get results like

Code:

“delete from ss_members where memberid=2;”

no crash .. no missing ” . Please explain so that even I can understand this!

[TomBez]

hi peter,

peterlaursen wrote on Oct 3 2006, 12:16 PM:

sorry Tom but we do not understand you here:

do you complain about a crash or a missing ” ??

neither 🙂

the bug is, that not all rows are being copied into the clipboard. this behavior occurs when you

copy the data into the clipboard with variable length. it seems also to occure only when you

have in the result varchar's build with concat, if you make a normal “select fieldname1, fieldname2

from sometable” there isn't any problem with the copy to clipboard. it also does not occure when

you export the resultset into csv. a line would look like:

Code:

concat('sometext ',memberid,';')
“sometext 112687
;”
“sometext 112688
;”

this brings me to some speculation about correct setting of “n” of resultfields that are not fields in a

table and that this additional n is making the problem.

peterlaursen wrote on Oct 3 2006, 12:16 PM:

copy the returned row(s) to clipboard. paste into Notepad and get results like

i did copy it to different editors, all with the same result (and here is the result)

Code:

“sometext 112687

Quote:

no crash .. no missing ” . Please explain so that even I can understand this!

the good news, there is no crash :). the bad news, the behavior is not the same as you described :(.

BUT the copy to clipboard does work if you use “fixed length” in the pop-up for the fields. than

everything works correctly.

hopefully I explained it now a bit more clear. if you need you can have screenshots, just give me

a short message.

cheers

[peterlaursen]

Thanks …

That explains! We will have to test with more data than we did I think.

Now we know what we are hunting!

But we still can't reproduce!

For use on windows systems I would alwasy use rn for line change (>LF> in ASCII/ANSI terms).

@Tom: we need a dump with structure (with the exact datatypes) and data and a screenshot of your settings in the export dialogue and te EXACT query.

Did you tell what was the MySQL version? Server platform?

[Author]

Posts