Re: [sqlite] sqlite3 feature or regression

ver...@comfirm.hu>] Sent: Mar 10, 2017 7:37 AM To: [SQLite mailing list <sqlite-users@mailinglists.sqlite.org>] Subject: [Re: [sqlite] sqlite3 feature or regression] Thanks. Naturally I had experimented with several versions of the program, and saw that any ordering makes the new feature/error disapp

Re: [sqlite] sqlite3 feature or regression

: Donnerstag, 09. März 2017 15:43 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] sqlite3 feature or regression Thanks. Naturally I had experimented with several versions of the program, and saw that any ordering makes the new feature/error disappear. Y

Re: [sqlite] sqlite3 feature or regression

Thanks. Naturally I had experimented with several versions of the program, and saw that any ordering makes the new feature/error disappear. You can see it if you read the comment at the bottom of my original script. But my purpose was the opposite: demonstrate the regression. I am not

Re: [sqlite] sqlite3 feature or regression

> With 3.11.0, the scan is probably using the index instead of the table In this case the phenomena would be a new "feature". Unfortunately this would contradict to the axiom, that the result of a query must be independent of the existence of the indices. -- Vermes Mátyás

Re: [sqlite] sqlite3 feature or regression

tclsh, aside from the inconvenience of prefixing every sql statement with "db eval {", looks like a great way to gain the equivalent functionality of scalar output stored procedures compared to the plain vanilla sqlite shell. Is there anything in the works for the tcl bindings to define/export

Re: [sqlite] sqlite3 feature or regression

On 03/09/2017 10:46 PM, James K. Lowden wrote: On Tue, 7 Mar 2017 19:04:47 +0100 Vermes Mátyás wrote: It is also unnecessarily complex and slow. The script demonstrates a regression (a bug). It is written in Ruby so that everybody can run it, and see its _results_. It is

Re: [sqlite] sqlite3 feature or regression

On Tue, 7 Mar 2017 19:04:47 +0100 Vermes Mátyás wrote: > > It is also unnecessarily complex and slow. > > The script demonstrates a regression (a bug). It is written in Ruby > so that everybody can run it, and see its _results_. It is absolutely > not interesting that it is

Re: [sqlite] sqlite3 feature or regression

