Re: [sqlite] SQLite on Windows Phone 8

: This is not an official version of SQLite There is completely NO affiliation with SQLite.org Bugs should not be reported to their ticket tracking system Thank you, Noah Hart -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLite-on-Windows-Phone-8-tp65316p65382.html Sent from

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

The C#-SQLite port at http://code.google.com/p/csharp-sqlite/ supports both Silverlight and Windows Phone Hope that help, Noah Hart Tim Leland wrote: Does anyone have any tips/suggestions for getting sqlite3 to run on windows mobile 6.5? Thanks Tim Leland W. Lee

Re: [sqlite] Cannot insert/retrieve 8 byte integers without losing digits

May be in your program; From the 3.7.10 shell sqlite select id, start_time from exports; d006dacf-3134-45b6-828b-0860738e4029|1311178875028 sqlite select id, cast(start_time as integer) from exports; d006dacf-3134-45b6-828b-0860738e4029|1311178875028 sqlite What version are you running?

[sqlite] ANN: C#-SQLite 3.7.7.1

of the alltest suite without error. The project is located at http://code.google.com/p/csharp-sqlite/ Enjoy, Noah Hart -- Please keep in mind the following: * C#-SQLite is an independent reimplementation of the SQLite software library

[sqlite] ANN: C#-SQLite 3.7.6.3

of Hipp, Wyrick Company, Inc Enjoy, Noah Hart -- View this message in context: http://old.nabble.com/ANN%3A-C--SQLite-3.7.6.3-tp31922081p31922081.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users

[sqlite] Is additional Check Constraint info available?

Assume that a table has several check restraints, such as a unique index and a foreign key. When inserting a row that violates more than one of the constraints, is there any way to tell which of the constraint would have been violated? Thanks, Noah Hart -- View this message in context

[sqlite] Check restraint

Assume that a table has several check restraints, such as a unique index and a foreign key. When inserting a row that violates more than one of the constraints, is there any way to tell which of the constraint would have been violated? Thanks, Noah Hart

Re: [sqlite] Running TCL tests on 3.7.5

do_test $testname [list execsql {$sql}] [list [concat $result]] } however, there are a number of others you will find. I'd try and update TCL on Ubuntu ~Noah Hart Krokodile wrote: Hello I've got 3.7.5 sources via ZIP archive from http://www.sqlite.org/cgi/src/info/ed759d5a9e - (SQLite

[sqlite] BUG: mutex_w32.c; diagnostic message needs to be clearer

In the routine winMutexTry at line 284 -printf(enter mutex %p (%d) with nRef=%d\n, p, p-trace, p-nRef); +printf(try mutex %p (%d) with nRef=%d\n, p, p-trace, p-nRef); -- View this message in context:

[sqlite] BUG: test script e_vacuum.test needs has_codec

. # if {[catch {sqlite3 -has-codec} r] || $r} { set has_codec 1 } else { set has_codec 0 } if {!$has_codec} { do_test e_vacuum-1.3.2.1 { ... } if {!$has_codec} { do_test e_vacuum-1.3.3.2 { ... } ~Noah Hart -- View this message in context: http://old.nabble.com/BUG%3A-test-script-e_vacuum.test-needs

[sqlite] ANN: C#-SQLite 3.7.5

trademark of Hipp, Wyrick Company, Inc Enjoy, Noah Hart -- View this message in context: http://old.nabble.com/ANN%3A-C--SQLite-3.7.5-tp31041201p31041201.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list

[sqlite] BUG: e_expr.test needs ifcapable utf16

