Re: [sqlite] Version 3.5.5 Released

[Eduardo Morras]

At 18:33 31/01/2008, you wrote:
>The big change from version 3.5.4 is that the internal virtual
>machine was reworked to use operands in registers rather than
>pulling operands from a stack.  The virtual machine stack has
>now been removed.  The removal of the VM stack will help prevent
>future stack overflow bugs and will also facilitate new optimizations
>in future releases.
>
>There should be no user-visible changes to the operation of SQLite
>in this release, except that the output of EXPLAIN looks different.
>
>In order to make this change, about 8.5% of the core SQLite code
>had to be reworked.  We thought this might introduce instability.
>But we have done two weeks of intensive testing, during which time
>we have increased the statement test coverage to 99% and during
>which we have found and fixed lots of minor bugs (mostly things
>like leaking memory following a malloc failure).  But for all of
>that testing, we have not detected a single bug in the new
>register-based VM.  And for that reason, we believe the new
>VM, and hence version 3.5.5, is stable and ready for production
>use.

The new VM was designed with a possible (low probable) port to 
VHDL/Verilog for Sqlite in FPGA? Changing from a VM stack to VM 
register based make easier to port.

Perhaps it's a very crazy idea...


One reason that life is complex is that it has a real part and an 
imaginary part
-Andrew Koenig  

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Version 3.5.5 Released

[[EMAIL PROTECTED]]

Thanks, that
helped.

[EMAIL PROTECTED] wrote:

  "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
  
  
Got the
sqlite3.exe version 3.5.5 but .explain still doesn't seem to work. 
Maybe it's me, could someone post a simple example of .explain working?


  
  

C:\ sqlite3
SQLite version 3.5.5
Enter ".help" for instructions
sqlite> create table t1(x);
sqlite> .explain
sqlite> EXPLAIN SELECT * FROM t1;

[explain output follows the above].

--
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] Version 3.5.5 Released

[drh]

"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Got the
> sqlite3.exe version 3.5.5 but .explain still doesn't seem to work. 
> Maybe it's me, could someone post a simple example of .explain working?
> 


C:\ sqlite3
SQLite version 3.5.5
Enter ".help" for instructions
sqlite> create table t1(x);
sqlite> .explain
sqlite> EXPLAIN SELECT * FROM t1;

[explain output follows the above].

--
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] Version 3.5.5 Released

[[EMAIL PROTECTED]]

Got the
sqlite3.exe version 3.5.5 but .explain still doesn't seem to work. 
Maybe it's me, could someone post a simple example of .explain working?

[EMAIL PROTECTED] wrote:
Also,
.schema and .explain don't seem to do anything in then sqlite3.exe
version 3.5.4. I downloaded in sqlite-3_5_5.zip
  
  
  
Mohd Radzi Ibrahim wrote:
  
  Hi,


The Precompiled Binary for Windows : the command-line sqlite-3_5_5.zip
still contain the 3.5.4 version


regards,

Radzi.

- Original Message - From: <[EMAIL PROTECTED]>

To: 

Sent: Friday, February 01, 2008 1:33 AM
    
Subject: [sqlite] Version 3.5.5 Released



SQLite version 3.5.5 is now available for
download from the
  
SQLite website:
  
  
  http://www.sqlite.org/
  
  
The big change from version 3.5.4 is that the internal virtual
  
machine was reworked to use operands in registers rather than
  
pulling operands from a stack.  The virtual machine stack has
  
now been removed.  The removal of the VM stack will help prevent
  
future stack overflow bugs and will also facilitate new optimizations
  
in future releases.
  
  
There should be no user-visible changes to the operation of SQLite
  
in this release, except that the output of EXPLAIN looks different.
  
  
In order to make this change, about 8.5% of the core SQLite code
  
had to be reworked.  We thought this might introduce instability.
  
But we have done two weeks of intensive testing, during which time
  
we have increased the statement test coverage to 99% and during
  
