[sqlite] Lemon
Hi, I found in wikipedia that Lemon parser is a part of SQLite project but i couldn't found any sort of information regarding to LEMON. Can u give me any documentation regarding how to install it and how to work for some programs on Lemon parser generator or any URL's that might be helpful and can download the information regarding LEMON. Thanks Arjun ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQL error: disk I/O error
Hello all, I recently got an error while running a long query with sqlite3 on Ubuntu Gutsy 7.10: SQL error: disk I/O error I googled for a solution but didn't find anything relevant. After a bit of sleuthing on my machine, I discovered that I was running out of disk space. I freed up some disk space, reran the query, and it finished this time without giving an error. Figured I'd post just in case someone else might run into something similar. Regards, - Robert ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using SQLite in embedded environment
Steven, If SQLite runs on ARM9/Linux, then I don't see any problems. I think you should watch the SQLite video on youtube. http://www.youtube.com/watch?v=giAMt8Tj-84 Enjoy! -Alex 2008/6/24 Steven Woody <[EMAIL PROTECTED]>: > Hi, > > I am considering to use SQLite in my current embedded application > project. It's a ARM9/Linux. Do you experts think it is a good idea？ > And, is there any tips or considerations in this combination? > > Thank you. > ___ > 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] Table Adapter Update Question (Richard W. Kulp)
Roosevelt, Thanks. That worked perfectly. Dick On Wed, 25 Jun 2008 18:17:39 -0400, Roosevelt Anderson <[EMAIL PROTECTED]> wrote: >Try using this library > >http://sqlite.phxsoftware.com/ > >It a complete ADO.NET 2 implementation and it should support the update. > >On Wed, Jun 25, 2008 at 5:14 PM, Richard W. Kulp <[EMAIL PROTECTED]> >wrote: >> I am trying to convert a VB 2005 program from a SQLExpress database to >> SQLite 3. I have been successful up to the following line of code: >> >> Me.Dbo_UsersTableAdapter.Update(Me.TSEPWin5UserSQLiteDB.dbo_Users) >> >> It seems that the DboTableAdapter does not support the Update command. >> What >> is the preferred way to update a dataset created from a SQLite db? I am >> using CoreLab's dotConnect SQLite data provider. Another consideration is >> that my ultimate goal is to move from Visual Studio to MonoDevelop. >> >> Thanks. >> >> Dick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Table Adapter Update Question
Robert, I looked at CoreLab's provider recently and didn't get the impression that they used your code at all. It's separate DLL's, very different classes, is missing some functionality that you provide (like custom functions written in .NET) but has other functionality (like robust connection pooling). Also the interop is very different and it uses three dll's, one of which they install to system32 (sucks). We were interested in their product precisely because it is commercial and thus includes support. Lack of custom functions is a deal breaker though--we use them extensively. Richard, CoreLab's product is commercial. Did you try asking their support? In any case, if you're considering a switch to Mono in the future than I'd highly recommend Robert's provider which we use and is very well written and is included with Mono (with some alterations). http://sqlite.phxsoftware.com Thanks, Sam - We're Hiring! Seeking passionate Flex, C#, or C++ (RTSP, H264) developer in the Washington D.C. Contact [EMAIL PROTECTED] On Wed, Jun 25, 2008 at 8:17 PM, Robert Simpson <[EMAIL PROTECTED]> wrote: > I'm not exactly sure what they've built on top of my (free) provider, but > it > looks like a good portion of their core codebase is my code. It's a bummer > they decided to split with the free spirit of SQLite and charge for their > provider (based on my public domain code), but to each his own. > > Robert > http://sqlite.phxsoftware.com > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] NOT LIKE statement
The only wild cards affecting operation of the LIKE operator are '%' and '_'. So the SQLite doesn't support '[ ]' and '^'. Right? Thank you. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Davies Sent: Wednesday, June 25, 2008 5:35 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] NOT LIKE statement You seemed to be expecting that name NOT LIKE 'InternetGatewayDevice.%.[1-9]' AND name NOT LIKE 'InternetGatewayDevice.%.[^1-9] would exclude some of the rows you are getting. This is incorrect. The only wild cards affecting operation of the LIKE operator are '%' and '_'. Regards, Simon 2008/6/25 James <[EMAIL PROTECTED]>: > Hi, Simon: >Thanks for help me solve this problem. >I have study the link you give me. But I still don't understand why > my original SQL statement can't work. Could you explain in detail? >Thank you. > > James > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Simon Davies > Sent: Wednesday, June 25, 2008 4:40 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] NOT LIKE statement > > I can get your expected results from the data you have given, as shown > below: > > sqlite> CREATE TABLE tst( name text ); > sqlite> > sqlite> insert into tst values( 'InternetGatewayDevice.DeviceInfo.' ); > sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.1' ); > sqlite> insert into tst values( > 'InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion' ); > sqlite> insert into tst values( > 'InternetGatewayDevice.DeviceInfo.SerialNumber' ); > sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.2' ); > sqlite> insert into tst values( 'InternetGatewayDevice.ManagementServer.' ); > sqlite> insert into tst values( 'InternetGatewayDevice.ManagementServer.URL' > ); > sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.3' ); > sqlite> insert into tst values( > 'InternetGatewayDevice.ManagementServer.Username' ); > sqlite> insert into tst values( > 'InternetGatewayDevice.ManagementServer.DownloadProgressURL' ); > sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.4' ); > sqlite> > sqlite> > sqlite> select name from tst where name like 'InternetGatewayDevice.%'; > InternetGatewayDevice.DeviceInfo. > InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion > InternetGatewayDevice.DeviceInfo.SerialNumber > InternetGatewayDevice.ManagementServer. > InternetGatewayDevice.ManagementServer.URL > InternetGatewayDevice.ManagementServer.Username > InternetGatewayDevice.ManagementServer.DownloadProgressURL > sqlite> > sqlite> > sqlite> select name from tst where name like 'InternetGatewayDevice.%' > and name not like 'InternetGatewayDevice.%._%'; > InternetGatewayDevice.DeviceInfo. > InternetGatewayDevice.ManagementServer. > sqlite> > > Rgds, > Simon > > 2008/6/25 James <[EMAIL PROTECTED]>: >> Hi, >> I will read that. >> But I want to know that is it possible to get the expected result? >> Thank you. >> >> >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of Simon Davies >> Sent: Wednesday, June 25, 2008 3:57 PM >> To: General Discussion of SQLite Database >> Subject: Re: [sqlite] NOT LIKE statement >> >> Hi James, >> >> I think the problem lies with your expectations. >> >> Read the section on the LIKE operator in >> http://www.sqlite.org/lang_expr.html >> >> Rgds, >> Simon >> >> 2008/6/25 James <[EMAIL PROTECTED]>: >>> Hi, >>> >>> I execute the SQL statement [SELECT Name FROM tr069;] and get the result >>> >>> InternetGatewayDevice.DeviceInfo. >>> >>> InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion >>> >>> InternetGatewayDevice.DeviceInfo.AdditionalSoftwareVersion >>> >>> InternetGatewayDevice.DeviceInfo.Description >>> >>> InternetGatewayDevice.DeviceInfo.DeviceLog >>> >>> InternetGatewayDevice.DeviceInfo.DeviceStatus >>> >>> InternetGatewayDevice.DeviceInfo.EnabledOptions >>> >>> InternetGatewayDevice.DeviceInfo.FirstUseDate >>> >>> InternetGatewayDevice.DeviceInfo.HardwareVersion >>> >>> InternetGatewayDevice.DeviceInfo.SoftwareVersion >>> >>> InternetGatewayDevice.DeviceInfo.Manufacturer >>> >>> InternetGatewayDevice.DeviceInfo.ManufacturerOUI >>> >>> InternetGatewayDevice.DeviceInfo.ModelName >>> >>> InternetGatewayDevice.DeviceInfo.ProductClass >>> >>> InternetGatewayDevice.DeviceInfo.ProvisioningCode >>> >>> InternetGatewayDevice.DeviceInfo.SerialNumber >>> >>> InternetGatewayDevice.DeviceInfo.UpTime >>> >>> InternetGatewayDevice.ManagementServer. >>> >>> InternetGatewayDevice.ManagementServer.URL >>> >>> InternetGatewayDevice.ManagementServer.Username >>> >>> InternetGatewayDevice.ManagementServer.Password >>> >>> InternetGatewayDevice.ManagementServer.PeriodicInformEnable >>> >>> InternetGatewayDevice.ManagementServer.PeriodicInformInterval >>> >>> InternetGatewayDevice.ManagementServer.PeriodicInformTime >>> >>>
Re: [sqlite] bug help
On Wed, Jun 25, 2008 at 08:19:35PM -0400, [EMAIL PROTECTED] scratched on the wall: > I tried to post this once and didn't see it. Is there a restriction on long > listings? I'll cut off most of it this time. > > Hi all. I'm new to SQLite. It was recommended by a friend who uses it on > PDA's and cell phones. I am trying to compile the Amalgamation on a version > of gcc > set up for ARM (devkitpro). I wasn't expecting a bunch of errors from the > Amalgamation since no header files are needed or other usual sources of > problems. > > Any ideas on where to start? It looks like you changed some of the build flags. That doesn't work with the amalgamation. If you need to alter the build flags you need to build from source OR re-build the amalgamation from a full source set. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "'People who live in bamboo houses should not throw pandas.' Jesus said that." - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006" ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3_open returns SQLITE_NOMEM
This is a "known" issue. http://www.sqlite.org/cvstrac/tktview?tn=2508,6 The fix is to include SYSGEN_CORELOC. Can someone mention that in the documentation somewhere? Ryan > -Original Message- > From: [EMAIL PROTECTED] [mailto:sqlite-users- > [EMAIL PROTECTED] On Behalf Of Ryan Clark > Sent: Wednesday, June 11, 2008 12:20 PM > To: 'sqlite-users@sqlite.org' > Subject: [sqlite] sqlite3_open returns SQLITE_NOMEM > > FWIW, this behavior seems similar to: > http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2008- > March/001419.html > http://tinyurl.com/5w5ttg > > > Ryan > > > ___ > 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] NOT LIKE statement
"P Kishor" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > You are expecting the LIKE (or NOT LIKE) operator to behave like a > RegExp operator. No, it doesn't. It just has a single wildcard > specifier, the % sign. Two of them: % (a sequence of zero or more of arbitrary characters) and _ (exactly one arbitrary character). Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] selecting an indexed table
Alex Katebi wrote: > I have no way of knowing which rows a select command has visited for an > indexed table. > > create table t(a); > create index it on t(a); > insert ... > select * from t where a=5; > > Is there a select hook for debugging? How about: explain select * from t where a=5; ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] bug help
I tried to post this once and didn't see it. Is there a restriction on long listings? I'll cut off most of it this time. Hi all. I'm new to SQLite. It was recommended by a friend who uses it on PDA's and cell phones. I am trying to compile the Amalgamation on a version of gcc set up for ARM (devkitpro). I wasn't expecting a bunch of errors from the Amalgamation since no header files are needed or other usual sources of problems. Any ideas on where to start? Thanks, Charlie Springer sqlite3.c c:/devkitpro/ident/helloworld/source/sqlite3.c:13259: error: expected specifier-qualifier-list before 'pthread_mutex_t' c:/devkitpro/ident/helloworld/source/sqlite3.c: In function 'sqlite3_mutex_alloc': c:/devkitpro/ident/helloworld/source/sqlite3.c:13316: error: 'PTHREAD_MUTEX_INITIALIZER' undeclared (first use in this function) c:/devkitpro/ident/helloworld/source/sqlite3.c:13316: error: (Each undeclared identifier is reported only once c:/devkitpro/ident/helloworld/source/sqlite3.c:13316: error: for each function it appears in.) c:/devkitpro/ident/helloworld/source/sqlite3.c:13316: warning: excess elements in struct initializer c:/devkitpro/ident/helloworld/source/sqlite3.c:13316: warning: (near initialization for 'staticMutexes[0]') c:/devkitpro/ident/helloworld/source/sqlite3.c:13316: warning: excess elements in struct initializer c:/devkitpro/ident/helloworld/source/sqlite3.c:13316: warning: (near initialization for 'staticMutexes[0]') etc. ** Gas prices getting you down? Search AOL Autos for fuel-efficient used cars. (http://autos.aol.com/used?ncid=aolaut000507) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Table Adapter Update Question
I'm not exactly sure what they've built on top of my (free) provider, but it looks like a good portion of their core codebase is my code. It's a bummer they decided to split with the free spirit of SQLite and charge for their provider (based on my public domain code), but to each his own. Robert http://sqlite.phxsoftware.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard W. Kulp Sent: Wednesday, June 25, 2008 2:15 PM To: sqlite-users@sqlite.org Subject: [sqlite] Table Adapter Update Question I am trying to convert a VB 2005 program from a SQLExpress database to SQLite 3. I have been successful up to the following line of code: Me.Dbo_UsersTableAdapter.Update(Me.TSEPWin5UserSQLiteDB.dbo_Users) It seems that the DboTableAdapter does not support the Update command. What is the preferred way to update a dataset created from a SQLite db? I am using CoreLab's dotConnect SQLite data provider. Another consideration is that my ultimate goal is to move from Visual Studio to MonoDevelop. Thanks. Dick ___ 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] selecting an indexed table
I have no way of knowing which rows a select command has visited for an indexed table. create table t(a); create index it on t(a); insert ... select * from t where a=5; Is there a select hook for debugging? Thanks, -Alex ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Table Adapter Update Question
Try using this library http://sqlite.phxsoftware.com/ It a complete ADO.NET 2 implementation and it should support the update. On Wed, Jun 25, 2008 at 5:14 PM, Richard W. Kulp <[EMAIL PROTECTED]> wrote: > I am trying to convert a VB 2005 program from a SQLExpress database to > SQLite 3. I have been successful up to the following line of code: > > Me.Dbo_UsersTableAdapter.Update(Me.TSEPWin5UserSQLiteDB.dbo_Users) > > It seems that the DboTableAdapter does not support the Update command. > What > is the preferred way to update a dataset created from a SQLite db? I am > using CoreLab's dotConnect SQLite data provider. Another consideration is > that my ultimate goal is to move from Visual Studio to MonoDevelop. > > Thanks. > > Dick > ___ > 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] bug help
[EMAIL PROTECTED] wrote: > Is this the correct list for airing SQLite amalgamation compilation problems? > Yes. Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] bug with NULL in NOT IN
D. Richard Hipp wrote: > > If I understand Peter correctly, he is saying that NULL should mean > "unknown" in the context of the RHS of a NOT IN operator. SQLite does > not currently operate this way. SQLite currently interprets a NULL in > the RHS of a NOT IN operator to mean "nothing". > > Can you or anybody else point to text in any > SQL spec that would suggest that SQLites behavior in this case is wrong? I believe that your interpretation is correct, and that SQLite's current behavior is incorrect according to the standard, at least the SQL:1999 standard. The IN predicate is a synonym for the quantified predicate = ANY, or = SOME which is equivalent. The inversion of this predicate, NOT IN, is therefore the inversion of the quantified predicate. The rules defined in section 8.4 Syntax Rules 3 and 4 show how this is transformed. col NOT IN subquery becomes NOT col IN subquery which becomes NOT (col = SOME subquery) And the inversion of the quantified predicate is col <> ALL subquery In the standard the rules for evaluating this quantified subquery are in section 8.8 General Rules 1 through 2e copied below. 1) Let R be the result of the and let T be the result of the . 2) The result of ‘‘R T’’ is derived by the application of the implied ‘‘R RT’’ to every row RT in T: Case: a) If T is empty or if the implied is true for every row RT in T, then ‘‘R T’’ is true. b) If the implied is false for at least one row RT in T, then ‘‘R T’’ is false. c) If the implied is true for at least one row RT in T, then ‘‘R T’’ is true. d) If T is empty or if the implied is false for every row RT in T, then ‘‘R T’’ is false. e) If ‘‘R T’’ is neither true nor false, then it is unknown . For the example given, the engine evaluates the following predicates. 1 <> ALL (NULL, 3, 4, 5) 2 <> ALL (NULL, 3, 4, 5) 3 <> ALL (NULL, 3, 4, 5) In each case the first comparison is X <> NULL And from 8.2 General Rules 1a we have a) If either XV or YV is the null value, then X Y is unknown. The results of the comparisons are therefore: (unknown, true, true, true) (unknown, true, true, true) (unknown, false, true, true) So all three rows result in an unknown result for the first, NULL, element. The last row is handled buy case b in section 8.8 General Rule 2 above since one subquery result is false. The other rows all fall through to case e in section 8.8 General Rule 2 above. The result of each quantified comparison is therefore unknown. The where clause only returns rows where the condition is true according to section 7.8 General Rule 1. 1) The is applied to each row of T. The result of the is a table of those rows of T for which the result of the is true. It looks like this should be changed to match the other database engines for improved standard compliance. Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Table Adapter Update Question
I am trying to convert a VB 2005 program from a SQLExpress database to SQLite 3. I have been successful up to the following line of code: Me.Dbo_UsersTableAdapter.Update(Me.TSEPWin5UserSQLiteDB.dbo_Users) It seems that the DboTableAdapter does not support the Update command. What is the preferred way to update a dataset created from a SQLite db? I am using CoreLab's dotConnect SQLite data provider. Another consideration is that my ultimate goal is to move from Visual Studio to MonoDevelop. Thanks. Dick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] motd
Small. Fast. Reliable. Choose any three ==> Small. Fast. Reliable. Free. Choose any four :) -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DB file name from sqlite3 *
On Jun 25, 2008, at 2:23 PM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED] > wrote: > Is there a way in a user program to get the db file name that has been > associated with a particular sqlite3* ? > PRAGMA database_list; D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] bug with NULL in NOT IN
Well, NULL is not a value, technically, it is the lack of a value. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wilson, Ron P Sent: Wednesday, June 25, 2008 11:12 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] bug with NULL in NOT IN Why should the second query return zero rows? Clearly ids 1 and 2 don't exist in b. I'm not defending sqlite per se, just asking, logically speaking, why would those other databases return zero rows for that query? On a related note, what if NULL exists in both tables? Sqlite doesn't return that row for the first query: SQLite version 3.5.9 Enter ".help" for instructions sqlite> create table a(id integer); sqlite> insert into a values(1); sqlite> insert into a values(2); sqlite> insert into a values(3); sqlite> insert into a values(NULL); sqlite> create table b(id integer); sqlite> insert into b values(NULL); sqlite> insert into b values(3); sqlite> insert into b values(4); sqlite> insert into b values(5); sqlite> select * from a where id in (select id from b); 3 sqlite> Sqlite deliberately ignores all NULL values in a select. This explains the result, but logically doesn't follow because in fact NULL does exist in both tables. Interesting. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp Sent: Wednesday, June 25, 2008 11:50 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] bug with NULL in NOT IN On Jun 25, 2008, at 11:33 AM, [EMAIL PROTECTED] wrote: > Hello, > > with the following schema and contents: > > BEGIN TRANSACTION; > CREATE TABLE a(id INTEGER); > INSERT INTO a VALUES(1); > INSERT INTO a VALUES(2); > INSERT INTO a VALUES(3); > CREATE TABLE b(id INTEGER); > INSERT INTO b VALUES(NULL); > INSERT INTO b VALUES(3); > INSERT INTO b VALUES(4); > INSERT INTO b VALUES(5); > COMMIT; > > mysql, postgres, sqlite and mssql agree on: > > SELECT * FROM a WHERE id IN (SELECT id FROM b); > > yielding one row with id=3. > > However, on the query: > > SELECT * FROM a WHERE id NOT IN (SELECT id FROM b); > > mysql, postgres and mssql correctly return zero rows. SQLite however > returns two rows, for id=1 and id=2. > > http://www.sqlite.org/nulls.html doesn't list it, so perhaps this has > never come up before. No, this has never come up before. The behavior of SQLite is as I intended it to be. NULLs are deliberately and willfully filtered out of the subquery to the right of NOT IN. Are you saying that this is incorrect? Other than the fact that three other database engines do it differently, do you have any evidence that this really is incorrect? NULL behavior in SQL is highly unintuitive. In fact, as far as I can tell it is arbitrary. Can you or anybody else point to text in any SQL spec that would suggest that SQLites behavior in this case is wrong? D. Richard Hipp [EMAIL PROTECTED] ___ 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] DB file name from sqlite3 *
Is there a way in a user program to get the db file name that has been associated with a particular sqlite3* ? Dan Winslow, GamePlan 402-991-5875 x219 [EMAIL PROTECTED] Third Nerd from the left,Technology Defenestration Office ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] bug with NULL in NOT IN
The lesson is very clear from the evidence. With SQL NULL is ambiguous and subject to intepretation so good design requires that you completely avoid it. Then you sidestep intractable implementation interptrations. A project management technique dating back further than I can remember was to define elments of languages and tools which were problem ridden and forbid their usage. Quality problems were slashed. D. Richard Hipp wrote: > On Jun 25, 2008, at 12:48 PM, Wilson, Ron P wrote: > > >>It seems to me that using NULL ... could >>create a lot of confusion in queries. > > > Yes, yes. SQL-NULL excels at creating confusion! > > D. Richard Hipp > [EMAIL PROTECTED] > > > > ___ > 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] bug help
Is this the correct list for airing SQLite amalgamation compilation problems? -- Charlie Springer ** Gas prices getting you down? Search AOL Autos for fuel-efficient used cars. (http://autos.aol.com/used?ncid=aolaut000507) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] bug with NULL in NOT IN
On Jun 25, 2008, at 12:48 PM, Wilson, Ron P wrote: > It seems to me that using NULL ... could > create a lot of confusion in queries. Yes, yes. SQL-NULL excels at creating confusion! D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] bug with NULL in NOT IN
Ah. Thanks for the clarification. It seems to me that using NULL as 'anything' or 'unknown' - it becomes a wildcard of sorts and could create a lot of confusion in queries. note to self : use NULL with extreme caution. Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp Sent: Wednesday, June 25, 2008 12:27 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] bug with NULL in NOT IN On Jun 25, 2008, at 12:12 PM, Wilson, Ron P wrote: > Why should the second query return zero rows? Clearly ids 1 and 2 > don't > exist in b. The meaning of "NULL" in SQL is overloaded. In some contexts NULL means "anything" or "unknown". In other contexts it means "nothing". If we assume NULL means "nothing" then your statement above is correct. But if we assume NULL means "anything" or "unknown" then we don't know if the right-hand side (RHS) of the NOT IN contains a 1 or 2 because it contains a NULL which is a placeholder for an unknown value which might be a 1 or a 2 - we just don't know. If I understand Peter correctly, he is saying that NULL should mean "unknown" in the context of the RHS of a NOT IN operator. SQLite does not currently operate this way. SQLite currently interprets a NULL in the RHS of a NOT IN operator to mean "nothing". D. Richard Hipp [EMAIL PROTECTED] ___ 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] bug with NULL in NOT IN
On Jun 25, 2008, at 12:12 PM, Wilson, Ron P wrote: > Why should the second query return zero rows? Clearly ids 1 and 2 > don't > exist in b. The meaning of "NULL" in SQL is overloaded. In some contexts NULL means "anything" or "unknown". In other contexts it means "nothing". If we assume NULL means "nothing" then your statement above is correct. But if we assume NULL means "anything" or "unknown" then we don't know if the right-hand side (RHS) of the NOT IN contains a 1 or 2 because it contains a NULL which is a placeholder for an unknown value which might be a 1 or a 2 - we just don't know. If I understand Peter correctly, he is saying that NULL should mean "unknown" in the context of the RHS of a NOT IN operator. SQLite does not currently operate this way. SQLite currently interprets a NULL in the RHS of a NOT IN operator to mean "nothing". D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] bug with NULL in NOT IN
Why should the second query return zero rows? Clearly ids 1 and 2 don't exist in b. I'm not defending sqlite per se, just asking, logically speaking, why would those other databases return zero rows for that query? On a related note, what if NULL exists in both tables? Sqlite doesn't return that row for the first query: SQLite version 3.5.9 Enter ".help" for instructions sqlite> create table a(id integer); sqlite> insert into a values(1); sqlite> insert into a values(2); sqlite> insert into a values(3); sqlite> insert into a values(NULL); sqlite> create table b(id integer); sqlite> insert into b values(NULL); sqlite> insert into b values(3); sqlite> insert into b values(4); sqlite> insert into b values(5); sqlite> select * from a where id in (select id from b); 3 sqlite> Sqlite deliberately ignores all NULL values in a select. This explains the result, but logically doesn't follow because in fact NULL does exist in both tables. Interesting. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp Sent: Wednesday, June 25, 2008 11:50 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] bug with NULL in NOT IN On Jun 25, 2008, at 11:33 AM, [EMAIL PROTECTED] wrote: > Hello, > > with the following schema and contents: > > BEGIN TRANSACTION; > CREATE TABLE a(id INTEGER); > INSERT INTO a VALUES(1); > INSERT INTO a VALUES(2); > INSERT INTO a VALUES(3); > CREATE TABLE b(id INTEGER); > INSERT INTO b VALUES(NULL); > INSERT INTO b VALUES(3); > INSERT INTO b VALUES(4); > INSERT INTO b VALUES(5); > COMMIT; > > mysql, postgres, sqlite and mssql agree on: > > SELECT * FROM a WHERE id IN (SELECT id FROM b); > > yielding one row with id=3. > > However, on the query: > > SELECT * FROM a WHERE id NOT IN (SELECT id FROM b); > > mysql, postgres and mssql correctly return zero rows. SQLite > however returns two rows, for id=1 and id=2. > > http://www.sqlite.org/nulls.html doesn't list it, so perhaps > this has never come up before. No, this has never come up before. The behavior of SQLite is as I intended it to be. NULLs are deliberately and willfully filtered out of the subquery to the right of NOT IN. Are you saying that this is incorrect? Other than the fact that three other database engines do it differently, do you have any evidence that this really is incorrect? NULL behavior in SQL is highly unintuitive. In fact, as far as I can tell it is arbitrary. Can you or anybody else point to text in any SQL spec that would suggest that SQLites behavior in this case is wrong? D. Richard Hipp [EMAIL PROTECTED] ___ 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] Preserve optimzation after a table change
Raphaël KINDT <[EMAIL PROTECTED]> wrote: > How can I change the schema of this table to keep the optimzation and > allow to have two same 'time'? > > CREATE TABLE events( >time REAL NOT NULL PRIMARY KEY, >detections BLOB); > > CREATE INDEX idxTime ON events (time ASC); Just drop PRIMARY KEY. As it stands, you have two indexes on events(time) - one explicit and one implicit in PRIMARY KEY. You only need one. Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] bug with NULL in NOT IN
On Jun 25, 2008, at 11:33 AM, [EMAIL PROTECTED] wrote: > Hello, > > with the following schema and contents: > > BEGIN TRANSACTION; > CREATE TABLE a(id INTEGER); > INSERT INTO a VALUES(1); > INSERT INTO a VALUES(2); > INSERT INTO a VALUES(3); > CREATE TABLE b(id INTEGER); > INSERT INTO b VALUES(NULL); > INSERT INTO b VALUES(3); > INSERT INTO b VALUES(4); > INSERT INTO b VALUES(5); > COMMIT; > > mysql, postgres, sqlite and mssql agree on: > > SELECT * FROM a WHERE id IN (SELECT id FROM b); > > yielding one row with id=3. > > However, on the query: > > SELECT * FROM a WHERE id NOT IN (SELECT id FROM b); > > mysql, postgres and mssql correctly return zero rows. SQLite > however returns two rows, for id=1 and id=2. > > http://www.sqlite.org/nulls.html doesn't list it, so perhaps > this has never come up before. No, this has never come up before. The behavior of SQLite is as I intended it to be. NULLs are deliberately and willfully filtered out of the subquery to the right of NOT IN. Are you saying that this is incorrect? Other than the fact that three other database engines do it differently, do you have any evidence that this really is incorrect? NULL behavior in SQL is highly unintuitive. In fact, as far as I can tell it is arbitrary. Can you or anybody else point to text in any SQL spec that would suggest that SQLites behavior in this case is wrong? D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] bug with NULL in NOT IN
Hello, with the following schema and contents: BEGIN TRANSACTION; CREATE TABLE a(id INTEGER); INSERT INTO a VALUES(1); INSERT INTO a VALUES(2); INSERT INTO a VALUES(3); CREATE TABLE b(id INTEGER); INSERT INTO b VALUES(NULL); INSERT INTO b VALUES(3); INSERT INTO b VALUES(4); INSERT INTO b VALUES(5); COMMIT; mysql, postgres, sqlite and mssql agree on: SELECT * FROM a WHERE id IN (SELECT id FROM b); yielding one row with id=3. However, on the query: SELECT * FROM a WHERE id NOT IN (SELECT id FROM b); mysql, postgres and mssql correctly return zero rows. SQLite however returns two rows, for id=1 and id=2. http://www.sqlite.org/nulls.html doesn't list it, so perhaps this has never come up before. Cheers, Peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Preserve optimzation after a table change
Hello, How can I change the schema of this table to keep the optimzation and allow to have two same 'time'? CREATE TABLE events( time REAL NOT NULL PRIMARY KEY, detections BLOB); CREATE INDEX idxTime ON events (time ASC); Thanks in advance. KINDT Raphaël ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] NOT LIKE statement
On 6/25/08, James <[EMAIL PROTECTED]> wrote: > Hi, Simon: > Thanks for help me solve this problem. > I have study the link you give me. But I still don't understand why > my original SQL statement can't work. Could you explain in detail? You are expecting the LIKE (or NOT LIKE) operator to behave like a RegExp operator. No, it doesn't. It just has a single wildcard specifier, the % sign. > Thank you. > > > James > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Simon Davies > > Sent: Wednesday, June 25, 2008 4:40 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] NOT LIKE statement > > I can get your expected results from the data you have given, as shown > below: > > sqlite> CREATE TABLE tst( name text ); > sqlite> > sqlite> insert into tst values( 'InternetGatewayDevice.DeviceInfo.' ); > sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.1' ); > sqlite> insert into tst values( > 'InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion' ); > sqlite> insert into tst values( > 'InternetGatewayDevice.DeviceInfo.SerialNumber' ); > sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.2' ); > sqlite> insert into tst values( 'InternetGatewayDevice.ManagementServer.' ); > sqlite> insert into tst values( 'InternetGatewayDevice.ManagementServer.URL' > ); > sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.3' ); > sqlite> insert into tst values( > 'InternetGatewayDevice.ManagementServer.Username' ); > sqlite> insert into tst values( > 'InternetGatewayDevice.ManagementServer.DownloadProgressURL' ); > sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.4' ); > sqlite> > sqlite> > sqlite> select name from tst where name like 'InternetGatewayDevice.%'; > InternetGatewayDevice.DeviceInfo. > InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion > InternetGatewayDevice.DeviceInfo.SerialNumber > InternetGatewayDevice.ManagementServer. > InternetGatewayDevice.ManagementServer.URL > InternetGatewayDevice.ManagementServer.Username > InternetGatewayDevice.ManagementServer.DownloadProgressURL > sqlite> > sqlite> > sqlite> select name from tst where name like 'InternetGatewayDevice.%' > and name not like 'InternetGatewayDevice.%._%'; > InternetGatewayDevice.DeviceInfo. > InternetGatewayDevice.ManagementServer. > sqlite> > > Rgds, > Simon > > 2008/6/25 James <[EMAIL PROTECTED]>: > > Hi, > > I will read that. > > But I want to know that is it possible to get the expected result? > > Thank you. > > > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Simon Davies > > Sent: Wednesday, June 25, 2008 3:57 PM > > To: General Discussion of SQLite Database > > Subject: Re: [sqlite] NOT LIKE statement > > > > Hi James, > > > > I think the problem lies with your expectations. > > > > Read the section on the LIKE operator in > > http://www.sqlite.org/lang_expr.html > > > > Rgds, > > Simon > > > > 2008/6/25 James <[EMAIL PROTECTED]>: > >> Hi, > >> > >> I execute the SQL statement [SELECT Name FROM tr069;] and get the result > >> > >> InternetGatewayDevice.DeviceInfo. > >> > >> InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion > >> > >> InternetGatewayDevice.DeviceInfo.AdditionalSoftwareVersion > >> > >> InternetGatewayDevice.DeviceInfo.Description > >> > >> InternetGatewayDevice.DeviceInfo.DeviceLog > >> > >> InternetGatewayDevice.DeviceInfo.DeviceStatus > >> > >> InternetGatewayDevice.DeviceInfo.EnabledOptions > >> > >> InternetGatewayDevice.DeviceInfo.FirstUseDate > >> > >> InternetGatewayDevice.DeviceInfo.HardwareVersion > >> > >> InternetGatewayDevice.DeviceInfo.SoftwareVersion > >> > >> InternetGatewayDevice.DeviceInfo.Manufacturer > >> > >> InternetGatewayDevice.DeviceInfo.ManufacturerOUI > >> > >> InternetGatewayDevice.DeviceInfo.ModelName > >> > >> InternetGatewayDevice.DeviceInfo.ProductClass > >> > >> InternetGatewayDevice.DeviceInfo.ProvisioningCode > >> > >> InternetGatewayDevice.DeviceInfo.SerialNumber > >> > >> InternetGatewayDevice.DeviceInfo.UpTime > >> > >> InternetGatewayDevice.ManagementServer. > >> > >> InternetGatewayDevice.ManagementServer.URL > >> > >> InternetGatewayDevice.ManagementServer.Username > >> > >> InternetGatewayDevice.ManagementServer.Password > >> > >> InternetGatewayDevice.ManagementServer.PeriodicInformEnable > >> > >> InternetGatewayDevice.ManagementServer.PeriodicInformInterval > >> > >> InternetGatewayDevice.ManagementServer.PeriodicInformTime > >> > >> InternetGatewayDevice.ManagementServer.ParameterKey > >> > >> InternetGatewayDevice.ManagementServer.ConnectionRequestURL > >> > >> InternetGatewayDevice.ManagementServer.ConnectionRequestUsername > >> > >> InternetGatewayDevice.ManagementServer.ConnectionRequestPassword > >> > >>
[sqlite] SQLITE_ENABLE_COLUMN_METADATA pro and cons
I have a question for which I couldn't find much in this list or in sqlite.org website: the pros are ovious, but what are the cons of compiling with -DSQLITE_ENABLE_COLUMN_METADATA? I guess there must be some, if that's not compiled by default. What's the concern? Code size? (this would not be a problem in my case) More memory used? per query o per row? Less efficient or somewhat slower? Or simply it is an unsupported option with no known cons but not tested enough yet? cheers, -- Lapo Luchini - http://lapo.it/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] NOT LIKE statement
You seemed to be expecting that name NOT LIKE 'InternetGatewayDevice.%.[1-9]' AND name NOT LIKE 'InternetGatewayDevice.%.[^1-9] would exclude some of the rows you are getting. This is incorrect. The only wild cards affecting operation of the LIKE operator are '%' and '_'. Regards, Simon 2008/6/25 James <[EMAIL PROTECTED]>: > Hi, Simon: >Thanks for help me solve this problem. >I have study the link you give me. But I still don't understand why > my original SQL statement can't work. Could you explain in detail? >Thank you. > > James > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Simon Davies > Sent: Wednesday, June 25, 2008 4:40 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] NOT LIKE statement > > I can get your expected results from the data you have given, as shown > below: > > sqlite> CREATE TABLE tst( name text ); > sqlite> > sqlite> insert into tst values( 'InternetGatewayDevice.DeviceInfo.' ); > sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.1' ); > sqlite> insert into tst values( > 'InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion' ); > sqlite> insert into tst values( > 'InternetGatewayDevice.DeviceInfo.SerialNumber' ); > sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.2' ); > sqlite> insert into tst values( 'InternetGatewayDevice.ManagementServer.' ); > sqlite> insert into tst values( 'InternetGatewayDevice.ManagementServer.URL' > ); > sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.3' ); > sqlite> insert into tst values( > 'InternetGatewayDevice.ManagementServer.Username' ); > sqlite> insert into tst values( > 'InternetGatewayDevice.ManagementServer.DownloadProgressURL' ); > sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.4' ); > sqlite> > sqlite> > sqlite> select name from tst where name like 'InternetGatewayDevice.%'; > InternetGatewayDevice.DeviceInfo. > InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion > InternetGatewayDevice.DeviceInfo.SerialNumber > InternetGatewayDevice.ManagementServer. > InternetGatewayDevice.ManagementServer.URL > InternetGatewayDevice.ManagementServer.Username > InternetGatewayDevice.ManagementServer.DownloadProgressURL > sqlite> > sqlite> > sqlite> select name from tst where name like 'InternetGatewayDevice.%' > and name not like 'InternetGatewayDevice.%._%'; > InternetGatewayDevice.DeviceInfo. > InternetGatewayDevice.ManagementServer. > sqlite> > > Rgds, > Simon > > 2008/6/25 James <[EMAIL PROTECTED]>: >> Hi, >> I will read that. >> But I want to know that is it possible to get the expected result? >> Thank you. >> >> >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of Simon Davies >> Sent: Wednesday, June 25, 2008 3:57 PM >> To: General Discussion of SQLite Database >> Subject: Re: [sqlite] NOT LIKE statement >> >> Hi James, >> >> I think the problem lies with your expectations. >> >> Read the section on the LIKE operator in >> http://www.sqlite.org/lang_expr.html >> >> Rgds, >> Simon >> >> 2008/6/25 James <[EMAIL PROTECTED]>: >>> Hi, >>> >>> I execute the SQL statement [SELECT Name FROM tr069;] and get the result >>> >>> InternetGatewayDevice.DeviceInfo. >>> >>> InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion >>> >>> InternetGatewayDevice.DeviceInfo.AdditionalSoftwareVersion >>> >>> InternetGatewayDevice.DeviceInfo.Description >>> >>> InternetGatewayDevice.DeviceInfo.DeviceLog >>> >>> InternetGatewayDevice.DeviceInfo.DeviceStatus >>> >>> InternetGatewayDevice.DeviceInfo.EnabledOptions >>> >>> InternetGatewayDevice.DeviceInfo.FirstUseDate >>> >>> InternetGatewayDevice.DeviceInfo.HardwareVersion >>> >>> InternetGatewayDevice.DeviceInfo.SoftwareVersion >>> >>> InternetGatewayDevice.DeviceInfo.Manufacturer >>> >>> InternetGatewayDevice.DeviceInfo.ManufacturerOUI >>> >>> InternetGatewayDevice.DeviceInfo.ModelName >>> >>> InternetGatewayDevice.DeviceInfo.ProductClass >>> >>> InternetGatewayDevice.DeviceInfo.ProvisioningCode >>> >>> InternetGatewayDevice.DeviceInfo.SerialNumber >>> >>> InternetGatewayDevice.DeviceInfo.UpTime >>> >>> InternetGatewayDevice.ManagementServer. >>> >>> InternetGatewayDevice.ManagementServer.URL >>> >>> InternetGatewayDevice.ManagementServer.Username >>> >>> InternetGatewayDevice.ManagementServer.Password >>> >>> InternetGatewayDevice.ManagementServer.PeriodicInformEnable >>> >>> InternetGatewayDevice.ManagementServer.PeriodicInformInterval >>> >>> InternetGatewayDevice.ManagementServer.PeriodicInformTime >>> >>> InternetGatewayDevice.ManagementServer.ParameterKey >>> >>> InternetGatewayDevice.ManagementServer.ConnectionRequestURL >>> >>> InternetGatewayDevice.ManagementServer.ConnectionRequestUsername >>> >>> InternetGatewayDevice.ManagementServer.ConnectionRequestPassword >>> >>> InternetGatewayDevice.ManagementServer.UpgradesManaged >>> >>> InternetGatewayDevice.ManagementServer.KickURL >>> >>>
Re: [sqlite] NOT LIKE statement
Hi, Simon: Thanks for help me solve this problem. I have study the link you give me. But I still don't understand why my original SQL statement can't work. Could you explain in detail? Thank you. James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Davies Sent: Wednesday, June 25, 2008 4:40 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] NOT LIKE statement I can get your expected results from the data you have given, as shown below: sqlite> CREATE TABLE tst( name text ); sqlite> sqlite> insert into tst values( 'InternetGatewayDevice.DeviceInfo.' ); sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.1' ); sqlite> insert into tst values( 'InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion' ); sqlite> insert into tst values( 'InternetGatewayDevice.DeviceInfo.SerialNumber' ); sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.2' ); sqlite> insert into tst values( 'InternetGatewayDevice.ManagementServer.' ); sqlite> insert into tst values( 'InternetGatewayDevice.ManagementServer.URL' ); sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.3' ); sqlite> insert into tst values( 'InternetGatewayDevice.ManagementServer.Username' ); sqlite> insert into tst values( 'InternetGatewayDevice.ManagementServer.DownloadProgressURL' ); sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.4' ); sqlite> sqlite> sqlite> select name from tst where name like 'InternetGatewayDevice.%'; InternetGatewayDevice.DeviceInfo. InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion InternetGatewayDevice.DeviceInfo.SerialNumber InternetGatewayDevice.ManagementServer. InternetGatewayDevice.ManagementServer.URL InternetGatewayDevice.ManagementServer.Username InternetGatewayDevice.ManagementServer.DownloadProgressURL sqlite> sqlite> sqlite> select name from tst where name like 'InternetGatewayDevice.%' and name not like 'InternetGatewayDevice.%._%'; InternetGatewayDevice.DeviceInfo. InternetGatewayDevice.ManagementServer. sqlite> Rgds, Simon 2008/6/25 James <[EMAIL PROTECTED]>: > Hi, > I will read that. > But I want to know that is it possible to get the expected result? > Thank you. > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Simon Davies > Sent: Wednesday, June 25, 2008 3:57 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] NOT LIKE statement > > Hi James, > > I think the problem lies with your expectations. > > Read the section on the LIKE operator in > http://www.sqlite.org/lang_expr.html > > Rgds, > Simon > > 2008/6/25 James <[EMAIL PROTECTED]>: >> Hi, >> >> I execute the SQL statement [SELECT Name FROM tr069;] and get the result >> >> InternetGatewayDevice.DeviceInfo. >> >> InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion >> >> InternetGatewayDevice.DeviceInfo.AdditionalSoftwareVersion >> >> InternetGatewayDevice.DeviceInfo.Description >> >> InternetGatewayDevice.DeviceInfo.DeviceLog >> >> InternetGatewayDevice.DeviceInfo.DeviceStatus >> >> InternetGatewayDevice.DeviceInfo.EnabledOptions >> >> InternetGatewayDevice.DeviceInfo.FirstUseDate >> >> InternetGatewayDevice.DeviceInfo.HardwareVersion >> >> InternetGatewayDevice.DeviceInfo.SoftwareVersion >> >> InternetGatewayDevice.DeviceInfo.Manufacturer >> >> InternetGatewayDevice.DeviceInfo.ManufacturerOUI >> >> InternetGatewayDevice.DeviceInfo.ModelName >> >> InternetGatewayDevice.DeviceInfo.ProductClass >> >> InternetGatewayDevice.DeviceInfo.ProvisioningCode >> >> InternetGatewayDevice.DeviceInfo.SerialNumber >> >> InternetGatewayDevice.DeviceInfo.UpTime >> >> InternetGatewayDevice.ManagementServer. >> >> InternetGatewayDevice.ManagementServer.URL >> >> InternetGatewayDevice.ManagementServer.Username >> >> InternetGatewayDevice.ManagementServer.Password >> >> InternetGatewayDevice.ManagementServer.PeriodicInformEnable >> >> InternetGatewayDevice.ManagementServer.PeriodicInformInterval >> >> InternetGatewayDevice.ManagementServer.PeriodicInformTime >> >> InternetGatewayDevice.ManagementServer.ParameterKey >> >> InternetGatewayDevice.ManagementServer.ConnectionRequestURL >> >> InternetGatewayDevice.ManagementServer.ConnectionRequestUsername >> >> InternetGatewayDevice.ManagementServer.ConnectionRequestPassword >> >> InternetGatewayDevice.ManagementServer.UpgradesManaged >> >> InternetGatewayDevice.ManagementServer.KickURL >> >> InternetGatewayDevice.ManagementServer.DownloadProgressURL >> >> >> >> And I execute the SQL statement [SELECT name FROM tr069 WHERE name LIKE >> 'InternetGatewayDevice.%' AND name NOT LIKE > 'InternetGatewayDevice.%.[1-9]' >> AND name NOT LIKE 'InternetGatewayDevice.%.[^1-9] ';] and expect to get > the >> result [InternetGatewayDevice.DeviceInfo.] and >> [InternetGatewayDevice.ManagementServer.]. >> >> But I still get the above result. I don't know where the problem is. >> >> Could someone tell me ? >> >> Thank you. >> >> >> >> James Liang
Re: [sqlite] NOT LIKE statement
I can get your expected results from the data you have given, as shown below: sqlite> CREATE TABLE tst( name text ); sqlite> sqlite> insert into tst values( 'InternetGatewayDevice.DeviceInfo.' ); sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.1' ); sqlite> insert into tst values( 'InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion' ); sqlite> insert into tst values( 'InternetGatewayDevice.DeviceInfo.SerialNumber' ); sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.2' ); sqlite> insert into tst values( 'InternetGatewayDevice.ManagementServer.' ); sqlite> insert into tst values( 'InternetGatewayDevice.ManagementServer.URL' ); sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.3' ); sqlite> insert into tst values( 'InternetGatewayDevice.ManagementServer.Username' ); sqlite> insert into tst values( 'InternetGatewayDevice.ManagementServer.DownloadProgressURL' ); sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.4' ); sqlite> sqlite> sqlite> select name from tst where name like 'InternetGatewayDevice.%'; InternetGatewayDevice.DeviceInfo. InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion InternetGatewayDevice.DeviceInfo.SerialNumber InternetGatewayDevice.ManagementServer. InternetGatewayDevice.ManagementServer.URL InternetGatewayDevice.ManagementServer.Username InternetGatewayDevice.ManagementServer.DownloadProgressURL sqlite> sqlite> sqlite> select name from tst where name like 'InternetGatewayDevice.%' and name not like 'InternetGatewayDevice.%._%'; InternetGatewayDevice.DeviceInfo. InternetGatewayDevice.ManagementServer. sqlite> Rgds, Simon 2008/6/25 James <[EMAIL PROTECTED]>: > Hi, > I will read that. > But I want to know that is it possible to get the expected result? > Thank you. > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Simon Davies > Sent: Wednesday, June 25, 2008 3:57 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] NOT LIKE statement > > Hi James, > > I think the problem lies with your expectations. > > Read the section on the LIKE operator in > http://www.sqlite.org/lang_expr.html > > Rgds, > Simon > > 2008/6/25 James <[EMAIL PROTECTED]>: >> Hi, >> >> I execute the SQL statement [SELECT Name FROM tr069;] and get the result >> >> InternetGatewayDevice.DeviceInfo. >> >> InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion >> >> InternetGatewayDevice.DeviceInfo.AdditionalSoftwareVersion >> >> InternetGatewayDevice.DeviceInfo.Description >> >> InternetGatewayDevice.DeviceInfo.DeviceLog >> >> InternetGatewayDevice.DeviceInfo.DeviceStatus >> >> InternetGatewayDevice.DeviceInfo.EnabledOptions >> >> InternetGatewayDevice.DeviceInfo.FirstUseDate >> >> InternetGatewayDevice.DeviceInfo.HardwareVersion >> >> InternetGatewayDevice.DeviceInfo.SoftwareVersion >> >> InternetGatewayDevice.DeviceInfo.Manufacturer >> >> InternetGatewayDevice.DeviceInfo.ManufacturerOUI >> >> InternetGatewayDevice.DeviceInfo.ModelName >> >> InternetGatewayDevice.DeviceInfo.ProductClass >> >> InternetGatewayDevice.DeviceInfo.ProvisioningCode >> >> InternetGatewayDevice.DeviceInfo.SerialNumber >> >> InternetGatewayDevice.DeviceInfo.UpTime >> >> InternetGatewayDevice.ManagementServer. >> >> InternetGatewayDevice.ManagementServer.URL >> >> InternetGatewayDevice.ManagementServer.Username >> >> InternetGatewayDevice.ManagementServer.Password >> >> InternetGatewayDevice.ManagementServer.PeriodicInformEnable >> >> InternetGatewayDevice.ManagementServer.PeriodicInformInterval >> >> InternetGatewayDevice.ManagementServer.PeriodicInformTime >> >> InternetGatewayDevice.ManagementServer.ParameterKey >> >> InternetGatewayDevice.ManagementServer.ConnectionRequestURL >> >> InternetGatewayDevice.ManagementServer.ConnectionRequestUsername >> >> InternetGatewayDevice.ManagementServer.ConnectionRequestPassword >> >> InternetGatewayDevice.ManagementServer.UpgradesManaged >> >> InternetGatewayDevice.ManagementServer.KickURL >> >> InternetGatewayDevice.ManagementServer.DownloadProgressURL >> >> >> >> And I execute the SQL statement [SELECT name FROM tr069 WHERE name LIKE >> 'InternetGatewayDevice.%' AND name NOT LIKE > 'InternetGatewayDevice.%.[1-9]' >> AND name NOT LIKE 'InternetGatewayDevice.%.[^1-9] ';] and expect to get > the >> result [InternetGatewayDevice.DeviceInfo.] and >> [InternetGatewayDevice.ManagementServer.]. >> >> But I still get the above result. I don't know where the problem is. >> >> Could someone tell me ? >> >> Thank you. >> >> >> >> James Liang >> >> ___ >> 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 >
Re: [sqlite] NOT LIKE statement
Hi, I will read that. But I want to know that is it possible to get the expected result? Thank you. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Davies Sent: Wednesday, June 25, 2008 3:57 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] NOT LIKE statement Hi James, I think the problem lies with your expectations. Read the section on the LIKE operator in http://www.sqlite.org/lang_expr.html Rgds, Simon 2008/6/25 James <[EMAIL PROTECTED]>: > Hi, > > I execute the SQL statement [SELECT Name FROM tr069;] and get the result > > InternetGatewayDevice.DeviceInfo. > > InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion > > InternetGatewayDevice.DeviceInfo.AdditionalSoftwareVersion > > InternetGatewayDevice.DeviceInfo.Description > > InternetGatewayDevice.DeviceInfo.DeviceLog > > InternetGatewayDevice.DeviceInfo.DeviceStatus > > InternetGatewayDevice.DeviceInfo.EnabledOptions > > InternetGatewayDevice.DeviceInfo.FirstUseDate > > InternetGatewayDevice.DeviceInfo.HardwareVersion > > InternetGatewayDevice.DeviceInfo.SoftwareVersion > > InternetGatewayDevice.DeviceInfo.Manufacturer > > InternetGatewayDevice.DeviceInfo.ManufacturerOUI > > InternetGatewayDevice.DeviceInfo.ModelName > > InternetGatewayDevice.DeviceInfo.ProductClass > > InternetGatewayDevice.DeviceInfo.ProvisioningCode > > InternetGatewayDevice.DeviceInfo.SerialNumber > > InternetGatewayDevice.DeviceInfo.UpTime > > InternetGatewayDevice.ManagementServer. > > InternetGatewayDevice.ManagementServer.URL > > InternetGatewayDevice.ManagementServer.Username > > InternetGatewayDevice.ManagementServer.Password > > InternetGatewayDevice.ManagementServer.PeriodicInformEnable > > InternetGatewayDevice.ManagementServer.PeriodicInformInterval > > InternetGatewayDevice.ManagementServer.PeriodicInformTime > > InternetGatewayDevice.ManagementServer.ParameterKey > > InternetGatewayDevice.ManagementServer.ConnectionRequestURL > > InternetGatewayDevice.ManagementServer.ConnectionRequestUsername > > InternetGatewayDevice.ManagementServer.ConnectionRequestPassword > > InternetGatewayDevice.ManagementServer.UpgradesManaged > > InternetGatewayDevice.ManagementServer.KickURL > > InternetGatewayDevice.ManagementServer.DownloadProgressURL > > > > And I execute the SQL statement [SELECT name FROM tr069 WHERE name LIKE > 'InternetGatewayDevice.%' AND name NOT LIKE 'InternetGatewayDevice.%.[1-9]' > AND name NOT LIKE 'InternetGatewayDevice.%.[^1-9] ';] and expect to get the > result [InternetGatewayDevice.DeviceInfo.] and > [InternetGatewayDevice.ManagementServer.]. > > But I still get the above result. I don't know where the problem is. > > Could someone tell me ? > > Thank you. > > > > James Liang > > ___ > 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] NOT LIKE statement
Hi James, I think the problem lies with your expectations. Read the section on the LIKE operator in http://www.sqlite.org/lang_expr.html Rgds, Simon 2008/6/25 James <[EMAIL PROTECTED]>: > Hi, > > I execute the SQL statement [SELECT Name FROM tr069;] and get the result > > InternetGatewayDevice.DeviceInfo. > > InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion > > InternetGatewayDevice.DeviceInfo.AdditionalSoftwareVersion > > InternetGatewayDevice.DeviceInfo.Description > > InternetGatewayDevice.DeviceInfo.DeviceLog > > InternetGatewayDevice.DeviceInfo.DeviceStatus > > InternetGatewayDevice.DeviceInfo.EnabledOptions > > InternetGatewayDevice.DeviceInfo.FirstUseDate > > InternetGatewayDevice.DeviceInfo.HardwareVersion > > InternetGatewayDevice.DeviceInfo.SoftwareVersion > > InternetGatewayDevice.DeviceInfo.Manufacturer > > InternetGatewayDevice.DeviceInfo.ManufacturerOUI > > InternetGatewayDevice.DeviceInfo.ModelName > > InternetGatewayDevice.DeviceInfo.ProductClass > > InternetGatewayDevice.DeviceInfo.ProvisioningCode > > InternetGatewayDevice.DeviceInfo.SerialNumber > > InternetGatewayDevice.DeviceInfo.UpTime > > InternetGatewayDevice.ManagementServer. > > InternetGatewayDevice.ManagementServer.URL > > InternetGatewayDevice.ManagementServer.Username > > InternetGatewayDevice.ManagementServer.Password > > InternetGatewayDevice.ManagementServer.PeriodicInformEnable > > InternetGatewayDevice.ManagementServer.PeriodicInformInterval > > InternetGatewayDevice.ManagementServer.PeriodicInformTime > > InternetGatewayDevice.ManagementServer.ParameterKey > > InternetGatewayDevice.ManagementServer.ConnectionRequestURL > > InternetGatewayDevice.ManagementServer.ConnectionRequestUsername > > InternetGatewayDevice.ManagementServer.ConnectionRequestPassword > > InternetGatewayDevice.ManagementServer.UpgradesManaged > > InternetGatewayDevice.ManagementServer.KickURL > > InternetGatewayDevice.ManagementServer.DownloadProgressURL > > > > And I execute the SQL statement [SELECT name FROM tr069 WHERE name LIKE > 'InternetGatewayDevice.%' AND name NOT LIKE 'InternetGatewayDevice.%.[1-9]' > AND name NOT LIKE 'InternetGatewayDevice.%.[^1-9] ';] and expect to get the > result [InternetGatewayDevice.DeviceInfo.] and > [InternetGatewayDevice.ManagementServer.]. > > But I still get the above result. I don't know where the problem is. > > Could someone tell me ? > > Thank you. > > > > James Liang > > ___ > 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] Fatal error: Call to undefined function sqlite_open()
Yes, thats it! Missing "extension=sqlite.so" in my php.ini. Now apt-get brings the 'sqlite.so' with it. Thanks Gopal ! :-) On Tue, Jun 24, 2008 at 4:04 PM, Gopal Venkatesan <[EMAIL PROTECTED]> wrote: > - "Philipp Morath" <[EMAIL PROTECTED]> wrote: > >> Thanks you Gopal. >> Nothing about sqlite in my error.log. Hum? >> How do I get the required library? > > Hi Philipp: > > Is it a stock version of PHP (installed from package), or is it compiled from > source? > > If its the former, what does the following command return? > > shell> dpkg -l | grep php5-sqlite > > If its returning empty, you're missing the PHP SQLite extension. Install it > using the following command: > > shell> sudo dpkg -i php5-sqlite > > If its the latter, you'll have to recompile PHP with the sqlite extension > turned on (this is by default), but doing a recompile might be worth the try. > > HTH. > -- > Gopal Venkatesan > http://gopalarathnam.com/weblog/ > ___ > 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] NOT LIKE statement
Hi, I execute the SQL statement [SELECT Name FROM tr069;] and get the result InternetGatewayDevice.DeviceInfo. InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion InternetGatewayDevice.DeviceInfo.AdditionalSoftwareVersion InternetGatewayDevice.DeviceInfo.Description InternetGatewayDevice.DeviceInfo.DeviceLog InternetGatewayDevice.DeviceInfo.DeviceStatus InternetGatewayDevice.DeviceInfo.EnabledOptions InternetGatewayDevice.DeviceInfo.FirstUseDate InternetGatewayDevice.DeviceInfo.HardwareVersion InternetGatewayDevice.DeviceInfo.SoftwareVersion InternetGatewayDevice.DeviceInfo.Manufacturer InternetGatewayDevice.DeviceInfo.ManufacturerOUI InternetGatewayDevice.DeviceInfo.ModelName InternetGatewayDevice.DeviceInfo.ProductClass InternetGatewayDevice.DeviceInfo.ProvisioningCode InternetGatewayDevice.DeviceInfo.SerialNumber InternetGatewayDevice.DeviceInfo.UpTime InternetGatewayDevice.ManagementServer. InternetGatewayDevice.ManagementServer.URL InternetGatewayDevice.ManagementServer.Username InternetGatewayDevice.ManagementServer.Password InternetGatewayDevice.ManagementServer.PeriodicInformEnable InternetGatewayDevice.ManagementServer.PeriodicInformInterval InternetGatewayDevice.ManagementServer.PeriodicInformTime InternetGatewayDevice.ManagementServer.ParameterKey InternetGatewayDevice.ManagementServer.ConnectionRequestURL InternetGatewayDevice.ManagementServer.ConnectionRequestUsername InternetGatewayDevice.ManagementServer.ConnectionRequestPassword InternetGatewayDevice.ManagementServer.UpgradesManaged InternetGatewayDevice.ManagementServer.KickURL InternetGatewayDevice.ManagementServer.DownloadProgressURL And I execute the SQL statement [SELECT name FROM tr069 WHERE name LIKE 'InternetGatewayDevice.%' AND name NOT LIKE 'InternetGatewayDevice.%.[1-9]' AND name NOT LIKE 'InternetGatewayDevice.%.[^1-9] ';] and expect to get the result [InternetGatewayDevice.DeviceInfo.] and [InternetGatewayDevice.ManagementServer.]. But I still get the above result. I don't know where the problem is. Could someone tell me ? Thank you. James Liang ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
