[sqlite] Possible bug

Hello all, I'm new to this mailing list and I guess I found a bug in SQLite. I'm not sure how to use this mailing list since this is the first time I'm using one. so I will just append the plain sql file to this email with an backtrace generated with gdb. Running the sqlite3 CLI interface with th

[sqlite] Possible bug

Is this a bug or something I'm missing with the logical handling of '' versus "" version 2.8.16 on Linux schema create table nicks (id integer primary key , nick TEXT, last integer(5)); Contents sqlite> select * from nicks; 4|Her|99 5|Her|99 6|Her|99 7|Him|99 8|You|99 Query 1 (correct beha

[sqlite] Possible bug

I tried to download sqlite3-3.1.1beta.bin.gz to see if this problem still exists, but my browser and wget both report that the file is empty. The following is from version 3.1.0. It is perhaps an unusual use of a correlated subquery. If it's a bug that someone wants to address, let me know and I'l

[sqlite] possible Bug

On 2015-04-09 07:57 PM, Simon Slavin wrote: > On 9 Apr 2015, at 6:04pm, Gustav Melno wrote: > >> Thanks for the help. Adding a trailing underscore helped also. I'm still >> wondering why insertion worked at all because defining oid as column name >> with the type VARCHAR should result in an er

[sqlite] possible Bug

This is the minimal SQL for a test case needed to reproduce the oid - foreign key bug: (By changing only 1 character renaming oid to xid in the first line, the SQL works as intended). CREATE TABLE tParent(id INTEGER PRIMARY KEY, c1 TEXT, oid INTEGER); CREATE TABLE tChild( id INTEGER PRIMARY KE

[sqlite] possible Bug

000 End: .abort -Urspr?ngliche Nachricht- Von: R.Smith [mailto:rsmith at rsweb.co.za] Gesendet: Donnerstag, 09. April 2015 20:52 An: sqlite-users at mailinglists.sqlite.org Betreff: Re: [sqlite] possible Bug On 2015-04-09 07:57 PM, Simon Slavin wrote: > On 9 Apr 20

[sqlite] Possible Bug

I am running into an issue with SQLite that I think might be a bug. When I run the PRAGMA table_info

[sqlite] Possible Bug

On 31 May 2015, at 2:22am, Alan Bryan wrote: > SELECT *, Sum(MyField) AS MySumField FROM MyTable > > Now run sqlite3 and type the following: > > PRAGMA table_info(MyView); > > You will notice there is no data type for some reason. I think you get datatypes only for exact copies of a source

[sqlite] Possible Bug

> To: sqlite-users at mailinglists.sqlite.org > Subject: [sqlite] Possible Bug > > I am running into an issue with SQLite that I think might be a bug. When I > run the PRAGMA table_info > <http://t.signauxcinq.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XZsRz > DgTW5vwkZs8pTgPFVRbxS056dNRV

[sqlite] Possible bug

Hello, I searched the bug tracker and the only thing I saw that looked relevant was ticket UUID 6c266900a22574d4d6474503da5bfe849c8b244f. http://www.sqlite.org/src/tktview?name=6c266900a2 However, that seems to deal with special Unicode characters and I'm not dealing with that here. I'm using

[sqlite] Possible bug

On 11/11/15, Adams, Justin wrote: > > I was trying to create a table with a column for IPv4 addresses as VARCHAR. > It seems when I set the .mode to column that some records are truncated on > the right. Changing the .mode fixes the problem, so I would think it has to > do with the column width ca

[sqlite] Possible bug

On 11 Nov 2015, at 10:38pm, Adams, Justin wrote: > VARCHAR(20) Not a solution to the problem or a diagnosis of the bug, it's worth saying that SQLite has no VARCHAR type. Columns where you specify VARCHAR will be understood as TEXT, and truncation will never occur. Simon.

[sqlite] Possible bug?

SQLite version 3.9.2 2015-11-02 18:31:45 sqlite> .header on sqlite> select 0x1zzz; zzz 1 sqlite>

[sqlite] Possible bug?

On 11/13/15, Quan Yong Zhai wrote: > SQLite version 3.9.2 2015-11-02 18:31:45 > sqlite> .header on > sqlite> select 0x1zzz; > zzz > 1 > sqlite> This is parsed as: SELECT 0x1 AS zzz; PostgreSQL the same thing (modulo the fact that postgres 7.3 does not support hexadecimal integer literals).

[sqlite] Possible bug

Hello, I am a member of this list, but I am not sure which email address you have. I have tried the ones that I usually use, but my messages are getting held due to not recognizing my address. I am having a problem doing a Linq Insert using SQLite in Visual Studio 2015 (Community version) in

[sqlite] Possible bug

On 10 Mar 2016, at 4:43am, Marv Anderson wrote: > SQL Logic error or missing database near "SELECT": syntax error > >SELECT CONVERT(Int,SCOPE_IDENTITY()) AS [value] This involves two things which are not built into SQLite: CONVERT() SCOPE_IDENTITY() Assuming that they're provided by your

Re: [sqlite] Possible bug

On Apr 8, 2009, at 6:21 AM, Arthur Skowronek wrote: > > Running the sqlite3 CLI interface with the parameters > -init twdata.sql twdata.db crashes the SQLite library > with a segfault. SQLite should never segfault, so this is a bug. But without seeing the twdata.sql and twdata.db files, there

Re: [sqlite] Possible bug

on Wed, 8 Apr 2009 06:58:21 -0400 "D. Richard Hipp" wrote: > > On Apr 8, 2009, at 6:21 AM, Arthur Skowronek wrote: > > > > Running the sqlite3 CLI interface with the parameters > > -init twdata.sql twdata.db crashes the SQLite library > > with a segfault. > > SQLite should never segfault, so th

Re: [sqlite] Possible bug

Hi, My attachments have been cutted out again... I have uploaded them now to my web space. They can be found at http://redsmile.org/twdata.tar cheers... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] Possible bug

Hi, Arthur, This mailing list, like many, will automatically strip attachments. Posting onto your own webspace is a great way, as you have discovered, to reference files. I'm writing just to say that I *did* reproduce a problem. I'm using Windows XP SP3. I narrowed the problem to the sql b

Re: [sqlite] Possible bug

Hello. The EzTools office is closed for 1 week holidays. Will be open again around 17 April. If you have purchase a product, we will process your order then. Sorry for any inconvenience. EzTools Support ___ sqlite-users mailing list sqlite-users@s

Re: [sqlite] Possible bug

Griggs, Donald wrote: > This mailing list, like many, will automatically strip attachments. Posting > onto your own webspace is a great way, as you have discovered, to reference files. Thank you for your advice :). > > I'm writing just to say that I *did* reproduce a problem. > > I'm using Windo