On 3/8/17, Vermes Mátyás wrote: > I rewrote the program for you to C. Thank you for the translation. Below is the equivalent program in 34 lines of TCL. (Compare to 101 lines of Ruby and 430 lines of C++. Everybody: If you are unfamiliar with the TCL programming language,

Re: [sqlite] sqlite3 feature or regression

On 03/09/2017 06:28 AM, Vermes Mátyás wrote: Why are you wanting me to work so hard at this? Under no circumstances work hard, I rewrote the program for you to C. The results are attached also, so you do not have to compile it, if you do not want. You can download it from

Re: [sqlite] sqlite3 feature or regression

> Why are you wanting me to work so hard at this? Under no circumstances work hard, I rewrote the program for you to C. The results are attached also, so you do not have to compile it, if you do not want. You can download it from http://comfirm.hu/pub/sqlite3-regression.tar.gz. -- Vermes

Re: [sqlite] sqlite3 feature or regression

> > The script ... is written in Ruby so that > > everybody can run it, and see its _results_. > > The point is that I cannot run your Ruby script on my Ubuntu desktop > because I get an error: Perhaps you have not installed Ruby. sudo apt-get install ruby ruby-sqlite3 Then

Re: [sqlite] sqlite3 feature or regression

Well, as I wrote, I am not a Ruby programmer. I found this phenomena first in a CCC test program. CCC is a translator, which translate a Clipper-like language to C. So there is a state of a CCC program, which can be considered as pure C. There is no Ruby in it at all. Ruby version was only

Re: [sqlite] sqlite3 feature or regression

On 8 Mar 2017, at 2:16pm, don v nielsen wrote: > Vermes, I'm late to the party but would still like to comment. The problem is > the ruby code, not sqlite. The following is what you coded in the Ruby: > >db.execute("select szamla,megnevezes from proba") do |row| >

Re: [sqlite] sqlite3 feature or regression

Vermes, I'm late to the party but would still like to comment. The problem is the ruby code, not sqlite. The following is what you coded in the Ruby: db.execute("select szamla,megnevezes from proba") do |row| In some shape or fashion, the result set is getting mangled by the update. When

Re: [sqlite] sqlite3 feature or regression

On 3/7/17, Vermes Mátyás wrote: >> It is also unnecessarily complex and slow. > > The script ... is written in Ruby so that > everybody can run it, and see its _results_. The point is that I cannot run your Ruby script on my Ubuntu desktop because I get an error:

Re: [sqlite] sqlite3 feature or regression

On 2017/03/07 5:00 PM, Vermes Mátyás wrote: On Mon, 6 Mar 2017 18:34:40 -0500 Richard Hipp wrote: I am not a Ruby programmer either nor a real SQLite user. I am interested in writing SQL interfaces to href="http://github.com/mrev11/ccc3;>CCC to various databases. Ruby was

Re: [sqlite] sqlite3 feature or regression

> It is also unnecessarily complex and slow. The script demonstrates a regression (a bug). It is written in Ruby so that everybody can run it, and see its _results_. It is absolutely not interesting that it is slow or complex. -- Vermes Mátyás

Re: [sqlite] sqlite3 feature or regression

On Mon, 6 Mar 2017 18:34:40 -0500 Richard Hipp wrote: > For the benefit of those of us who do not do Ruby, perhaps you could > explain in words what you think it is that SQLite is doing > incorrectly? I am not a Ruby programmer either nor a real SQLite user. I am interested in

Re: [sqlite] sqlite3 feature or regression

On Tue, 7 Mar 2017 09:36:34 +0100 Clemens Ladisch wrote: > I do not know what you expect to happen, or what actually happens, but > changing a table and reading it through a query at the same time has > an unspecified result. It is also unnecessarily complex and slow.

Re: [sqlite] sqlite3 feature or regression

On Tue, Mar 7, 2017 at 9:36 AM, Clemens Ladisch wrote: > Vermes Mátyás wrote: > > http://comfirm.hu/pub/sqlite3-regression.rb > > > db.execute("select szamla,megnevezes from proba") do |row| > > ... > > db.execute( "update proba set megnevezes=? where

Re: [sqlite] sqlite3 feature or regression

Vermes Mátyás wrote: > http://comfirm.hu/pub/sqlite3-regression.rb > db.execute("select szamla,megnevezes from proba") do |row| > ... > db.execute( "update proba set megnevezes=? where szamla=?", > row[1]+"*", row[0] ) The equivalent Python code would be: for row in

Re: [sqlite] sqlite3 feature or regression

For the benefit of those of us who do not do Ruby, perhaps you could explain in words what you think it is that SQLite is doing incorrectly? On 3/6/17, Vermes Mátyás wrote: > Hi, > I resend my earlier mail, now with an URL instead of attachement: > >

[sqlite] sqlite3 feature or regression

Hi, I resend my earlier mail, now with an URL instead of attachement: http://comfirm.hu/pub/sqlite3-regression.rb The linked ruby script demonstrates a feature of the newer sqlite3 libraries, which may be a regression. -- Vermes Mátyás

Re: [sqlite] sqlite3 feature or regression

On 3 Mar 2017, at 1:12pm, Vermes Mátyás wrote: > The attached ruby script demonstrates a feature of the newer sqlite3 > libraries, which may be a regression. Just a note that you cannot attach files to posts to this list. If your file is text, just paste it into a

[sqlite] sqlite3 feature or regression

Hi! The attached ruby script demonstrates a feature of the newer sqlite3 libraries, which may be a regression. -- Vermes Mátyás ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org