Re: [sqlite] Why row is not found?
Hello Martin, it's a db than an user sent me... so I really don't know... -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Jun 5, 2009, at 11:31 AM, Martin Engelschalk wrote: > Hi Marco, > > How do you insert this data into your database? > I opened your database with an old version of SQLiteSpy, which uses an > even older version of sqlite. It showed the value as a blob. > > Martin > Marco Bambini wrote: >> 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 >> >> > > ___ > 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
Re: [sqlite] Why row is not found?
Hi Marco, How do you insert this data into your database? I opened your database with an old version of SQLiteSpy, which uses an even older version of sqlite. It showed the value as a blob. Martin Marco Bambini wrote: > 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 > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Why row is not found?
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
Re: [sqlite] Why row is not found?
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
Re: [sqlite] Why row is not found?
Maybe don't use varchar, but text instead when creating the table. RBS > 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
Re: [sqlite] Why row is not found?
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
Re: [sqlite] Why row is not found?
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
Re: [sqlite] Why row is not found?
You can download the db from: http://www.sqlabs.com/download/test.sqlite It's only 4KB. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Jun 5, 2009, at 11:04 AM, 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] Why row is not found?
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