Hi, I'm just upgrading from 3.8.5 to 3.8.7.1 and experience the following incorrect behavior (see commands below):
- The where clause A <> B is expected to return only the first row, but returns all rows. - String concatenation on column B doesn't sometimes work (e. g. see end of line on row 7). I can provide the 17 kB bug.db if required. I've compiled sqlite3.exe and sqlite3.dll myself, but didn't change any of settings I've used for 3.8.5 when compiling 3.8.7.1. D:\Projects\sqlite3\Debug_Win32>sqlite3 d:\temp\bug.db SQLite version 3.8.7.1 2014-10-29 13:59:56 Enter ".help" for usage hints. sqlite> drop table if exists x ; create table x as select [Rohmaterial.OID] as A, cast(coalesce(TranslateID.TOID, [Rohmaterial.OID]) as text) as B, TranslateID.TOID as C from FertAuftragRohmaterial left join TranslateID on FertAuftragRohmaterial.[Rohmaterial.OID] = TranslateID.OID; sqlite> select A, B, A || '_', B || '_', C from x where A <> B; (0:0-3209838#0, 402)|(0:0-193511#56473, 402)|(0:0-3209838#0, 402)_|(0:0-193511#56473, 402)_|(0:0-193511#56473, 402) (0:0-24992#5293, 402)|(0:0-24992#5293, 402)|(0:0-24992#5293, 402)_|(0:0-24992#5293, 402)_| (0:0-25012#5513, 402)|(0:0-25012#5513, 402)|(0:0-25012#5513, 402)_|(0:0-25012#5513, 402)_| (0:0-25032#5758, 402)|(0:0-25032#5758, 402)|(0:0-25032#5758, 402)_|(0:0-25032#5758, 402)_| (0:0-25051#5698, 402)|(0:0-25051#5698, 402)|(0:0-25051#5698, 402)_|(0:0-25051#5698, 402)_| (0:0-25069#5453, 402)|(0:0-25069#5453, 402)|(0:0-25069#5453, 402)_|(0:0-25069#5453, 402)_| (0:0-25078#5343, 402)|(0:0-25078#5343, 402)|(0:0-25078#5343, 402)_|(0:0-25078#5343, 402)| (0:0-25427#3656, 402)|(0:0-25427#3656, 402)|(0:0-25427#3656, 402)_|(0:0-25427#3656, 402)_| (0:0-25457#4076, 402)|(0:0-25457#4076, 402)|(0:0-25457#4076, 402)_|(0:0-25457#4076, 402)_| (0:0-25447#3966, 402)|(0:0-25447#3966, 402)|(0:0-25447#3966, 402)_|(0:0-25447#3966, 402)_| (0:0-25477#4296, 402)|(0:0-25477#4296, 402)|(0:0-25477#4296, 402)_|(0:0-25477#4296, 402)_| (0:0-25487#4406, 402)|(0:0-25487#4406, 402)|(0:0-25487#4406, 402)_|(0:0-25487#4406, 402)_| (0:0-25527#4846, 402)|(0:0-25527#4846, 402)|(0:0-25527#4846, 402)_|(0:0-25527#4846, 402)_| (0:0-25537#4956, 402)|(0:0-25537#4956, 402)|(0:0-25537#4956, 402)_|(0:0-25537#4956, 402)_| (0:0-25565#4786, 402)|(0:0-25565#4786, 402)|(0:0-25565#4786, 402)_|(0:0-25565#4786, 402)_| (0:0-25592#4456, 402)|(0:0-25592#4456, 402)|(0:0-25592#4456, 402)_|(0:0-25592#4456, 402)_| (0:0-25628#4016, 402)|(0:0-25628#4016, 402)|(0:0-25628#4016, 402)_|(0:0-25628#4016, 402)_| (0:0-25574#4676, 402)|(0:0-25574#4676, 402)|(0:0-25574#4676, 402)_|(0:0-25574#4676, 402)_| (0:0-25646#3796, 402)|(0:0-25646#3796, 402)|(0:0-25646#3796, 402)_|(0:0-25646#3796, 402)_| (0:0-26531#6800, 402)|(0:0-26531#6800, 402)|(0:0-26531#6800, 402)_|(0:0-26531#6800, 402)_| (0:0-26567#6956, 402)|(0:0-26567#6956, 402)|(0:0-26567#6956, 402)_|(0:0-26567#6956, 402)_| (0:0-25637#3906, 402)|(0:0-25637#3906, 402)|(0:0-25637#3906, 402)_|(0:0-25637#3906, 402)_| (0:0-26585#6744, 402)|(0:0-26585#6744, 402)|(0:0-26585#6744, 402)_|(0:0-26585#6744, 402)_| (0:0-26576#6850, 402)|(0:0-26576#6850, 402)|(0:0-26576#6850, 402)_|(0:0-26576#6850, 402)_| (0:0-574781#15625, 402)|(0:0-574781#15625, 402)|(0:0-574781#15625, 402)_|(0:0-574781#15625, 402)_| (0:0-221176#56809, 402)|(0:0-221176#56809, 402)|(0:0-221176#56809, 402)_|(0:0-221176#56809, 402)_| (0:0-221160#56781, 402)|(0:0-221160#56781, 402)|(0:0-221160#56781, 402)_|(0:0-221160#56781, 402)| (0:0-574785#15638, 402)|(0:0-574785#15638, 402)|(0:0-574785#15638, 402)_|(0:0-574785#15638, 402)_| (0:0-574764#18136, 402)|(0:0-574764#18136, 402)|(0:0-574764#18136, 402)_|(0:0-574764#18136, 402)_| (0:0-3118276#78573, 402)|(0:0-3118276#78573, 402|(0:0-3118276#78573, 402)_|(0:0-3118276#78573, 402_| (0:0-506625#57242, 402)|(0:0-506625#57242, 402)|(0:0-506625#57242, 402)_|(0:0-506625#57242, 402)_| (0:0-574767#18147, 402)|(0:0-574767#18147, 402)|(0:0-574767#18147, 402)_|(0:0-574767#18147, 402)_| (0:0-574717#18019, 402)|(0:0-574717#18019, 402)|(0:0-574717#18019, 402)_|(0:0-574717#18019, 402)_| (0:0-574797#15677, 402)|(0:0-574797#15677, 402)|(0:0-574797#15677, 402)_|(0:0-574797#15677, 402)| (0:0-506628#17302, 402)|(0:0-506628#17302, 402)|(0:0-506628#17302, 402)_|(0:0-506628#17302, 402)_| (0:0-574722#18034, 402)|(0:0-574722#18034, 402)|(0:0-574722#18034, 402)_|(0:0-574722#18034, 402)_| (0:0-506631#17313, 402)|(0:0-506631#17313, 402)|(0:0-506631#17313, 402)_|(0:0-506631#17313, 402)| (0:0-506636#17335, 402)|(0:0-506636#17335, 402)|(0:0-506636#17335, 402)_|(0:0-506636#17335, 402)_| Mit freundlichen Grüßen / Best regards Reinhard Nißl Softwareentwicklung F.EE GmbH Informatik + Systeme Industriestraße 6e, 92431 Neunburg v. W. Phone +49 9672 506-198 Fax +49 9672 506-10198 E-Mail: [email protected] Internet: www.fee.de<http://www.fee.de/> - www.fee-systemhaus.de<http://www.fee-systemhaus.de/> - www.factwork.de<http://www.factwork.de/> Geschäftsführung: J. u. G. Fleischmann Geschäftssitz: Neunburg v. W., Amtsgericht Amberg HRB 1290 Diese E-Mail ist allein für den bezeichneten Adressaten bestimmt. Sie kann rechtlich vertrauliche Informationen enthalten. Wenn Sie diese E-Mail irrtümlich erhalten haben, informieren Sie bitte unverzüglich den Absender per E-Mail und löschen Sie diese E-Mail von Ihrem Computer, ohne Kopien anzufertigen. Vielen Dank. This email is for the exclusive use of the addressee. It may contain legally privileged information. If you have received this message in error, please notify the sender by email immediately and delete the message from your computer without making any copies. Thank you. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