which we have found and fixed lots of minor bugs (mostly things
  
like leaking memory following a malloc failure).  But for all of
  
that testing, we have not detected a single bug in the new
  
register-based VM.  And for that reason, we believe the new
  
VM, and hence version 3.5.5, is stable and ready for production
  
use.
  
  
As usual, please report any problems to this mailing list, or
  
directly to me.
  
  
-- 
D. Richard Hipp <[EMAIL PROTECTED]>
  
  
  
-
  
To unsubscribe, send email to [EMAIL PROTECTED]
  
-
  
  
  
  




-

To unsubscribe, send email to [EMAIL PROTECTED]

-




  
  
-
  
To unsubscribe, send email to [EMAIL PROTECTED]
  
-
  
  
  
  



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Version 3.5.5 Released

[[EMAIL PROTECTED]]

Also, .schema and .explain don't seem to do anything in then sqlite3.exe 
version 3.5.4. I downloaded in sqlite-3_5_5.zip



Mohd Radzi Ibrahim wrote:

Hi,

The Precompiled Binary for Windows : the command-line sqlite-3_5_5.zip 
still contain the 3.5.4 version


regards,
Radzi.
- Original Message - From: <[EMAIL PROTECTED]>
To: 
Sent: Friday, February 01, 2008 1:33 AM
Subject: [sqlite] Version 3.5.5 Released



SQLite version 3.5.5 is now available for download from the
SQLite website:

  http://www.sqlite.org/

The big change from version 3.5.4 is that the internal virtual
machine was reworked to use operands in registers rather than
pulling operands from a stack.  The virtual machine stack has
now been removed.  The removal of the VM stack will help prevent
future stack overflow bugs and will also facilitate new optimizations
in future releases.

There should be no user-visible changes to the operation of SQLite
in this release, except that the output of EXPLAIN looks different.

In order to make this change, about 8.5% of the core SQLite code
had to be reworked.  We thought this might introduce instability.
But we have done two weeks of intensive testing, during which time
we have increased the statement test coverage to 99% and during
which we have found and fixed lots of minor bugs (mostly things
like leaking memory following a malloc failure).  But for all of
that testing, we have not detected a single bug in the new
register-based VM.  And for that reason, we believe the new
VM, and hence version 3.5.5, is stable and ready for production
use.

As usual, please report any problems to this mailing list, or
directly to me.

--
D. Richard Hipp <[EMAIL PROTECTED]>


- 


To unsubscribe, send email to [EMAIL PROTECTED]
- 









- 


To unsubscribe, send email to [EMAIL PROTECTED]
- 







-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Version 3.5.5 Released

[Mohd Radzi Ibrahim]

Hi,

The Precompiled Binary for Windows : the command-line sqlite-3_5_5.zip still 
contain the 3.5.4 version


regards,
Radzi.
- Original Message - 
From: <[EMAIL PROTECTED]>

To: 
Sent: Friday, February 01, 2008 1:33 AM
Subject: [sqlite] Version 3.5.5 Released



SQLite version 3.5.5 is now available for download from the
SQLite website:

  http://www.sqlite.org/

The big change from version 3.5.4 is that the internal virtual
machine was reworked to use operands in registers rather than
pulling operands from a stack.  The virtual machine stack has
now been removed.  The removal of the VM stack will help prevent
future stack overflow bugs and will also facilitate new optimizations
in future releases.

There should be no user-visible changes to the operation of SQLite
in this release, except that the output of EXPLAIN looks different.

In order to make this change, about 8.5% of the core SQLite code
had to be reworked.  We thought this might introduce instability.
But we have done two weeks of intensive testing, during which time
we have increased the statement test coverage to 99% and during
which we have found and fixed lots of minor bugs (mostly things
like leaking memory following a malloc failure).  But for all of
that testing, we have not detected a single bug in the new
register-based VM.  And for that reason, we believe the new
VM, and hence version 3.5.5, is stable and ready for production
use.

