I understand that the issue could be caused by the wrong datatype... but what is strange is that the same db and the same query worked fine with sqlite 3.4.2 and the behavior changed with sqlite 3.6.x
-- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Jun 5, 2009, at 11:17 AM, Martin Engelschalk wrote: > Your field value is a blob, so you have to use a cast like you did to > find the row, or use a blob literal: > SELECT * FROM lo_user WHERE lo_name=X'61646d696e'; > > > > Marco Bambini wrote: >> I just posted the db on my website... there is one row and there >> aren't invisible characters. >> >> Please note that the following query returns the exact row: >> SELECT * FROM lo_user WHERE CAST(lo_name AS TEXT)='admin'; >> but I really don't have an explanation... >> >> -- >> Marco Bambini >> http://www.sqlabs.com >> http://www.creolabs.com/payshield/ >> >> >> >> >> >> >> On Jun 5, 2009, at 11:10 AM, Martin Engelschalk wrote: >> >> >>> Hi, >>> >>> attachments do not make it through the list. >>> There is no row with the value 'admin' in the field 'lo_name' in >>> your >>> table. Did you check that there are no blank spaces or other >>> invisible >>> characters? >>> >>> Martin >>> >>> Marco Bambini wrote: >>> >>>> Anyone can please explain me why this query: >>>> SELECT * FROM lo_user WHERE lo_name='admin'; >>>> returns 0 rows in this db? >>>> >>>> >>>> >>>> Thanks. >>>> -- >>>> Marco Bambini >>>> http://www.sqlabs.com >>>> http://www.creolabs.com/payshield/ >>>> >>>> >>>> >>>> >>>> >>>> >>>> ------------------------------------------------------------------------ >>>> >>>> _______________________________________________ >>>> sqlite-users mailing list >>>> sqlite-users@sqlite.org >>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>>> >>>> >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
