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.
Full Version: Copy All Rows Data To Clipboard In 5.2 Beta 3
I run this SQL
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.
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.
edit:
reproduced with beta4!
reproduced with beta4!
I am sorry I can't see BETA Discussions header before.
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.
.. 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.
The 'pre-beta5' with the fix:
http://www.webyog.com/downloads/betas/not_...SQLyog52Ent.exe
we only compiled the REGISTERED ENTERPRISE version.
http://www.webyog.com/downloads/betas/not_...SQLyog52Ent.exe
we only compiled the REGISTERED ENTERPRISE version.
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.
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.
A few examples form here that are both OK:
Select * from a TABLE .. copy all to clipboard
SELECT ... from a VIEW .. copy all to clipboard
and three rows randomly selected from the last query:
.. if there there is an issue then we will ned a 'reproducable test case'
Select * from a TABLE .. copy all to clipboard
CODE
"5" "a" "b" \N
"6" "c" "d" \N
"7" "a" "q" \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"
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"
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'
QUOTE (peterlaursen @ 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
sorry Tom but we do not understand you here:
do you complain about a crash or a missing " ??
We
next insert some rows and execute like
copy the returned row(s) to clipboard. paste into Notepad and get results like
no crash .. no missing " . Please explain so that even I can understand this!
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
`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!
hi peter,
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:
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.
i did copy it to different editors, all with the same result (and here is the result)
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
QUOTE (peterlaursen @ Oct 3 2006, 12:16 PM)
sorry Tom but we do not understand you here:
do you complain about a crash or a missing " ??
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
;"
"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.
QUOTE (peterlaursen @ 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
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 \r\n for line change (<CR>>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?
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 \r\n for line change (<CR>>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?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.