Re: [Squirrel-sql-users] SQuirreL somehow interpreting vertical bar in varchar value?

[KARR, D. <dk...@at...>]

> -----Original Message-----
> From: John Hardin [mailto:jh...@im...]
> Sent: Tuesday, April 25, 2017 2:57 PM
> To: KARR, DAVID <dk...@at...>
> Cc: squ...@li...
> Subject: Re: [Squirrel-sql-users] SQuirreL somehow interpreting vertical
> bar in varchar value?
> 
> On Tue, 25 Apr 2017, KARR, DAVID wrote:
> 
> > Now that I've turned off variable interpolation in my big sql import
> script, when I run it, it gets an odd error on a particular insert line.
> It looks somewhat like this (mostly elided, except for the start of the
> values list):
> >
> >    insert into blah (colname1,colname2,colname3,...) values
> (371,null,'433449 | 274027 - ...
> >
> > In the error message, it says the syntax error is near "433449", and
> > when it shows the entire query, the end of the line is the "9" at the
> > end of that number.  It seems like that vertical bar character is
> > doing something.
> >
> > I don't know whether this is a mysql/mariadb issue, or SQuirreL.
> 
> Take a look at Session -> Session Properties -> SQL tab -> Statement
> Separator, is that perhaps set to vertical bar?
> 
> It doesn't make any sense for that to be the case, but that is one thing
> that can cause Squirrel to break the parsing of SQL midway through.

It turns out the problem was in the "MySQL Script Settings", in the "Procedure/Function Separator" field.  It was "|", and I changed it to "|||" to fix this problem.