db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.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:05:56 GMT
 > 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?



View raw message