Re: [sqlite] Possible bug

On Apr 9, 2009, at 3:18 PM, Arthur Skowronek wrote: > Griggs, Donald wrote: >> This mailing list, like many, will automatically strip attachments. >> Posting onto your own webspace is a great way, as you have >> discovered, > to reference files. > Thank you for your advice :). > >> >> I'm wri

Re: [sqlite] Possible bug

Tenkawa a écrit : Query 1 (correct behavior) sqlite> select id,nick,last from nicks where nick = 'Nick'; sqlite> Query 2 (incorrect?) sqlite> select id,nick,last from nicks where nick = "Nick"; 4|Her|99 5|Her|99 6|Her|99 7|Him|99 8|You|99 When dealing with STRING values, use only single quo

Re: [sqlite] Possible bug

Thanks. Thats what I thought but wanted to be sure. On Fri, 11 Nov 2005, Guillaume MAISON wrote: Tenkawa a écrit : Query 1 (correct behavior) sqlite> select id,nick,last from nicks where nick = 'Nick'; sqlite> Query 2 (incorrect?) sqlite> select id,nick,last from nicks where nick = "Nick

Re: [sqlite] Possible bug

> I tried to download sqlite3-3.1.1beta.bin.gz to see if > this problem still exists, but my browser and wget both > report that the file is empty. I get that too. Not sure why, the file is there on the server. > The following is from version 3.1.0. It is perhaps an > unusual use of a correlated