As usual, please report any problems to this mailing list, or
directly to me.

--
D. Richard Hipp <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-







-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] Version 3.5.5 Released

[Rich Shepard]

  For any who care, 3.5.5 built flawlessly on Slackware-11.0 and -12.0.
Works, too.

  Thank you, development team.

Rich

--
Richard B. Shepard, Ph.D.   |  IntegrityCredibility
Applied Ecosystem Services, Inc.|Innovation
 Voice: 503-667-4517  Fax: 503-667-8863

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] Version 3.5.5 Released

[Noah Hart]

Got it!  Thanks for the clarification.

Noah


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 31, 2008 10:43 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Version 3.5.5 Released
Importance: High

"Noah Hart" <[EMAIL PROTECTED]> wrote:
> With SQLITE_OMIT_VIRTUALTABLE defined, I get a linker fault under VC++
> 
> It claims that:
> error LNK2001: unresolved external symbol sqlite3VtabBeginParse

That call *is* surrounded by #ifndef SQLITE_OMIT_VIRTUALTABLE.  But
the #ifndef is located in parse.y.  You are probably trying to build
off of parse.c, which is a generated file.  You have to tell "lemon"
about the SQLITE_OMIT_VIRTUALTABLE macro or it will generate code
to call sqlite3VtabBeginParse().

In general, you cannot use SQLITE_OMIT macros if you are compiling
from the amalgamation or from the preprocessed C code.  You have
to compile from canonical sources, an in particular you must compile
starting with parse.y, not parse.c.

--
D. Richard Hipp <[EMAIL PROTECTED]>



-
To unsubscribe, send email to [EMAIL PROTECTED]

-




CONFIDENTIALITY NOTICE: 
This message may contain confidential and/or privileged information. If you are 
not the addressee or authorized to receive this for the addressee, you must not 
use, copy, disclose, or take any action based on this message or any 
information herein. If you have received this message in error, please advise 
the sender immediately by reply e-mail and delete this message. Thank you for 
your cooperation.




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Version 3.5.5 Released

[drh]

"Noah Hart" <[EMAIL PROTECTED]> wrote:
> With SQLITE_OMIT_VIRTUALTABLE defined, I get a linker fault under VC++
> 
> It claims that:
> error LNK2001: unresolved external symbol sqlite3VtabBeginParse

That call *is* surrounded by #ifndef SQLITE_OMIT_VIRTUALTABLE.  But
the #ifndef is located in parse.y.  You are probably trying to build
off of parse.c, which is a generated file.  You have to tell "lemon"
about the SQLITE_OMIT_VIRTUALTABLE macro or it will generate code
to call sqlite3VtabBeginParse().

In general, you cannot use SQLITE_OMIT macros if you are compiling
from the amalgamation or from the preprocessed C code.  You have
to compile from canonical sources, an in particular you must compile
starting with parse.y, not parse.c.

--
D. Richard Hipp <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] Version 3.5.5 Released

[Noah Hart]

With SQLITE_OMIT_VIRTUALTABLE defined, I get a linker fault under VC++

It claims that:
error LNK2001: unresolved external symbol sqlite3VtabBeginParse

Looking through the source code, I see the following

  Y:\SQLite3\Projects\3_5_5\src\sqliteInt.h(1986)
#ifdef SQLITE_OMIT_VIRTUALTABLE
#  define sqlite3VtabClear(X)
#  define sqlite3VtabSync(X,Y) (Y)
#  define sqlite3VtabRollback(X)
#  define sqlite3VtabCommit(X)
#else
   void sqlite3VtabClear(Table*);
   int sqlite3VtabSync(sqlite3 *db, int rc);
   int sqlite3VtabRollback(sqlite3 *db);
   int sqlite3VtabCommit(sqlite3 *db);
#endif
void sqlite3VtabLock(sqlite3_vtab*);
void sqlite3VtabUnlock(sqlite3*, sqlite3_vtab*);
void sqlite3VtabBeginParse(Parse*, Token*, Token*, Token*);