e_expr has a number of tests that need to have ifcapable utf16 bracketing For example: db eval { PRAGMA encoding = 'utf-16le' } do_qexpr_test e_expr-27.4.4 { CAST('ghi' AS blob) } X'670068006900' do_qexpr_test e_expr-27.4.5 { CAST(456 AS blob) } X'340035003600' do_qexpr_test e_expr-27.4.6 {

[sqlite] BUG: e_vacuum.test backcompat.test need ifcapable wal

test files have a couple of lines similar to: execsql { PRAGMA journal_mode = wal } These tests need to be bracketed with ifcapable wal ~ Noah Hart -- View this message in context: http://old.nabble.com/BUG%3A-e_vacuum.test---backcompat.test-need-ifcapable-wal-tp31037029p31037029.html Sent

[sqlite] BUG: types3.test

SELECT '1234567890123456.0', typeof('1234567890123456.0'); 1234567890123456.0|text I think that the test is wrong and tcl should be expecting {string} Regards, Noah Hart -- View this message in context: http://old.nabble.com/BUG%3A-types3.test-tp31016794p31016794.html Sent from the SQLite mailing

[sqlite] BUG: test scripts corrupt*.test need do_not_use_codec

). +# +do_not_use_codec ~Noah Hart -- View this message in context: http://old.nabble.com/BUG%3A-test-scripts-corrupt*.test-need-do_not_use_codec-tp30927026p30927026.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users

[sqlite] BUG: test script vacuum2.test needs do_not_use_codec

] command). +# +do_not_use_codec Also, this file contains 2 tests named vacuum2-2.1 ~Noah Hart -- View this message in context: http://old.nabble.com/BUG%3A-test-script-vacuum2.test-needs-do_not_use_codec-tp30927226p30927226.html Sent from the SQLite mailing list archive at Nabble.com

[sqlite] BUG: test script exclusive2.test needs do_not_use_codec

) +# +do_not_use_codec ~Noah Hart -- View this message in context: http://old.nabble.com/BUG%3A-test-script-exclusive2.test-needs-do_not_use_codec-tp30927245p30927245.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users

[sqlite] BUG: capi3e.test when compiled with SQLITE_OMIT_UTF16

capi3e.test needs ifcapable utf16 logic before capi3e-2.1.$i to properly pass tests when compiled with SQLITE_OMIT_UTF16 ~ Noah Hart -- View this message in context: http://old.nabble.com/BUG%3A-capi3e.test-when-compiled-with-SQLITE_OMIT_UTF16-tp30905474p30905474.html Sent from

[sqlite] BUG REPORT: 3.7.5 fails to compile with SQLITE_OMIT_WAL

Moving the routing in pager.c to after the #endif at line 3025 will solve the problem. Are you running your test suite against comditional compilation with SQLITE_OMIT_WAL? Regards, Noah Hart -- View this message in context: http://old.nabble.com/BUG-REPORT%3A-3.7.5-fails-to-compile

[sqlite] how to use group_concat uniquely

the expected results A 1;1;2;2 R;S;R;S However, I would like to create a query will return the results A 1;2 R;S Any ideas? Noah Hart -- View this message in context: http://old.nabble.com/how-to-use-group_concat-uniquely-tp30712025p30712025.html Sent from the SQLite mailing list archive

Re: [sqlite] how to use group_concat uniquely

On 1/19/2011 12:19 PM, Noah Hart wrote: I am having difficulty trying to return data in a very compact form. Here is a simple example that will explain the problem: I have a table with column E, T and P containing data such as A, 1, R A, 1, S A, 2, R A, 2, S Trying the query select

Re: [sqlite] how to use group_concat uniquely

Igor Tandetnik wrote: On 1/19/2011 12:51 PM, Noah Hart wrote: select E, replace(group_concat(distinct T), ',', ';'), replace(group_concat(distinct P), ',', ';') from MyTable; Ahhh the DISTINCT keyword was what I'm missing. However, this may be a bug, when I use group_concat(DISTINCT T

[sqlite] dbstatus test needs ifcapable !lookaside logic

if SQLITE is compiled with SQLITE_OMIT_LOOKASIDE then the dbstatus test 2 and 3 series will fail. recommend adding the lines ifcapable !lookaside { finish_test return } right before the lines #--- # Run the dbstatus-2

[sqlite] vacuum2 3 test does not work if compiled with codes

proc [set_file_format]. # do_not_use_codec Also the second test # vacuum2-2.1 should be vacuum2-2.2 Noah Hart -- View this message in context: http://old.nabble.com/vacuum2---3-test-does-not-work-if-compiled-with-codes-tp29711540p29711540.html Sent from the SQLite mailing list archive

[sqlite] journal2.test needs ifcapable !vtab block

This test uses the testvfs which is not available when compiled with SQLITE_OMIT_VIRTUALTABLE ifcapable !vtab { finish_test return } Regards, Noah -- View this message in context: http://old.nabble.com/journal2.test-needs-ifcapable-%21vtab--block-tp29681580p29681580.html Sent from the

[sqlite] tkt-9d68c88.test needs ifcapable vtab test

This test uses sqlite3 db test.db -vfs devsym which is not available when compiled with SQLITE_OMIT_VIRTUALTABLE needs the following block ifcapable !vtab { finish_test return } Regards, Noah -- View this message in context:

Re: [sqlite] rollback to savepoint regression / bug with journal_mode=off and locking_mode=exclusive

http://www.sqlite.org/pragma.html#pragma_journal_mode states The OFF journaling mode disables the atomic commit and rollback capabilities of SQLite. The ROLLBACK command no longer works; it behaves in an undefined way. Applications must avoid using the ROLLBACK command when the journal mode is

[sqlite] Commenting correction

routines that are called by the parser Noah Hart ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Comment Correction in vdbemem.c

line 1019 /* op can only be TK_REGISTER is we have compiled with SQLITE_ENABLE_STAT2. s/b /* op can only be TK_REGISTER if we have compiled with SQLITE_ENABLE_STAT2. Noah Hart ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] Version 3.7.0 delayed. Was: no longer able to use read-only databases?

Richard, In thinking about this, consider that if you embed the WAL within the SQLite database itself, past the high-water mark, it would also take case of this problem. Noah Hart On Fri, Jul 9, 2010 at 3:21 PM, Matthew L. Creech mlcre...@gmail.comwrote: In testing the latest SQLite

[sqlite] ANN: C#-SQLite 3.6.23 with aes 256 encryption

trademark of Hipp, Wyrick Company, Inc Enjoy, Noah Hart -- View this message in context: http://old.nabble.com/ANN%3A-C--SQLite-3.6.23-with-aes-256-encryption-tp28966276p28966276.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite

[sqlite] Error in minmax3.test with SQLITE_HAS_CODEC

minmax3.test has a routine at line 23 # This procedure sets the value of the file-format in file 'test.db' # to $newval. Also, the schema cookie is incremented. # proc set_file_format {newval} { hexio_write test.db 44 [hexio_render_int32 $newval] set schemacookie [hexio_get_int [hexio_read

[sqlite] Error in jrnlmode2.test with encryption codec

jrnlmode2-2.4 2-2.6, return incorrect results when using a codec with an encryption routine Expected: [0 {1 2 3 4 5 6}] Got: [1 {file is encrypted or is not a database}] This happens because the sqlite db command in TCL opens the database with the option -key {xyzzy} # Use the pager codec

[sqlite] Error in filefmt.test with encryption codec

. If there is a better method for running these tests with an encryption codec, please let me know Noah Hart -- View this message in context: http://old.nabble.com/Error-in-filefmt.test-with-encryption-codec-tp28952009p28952009.html Sent from the SQLite mailing list archive at Nabble.com

[sqlite] Error in vacuum2.test with encryption codec

vacuum2 returns incorrect results when using a codec with an encryption routine Suggested changes: line 31: +# Disable encryption on the database for this test. sqlite3 db test.db -key {} Change line 70 - sqlite3 db2 test.db +sqlite3 db2 test.db -key {} Noah Hart -- View

[sqlite] Error in pcache.test with encryption codec

{} Regards, Noah Hart -- View this message in context: http://old.nabble.com/Error-in-pcache.test-with-encryption-codec-tp28952275p28952275.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users

[sqlite] Error in nan.test with encryption codec

on the database for this test. +sqlite3 db test.db -key {} 167: - sqlite3 db test.db + sqlite3 db test.db -key {} 173: - sqlite3 db test.db + sqlite3 db test.db -key {} 179: - sqlite3 db test.db + sqlite3 db test.db -key {} 185: - sqlite3 db test.db + sqlite3 db test.db -key {} Regards, Noah Hart

[sqlite] Error in exclusive2.test with encryption codec

, Noah Hart -- View this message in context: http://old.nabble.com/Error-in-exclusive2.test-with-encryption-codec-tp28952460p28952460.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] Error in pagesize.test with encryption codec

statements Regards, Noah Hart -- View this message in context: http://old.nabble.com/Error-in-pagesize.test-with-encryption-codec-tp28952580p28952580.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite

[sqlite] Error in date.test with encryption codec

The date14 test uses hexio_write, which is invalid when opened with an encryption codec Regards, Noah Hart -- View this message in context: http://old.nabble.com/Error-in-date.test-with-encryption-codec-tp28953028p28953028.html Sent from the SQLite mailing list archive at Nabble.com

[sqlite] BUG REPORT: alter2 test does not run with SQLITE_HAS_CODEC

Line 25 of alter2.test has the following comment: # These tests do not work if there is a codec. # #if {[catch {sqlite3 -has_codec} r] || $r} return Either the comment on line 25 is incorrect, or should line 27 should be uncommented Please advise, Noah CONFIDENTIALITY NOTICE: This

[sqlite] Locking under various Windows versions

, then a connection to the database is made under WindowsCE. I've read the os_win.c code and am not clear how it is handled in this type of mixed mode Regards Noah Hart CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee

Re: [sqlite] Locking under various Windows versions

on a network share from a CE device, then it will not be able to use the network share's locking mechanisms. In short, don't do it. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Noah Hart Sent: Friday, April 16, 2010 3:48 PM

[sqlite] REQUEST: Implement APDB like PRAGMA for CHS access

Maybe SQLite could implement a PRAGMA to use the physical memory locator (CHS# - Cylinder, Head, Sector) as data-access keys as well Could even be faster than the INTEGER PRIMARY KEY now used. What do you think? http://thedailywtf.com/Articles/Announcing-APDB-The-Worlds-Fastest-Datab

Re: [sqlite] BUG: shell.c ATTACH parses filename poorly

There may be a documentation bug According to http://sqlite.org/lang_attach.html the format of the attach command is ATTACH [DATABASE] filename AS dbname Jay reports below that the filename can be an expression. Looks like the documentation needs to be clarified. REQUEST: Add

[sqlite] BUG 3.6.23 CorruptE.test needs ifcapable oversize_cell_check

. # # The error message is different depending on whether or not the # SQLITE_ENABLE_OVERSIZE_CELL_CHECK compile-time option is engaged. # ifcapable oversize_cell_check { Regards, == Noah Hart Sr. Systems Analyst Lipman Ins Admin, Inc. '510-796-4676 x266

[sqlite] ANN: C#-SQLite 3.6.22

, Inc Enjoy, Noah Hart -- View this message in context: http://old.nabble.com/ANN%3A-C--SQLite-3.6.22-tp27133897p27133897.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] BUG REPORT: 3.6.21;

to work correctly; The assert in btree.c at line 3699 in the routine sqlite3BtreeRollback was failing returning a 2000, rather than 0 assert( countWriteCursors(pBt)==0 ); Regards, Noah Hart CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you

[sqlite] BUG Report -- schema.test does not check for authorization in build

fails because tclsqlite.c has #ifdef SQLITE_OMIT_AUTHORIZATION Tcl_AppendResult(interp, authorization not available in this build, 0); return TCL_ERROR; #else Regards, Noah Hart CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you

[sqlite] BUG Report -- check.test has inconsistent test numbering

Documentation bug -- annoyance level Check.test has test # 4.3 listed twice do_test check-4.3 { execsql { UPDATE t4 SET x=4, y=3; SELECT * FROM t4 } } {4 3} do_test check-4.3 { execsql { UPDATE t4 SET x=12, y=2; SELECT * FROM t4 } } {12 2} Regards, Noah Hart

[sqlite] Bug in test file tkt-3fe897352e.test

This test file has a call to hex_to_utf16be which is unavailable when compiled with SQLITE_OMIT_UTF16 Test needs to be bracketed with ifcapable {utf16} Regards, Noah Hart CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you

[sqlite] Bug in test file fuzz3.test

to be bracketed with ifcapable {trigger} { # Only do the following tests if triggers are enable Regards, Noah Hart CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee

[sqlite] Documentation correction

vdbe.c line 3217 /* The input value in P3 might be of any type: integer, real, string, ** blob, or NULL. But it needs to be an integer before we can do ** the seek, so covert it. */ == s/b convert Regards, Noah Hart ___ sqlite