[sqlite] Possible bug in 3.6.23?

I've had problems with update queries using sqlite 3.6.23 on Windows XP + Visual Studio 2005 and am wondering if it is a bug. sqlite seems to go off into the weeds when calling sqlite3_exec(). I've also had the same behavior when using sqlite3_prepare_v2() + sqlite3_step() + sqlite3_finalize()

[sqlite] Possible Bug SQLITE 3.7.0

Dear sqlite developers, I have noticed that the .dump command quotes the table name on INSERT commands, but does not quote them on CREATE TABLE commands. Import operations using the generated SQL into Postgresql fails unless one manually edits the SQL to quote mixed case or upper case table names

[sqlite] Possible bug in sqlite3_prepare

Hi, For the last month I've been troubled by an apparent bug in SQLite 3.3.5 which has been very hard to track down. After extensive debugging and bug-tracking it seems there must be a bug/feature somewhere in SQLite - propably in sqlite3_prepare because this is where the symptom of the bug appea

[sqlite] possible bug in lockBtree

I think there might be a bug in this code in lockBtree: if( sqlite3pager_pagecount(pBt->pPager)>0 ){ u8 *page1 = pPage1->aData; if( memcmp(page1, zMagicHeader, 16)!=0 ){ goto page1_init_failed; The problem is if you are trying to open a non-sqlite file that is smaller than pa

[sqlite] possible bug 3.8.1 /3.8.3

Good day, I'm debugging some code that uses 3.8.1, and I've tried just upgrading to 3.8.3, which didn't work. The observation is that This query: SELECT id, data_blob FROM data WHERE timestamp = (SELECT MIN(timestamp) FROM data WHERE stream_num = ?) LIMIT 1 seems to occasionally produce a wrong

Re: [sqlite] Possible bug in 3.6.23?

What does CMyAppClass::somefunction() do? Is it your own VFS implementation? Pavel On Fri, Apr 2, 2010 at 1:06 PM, Kevin M. wrote: > I've had problems with update queries using sqlite 3.6.23 on Windows XP + > Visual Studio 2005 and am wondering if it is a bug.  sqlite seems to go off > into t

Re: [sqlite] Possible bug in 3.6.23?

7;s no MySQL in there, that was just a quick random name choice to change the name from that of the real code. -- Kevin From: Pavel Ivanov To: General Discussion of SQLite Database Sent: Fri, April 2, 2010 1:57:49 PM Subject: Re: [sqlite] Possible b

Re: [sqlite] Possible bug in 3.6.23?

name from that of the real code. > > -- Kevin > > > > > > From: Pavel Ivanov > To: General Discussion of SQLite Database > Sent: Fri, April 2, 2010 1:57:49 PM > Subject: Re: [sqlite] Possible bug in 3.6.23? > > What does

[sqlite] Possible bug in SQLite 3.3.4

Hello, I'm maintaining bindings to SQLite3 for the CHICKEN Scheme compiler / interpreter and I got a bug report from a user about the following problem: Creating a table with the CREATE TABLE IF NOT EXISTS table_name(...); syntax or dropping a table with the DROP TABLE IF EXISTS tabl

Re: [sqlite] Possible bug in sqlite3_prepare

On 5/26/06, Michael B. Hansen <[EMAIL PROTECTED]> wrote: This all works very well for some time - then suddenly after 250 - 1 calls to my function sqlite3_prepare returns "Object reference not set to an instance of an object" - which is a .NET exception I interpretate as a Null-pointer-excep

RE: [sqlite] Possible bug in sqlite3_prepare

> - Original Message - > From: "Michael B. Hansen" <[EMAIL PROTECTED]> > To: > Sent: Friday, May 26, 2006 8:23 AM > Subject: [sqlite] Possible bug in sqlite3_prepare > > > Hi, > > For the last month I've been troubled by an apparent b

RE: [sqlite] Possible bug in sqlite3_prepare

chael Hansen From: Joel Lucsy [mailto:[EMAIL PROTECTED] Sent: Fri 2006-05-26 17:37 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Possible bug in sqlite3_prepare On 5/26/06, Michael B. Hansen <[EMAIL PROTECTED]> wrote: > > This all works very w

RE: [sqlite] Possible bug in sqlite3_prepare

on [mailto:[EMAIL PROTECTED] Sent: Fri 2006-05-26 17:42 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Possible bug in sqlite3_prepare > - Original Message - > From: "Michael B. Hansen" <[EMAIL PROTECTED]> > To: > Sent: Friday, May 26, 2006 8:23 AM > Subject:

RE: [sqlite] Possible bug in sqlite3_prepare

: Fri 2006-05-26 19:07 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Possible bug in sqlite3_prepare Hi Joel, I too have suspected Finisar.SQLite wrapper - and yes I have updated the SQLite library to a newer version than the one Finisar.SQLite ships with. However, I have dug pretty dee

Re: [sqlite] Possible bug in sqlite3_prepare

Michael B. Hansen wrote: Of course I suspected some error in my program - but there aren't any. There aren't *ANY*. I highly doubt that. :-) All programs of any significant size contain errors. I have run SQLite in both runtime and debug - and know that the sqlite3_prepare has an

RE: [sqlite] Possible bug in sqlite3_prepare

fire if their conditions was met in DEBUG-mode. /Michael From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Fri 2006-05-26 20:19 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Possible bug in sqlite3_prepare Michael B. Hansen wrote: > > Of cour

RE: [sqlite] Possible bug in sqlite3_prepare

/Michael From: Michael B. Hansen [mailto:[EMAIL PROTECTED] Sent: Fri 2006-05-26 19:08 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Possible bug in sqlite3_prepare Hi Robert, My project doesn't work well with .NET 2.0 - so that's not an option (believe

RE: [sqlite] Possible bug in sqlite3_prepare

e.org Subject: RE: [sqlite] Possible bug in sqlite3_prepare For whom it may concern. I have done some quick testing - and it seems Mono.Data.SQLite is fully compatibale with MS.Net framework 1.1 - great job you guys at Mono :) On monday I'll convert my project to use Mono's wrapper

[sqlite] Possible bug in Alter Table

Hi, I am writing to report a possible bug in the Alter Table command. It seems to fail on a somewhat complex schema with multiple tables and views, and views that reference other views. I was not able to come up with a simple one table, one view schema where this error actually shows up. Th

[sqlite] Possible bug with locking/retying

In searching for something else I came across this: I don't like the fact that it's undated. For all I know this is about a three year old bug which has long since been patched. I understand the description, but not what SQLite does internal

[sqlite] Possible bug with locking/retying

If you look here: http://beets.radbox.org/blog/, you can see the blog entry is dated August 24th, 2012. Peter On 5/2/2015 5:18 PM, Simon Slavin wrote: > In searching for something else I came across this: > > > > I don't like the fact that it'

[sqlite] Possible bug with locking/retying

On Sun, 3 May 2015 01:18:11 +0100 Simon Slavin wrote: > In searching for something else I came across this: > > > > I don't like the fact that it's undated. For all I know this is > about a three year old bug which has long since been patche

[sqlite] Possible bug with locking/retying

> I think it's a misuse of Sqlite and not a real bug. He adds code to ensure > only one thread access the database in a multithread application. For the > description, I infer he uses -DSQLITE_THREADSAFE=2 (multithread), where a > -DSQLITE_THREADSAFE=1 (serialized) solve the problem better because

[sqlite] Possible bug with locking/retying

cussion of SQLite Database Betreff: [sqlite] Possible bug with locking/retying In searching for something else I came across this: <http://beets.radbox.org/blog/sqlite-nightmare.html> I don't like the fact that it's undated. For all I know this is about a three year old bug

[sqlite] Possible bug - journal_mode DELETE/TRUNCATE

I am fairly new to sqlite and as a result of not reading the manual and not doing some performance testing, I got punished somewhat. I did not anticipate that on journal_mode=DELETE and synchronous=FULL, I would get no more than 5 inserts (in auto-commit mode) per second. It crippled a certain ba

Re: [sqlite] possible bug 3.8.1 /3.8.3

On 02/04/2014 12:25 AM, Adam Devita wrote: Good day, I'm debugging some code that uses 3.8.1, and I've tried just upgrading to 3.8.3, which didn't work. The observation is that This query: SELECT id, data_blob FROM data WHERE timestamp = (SELECT MIN(timestamp) FROM data WHERE stream_num = ?) L

Re: [sqlite] possible bug 3.8.1 /3.8.3

On 2/3/2014 12:25 PM, Adam Devita wrote: This query: SELECT id, data_blob FROM data WHERE timestamp = (SELECT MIN(timestamp) FROM data WHERE stream_num = ?) LIMIT 1 seems to occasionally produce a wrong result (the content of data_blob is incorrect given the values of stream_num) yet this query

Re: [sqlite] possible bug 3.8.1 /3.8.3

Can you provide data? Without some sample data, we cannot tell if the answer SQLite is providing is right or wrong. On Mon, Feb 3, 2014 at 12:25 PM, Adam Devita wrote: > Good day, > > I'm debugging some code that uses 3.8.1, and I've tried just upgrading to > 3.8.3, which didn't work. The obs

Re: [sqlite] possible bug 3.8.1 /3.8.3

Good day all, Thank you for your replies. Yes, I can provide the data if required, although I don't think it is needed, as the bug is in the user's code. The point about what happens if several timestamps have the same value is valid, and in this case, I think is the explanation. sqlite> SELE

[sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Hello, >From what I can tell, this is the place to ask about a bug in the ADO.Net >driver for SQLite. If it's not, my apologies. I've run into an issue while using System.Data.Sqlite.Core v 1.0.93.0 to execute select queries like the following: SELECT "Country"."Id", "Country"."Code", "Countr

Re: [sqlite] Possible bug in SQLite 3.3.4

Thomas Chust wrote: Hello, I'm maintaining bindings to SQLite3 for the CHICKEN Scheme compiler / interpreter and I got a bug report from a user about the following problem: Creating a table with the CREATE TABLE IF NOT EXISTS table_name(...); syntax or dropping a table with the DRO

Re: [sqlite] Possible bug in SQLite 3.3.4

On Fri, 17 Feb 2006, DennisCote wrote: Thomas Chust wrote: [...] I'm maintaining bindings to SQLite3 for the CHICKEN Scheme compiler / interpreter and I got a bug report from a user about the following problem: Creating a table with the CREATE TABLE IF NOT EXISTS table_name(...); synt

[sqlite] Possible bug with union and join.

Hi everyone. When I was working with sqlite3 I've found weird behavior of JOIN clause when I was trying to merge table with union of tables. Let me explain this using database with reproduced problem. Database dump: CREATE TABLE map_integer (id INTEGER PRIMARY KEY, name TEXT); INSERT INTO "map_in

[sqlite] Possible bug with union and join.

Hi everyone. When I was working with sqlite3 I've found weird behavior of JOIN clause when I was trying to merge table with union of tables. Let me explain this using database with reproduced problem. Database dump: CREATE TABLE map_integer (id INTEGER PRIMARY KEY, name TEXT); INSERT INTO "map_in

[sqlite] Possible bug in window function queries.

Been playing around with the new window functions in 3.25, and ran into something that looks like an infinite loop. Working with the t1 table many of the examples in the documentation use, I've come up with a minimal test case: sqlite> select id, b, lead(c, 1) over (order by c) as x from t1 where

Re: [sqlite] Possible bug in Alter Table

On Mon, Nov 26, 2018 at 2:52 AM Balaji Ramanathan < balaji.ramanat...@gmail.com> wrote: > SQLite> Alter Table Trip rename column StartGMTOffset to StartUTCOffset; > Error: error in view CumulativeStatisticsByPlaceName after rename: no such > column: StartGMTOffset > > I was able to reproduce this

Re: [sqlite] Possible bug in Alter Table

On 11/25/18, Balaji Ramanathan wrote: > I expected the Alter Table command to find and replace all occurrences of > that column name in my schema with the new name. Here is simplified SQL that illustrates the problem: CREATE TABLE t1(x); CREATE VIEW v1 AS SELECT x FROM t1; CREATE VIEW v2 AS SELE

Re: [sqlite] Possible bug in Alter Table

> On Nov 26, 2018, at 20:11, Richard Hipp wrote: > > though there probably is not time to get warnings in to the forthcoming > 3.26.0 release. Talking of which, the CLI doesn’t seem to handle the following statement very gracefully: sqlite> select DATE '1998-12-25’; ...> ...> …> Note

Re: [sqlite] Possible bug in Alter Table

On 11/26/18, Petite Abeille wrote: > the CLI doesn’t seem to handle the following statement > very gracefully: > > sqlite> select DATE '1998-12-25’; > ...> > ...> > …> Unable to repro: SQLite version 3.25.3 2018-11-05 20:37:38 Enter ".help" for usage hints. Connected to a transient in-memo

Re: [sqlite] Possible bug in Alter Table

> On Nov 26, 2018, at 20:25, Richard Hipp wrote: > > Unable to repro: Hmmm… ok… then… local problem of some type… $ uname -a Darwin 18.2.0 Darwin Kernel Version 18.2.0: Fri Oct 5 19:41:49 PDT 2018; root:xnu-4903.221.2~2/RELEASE_X86_64 x86_64 $ brew info sqlite3 sqlite: stable 3.25.3 (bottl

Re: [sqlite] Possible bug in Alter Table

It's waiting on a plain single quote to end the string. You have a Unicode smart quote character U+2019 (’) instead of a ' at the end before the semicolon, which doesn't count. On Mon, Nov 26, 2018, 11:19 AM Petite Abeille > > > On Nov 26, 2018, at 20:11, Richard Hipp wrote: > > > > though there

Re: [sqlite] Possible bug in Alter Table

> On Nov 26, 2018, at 21:16, Shawn Wagner wrote: > > It's waiting on a plain single quote to end the string. You have a Unicode > smart quote character U+2019 (’) instead of a ' at the end before the > semicolon, which doesn't count. D’oh. Facepalm. Right you are. Long live Unicode! :) __

Re: [sqlite] Possible bug in Alter Table

On Monday, 26 November, 2018 12:19, Petite Abeille wrote: ... > Talking of which, the CLI doesn’t seem to handle the following > statement very gracefully: > > sqlite> select DATE '1998-12-25’; > ...> > ...> > …> >Note how the CLI doesn’t recognize the semicolon marking the end-of- >sta

Re: [sqlite] Possible bug in Alter Table

> > > You have something mucking about and "helping you" to be cutie-pie. If > you turn that crap off, your problems will go away... > If it's on a mac, this terrible misfeature can be turned off in system preferences - keyboard - text - smart quotes. I lost a couple hours this way too, I paired

Re: [sqlite] Possible bug in Alter Table

> On Nov 27, 2018, at 06:16, Wout Mertens wrote: > > If it's on a mac, this terrible misfeature can be turned off in system > preferences - keyboard - text - smart quotes. Oh my... right you are :| Grrr indeed. ___ sqlite-users mailing list sqlite-

Re: [sqlite] Possible bug in Alter Table

n, 26 Nov 2018 14:11:54 -0500 Subject: Re: [sqlite] Possible bug in Alter Table On 11/25/18, Balaji Ramanathan wrote: > I expected the Alter Table command to find and replace all occurrences of > that column name in my schema with the new name. Here is simplified SQL that illustrates the probl

[sqlite] Possible bug in shell .open command?

I took that the .open command could be issued as ".open" to open a new in-memory database and ".open ''" (followed by a pair of single quotes) to open a new unnamed temporary file database. I wonder what is going on here: After issuing a short combination of these commands with/without putting any

[sqlite] Possible bug in shell .open command?

The aftermath... dir *. /x /b h8 08 @_8 0o8 hN Q N xa8 b8 0f8 10 soubor?, 14,336 bajt?

[sqlite] Possible bug in shell .open command?

Should be fixed now on trunk. On 6/17/15, Jean Chevalier wrote: > I took that the .open command could be issued as ".open" to open a new > in-memory database and ".open ''" (followed by a pair of single quotes) > to open a new unnamed temporary file database. > > I wonder what is going on here: A

[sqlite] Possible bug in the SQL parser

I'm using SQLite 3.8.10.2 and the following query illustrates the problem: WITH tA(id, name) AS ( SELECT 1, "a" UNION ALL SELECT 2, "b" ), tB(name) AS ( SELECT "a" UNION ALL SELECT "b" ) SELECT tB.id FROM tA INNER JOIN tB ON (tA.name = tB.name); There is no _id_ column in the tB table, y

[sqlite] Possible bug in the SQL parser

On 02/27/2016 12:49 AM, Jo?o Ramos wrote: > I'm using SQLite 3.8.10.2 and the following query illustrates the problem: > > WITH > tA(id, name) AS > ( > SELECT 1, "a" UNION ALL SELECT 2, "b" > ), > tB(name) AS > ( > SELECT "a" UNION ALL SELECT "b" > ) > SELECT tB.id FROM tA INNER JOIN tB O

[sqlite] Possible bug in the SQL parser

Maybe this has been fixed then? This is what I'm getting: select sqlite_version(); -- 3.8.10 select sqlite_source_id(); -- 2015-05-04 19:13:25 850c11866686a7b39d7b163fb60898c11283688e WITH tA(id, name) AS ( SELECT 1, "a" UNION ALL SELECT 2, "b" ), tB(name) AS ( SELECT "a" UNION ALL SELEC

[sqlite] Possible bug in the SQL parser

On 2/29/16, Jo?o Ramos wrote: > Maybe this has been fixed then? This is what I'm getting: > > select sqlite_version(); -- 3.8.10 > > select sqlite_source_id(); -- 2015-05-04 19:13:25 > 850c11866686a7b39d7b163fb60898c11283688e Compiling with that exact same version of the source code, it works fin

[sqlite] Possible bug in the SQL parser

On 2016/02/29 12:49 PM, Jo?o Ramos wrote: > Maybe this has been fixed then? This is what I'm getting: > > select sqlite_version(); -- 3.8.10 > > select sqlite_source_id(); -- 2015-05-04 19:13:25 > 850c11866686a7b39d7b163fb60898c11283688e > > > WITH > > tA(id, name) AS > > ( > > SELECT 1, "a" UNIO

[sqlite] Possible bug in the SQL parser

Sorry for the late reply. That output (--1 etc.) was me manually "formatting" the results. I came across this issue using SQLiteStudio v3.0.7 on Windows. I just create a new DB and run that script: it outputs two rows, with one column each, with the values 1 and 2 respectively, instead of an error.

Re: [sqlite] Possible bug - journal_mode DELETE/TRUNCATE

Note: attachments are stripped out of this list. So if you want for anybody else to see your zip file you need to put it on some website and post link here. About the problem you have: I wonder how are you sure that there should be 50 rows in the database and not 49? If you are resetting the OS be

Re: [sqlite] Possible bug - journal_mode DELETE/TRUNCATE

My apologies about the attachment; should have known better. This should be better: https://dl.dropbox.com/u/50838941/SQLite3_Test.zip I only get the problem with DELETE and TRUNCATE journal_mode (synchronous set to NORMAL or FULL), but not with PERSIST (synchronous set to NORMAL or FULL) or WAL (

Re: [sqlite] Possible bug - journal_mode DELETE/TRUNCATE

On 9 Sep 2012, at 9:15pm, Daniel Frimerman wrote: > The reason I think there has to be 50 rows is because on FULL mode for > example, the I/O buffers are flushed, and it's consistently missing 1 > record as opposed to any other number of records. I insert 50 records, the > sqlite3 command line u

Re: [sqlite] Possible bug - journal_mode DELETE/TRUNCATE

Actually, I am not using sqlite at the API level. That's why prepared a bunch of batch files that reproduce the issue with sqlite command line shell. To answer your question, the queries complete in sqlite3 command line, and they also complete successfully using the API, albeit, through a wrapper

Re: [sqlite] Possible bug - journal_mode DELETE/TRUNCATE

On 09/10/2012 03:15 AM, Daniel Frimerman wrote: My apologies about the attachment; should have known better. This should be better: https://dl.dropbox.com/u/50838941/SQLite3_Test.zip I only get the problem with DELETE and TRUNCATE journal_mode (synchronous set to NORMAL or FULL), but not with PE

Re: [sqlite] Possible bug - journal_mode DELETE/TRUNCATE

Yes! The journal file was indeed there. I deleted it before openning the database, and read 50 records. I repeated the process; it's consistent. The way I see it that even though the synchronous setting is FULL, there is no API to tell the OS to physically delete a file from disk, just like there

[sqlite] Possible bug in FTS3 "NOT" operator

With ICU extension does not work "NOT ..." construction. Below the example from FTS3 documentation: sqlite> CREATE VIRTUAL TABLE docs USING fts3(); sqlite> INSERT INTO docs(docid, content) VALUES(1, 'a database is a software system'); sqlite> INSERT INTO docs(docid, content) VALUES(2, 'sqlite is a

[sqlite] Possible bug in FTS3 or Parametrization?

Hi all I have discovered what may be a bug in either SQLLite or System.Data.SQLite (v 1.0.66.0 using SQLite 3.6.23.1). I certainly don't understand what's happening and I'd apprecite it if someone could help me out; perhaps I'm missing something. To recreate the issue create a database with the f

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

On 27 Aug 2014, at 8:30pm, Zachary Yates wrote: > When I use SQLiteCommand.ExecuteReader(), the IDataReader.GetName(i) method > returns only the table name, in my case "Country". You do not provide your own names for the columns returned. Therefore SQLite is free to use whatever column names

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

of the SQLite driver seems to be the only one having this issue. Thanks, -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Wednesday, August 27, 2014 4:39 PM To: General Discussion of SQLite Database Subject: R

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

On 28 Aug 2014, at 12:47am, Zachary Yates wrote: > That's not actually the issue. When I run the query using the SQLite console > or via another driver, (for example using 0xDBE + Xerial), the column names > are returned exactly as they are specified in the query. > > The problem is that all

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

> Yes, you're free to consider this a peculiarity of the ADO driver. It might be easily fixable. But it's not a bug. I respectfully disagree with that. GetName() is supposed to return a _Column_ Name, not a _Table_ Name. Even more, it is supposed to return a Value to identify a Column, so in

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Simon Slavin wrote: > you're free to consider this a peculiarity of the ADO driver. It's a peculiarity of SQLite itself (introduced in 5526e0aa3c). > It might be easily fixable. But it's not a bug. The comment "Dequote column names generated by the query flattener" shows that combined table/col

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Zachary Yates wrote: > > There's a lot more detail to this question posted at: > http://stackoverflow.com/questions/25534898/trouble-with-sqlexpressiont-join -and-column-names > I'm unable to replicate this issue using System.Data.SQLite. Here is what I've tried so far: set db [sql open -type

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Joe Mistachkin wrote: > I'm unable to replicate this issue Your query did not involve the query flattener. Try this: select "t".x from (select x from (select 1 x)) t; Regards, Clemens ___ sqlite-users mailing list sqlite-users@sqlite.org http://sql

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Clemens Ladisch wrote: > > Your query did not involve the query flattener. Try this: > I used the query as originally reported. However, as others have stated, without AS clauses, the column names are not well-defined. In this case, the IDataRecord.GetName method of the SQLiteDataReader class

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Thursday, August 28, 2014 10:07 AM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net) Clemens Ladisch wrote: > > Your query did not involve the

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Zachary Yates wrote: > > create view ProgrammingMapView as > select > p.Id ProductId > , pt.Id ProtocolId > , m.Id Mid > from Mid m > join MidProduct mprod on (mprod.RegisteredMid = m.Id) > join Product p on (p.Id = mprod.ProductId) > joi

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

e Database' Subject: Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net) Zachary Yates wrote: > > create view ProgrammingMapView as > select > p.Id ProductId > , pt.Id ProtocolId > , m.Id Mid > from Mid m > join MidProdu

  1   2   3   >