db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Embretsen <John.Embret...@Sun.COM>
Subject Re: [jira] Commented: (DERBY-2962) Change functional tests to use casts for System table queries to avoid conversion errors when run with TERRITORY_BASED collation
Date Thu, 02 Aug 2007 15:35:26 GMT
Bryan Pendleton wrote:
>  > ij> select SQL_TEXT from syscs_diag.statement_cache where 
> CAST(SQL_TEXT  AS LONG VARCHAR) LIKE '%932432%';
> ...
>  > Kathey, was it intentional to include an extra space in the above 
> mentioned statement (between "TEXT" and "AS")?
>  > I think if the second space is removed, the result will contain one 
> row instead of two, and we won't see this diff any longer...
> 
> 
> Why does the extra space affect the number of rows in the result? Isn't
> that space just whitespace and discarded by the SQL parser?

I don't know. I've attached the failing output in case you want to have a look.


-- 
John

Mime
View raw message