may be not a firebird bug, could you check it please ----------------------------------------------------
Key: CORE-4324 URL: http://tracker.firebirdsql.org/browse/CORE-4324 Project: Firebird Core Issue Type: Bug Affects Versions: 2.5.2 Update 1 Environment: windows 8 Reporter: Vlad i write a program to learn words. i use c++ builder and firebird, i use IBExpress IBTable component and method Lookup. I have a smal database not corrupted ( backup and restore ) the lookup method uses index on DB, it works wrong, it search wrong words in one case. i type "kjd" or "kj" and it points to word "kjhk..." instead of "kjd..." . I can't upload it here, it is 1 mb 7zip program and firebird 1.5 same story with latest firebird 2.5. If you tell me where to e-mail a program and db, i will do it. It could be a c++ builder bug, i do not know. As i understand, lookup uses LIKE to compare, and firebird reply not ordered dataset. select word from words where word like 'kj%'; but the index exist and i think c++builder assumes it is ordered. (from old *.dbf times) p.s. i saw a message some one wrote about corruption database. I found that gcc and msvc++ treat const volatile as simple const. and also optimizes it out -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel