Thanks everyone who chimed in about the non-breaking space issue!
> Sent: Wednesday, July 15, 2015 at 3:53 PM
> From: "Jason H"
> To: sqlite-users at mailinglists.sqlite.org
> Cc: "General Discussion of SQLite Database" mailinglists.sqlite.org>
> Subject: Re: [sqlite] Error: no such column: Whe
Thanks everyone!
> Sent: Wednesday, July 15, 2015 at 4:33 PM
> From: "Jason H"
> To: sqlite-users at mailinglists.sqlite.org
> Cc: sqlite-users at mailinglists.sqlite.org
> Subject: Re: [sqlite] Error: no such column: When column exists!
>
> So after further review, there is a 0xa0 (non-breaking
So after further review, there is a 0xa0 (non-breaking space - )
character - a non-breaking space before the semi-colon. Thus making the column
name analogous to ptn.TreatmentNoteID_;
I guess it is functioning as intended?
> Sent: Wednesday, July 15, 2015 at 3:53 PM
> From: "Jason H"
> To:
So yes, I was missing 'S's, but that is only because I've been hacking at the
tables to get something to change.
So the query you gave me works, however, when I put it all on the same line, it
is identical to my query which does not. To prove this, I updated the file on
github with a query tabl
On Wed, Jul 15, 2015 at 8:43 PM, Richard Hipp wrote:
> On 7/15/15, T?r?k Edwin wrote:
>> On 07/15/2015 08:34 PM, T?r?k Edwin wrote:
>>
>> In fact such detection could be added to fuzzcheck.c too (I didn't know that
>> you can detect presence of address sanitizer at compile time until now):
>
> It
On 15 Jul 2015, at 8:53pm, Jason H wrote:
> sqlite> select * from PatientTreatmentNotes ptn join
> PatientTreatmentNotesSteps pts ON pts.TreatmentNoteID = ptn.TreatmentNoteID ;
> Error: no such column: ptn.TreatmentNoteID
I downloaded your database file and copied straight from the above. The
Hello Jason,
Your second example ends with 0xA0 (a space with the high-bit set;
sometimes used as a non-breaking space).
Graham Holden
Wednesday, July 15, 2015, 8:53:20 PM, you wrote:
> So yes, I was missing 'S's, but that is only because I've been hacking at the
> tables to get something to c
On 07/15/2015 08:34 PM, T?r?k Edwin wrote:
> On 07/15/2015 08:17 PM, Richard Hipp wrote:
>> On 7/15/15, T?r?k Edwin wrote:
>>> This might be just the test runner and not sqlite itself, I'm not sure:
>>>
>>> Time: capi2.test 25 ms
>>>
On 07/15/2015 08:17 PM, Richard Hipp wrote:
> On 7/15/15, T?r?k Edwin wrote:
>> This might be just the test runner and not sqlite itself, I'm not sure:
>>
>> Time: capi2.test 25 ms
>> =
>> ==2330==ERROR: AddressSanitizer: heap-use-aft
When I look at your queries table in sqlite3 in a windows command prompt, the
failing SQL has a non-ASCII character instead of a semicolon.
Peter
On Wednesday, July 15, 2015 12:53 PM, Jason H wrote:
So yes, I was missing 'S's, but that is only because I've been hacking at the
tables
Since attachments are not supported,
https://github.com/jhihn/files/blob/master/no_such_column.sqlite3
I apologize for the added complexity.
> Sent: Wednesday, July 15, 2015 at 1:41 PM
> From: "Jason H"
> To: sqlite-users at mailinglists.sqlite.org
> Cc: "General Discussion of SQLite Database"
Ok, I've dropped irrelevant tables, dropped the data, vacuumed, and am
attaching the result. (Does this ML support attachments?)
I was using v3.7.17, I tried the 3.8.5 and 3.8.10 releases, and all are the
same error.
> Sent: Wednesday, July 15, 2015 at 10:28 AM
> From: "Donald Griggs"
> To:
On 07/15/2015 06:59 PM, Richard Hipp wrote:
> On 7/15/15, T?r?k Edwin wrote:
>>>
>>> 1) unknown-crash (might be due to some alignment requirements in asan):
>>
>> Build with clang 3.4 shows a heap-use-after-free instead of unknown-crash,
>> and building a normal (just ./configure) executable with
On 15 Jul 2015, at 6:40pm, Mayank Kumar (mayankum)
wrote:
> -what do you mean by journal file is created only when needed ? Is it not
> true, that for any transactions it is always created.
Yes, but many programs keep a connection to the database the whole time they're
run, but seldom do any
I noticed that when --linemacros option is used, line numbers are wrong,
often by one line, sometimes more. This is due to bug in mksqlite3c.tcl
tool, that output nothing when #include line is skipped.
Trivial patch below.
Index: sqlite3-3.8.10.2/tool/mksqlite3c.tcl
=
On 15 Jul 2015, at 6:41pm, Jason H wrote:
> (Does this ML support attachments?)
Sorry, but no it doesn't.
Simon.
On 15 Jul 2015, at 5:28pm, T?r?k Edwin wrote:
> Thanks, do I still need to turn this on if I run 'PRAGMA integrity_check'?
You don't need to turn it on at all. It's there only to get rid of a warning
from clang and a couple of other things.
Simon.
On 07/15/2015 06:19 PM, Richard Hipp wrote:
> On 7/15/15, T?r?k Edwin wrote:
>> On 07/15/2015 12:05 AM, Richard Hipp wrote:
>>
>> I've run the address and undefined behaviour sanitizer (+ usual hardening
>> and bug finding flags from Debian) from GCC 4.9.2 on Debian Jessie on this
>> fossil checko
On 07/15/2015 05:59 PM, T?r?k Edwin wrote:
> On 07/15/2015 12:05 AM, Richard Hipp wrote:
>> The plan is to release SQLite version 3.8.11 on or about the end of July.
>>
>> The current code is passing all tests that we have run against it.
>> Some soak tests are still running. There are quite a few
On 07/15/2015 12:05 AM, Richard Hipp wrote:
> The plan is to release SQLite version 3.8.11 on or about the end of July.
>
> The current code is passing all tests that we have run against it.
> Some soak tests are still running. There are quite a few
> cross-platform tests (running on PPC, Sparc,
Thanks Clemens
-what do you mean by journal file is created only when needed ? Is it not true,
that for any transactions it is always created. The documentation here
https://www.sqlite.org/tempfiles.html says in exclusive mode it is created at
the start of first transaction and not deleted unti
An idea I?ve had a while ago was to implement functions for json documents
(using sqlite3_create_function_v2)
Json would be stored in a text column. You would need to define 2 functions:
- docget(document,key1,subval1,subval2,?)
- docset(document,key1,subval1,subval2,..,val)
Last parameter of doc
I'm beginning to understand some of the implementation challenges here.
Eric, it'd be great to get that open sourced. I can tell you at least
I will jump and prototype on it.
Sergej and Roger, I do like this potential idea as well. Of course,
now it's a custom sqlite, but at least the job gets do
Whenever I try a multi-table join on a field I get a no such column error.
sqlite> select * from PatientTreatmentNote ptn join PatientTreatmentNoteStep
pts ON pts.TreatmentNoteID = ptn.TreatmentNoteID?;
Error: no such column: ptn.TreatmentNoteID
sqlite> .schema PatientTreatmentNote
CREATE TABLE Pa
On 15 Jul 2015, at 3:09pm, Jason H wrote:
> Whenever I try a multi-table join on a field I get a no such column error.
>
> sqlite> select * from PatientTreatmentNote ptn join PatientTreatmentNoteStep
> pts ON pts.TreatmentNoteID = ptn.TreatmentNoteID ;
> Error: no such column: ptn.TreatmentNot
In my little test below, both the "ON DELETE CASCADE" in table_2 and the
(later created) delete_trigger_2 are about to execute removal when a row
in table_1 is removed.
The table_3 also has the "ON DELETE CASCADE", but it doesn't yet have
any content when removing the row in table_1 so it's init
On Wed, Jul 15, 2015 at 10:03 AM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 07/15/2015 08:22 AM, Sergej Jure?ko wrote:
> > What do you guys think? Is it stupid, could it be improved?
>
> I recommend looking at Mongodb and Postgres first to see how they do
> quer
Is there a simple way to replace portions of a string using the regex
function of sqlite without actually accessing any specific DB entres.
Similar to
SELECT strftime('%s','now') as unixtimestamp
what just returns the result in unixtimestamp... just that I need to perform
regex on a normal stri
On 7/15/15, T?r?k Edwin wrote:
> On 07/15/2015 08:34 PM, T?r?k Edwin wrote:
>
> In fact such detection could be added to fuzzcheck.c too (I didn't know that
> you can detect presence of address sanitizer at compile time until now):
It's a clever idea. I'm not so sure I want to add this to fuzzch
Mayank Kumar (mayankum) wrote:
> Sometimes we see the journal file not present on the system although
> active transactions are ongoing. How is that possible since the
> documentation says the journal file is always created in exclusive
> mode ?
The journal file is created only when it is needed.
On 15 Jul 2015, at 2:07pm, Daniel Polski wrote:
> Or if there is a more elegant solution I haven't thought about?
I would suggest here that you rethink your reason for needing three tables
table_1, table_2 and table_3. It looks more like you need only one table here,
with 'id', 'starttime' a
On 7/15/15, Jason H wrote:
> Since attachments are not supported,
> https://github.com/jhihn/files/blob/master/no_such_column.sqlite3
>
The table names were both misspelled in your original query. After I
fixed that, everything seems to work. I tested with 3.7.8, 3.7.17,
3.8.0, 3.8.7, and trunk
Jason,
I downloaded your database and copied the SELECT from your original post.
sqlite> select * from PatientTreatmentNote ptn join
PatientTreatmentNoteStep pts
ON pts.TreatmentNoteID = ptn.TreatmentNoteID ;
Error: no such table: PatientTreatmentNote
(note that this was because table name missp
Devart team is proud to introduce new SQLite ODBC Drivers.
The most significant features in this version are:
- Direct Mode - allows to connect to your databases directly via TCP/IP
avoiding DB client software, thus simplifying application deployment process
and increasing performance.
- Dri
On 7/15/15, T?r?k Edwin wrote:
>
> I've attached a patch that fixes these warnings from GCC
>
No attachments on this mailing list. Can you send the patch via
direct email to me?
--
D. Richard Hipp
drh at sqlite.org
Yuriy M. Kaminskiy
>
> I noticed that when --linemacros option is used, line numbers are wrong,
> often by one line, sometimes more. This is due to bug in mksqlite3c.tcl
> tool, that output nothing when #include line is skipped.
> Trivial patch below.
>
Thanks for the report. This should now
On 7/15/15, T?r?k Edwin wrote:
> This might be just the test runner and not sqlite itself, I'm not sure:
>
> Time: capi2.test 25 ms
> =
> ==2330==ERROR: AddressSanitizer: heap-use-after-free on address
> 0x6180003b58dc at pc 0x7f5bb48
Hi Hayden,
On 14.07.2015 03:43, Hayden Livingston wrote:
> Is there a concept of a schema-less JSON SQLite DB?
>
> My reason is simple: versioning. We have lot of business metrics that
> get updated let's say once a month, and we need to be agile to get
> them. Right now, we just put the v
On 7/15/15, T?r?k Edwin wrote:
>>
>> 1) unknown-crash (might be due to some alignment requirements in asan):
>
> Build with clang 3.4 shows a heap-use-after-free instead of unknown-crash,
> and building a normal (just ./configure) executable with GCC and running
> under valgrind shows an invalid r
On 7/15/15, T?r?k Edwin wrote:
> On 07/15/2015 12:05 AM, Richard Hipp wrote:
>
> I've run the address and undefined behaviour sanitizer (+ usual hardening
> and bug finding flags from Debian) from GCC 4.9.2 on Debian Jessie on this
> fossil checkout: a73d7128fbca8dde5e90bd46ee915e39ae07dd1f 2015-0
Jason,
I think your problem description is too abbreviated to allow anyone to
easily reproduce it.
Maybe you can repost with a minimal example of the failure, but include a
full script that will show the problem, and let us know what version of the
sqlite3 commandline utility was used and what OS
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/15/2015 08:22 AM, Sergej Jure?ko wrote:
> What do you guys think? Is it stupid, could it be improved?
I recommend looking at Mongodb and Postgres first to see how they do
queries. It would be better to be compatible with them where
practical,
Given the number of the threads in the list, it seems a
> lot of people want hierarchical data in SQLite :-)
>
Throwing in another $.02 here, my company had a need to ingest JSON of
various formats into SQLite databases in low-power embedded devices. We
wrote the utility program described here:
Our application uses the following pragma with sqlite 3.7.7.1
PRAGMA synchronous=FULL;
PRAGMA locking_mode=EXCLUSIVE";
I understand from the documentation that with exclusive mode the journal file
is always created and never deleted until the exclusive mode is exited.
Now my questions are:-
-my
The record sort order is:
NULLs
Numeric by value
Text by collating function
Blob by memcmp order
So your result set will contain all rows having a FooColumn with numeric value
greater than 50, a text value or a blob value.
-Urspr?ngliche Nachricht-
Von: Hayden Livingston [mailto:halivin
On Wed, Jul 15, 2015 at 2:14 AM, Alek Paunov wrote:
> Hi Hayden,
>
> On 14.07.2015 03:43, Hayden Livingston wrote:
>
>> Is there a concept of a schema-less JSON SQLite DB?
>>
>> My reason is simple: versioning. We have lot of business metrics that
>> get updated let's say once a month, and
46 matches
Mail list logo