Carlos Guzmán Álvarez <[EMAIL PROTECTED]> writes: > > Hello: > > > You're right, LIKE 'xxx%' OR Starting with 'xxx' both generate the same > > execution plan. > > Unfortunately, there are situations where starting with doesn't fit my > > needs. > > the query runs fine under isql ?? >
Yes, I have tried to execute the query with many database management tools and it runs fine. When using ADO.net provider, it works too... But only if you set the FbCommand.CommandText property to a ready-to-execute Sql string (without using parameters). I have also created an empty test database containing a single table and a single varchar column (without specifying column collation or whatever), the problem remains so I don't think there's something wrong in my DB... Regards PS: Sorry for double post. I wasn't aware that jira bug reports were automatically posted on this board. ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
