headers
KARR, DAVID | 27 Jul 2012 17:41
Picon
Favicon

SQuirreL deals badly with very long lines

When I'm navigating through the SQL editor in SQuirreL I have to be very careful when I have very long lines.  I
often have to work on queries that are 20k characters long.  I often have to paste these queries in from other
resources, and they are often a single line.  I've learned that if I start at the beginning of the line and try
to press the End key, SQuirreL will freeze, either for a very long time, or essentially forever, forcing me
to kill the process.  I often have to preprocess these long SQL lines in an external text editor, breaking
them up into shorter lines, before I try to use them in SQuirreL.

I don't have a specific test case yet.

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Permalink | Reply |
headers
Roger Harris [Consultant] | 27 Jul 2012 17:52
Favicon

Re: SQuirreL deals badly with very long lines

Have you tried using the Format SQL option: MENU Session > SQL Entry Editing > Format SQL (Ctrl+Alt+F)
before you try navigating through the text?

Roger

-----Original Message-----
From: KARR, DAVID [mailto:dk068x <at> att.com] 
Sent: Friday, July 27, 2012 10:41 AM
To: squirrel-sql-users <at> lists.sourceforge.net
Subject: [Squirrel-sql-users] SQuirreL deals badly with very long lines

When I'm navigating through the SQL editor in SQuirreL I have to be very careful when I have very long lines.  I
often have to work on queries that are 20k characters long.  I often have to paste these queries in from other
resources, and they are often a single line.  I've learned that if I start at the beginning of the line and try
to press the End key, SQuirreL will freeze, either for a very long time, or essentially forever, forcing me
to kill the process.  I often have to preprocess these long SQL lines in an external text editor, breaking
them up into shorter lines, before I try to use them in SQuirreL.

I don't have a specific test case yet.

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
(Continue reading)

Permalink | Reply |
headers
KARR, DAVID | 27 Jul 2012 20:44
Picon
Favicon

Re: SQuirreL deals badly with very long lines

> -----Original Message-----
> From: Roger Harris [Consultant] [mailto:RHarris <at> theocc.com]
> Sent: Friday, July 27, 2012 8:52 AM
> To: squirrel-sql-users <at> lists.sourceforge.net
> Subject: Re: [Squirrel-sql-users] SQuirreL deals badly with very long
> lines
> 
> Have you tried using the Format SQL option: MENU Session > SQL Entry
> Editing > Format SQL (Ctrl+Alt+F) before you try navigating through the
> text?

That's essentially a different version of "preprocess these long SQL lines in an external text editor",
within the same tool, but with less control over the formatting.  I'm sure that prevents the problem, but
that formatting algorithm often results in many more lines than I want.

> -----Original Message-----
> From: KARR, DAVID [mailto:dk068x <at> att.com]
> Sent: Friday, July 27, 2012 10:41 AM
> To: squirrel-sql-users <at> lists.sourceforge.net
> Subject: [Squirrel-sql-users] SQuirreL deals badly with very long lines
> 
> When I'm navigating through the SQL editor in SQuirreL I have to be
> very careful when I have very long lines.  I often have to work on
> queries that are 20k characters long.  I often have to paste these
> queries in from other resources, and they are often a single line.
> I've learned that if I start at the beginning of the line and try to
> press the End key, SQuirreL will freeze, either for a very long time,
> or essentially forever, forcing me to kill the process.  I often have
> to preprocess these long SQL lines in an external text editor, breaking
> them up into shorter lines, before I try to use them in SQuirreL.
(Continue reading)

Permalink | Reply |
headers
Alexandre Peshansky | 27 Jul 2012 20:55
Favicon

Re: SQuirreL deals badly with very long lines

On Fri, July 27, 2012 at 2:45 PM, DAVID KARR wrote:
> On Fri, July 27, 2012 at 8:52 AM, Roger Harris [Consultant] wrote:
> > Have you tried using the Format SQL option: MENU Session > SQL Entry
> > Editing > Format SQL (Ctrl+Alt+F) before you try navigating through
> > the text?
> 
> That's essentially a different version of "preprocess these long SQL lines
> in an external text editor", within the same tool, but with less control
> over the formatting.  I'm sure that prevents the problem, but that
> formatting algorithm often results in many more lines than I want.

And why exactly do you care how many lines is in your SQL after reformatting?  You don't even need to look at it -
make the SQL pane short.  You did say that you are getting your SQL from external source, so presumably you
are modifying it in your external source, too (I know I do: I develop all SQL in Notepad++ so that I always
have a log of what I did - you know, belt and suspenders ;-)
--

-- 
Alexandre Peshansky, MS
Senior Bioinformatics Analyst, Research Informatics Core (RIC)
Einstein-Montefiore Institute for Clinical and Translational Research (ICTR)
Albert Einstein College of Medicine
1300 Morris Park Ave, Mazer Bldg., Rm 534
Bronx, NY 10461
(718) 430-2440 (Mo, Th, Fr)  (718) 920-4885 (Tu & We)

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
(Continue reading)

Permalink | Reply |
headers
John Hardin | 27 Jul 2012 21:32
Gravatar

Re: SQuirreL deals badly with very long lines

On Fri, 27 Jul 2012, KARR, DAVID wrote:

>> From: Roger Harris [Consultant] [mailto:RHarris <at> theocc.com]
>>
>> Have you tried using the Format SQL option: MENU Session > SQL Entry
>> Editing > Format SQL (Ctrl+Alt+F) before you try navigating through the
>> text?
>
> That's essentially a different version of "preprocess these long SQL 
> lines in an external text editor", within the same tool, but with less 
> control over the formatting.  I'm sure that prevents the problem, but 
> that formatting algorithm often results in many more lines than I want.

Looking at bug#3488629 the format should be controllable. I haven't looked 
to see _how_ controllable it is, though; have you tried to see whether you 
can specify a format more to your liking?

--

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jhardin <at> impsec.org    FALaholic #11174     pgpk -a jhardin <at> impsec.org
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   Christian martyrs don't explode.                         -- Marisol
-----------------------------------------------------------------------
  9 days until the rover Curiosity lands on Mars

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions
(Continue reading)

Permalink | Reply |

Gmane