Re: [sqlite] ynVar

The source from 12/7 do show #if SQLITE_MAX_VARIABLE_NUMBER=32767 typedef i16 ynVar; #else typedef int ynVar; #endif Regards, Noah -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Lauren Foutz Sent: Friday, December 11, 2009

[sqlite] Testfixture test file may be misnamed

Was it deliberate that the following file was created with a .txt rather than .test extension? test/tkt-d82e3f3721.txt Regards, Noah Hart -- View this message in context: http://old.nabble.com/Testfixture-test-file-may-be-misnamed-tp26752815p26752815.html Sent from the SQLite mailing list

Re: [sqlite] Most wanted features of SQLite ?

Stored Procedures Noah Simon Slavin-2 wrote: So if you had a team of programmers to write something like SQLite which didn't have the drawbacks SQLite has, which drawbacks would you identify ? I'm asking not about minor faults with specific SQLite library calls, but about the

[sqlite] ANN: C#-SQLite 3.6.17

reimplementation of the SQLite software library * This is not an official version of SQLite * Bugs should not be reported to the SQLite.org ticket tracking system SQLite® is a registered trademark of Hipp, Wyrick Company, Inc Enjoy, Noah Hart -- View this message in context: http

Re: [sqlite] ANN: C#-SQLite 3.6.16

Kosenko Max wrote: Noah Hart wrote: C#-SQLite is now ready for review. The project is located at http://code.google.com/p/csharp-sqlite I think this name much better than sql-sharp. I've posted a question on SQLite ADO.NET forum http://sqlite.phxsoftware.com/forums/p/1879/7971.aspx

[sqlite] ANN: C#-SQLite 3.6.16

* This is not an official version of SQLite * Bugs should not be reported to the SQLite.org ticket tracking system SQLite® is a registered trademark of Hipp, Wyrick Company, Inc Enjoy, Noah Hart -- View this message in context: http://www.nabble.com/ANN%3A-C--SQLite-3.6.16

Re: [sqlite] ANN: SQLite 3.6.16.C#

in the future when the new project is ready. Also, if anyone has an ideal about what to call it ... Regards, Noah Hart Noah Hart wrote: I am pleased to announce that the C# port is done to the point where others can look at it. The project is located at http://code.google.com/p/sqlitecs

Re: [sqlite] ANN: SQLite 3.6.16.C#

The license is the same as SQLite, I'm waiting on google to change the project to PD since that is not one of the canned choices. Noah It's a pity news. I hoped Dr. can think about even somehow supporting your project. I don't know why he insists on that (he actually can answer for himself

Re: [sqlite] ANN: SQLite 3.6.16.C#

And in the Window's there are ... For example: System.Data.SQLite An open source ADO.NET provider for the SQLite database engine http://sqlite.phxsoftware.com/ http://code.google.com/p/sqlite-ng/ sqlite-ng A fork of SQLite with more community involvement SQLite-ng is a fork of SQLite with the

Re: [sqlite] ANN: SQLite 3.6.16.C#

Cory, There was no attempt at optimization in this initial port. SQLite does a lot of char/byte/string manipulation as well as and passing parameters by address in the middle of an array. But I ended up having to do a lot of byte buffer copying. MY guess is that is where most of the time is

Re: [sqlite] ANN: SQLite 3.6.16.C#

Yes, but still decent speed All Results are in Rows per Second TestSQLite3C# SQLite3 Inserts 300K1300K Selects 1500K 8450K Updates 60K 300K Deletes 250K700K Noah Kosenko Max wrote: Seems like I've misunderstood your performance results. And they are 3-5times

Re: [sqlite] ANN: SQLite 3.6.16.C#

The compiled version of the SQLite3.exe is 528KB vs 506KB for the official release I haven't checked the footprint while it is running. That would be depend on what it is doing ... Noah Fred Williams wrote: Hummm... Guess there is a reason there are no implementations of C# external to

Re: [sqlite] ANN: SQLite 3.6.16.C#

This is not a driver, dll, or wrapper. This is a port of the underlying SQLite software. Noah Yves Goergen wrote: On 01.08.2009 02:14 CE(S)T, Noah Hart wrote: I am pleased to announce that the C# port is done to the point where others can look at it. The project is located at http

Re: [sqlite] ANN: SQLite 3.6.16.C#

. I'm sure you'll find additional contributors. Just recently Miguel de Icaza was asking for line by line port of SQLite to C#. Great achievement that all tests are passing now. Max. Noah Hart wrote: I am pleased to announce that the C# port is done to the point where others can look

[sqlite] ANN: SQLite 3.6.16.C#

I am pleased to announce that the C# port is done to the point where others can look at it. The project is located at http://code.google.com/p/sqlitecs Enjoy, Noah Hart -- View this message in context: http://www.nabble.com/ANN%3A--SQLite-3.6.16.C--tp24764742p24764742.html Sent from

[sqlite] Port to C#; Progress report

the full C# code in the next few weeks Regards, Noah Hart -- View this message in context: http://www.nabble.com/Pros-and-cons-of-various-online-code-sharing-sites-tp24413069p24655194.html Sent from the SQLite mailing list archive at Nabble.com

[sqlite] Pros and cons of various online code sharing sites

-topic, but I am really interested in your suggestions. If you want to flame me, please reply directly, and not to the list. Regards, Noah Hart -- View this message in context: http://www.nabble.com/Pros-and-cons-of-various-online-code-sharing-sites-tp24413069p24413069.html Sent from the SQLite

Re: [sqlite] Pros and cons of various online code sharing sites

How do you plan to statically link your new library into multiple projects? Are you planning to make a copy of the code files for each C# project that uses Sqlite? I use the Add as Link. Again my goal was not to create a reusable library, but rather as a programming challenge to learn C# I

Re: [sqlite] error in documentation of SELECT?

Just because the syntax allows it, doesn't mean that it will be useful SELECT '1', sqlite_version() as A where A 'a' group by 1 order by 1 Noah -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Monday, May

[sqlite] Changes to closed tickets.

General question: If I append a report to a closed ticket, will developers look at it, or should I open a new ticket? For example: Ticket #3802 was closed with Unable to reproduce this problem I've added new information to allow the developers to reproduce. Will it be looked at, or should I

Re: [sqlite] Proposal for SQLite and non pure ASCII letters

, but differing collation lookups. I would encourage the developers to at least consider such a feature, after all, they did recently add the built-in RTRIM collation. Regards, Noah Hart -Original Message- - Please, let us try to bring down the discussion to the intended solution - a simple way

Re: [sqlite] Proposal for SQLite and non pure ASCII letters