-- So it is supposed to exist, even with SQLITE_OMIT_VIRTUALTABLE
defined.

Also, Parse uses it here 
Y:\SQLite3\Projects\3_5_5\src\parse.c(3225):   
case 302: /* create_vtab ::= CREATE VIRTUAL TABLE nm dbnm USING nm */
#line 1102 "parse.y"
{
sqlite3VtabBeginParse(pParse, &yymsp[-3].minor.yy410,
&yymsp[-2].minor.yy410, &yymsp[0].minor.yy410);
}

But it is not compiled in Y:\SQLite3\Projects\3_5_5\src\vtab.c, since
this entire routine is excluded via line 16
#ifndef SQLITE_OMIT_VIRTUALTABLE 


Looks like a dummy MACRO or function needs to be created, 
or the PARSE code needs to be bracketed with #ifndef
SQLITE_OMIT_VIRTUALTABLE


Can someone with source access please make this change.

Regards,

Noah Hart



CONFIDENTIALITY NOTICE: 
This message may contain confidential and/or privileged information. If you are 
not the addressee or authorized to receive this for the addressee, you must not 
use, copy, disclose, or take any action based on this message or any 
information herein. If you have received this message in error, please advise 
the sender immediately by reply e-mail and delete this message. Thank you for 
your cooperation.




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Version 3.5.5 Released

[Marco Bambini]

What about speed?
Can we expect the same performance of version 3.5.4?

Thanks a lot for your continue improvements.
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/



On Jan 31, 2008, at 6:33 PM, [EMAIL PROTECTED] wrote:


SQLite version 3.5.5 is now available for download from the
SQLite website:

   http://www.sqlite.org/

The big change from version 3.5.4 is that the internal virtual
machine was reworked to use operands in registers rather than
pulling operands from a stack.  The virtual machine stack has
now been removed.  The removal of the VM stack will help prevent
future stack overflow bugs and will also facilitate new optimizations
in future releases.

There should be no user-visible changes to the operation of SQLite
in this release, except that the output of EXPLAIN looks different.

In order to make this change, about 8.5% of the core SQLite code
had to be reworked.  We thought this might introduce instability.
But we have done two weeks of intensive testing, during which time
we have increased the statement test coverage to 99% and during
which we have found and fixed lots of minor bugs (mostly things
like leaking memory following a malloc failure).  But for all of
that testing, we have not detected a single bug in the new
register-based VM.  And for that reason, we believe the new
VM, and hence version 3.5.5, is stable and ready for production
use.

As usual, please report any problems to this mailing list, or
directly to me.

--
D. Richard Hipp <[EMAIL PROTECTED]>


-- 
---

To unsubscribe, send email to [EMAIL PROTECTED]
-- 
---





-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Version 3.5.5 Released

[drh]

SQLite version 3.5.5 is now available for download from the
SQLite website:

   http://www.sqlite.org/

The big change from version 3.5.4 is that the internal virtual
machine was reworked to use operands in registers rather than
pulling operands from a stack.  The virtual machine stack has
now been removed.  The removal of the VM stack will help prevent
future stack overflow bugs and will also facilitate new optimizations
in future releases.

There should be no user-visible changes to the operation of SQLite
in this release, except that the output of EXPLAIN looks different.

In order to make this change, about 8.5% of the core SQLite code
had to be reworked.  We thought this might introduce instability.
But we have done two weeks of intensive testing, during which time
we have increased the statement test coverage to 99% and during
which we have found and fixed lots of minor bugs (mostly things
like leaking memory following a malloc failure).  But for all of
that testing, we have not detected a single bug in the new 
register-based VM.  And for that reason, we believe the new
VM, and hence version 3.5.5, is stable and ready for production
use.

As usual, please report any problems to this mailing list, or
directly to me.

--
D. Richard Hipp <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-