Re: [sqlite] sqlite-users Digest, Vol 147, Issue 13

Thank you, thank you! Balaji Ramanathan -- Forwarded message -- From: Richard Hipp To: General Discussion of SQLite Database < sqlite-users@mailinglists.sqlite.org> Cc: Bcc: Date: Thu, 12 Mar 2020 16:17:59 -0400 Subject: [sqlite] New SQLite Forum established - this mailing list

Re: [sqlite] SQLite forum posts are about the forum, not SQLite

That should be. Also as stated in a previous email, I want to interact with the forum via email also. I mean, I have been using web forums for a long time and I find the UX _really,_ really lacking. GitHub allows me to comment on issues by email, which is more convenient for me. On Fri, Mar 13,

[sqlite] SQLite forum posts are about the forum, not SQLite

I hope that's only a temporary situation... --DD ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite 3.31.1 crashes in SVN on OpenBSD/sparc64

On Wed, Mar 11, 2020 at 08:20:01AM -0400, Richard Hipp wrote: > On 3/11/20, Stefan Sperling wrote: > > > > Does this help? > > > > Studying the trace output makes me think this is the same problem that > came up on the s390 hardware and was fixed here: >

Re: [sqlite] sqlite 3.31.1 crashes in SVN on OpenBSD/sparc64

On 3/11/20, Stefan Sperling wrote: > > Does this help? > Studying the trace output makes me think this is the same problem that came up on the s390 hardware and was fixed here: https://www.sqlite.org/src/info/04885763c4cd00cb Stefan: Can you verify that the patch above fixes the problem? If

Re: [sqlite] sqlite 3.31.1 crashes in SVN on OpenBSD/sparc64

On 3/11/20, Stefan Sperling wrote: > > Does this help? > It does help some. But I need a good copy of the database schema, which I don't have. Please bring up the database file in the "sqlite3" command-line shell, then enter the command ".fullschema". Save off the results and send them to me,

Re: [sqlite] sqlite 3.31.1 crashes in SVN on OpenBSD/sparc64