Igor Tandetnik writes: This is not quite true. You say custom functions are supported: then you can do ORDER BY sortkey(textField), with a suitably defined sortkey() function (see strxfrm, LCMapString). You can't however build indexes using such a function, something you can do with a

Re: [sqlite] Proposal for SQLite and non pure ASCII letters

Nico wrote: Number 1, the database is no longer portable. The only solution to this is to include the functionality in the core. Yes but, there is no single Unicode collation. Collation is language-specific, even when using Unicode. Thus you're asking that SQLite3 have a plethora of built-in

[sqlite] Is this expected behavoir, or should I open a ticket?

SQL Version: 3.6.10 CREATE TABLE T1(a, b); INSERT INTO T1 VALUES(C1_A, randomblob(1)); SQL error:no such column: C1_A I know that I can quote the value C1_A, but why is that necessary? Thanks, Noah CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged

Re: [sqlite] Is this expected behavoir, or should I open a ticket?

@sqlite.org Subject: Re: [sqlite] Is this expected behavoir, or should I open a ticket? Noah Hart n...@lipmantpa.com wrote: SQL Version: 3.6.10 CREATE TABLE T1(a, b); INSERT INTO T1 VALUES(C1_A, randomblob(1)); SQL error:no such column: C1_A I know that I can quote the value C1_A, but why

Re: [sqlite] SELECT issue with SQLite 3.6.10

Please supply the SQL TEXT for the TABLE and the VIEW; Noah -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of KurDtE Sent: Tuesday, January 27, 2009 8:41 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SELECT issue with

Re: [sqlite] Assigning REGEX from javascript

of concept. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Noah Hart Sent: Tuesday, January 13, 2009 9:29 AM To: General Discussion of SQLite Database Subject: [sqlite] Assigning REGEX from javascript BACKGROUND: Firefox includes

Re: [sqlite] SQLite 3.6.8+ breaks YUM

Fixed here --- 11:04 Check-in [6186] : Allow recently added keywords 'savepoint' and 'release' to be used as database object names. Just as they could be prior to 3.6.8. Ticket #3590. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]

Re: [sqlite] reading beyond end of file

Just a random thought ... This is new code in pager.c, and if Pager-journalOff is at the end of the file, then perhaps it could cause his problem. ** ** To work around this, if the journal file does appear to contain ** a valid header following Pager.journalOff, then

[sqlite] Assigning REGEX from javascript

BACKGROUND: Firefox includes SQLite version 3.5.9, it also allows extensions, which are written in javascript and can call the embedded SQLite engine. As expected, executing the following SQL statement 'SELECT TEXT REGEX T*;' gives an error, since there is no REGEX function included.

Re: [sqlite] SQLite syntax diagrams

Page http://www.sqlite.org/draft/lang_droptable.html add and triggers after All indices. Add a caution note = Note: It is possible to drop a table while there are views that reference that table. Regards, Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Re: [sqlite] problem using random() in queries

Richard, Before you fix it, I'm not convinced it is broken. From MS SQL server create table _names (N varchar(5)); insert into _names values('a'); insert into _names values('b'); insert into _names values('c'); insert into _names values('d'); insert into _names values('e'); select N, RAND() as

Re: [sqlite] problem using random() in queries

-users@sqlite.org Subject: Re: [sqlite] problem using random() in queries Noah Hart [EMAIL PROTECTED] wrote: I would expect that multiple calls to random always return different values, even if in the same line. The fact that we are aliasing random by a column name makes no difference to me. What

Re: [sqlite] Generic speed testing

Good Point Ken, Here is version 1.2 with the missing CREATE TABLE statement and some new PRAGMA settings. Any suggestions for the CACHE_SIZE setting? Also -- I can see how to modify an existing Wiki page, but does anyone know how to create a new Wiki page, so I can put this script there rather

Re: [sqlite] Generic speed testing

