, 2017 7:37 AM
To: [SQLite mailing list ]
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 disappear. You can see it if
you read the comment at the bottom of my
endet: Donnerstag, 09. März 2017 15:43
An: SQLite mailing list
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. You can see it if
you read the comment a
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 intereste
> 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
__
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
epo
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 absolutely
not intere
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 slow or complex.
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, you would do well to
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 http://comfirm.h
> 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 Mát
> > 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
./sqlite3-r
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 wri
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|
>
> In some shape or fashi
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
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:
/usr/lib/ruby/2.3.0/rubygems/cor
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 chosen only becaus
> 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
__
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
writing SQL int
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.
To the OP, Vermes: if
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 szamla=?",
> row[1]+"*",
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 db.exe
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:
>
> http://comfirm.hu/pub/sqlite3-regression.rb
>
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 message. Otherwise please
23 matches
Mail list logo