On Tue, Mar 10, 2020 at 06:42:18PM +0100, Stefan Sperling wrote: > On Tue, Mar 10, 2020 at 01:21:34PM -0400, Richard Hipp wrote: > > Set a breakpoint on the sqlite3VdbeExec() function that fires when the > > statement that is crashing is first executed. (You can determine that > > it is the

Re: [sqlite] Sqlite error code 14 when using 3.31.0+

Den 2020-03-10 kl. 12:31, skrev Daniel Polski: Den 2020-03-10 kl. 02:33, skrev Rowan Worth: On Mon, 9 Mar 2020 at 23:22, Daniel Polski wrote: Updated to 3.31.1 but my application started spitting out an error when opening the database, so I tested some earlier sqlite versions to figure

Re: [sqlite] sqlite 3.31.1 crashes in SVN on OpenBSD/sparc64

Stefan Sperling wrote: > > Does valgrind give any clues? > > Valgrind does not run on the OpenBSD/sparc64 platform, unfortunately. Would the address sanitizer (i.e. gcc -fsanitize=address, or clang -fsanitize=address) work on OpenBSD/sparc64? Regards Dominique

Re: [sqlite] sqlite 3.31.1 crashes in SVN on OpenBSD/sparc64

On Tue, Mar 10, 2020 at 01:21:34PM -0400, Richard Hipp wrote: > On 3/10/20, Stefan Sperling wrote: > > The query being executed is "STMT_INSERT_NODE": > > -- STMT_INSERT_NODE > > INSERT OR REPLACE INTO nodes ( > > wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, > >

Re: [sqlite] sqlite 3.31.1 crashes in SVN on OpenBSD/sparc64

On 3/10/20, Stefan Sperling wrote: > The query being executed is "STMT_INSERT_NODE": > -- STMT_INSERT_NODE > INSERT OR REPLACE INTO nodes ( > wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, > revision, presence, depth, kind, changed_revision, changed_date, >

[sqlite] sqlite 3.31.1 crashes in SVN on OpenBSD/sparc64

Hi, We have seen sqlite segfault on OpenBSD/sparc64 in the context of running Subversion's regression test suite: https://ci.apache.org/builders/svn-bb-openbsd/builds/498 The log files show that a simple 'svn update' triggers the problem:

Re: [sqlite] Sqlite error code 14 when using 3.31.0+

Den 2020-03-10 kl. 02:33, skrev Rowan Worth: On Mon, 9 Mar 2020 at 23:22, Daniel Polski wrote: Updated to 3.31.1 but my application started spitting out an error when opening the database, so I tested some earlier sqlite versions to figure out when the problem starts. I don't get the message

Re: [sqlite] Sqlite error code 14 when using 3.31.0+

Tuesday, March 10, 2020, 1:33:13 AM, Rowan Worth wrote: > On Mon, 9 Mar 2020 at 23:22, Daniel Polski wrote: >> Updated to 3.31.1 but my application started spitting out an error when >> opening the database, so I tested some earlier sqlite versions to figure >> out when the problem starts. >>

Re: [sqlite] Sqlite error code 14 when using 3.31.0+

On Mon, 9 Mar 2020 at 23:22, Daniel Polski wrote: > Updated to 3.31.1 but my application started spitting out an error when > opening the database, so I tested some earlier sqlite versions to figure > out when the problem starts. > I don't get the message in versions <= 3.30.1. > > (from the

[sqlite] Sqlite error code 14 when using 3.31.0+

Updated to 3.31.1 but my application started spitting out an error when opening the database, so I tested some earlier sqlite versions to figure out when the problem starts. I don't get the message in versions <= 3.30.1. (from the applications log) SQLite Version: 3.31.0 INFO: Database opened:

[sqlite] sqlite CLI .dbinfo not working

Hi, I have downloaded the amalgamation source code and are trying to build the CLI but I can´t get the .dbinfo to work. SQLite version 3.31.1 2020-01-27 19:55:54 Enter ".help" for usage hints. sqlite> .dbinfo the ".dbinfo" command requires the -DSQLITE_ENABLE_DBPAGE_VTAB compile-time options

Re: [sqlite] sqlite-users Digest, Vol 146, Issue 27

On Thu, Feb 27, 2020 at 6:00 AM < sqlite-users-requ...@mailinglists.sqlite.org> wrote: > 18. Cannot export 'sqlite3' file to CSV (Rachael Courts) > From: Rachael Courts > To: "sqlite-users@mailinglists.sqlite.org" < > sqlite-users@mailinglists.sqlite.org> > Cc: > Bcc: > Date: Thu, 27 Feb 2020

Re: [sqlite] sqlite-3.31.0 segfaults on fuzzcheck on s390x architectures

On Dienstag, 28. Januar 2020 18:26:05 CET Brüns, Stefan wrote: > > On armv7l, there is another failure in the fuzztests, with and without the > patch: > sessionfuzz-data1.db: sessionfuzz: ./sqlite3.c:57249: pager_open_journal: > Assertion `rc!=SQLITE_OK || isOpen(pPager->jfd)' failed. I had

Re: [sqlite] sqlite-3.31.0 segfaults on fuzzcheck on s390x architectures

On Mittwoch, 29. Januar 2020 13:40:44 CET Richard Hipp wrote: > Please retry using this check-in: > https://www.sqlite.org/src/info/b20503aaf5b6595a The failings test now pass on all architectures: - ix86/x86_64 - armv7hl, aarch64 - ppc32be, ppc64be, ppc64le - s390x Kind regards, Stefan > On

Re: [sqlite] sqlite-3.31.0 segfaults on fuzzcheck on s390x architectures

Please retry using this check-in: https://www.sqlite.org/src/info/b20503aaf5b6595a On 1/28/20, Brüns, Stefan wrote: > On Dienstag, 28. Januar 2020 18:26:05 CET Brüns, Stefan wrote: >> On Dienstag, 28. Januar 2020 16:16:01 CET Richard Hipp wrote: >> > On 1/27/20, Ondrej Dubaj wrote: >> > > Hi,

Re: [sqlite] sqlite-3.31.0 segfaults on fuzzcheck on s390x architectures

On Dienstag, 28. Januar 2020 18:26:05 CET Brüns, Stefan wrote: > On Dienstag, 28. Januar 2020 16:16:01 CET Richard Hipp wrote: > > On 1/27/20, Ondrej Dubaj wrote: > > > Hi, > > > > > > I came across a problem during mate test, where fuzzcheck ends with > > > segfault. > > > The problem appears

Re: [sqlite] sqlite-3.31.0 segfaults on fuzzcheck on s390x architectures

On Dienstag, 28. Januar 2020 16:16:01 CET Richard Hipp wrote: > On 1/27/20, Ondrej Dubaj wrote: > > Hi, > > > > I came across a problem during mate test, where fuzzcheck ends with > > segfault. > > The problem appears to be only on [s390x]. Other architectures are > > working fine. > > Fixed by

Re: [sqlite] sqlite-3.31.0 segfaults on fuzzcheck on s390x architectures

On 1/27/20, Ondrej Dubaj wrote: > Hi, > > I came across a problem during mate test, where fuzzcheck ends with > segfault. > The problem appears to be only on [s390x]. Other architectures are > working fine. Fixed by check-in https://www.sqlite.org/src/info/04885763c4cd00cb Thanks for the

Re: [sqlite] sqlite-3.31.0 segfaults on fuzzcheck on s390x architectures

On 1/27/20, Ondrej Dubaj wrote: > The problem appears to be only on this arches. That probably means it is an EBCDIC problem. We have no way of replicating or debugging this problem as we have no access to an s390 machine. Can RedHat perhaps provide one of the SQLite developers with a

[sqlite] sqlite-3.31.0 segfaults on fuzzcheck on s390x architectures

Hi, I came across a problem during mate test, where fuzzcheck ends with segfault. The problem appears to be only on this arches. Other architectures are working fine. Build here: https://koji.fedoraproject.org/koji/taskinfo?taskID=40950404 Log: ./fuzzcheck

[sqlite] SQLite: A couple minor doc bugs

To whom it may concern, A couple minor SQLite documentation bugs: https://sqlite.org/testing.html Section 7.1, in paragraph beginning "Branch coverage is more strict": Paragraph ends saying "three test cases", but only two are listed (first appears garbled).

Re: [sqlite] Sqlite 3.31.0 breaks firefox and thunderbird

Thank you for the suggestion, Warren. Bisect first pointed to commit df51ae19c1aa4c26, but sometime after that this segfault seemed to be fixed, a second bisect blamed commit 2ae77bd233570834: https://www.sqlite.org/src/info/2ae77bd233570834 I've attached a backtrace from a crash at this

Re: [sqlite] Sqlite 3.31.0 breaks firefox and thunderbird

On Jan 23, 2020, at 8:33 AM, Bernhard Rosenkraenzer wrote: > > The Debian guys have also observed this: > https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=949644 > (and also don't have a fix yet). > > Any ideas? Can you bisect SQLite to narrow the range here? This release had an unusually

Re: [sqlite] Sqlite 3.31.0 breaks firefox and thunderbird

On 1/23/20, Bernhard Rosenkraenzer wrote: > Hi, > after updating sqlite to 3.31.0, both firefox and thunderbird crash on > startup (rebuilding them against the newer sqlite doesn't help). Is this related to https://bugzilla.mozilla.org/show_bug.cgi?id=1607902 > Backtrace: > (gdb) bt > #0

[sqlite] Sqlite 3.31.0 breaks firefox and thunderbird

Hi, after updating sqlite to 3.31.0, both firefox and thunderbird crash on startup (rebuilding them against the newer sqlite doesn't help). Backtrace: (gdb) bt #0 0x71b9fe20 in ?? () from /usr/lib64/firefox-71.0/libxul.so #1 0x71b993d2 in ?? () from

Re: [sqlite] SQLite 3.31.0 enters pre-release testing

Richard Hipp, on Friday, January 17, 2020 07:56 AM, wrote... > A terse summary of changes can be seen at > https://www.sqlite.org/draft/releaselog/current.html No gain in speed? :-) I love it when I see, "2% faster..." Thanks. josé ___ sqlite-users

[sqlite] SQLite 3.31.0 enters pre-release testing

Our intent is that there will be no more changes to SQLite, other than documentation updates and bug fixes, prior to the 3.31.0 release. Consider the "Prerelease Snapshot" at https://sqlite.org/download.html to be a beta-release. Please test that snapshot and report any problems. A terse summary

Re: [sqlite] SQLite command-line result is different from Perl DBI::Sqlite result (Keith Medcalf)

On 5 Jan 2020, at 5:01pm, Amer Neely wrote: > But the question still remains, why the different results? The optimizer gets improved from time to time in SQLite versions. SQLite solved the problem faster by breaking down your query differently: deciding whether to do one scan or use two

Re: [sqlite] SQLite command-line result is different from Perl DBI::Sqlite result (Keith Medcalf)

> On Saturday, 4 January, 2020 18:31, Amer Neely > wrote: > >> I'm fairly new to SQLite, but have been using MySQL / mariadb in a local >> and web-based environment for several years. So far I'm happy and >> impressed with SQLite, but I recently noticed some odd behaviour with >> one of my

Re: [sqlite] SQLite command-line result is different from Perl DBI::Sqlite result (Igor Korot)

-- > What is your version of Perl and the SQLite module? This is perl 5, version 18, subversion 2 (v5.18.2) built for darwin-thread-multi-2level (with 2 registered patches, see perl -V for more detail) Copyright 1987-2013, Larry Wall SQLite version 3.30.1 2019-10-10 20:19:45 Enter ".help" for

Re: [sqlite] SQLite command-line result is different from Perl DBI::Sqlite result

-- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. On Saturday, 4 January, 2020 18:31, Amer Neely wrote: >I'm fairly new to SQLite, but have been using MySQL / mariadb in a local >and web-based environment for several

Re: [sqlite] SQLite command-line result is different from Perl DBI::Sqlite result

Hi, On Sat, Jan 4, 2020 at 7:31 PM Amer Neely wrote: > > Hello all, > I'm fairly new to SQLite, but have been using MySQL / mariadb in a local > and web-based environment for several years. So far I'm happy and > impressed with SQLite, but I recently noticed some odd behaviour with > one of my

[sqlite] SQLite command-line result is different from Perl DBI::Sqlite result

Hello all, I'm fairly new to SQLite, but have been using MySQL / mariadb in a local and web-based environment for several years. So far I'm happy and impressed with SQLite, but I recently noticed some odd behaviour with one of my queries. Using the command-line in a shell (Mac High Sierra) I get a

Re: [sqlite] Sqlite database gets corrupted

On 20 Dec 2019, at 12:11pm, Syed Ahmad wrote: > Any way to recover it. This mailing list strips attachments. When's the last time you could use this file ? Did it have any form of encryption ? Was it usable with your own software ? Could you open it with the SQLite command-line tool ?

[sqlite] Sqlite database gets corrupted

Hi, Operating system: Embedded Linux. Version : 3.14.2 2016-09-12 sqlite3 bad.sqlite "PRAGMA integrity_check" Error: file is encrypted or is not a database I have attached the file. Any way to recover it. Is any there at fixes in latest sqlite version 3.x. which will fix this issue.

[sqlite] SQLite overload help

I have created a custom function (aux), I'm able to load it via load_extension() on shell. Now I'm trying to overload a function for a Virtual Table (fts3 or fts5) These what I know: need to hit sqlite3_overload_function which uses the xFindFunction() that goes back to `fts3FindFunctionMethod` I

Re: [sqlite] sqlite sync over network

> On Dec 9, 2019, at 7:43 AM, George wrote: > > (litesync - SQLite Replication and Synchronization) > litesync seems to be a version of sqlite made by Ramos Bernardo from Brazil. Interesting, but I don't see how they can make those kinds of claims without running into conflicts on primary

Re: [sqlite] sqlite sync over network

thank you Jens,I have just found litesync (litesync - SQLite Replication and Synchronization) litesync seems to be a version of sqlite made by Ramos Bernardo from Brazil. | | | | litesync - SQLite Replication and Synchronization litesync makes easy to replicate and synchronize SQLite

Re: [sqlite] sqlite sync over network

> On Dec 5, 2019, at 8:05 AM, George wrote: > > Changes -> bidirectional. All terminals can save to db. Amount of collected > data it's not big and frequency between readings will be minimum 2sec. When > we push more readings. Data itself it's very small. Like reading temperature > from a

Re: [sqlite] sqlite sync over network

On 5 Dec 2019, at 4:48pm, George wrote: > We have an app already done in Qt on all terminals. Sqlite it's already used > by this app. When a terminal makes up a SQL INSERT command to add new data to the database, have it also save this command to a file. That's the file you send to the

Re: [sqlite] sqlite sync over network

On Thu, 2019-12-05 at 12:54 +, George wrote: > [EXTERNAL SOURCE] > > > > Hi, > I need to sync sqlite tables over network between few devices. > Please help me with an opinion with what will be the best approach ? > thanks, > George > ___ >

Re: [sqlite] sqlite sync over network

We have an app already done in Qt on all terminals. Sqlite it's already used by this app. The only missing part it's our sync to have data on PC for reports and also on screen reports on terminals if operator will need to check.We need sqlite because help us to manage data on terminal and

Re: [sqlite] sqlite sync over network

Okay. Do you really need all of the terminals to have up-to-date data from all the terminals ? If not, it's a simple problem: each terminal sends data to the master, which puts all the incoming data into the same database. Terminals don't need a SQL dataase at all. They simply report

Re: [sqlite] sqlite sync over network

Hi Simon, I miss to talk about sync trigger. Will be great to be after post trigger. I mean we read a probe on terminal T1, save data and on post trigger also put a job for sync and leave it on other thread to do this. If some sync jobs fail will must to try again to sync or on timeout  stay in

Re: [sqlite] sqlite sync over network

Hi Simon, Thx for helping me. I'm trying to explain our setup next: Changes -> bidirectional. All terminals can save to db. Amount of collected data it's not big and frequency between readings will be minimum 2sec. When we push more readings. Data itself it's very small. Like reading

Re: [sqlite] sqlite sync over network

On 5 Dec 2019, at 12:54pm, George wrote: > I need to sync sqlite tables over network between few devices. > Please help me with an opinion with what will be the best approach ? Unfortunately this is a subject which has no simple solution. The things you have to do are not simple. To help us

[sqlite] sqlite sync over network

Hi, I need to sync sqlite tables over network between few devices. Please help me with an opinion with what will be the best approach ? thanks, George ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] sqlite syntax auto suggest

Dear Richard & others, Now it is clear but how do I let the user make for example an UPDATE query without the OR. I have UPDATE on position 0, then I want OR, OF, tableName. This works but SET is only available on position 4-5. I want this also on position 2. What I want to do is get a

Re: [sqlite] sqlite syntax auto suggest

Hello Dominique ! Here are two views that can bring that info to a query: == CREATE VIEW rule_list_view AS SELECT     a.ruleid,     b.name,     a.lhs FROM rule AS a LEFT JOIN symbol AS b ON a.lhs = b.id; CREATE VIEW rulerhs_list_view AS SELECT     a.ruleid,     b.name as symbol_name,    

Re: [sqlite] sqlite syntax auto suggest

On Fri, Nov 29, 2019 at 2:10 PM Richard Hipp wrote: > On 11/29/19, Laurent wrote: > > > > Could you perhaps explain what pos means and what the [isTerminal] = > 0 rows mean. > > New check-in enhances the output to include a comment in the SQL > before the encoding of each production rule. This

Re: [sqlite] sqlite syntax auto suggest

On 11/29/19, Laurent wrote: > > Could you perhaps explain what pos means and what the [isTerminal] = 0 > rows mean. > New check-in enhances the output to include a comment in the SQL before the encoding of each production rule. This should help make it clear what the SQL is trying to represent.

Re: [sqlite] sqlite syntax auto suggest

Dear Richard, This has been very helpful, I have the parse.sql file. I feel very flattered that you took the time to answer my question. My boss says you are the one that should win a nobel prize. This has been much appreciated!! I completely understand if you won't answer anymore but I

Re: [sqlite] sqlite syntax auto suggest

Hello Richard ! Sorry by split my reply in so many small ones ! When trying to use the generate "parse.sql" I'm getting this: sqlite3 parse.db < parse.sql Error: near line 10: FOREIGN KEY constraint failed Error: near line 11: FOREIGN KEY constraint failed Error: near line 12: FOREIGN

Re: [sqlite] sqlite syntax auto suggest

Hello Richard ! Again after rereading your reply and trying to use the "parse.sql" I noticed that it doesn't have a "begin;../commit;" wrapper as it's recommended to not having "fsync" calls on each insert. Cheers ! On 28/11/19 23:54, Richard Hipp wrote: On 11/28/19, Laurent Dhont wrote:

Re: [sqlite] sqlite syntax auto suggest

Hello Richard ! My bad after writing the last reply I found that "EXPLAIN" and "explain" are different symbols there. Could a small comment be generated at the begin of the generated "parse.sql" ? Something like: (dummy example) --- -- This is a generated output from lemon parse

Re: [sqlite] sqlite syntax auto suggest

Hello Richard ! I just looked at it and I have some doubts about the generated parse.sql, as I see it there is this table: CREATE TABLE symbol(   id INTEGER PRIMARY KEY,   name TEXT NOT NULL,   isTerminal BOOLEAN NOT NULL,   fallback INTEGER REFERENCES symbol ); --and this entries

Re: [sqlite] sqlite syntax auto suggest

On 11/28/19, Laurent Dhont wrote: > is there an API to > get this information in a format that is not an image? By coincidence, I checked in a change two days ago that might be helpful. See https://www.sqlite.org/src/timeline?c=4dbd398d640852d4 for the specific check-in. If you now build

[sqlite] sqlite syntax auto suggest

Hi all, I am trying to create a fully automated auto suggestion feature for my web application for sqlite. Currently this is going well, but I realized there are to many features in sqlite to hardcode this, so it will be near impossible and take a lot off time. The diagrams on the site of

Re: [sqlite] SQLite Message Passing Interface

On 26 Nov 2019, at 10:54pm, Enzo Madda wrote: > Id appreciate constructive feedback or questions, thanks! Your project is a feeder library to a SQL engine. So you might want to add to your documentation something about how your users can avoid SQL injection vulnerabilities. Or how your

[sqlite] SQLite Message Passing Interface

Hello, Ive been working on something called the SQLite Message Passing Interface, or SMPI for short. It allows you to use SQLite from Javascript code in React Native apps. There is an introduction at https://sqlitempi.com/. Id appreciate constructive feedback or questions, thanks! Enzo

[sqlite] SQLite 2019-11-25 04:15:33 says 0 errors out of 250197 tests

I felt it was time to change the subject line to something more useful. Also everything works flawlessly here on Red Hat Enterprise Linux 7.4 : . . . SQLite 2019-11-25 04:15:33 b0b655625cf491c832a259d29a67660b8d5943c201617900a83d0660b2673377 0 errors out of 250197 tests on boe13.genunix.com

Re: [sqlite] sqlite-src-3300100 on RHEL 7.4 toss mad errors about 'asm'

On 8/11/62 00:15, Dennis Clarke wrote: On 2019-11-07 11:44, Shawn Wagner wrote: ... Just don't use strict c99 mode when compiling with gcc? Drop the -std argument from your CFLAGS to use the default (gnu11 since gcc 5) or explicitly use gnu99, which gives you that version of the C standard +

Re: [sqlite] SQLite with branching

On 4 Nov 2019, at 22:25, Jens Alfke wrote: >> On Nov 4, 2019, at 4:57 AM, Simon Slavin wrote: >> >> That's one of the reasons that the source code for SQLite is public: so that >> people can add the features they want. > > Totally agree. However, when you go off the mainline of SQLite you lose

Re: [sqlite] SQLite with branching

I included WAL mode and mmap on the LiteTree simple benchmark. It turns out that WAL mode is as fast as LiteTree on Linux (with a hard disk) for writes and a little slower on reads. On MacBook Pro (with SSD) LiteTree is faster on both writing and reading. SQLite's mmap make it slightly

Re: [sqlite] SQLite with branching

> On Nov 7, 2019, at 9:02 AM, Bernardo Ramos wrote: > > If you are interested in just the performance without the branching feature, > there are at least 3 options: > > 1. SQLigthning: I was thinking in updating it to the last version of SQLite That would be awesome! I have looked at it a

Re: [sqlite] sqlite-src-3300100 on RHEL 7.4 toss mad errors about 'asm'

Another option (Which the devs might consider) is to replace use of the asm keyword with __asm__, which is a form of the extension understood even in strict mode. (I have no idea why gcc doesn't offer intrinsics for bit rotation, as it's a common task and shouldn't require hacks like this to

Re: [sqlite] sqlite-src-3300100 on RHEL 7.4 toss mad errors about 'asm'

On 2019-11-07 11:44, Shawn Wagner wrote: ... Just don't use strict c99 mode when compiling with gcc? Drop the -std argument from your CFLAGS to use the default (gnu11 since gcc 5) or explicitly use gnu99, which gives you that version of the C standard + gcc extensions. (Not that they have

Re: [sqlite] SQLite with branching

Hi! I am the creator of LiteTree (also LiteReplica, LiteSync and 3 new products that will be released soon). When I was planning to add branching I discovered many ways to implement it. I selected the one that satisfied performance over disk usage. It can also be implemented the other way

Re: [sqlite] sqlite-src-3300100 on RHEL 7.4 toss mad errors about 'asm'

... Just don't use strict c99 mode when compiling with gcc? Drop the -std argument from your CFLAGS to use the default (gnu11 since gcc 5) or explicitly use gnu99, which gives you that version of the C standard + gcc extensions. (Not that they have anything to do with the problem, but compiling

Re: [sqlite] sqlite-src-3300100 on RHEL 7.4 toss mad errors about 'asm'

On 2019-11-07 11:15, Shawn Wagner wrote: Does that toolchain use gcc, or a different compiler? If gcc, are you using the same CFLAGS as on the redhat box (you're turning on a bunch of extra non-default options there)? I don't see how --with-threads can be a concern. The other options do not

Re: [sqlite] sqlite-src-3300100 on RHEL 7.4 toss mad errors about 'asm'

For that matter, is the Solaris box x86 or sparc? If the latter, this particular code path obviously wouldn't ever be used on it. On Thu, Nov 7, 2019, 8:10 AM Dennis Clarke wrote: > On 2019-11-07 11:01, Shawn Wagner wrote: > > Compiling with -std=iso9899:1999 is the culprit. Strict c99 mode

Re: [sqlite] sqlite-src-3300100 on RHEL 7.4 toss mad errors about 'asm'

Does that toolchain use gcc, or a different compiler? If gcc, are you using the same CFLAGS as on the redhat box (you're turning on a bunch of extra non-default options there)? On Thu, Nov 7, 2019, 8:10 AM Dennis Clarke wrote: > On 2019-11-07 11:01, Shawn Wagner wrote: > > Compiling with

Re: [sqlite] sqlite-src-3300100 on RHEL 7.4 toss mad errors about 'asm'

On 2019-11-07 11:01, Shawn Wagner wrote: Compiling with -std=iso9899:1999 is the culprit. Strict c99 mode disables gcc extensions like inline asm. OKay but I have no issues doing a compile on a Solaris server using the Oracle Studio 12.6 tools and strict C99. So how is C99 the issue? Dennis

Re: [sqlite] sqlite-src-3300100 on RHEL 7.4 toss mad errors about 'asm'

Compiling with -std=iso9899:1999 is the culprit. Strict c99 mode disables gcc extensions like inline asm. On Thu, Nov 7, 2019, 7:57 AM Dennis Clarke wrote: > > While building sqlite from the zip file sqlite-src-3300100.zip I saw > what seems to be a normal configure and then madness : > > >

[sqlite] sqlite-src-3300100 on RHEL 7.4 toss mad errors about 'asm'

While building sqlite from the zip file sqlite-src-3300100.zip I saw what seems to be a normal configure and then madness : boe13$ pwd /opt/bw/build/sqlite-src-3300100_rhel_74_3.10.0-693.el7.x86_64.001 boe13$ ./configure --prefix=/opt/bw --enable-shared --enable-static --enable-readline

Re: [sqlite] SQLite with branching

> On Nov 5, 2019, at 1:27 AM, Dominique Devienne wrote: > > AFAIK, that was one of the goals of SQLite4 [1], to change the backend to LSM. LMDB (LiteTree's back-end) doesn't use LSM; it's a B-tree manager. The speedup appears to come from a combination of techniques like eliminating caching

Re: [sqlite] SQLite with branching

On Tue, Nov 5, 2019 at 10:01 AM Wout Mertens wrote: > On Mon, Nov 4, 2019 at 10:26 PM Jens Alfke wrote: > > > I don't have a practical use for the branching features, though they're > cool, but I'm salivating at the thought of a 2x speedup. > > With all the work that's put into eking out small

Re: [sqlite] SQLite with branching

On Mon, Nov 4, 2019 at 10:26 PM Jens Alfke wrote: > I don't have a practical use for the branching features, though they're cool, > but I'm salivating at the thought of a 2x speedup. > With all the work that's put into eking out small performance increases in > SQLite, I'd imagine the devs

Re: [sqlite] SQLite with branching

> On Nov 4, 2019, at 4:57 AM, Simon Slavin wrote: > > That's one of the reasons that the source code for SQLite is public: so that > people can add the features they want. Totally agree. However, when you go off the mainline of SQLite you lose some things, like easy updating to new SQLite

Re: [sqlite] SQLite with branching

The post you quoted points to exactly that: a version of SQLite that handles branches. Check it out. That's one of the reasons that the source code for SQLite is public: so that people can add the features they want. ___ sqlite-users mailing list

Re: [sqlite] SQLite with branching

@SQLite Guys: Do you have something like branching on your roadmap? I really like this feature and see a lot of use-cases beside the blockchain topic. And, of course if this works with your encryption extension that would be awesome. * simple versioning of a database: Useful when you want to

Re: [sqlite] [sqlite-dev] Error 25: column index out of range when binding for a DATETIME

On Thu, Oct 31, 2019 at 9:52 AM Keith Medcalf wrote: > On Thursday, 31 October, 2019 07:17, Jeffrey Walton > wrote: > ... > >/* negative for days in the past */ > >int days = 120; > >days = -days; > > >const char DELETE_STMT[] = "DELETE from blacklist " \ > >"WHERE dtime

Re: [sqlite] [sqlite-dev] Error 25: column index out of range when binding for a DATETIME

On Thursday, 31 October, 2019 07:17, Jeffrey Walton wrote: First, your question should go to the sqlite-users mailing list, not the developers mailing list. >I'm having trouble binding a parameter for a DELETE. I am trying to >delete records older than 120 days. Below, I have a table with a

Re: [sqlite] sqlite - AIX memory fault coredupm when using .output command [WARNING! - EXTERNAL]

On Oct 29, 2019, at 2:56 PM, Dawson, Jeff G wrote: > > SQLite version 3.7.14.1 2012-10-04 19:37:12 I infer that you’re migrating a legacy system. There are two good alternatives to your current method that should avoid the symptom entirely: 1. Build a current version of SQLite for the old

[sqlite] sqlite - AIX memory fault coredupm when using .output command [WARNING! - EXTERNAL]

Hello, We are running sqlite version below on AX 7.2 TL 1. We have a database around 430MB and was trying to export the contents to a file shown below, done this with other databases but it seems there is some type of limitation possibly with the version of sqlite we are running? We did open

Re: [sqlite] sqlite segfault bug report

On 28 Oct 2019, at 11:07am, Richard Hipp wrote: > Bisect: Just to explain to the Korean students: you spotted a real bug, but very recently the bug was fixed. However, your work is useful. Please download the current version of SQLite from and continue

Re: [sqlite] sqlite segfault bug report

On 10/28/19, Graham Holden wrote: > Monday, October 28, 2019, 5:46:55 AM, ??? wrote: > >> Code: > >> BEGIN; >> CREATE TABLE t1(a); >> ALTER TABLE t1 ADD c CHECK (b>c); >> PRAGMA writable_schema=on; >> INSERT INTO t1 VALUES(2,3); > >> Version: 3.29.0, 3.22.0 > > On "SQLite version 3.30.1

Re: [sqlite] sqlite segfault bug report

Monday, October 28, 2019, 5:46:55 AM, ??? wrote: > Code: > BEGIN; > CREATE TABLE t1(a); > ALTER TABLE t1 ADD c CHECK (b>c); > PRAGMA writable_schema=on; > INSERT INTO t1 VALUES(2,3); > Version: 3.29.0, 3.22.0 On "SQLite version 3.30.1 2019-10-10 20:19:45" this returns an error after the

[sqlite] sqlite segfault bug report

Code: BEGIN; CREATE TABLE t1(a); ALTER TABLE t1 ADD c CHECK (b>c); PRAGMA writable_schema=on; INSERT INTO t1 VALUES(2,3); Version: 3.29.0, 3.22.0 Hello, we are students from Korea. We learned about fuzzing and tried to fuzz on sqlite3, and we found a piece of code which makes crash.

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

Roman Fleysher, on Thursday, October 10, 2019 04:31 PM, wrote... > Imagine a vehicle which has wheels to drive on a road. And wings to fly and > a hull to float. How nice and happy world would be !? True? Of course true. > > But, this vehicle would be bad as a car, bad as an airplane and bad a

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

ull a Red Hat atop SQLite. _______ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

It's ok that you don't believe in it, but the last statement, you know is not true. I have been in this list since 2003 or so, and constantly there is one or two request to Dr. Hipp and the owners, per month, to add "stuff" to it. Or, things like, "I would love to have SQLite do...", etc.

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

Roman Fleysher, on Thursday, October 10, 2019 04:17 PM, wrote... > > With your brain excluded, who is "we"? > > The beauty of SQLite is that SQL was distilled to the smallest and most > reproducible > on many platforms set. Over time, I see how developers expand functionality > to make it >

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

> It has LEFT JOIN and does not have RIGHT JOIN. Why? Because RIGHT can be made > out of LEFT by swapping order of tables. The paradigma of SQL is to let the user describe what he wants to do, not to think about how to describe the problem so that the database system does understand. The lack

  1   2   3   4   5   6   7   8   9   10   >