--- On Fri, 8/15/08, Noah Hart [EMAIL PROTECTED] wrote: From: Noah Hart [EMAIL PROTECTED] Subject: Re: [sqlite] Generic speed testing To: General Discussion of SQLite Database sqlite-users@sqlite.org Date: Friday, August 15, 2008, 4:34 PM Good Point Ken, Here is version 1.2 with the missing CREATE

Re: [sqlite] Generic speed testing

Greg, I intended that sqlite3 be launched without a filename, so this will give a memory based database and disk I/O would not need to be considered. Regards -- Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Griggs, Donald Sent: Friday, August 15,

[sqlite] Generic speed testing

After looking at the code for speed test #1-4, I've decided that a command line version that does not use TCL would be better. Wanting to keep things simple, I'm looking only at inserts, selections and deletes. I'm not sure if this will even be a valid comparison, so your feedback and initial

[sqlite] Looking for generic speed test results

I understand that memory, disk and processor all play a part in the speed test results. However, I am looking for some benchmarks that would give ballpark figures for the results. Are people willing to post their speed test results, along with OS, CPU speed and Memory characteristics? Such as

Re: [sqlite] Looking for generic speed test results

to post results for Ubuntu 7.10 on a Dell Inspiron 530 (Dual Core 1.6Ghz) if you're interested. Just supply source code, compile options you want me to use, etc. Noah Hart wrote: I understand that memory, disk and processor all play a part in the speed test results. CONFIDENTIALITY NOTICE

Re: [sqlite] Looking for generic speed test results

Such as SQLite 3.6.1 running under Vista 32 bit, 2.4GHz, 3G ram, 5000rpmDisk speed1-insert1...326279489 uS 10.8195909732183 row/s Right off the bat, I notice that I'm getting 101871.8 rows/s under Linux. Almost 10,000 times faster. These were just dummy numbers I pasted here

Re: [sqlite] Looking for generic speed test results

, at 2:46 PM, Noah Hart wrote: If you want to do a meaningful speed comparison, then speed1.test should probably be modified to set PRAGMA synchronous=OFF. Would this be true for all the speed tests? I'll open a ticket to make that request. The speed1.test script was actually designed

Re: [sqlite] Proposed removal of (mis-)feature

+3 on removal of #3 Noah --- On Thu, 8/7/08, D. Richard Hipp [EMAIL PROTECTED] wrote: From: D. Richard Hipp [EMAIL PROTECTED] Subject: [sqlite] Proposed removal of (mis-)feature To: General Discussion of SQLite Database sqlite-users@sqlite.org Date: Thursday, August 7, 2008, 12:26 PM String

Re: [sqlite] problem with simple select

Sean, what version of sqlite are you using? With the command line version it appears to work under 3.5.9 SQLite version 3.5.9 Enter .help for instructions sqlite DROP TABLE if exists ae_objects ; sqlite CREATE TABLE ae_objects ( ... oid INTEGER PRIMARY KEY, ... name

Re: [sqlite] problem with simple select

My guess is that there is a trailing space in the record. Try the following: sqlite select save_id ||'' from ae_objects where save_id like 165; 165 And see where the sean save_id field ends. Regards, Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

Re: [sqlite] Index and ORDER BY

Richard, Just a suggestion. Would it make sense to ask one of your document maintainers to add something similar to your explanation and add it to the SELECT documentation page as a note to using the WHERE clause and the INDEX documentation page

Re: [sqlite] Index and ORDER BY

Jeff, try this select instead sqlite EXPLAIN QUERY PLAN SELECT events.* FROM events WHERE eid=32619760 and +type=22 ORDER BY eid DESC LIMIT 1; 0|0|TABLE events USING PRIMARY KEY ORDER BY Regards-- Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

Re: [sqlite] Count(1)

Questions to the SQLite maintainers... The docs tell us that ... ** The page headers looks like this: ** ** OFFSET SIZE DESCRIPTION ** 0 1 Flags. 1: intkey, 2: zerodata, 4: leafdata, 8: leaf ** 1 2 byte offset to the first freeblock

  1   2   >