On 9/8/19, t...@qvgps.com wrote:
>
> One option would be to create a new table with rowid, copy all records from
> the old one, delete old one and rename new table.
That is the quickest solution.
--
D. Richard Hipp
d...@sqlite.org
___
sql
calling sqlite3_close()".
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
have questions,
please ask and I will see if I can find answers. Or, some of the
conference organizers are on this mailing list, so perhaps they will
speak up.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users
me decoder
works regardless of the compression level.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ed recently to implement the best practices outlined
in the first document above. The existing code is safe. But I'll get
busy and add the extra layers of defense to make it even safer.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-us
ttps://www.sqlite.org/sqlar.html#managing_an_sqlite_archive_from_the_command_line
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
.S.: I am not subscribed to this mailing list, so please CC me
> directly on any replies.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Ric
On 8/20/19, Mark Tomlin wrote:
> I've looked at the PRAGMA statements and there doesn't appear to
> be any public documentation on this interface.
The PRAGMAs in question are part of the SEE documentation, as they are
unique to SEE.
--
D. Richard Hipp
he PHP source code.
You do not need to modify any C code, either in SQLite/SEE or in PHP.
You can activate encryption and set the encryption key using a PRAGMA
statement.
>
> Has anyone done this before?
Yes.
--
D. Richard Hipp
d...@sqlite.org
_
On 8/20/19, Matt Zand wrote:
> I wonder if version 3.29 does support error handling for sql transaction
> rollbacks. Also, does it support bypassing errors by forcing unconditional
> rollback yet.
I don't understand what you are asking.
--
D. Richard Hipp
d
_held(db->mutex) );
> 27023: assert( db->pnBytesFreed==0 );
>
>
> Thanks in advance!
>
> Tham
>
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ses? That depends, I suppose, one how the new CREATE differs from
the prior table that you DROP-ed.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
I used as a template when throwing together the LSM1
vtab.
The fix has now been checked into the SQLite source tree.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
le.
If you are not deliberately holding a read transaction open, perhaps
you are doing so accidentally by failing to sqlite3_reset() or
sqlite3_finalize() a prepared statement. You can perhaps figure out
which statement that is by running:
SELECT sql FROM sqlite_stmt WHERE busy;
--
ing a
hung process.
I am not aware of a way to do a blocking file lock with a timeout that
is portable across operating systems.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
> I didn't notice that, for some reason. Thanks for the correction.
You didn't notice it because I only added it moments ago, in response
to your documentation update request.
--
D. Richard Hipp
d...@sqlite.org
__
e and
each index is a separate b-tree. Each b-tree has a root page. All
other pages of the b-tree are descended from the root page. The
sqlite_master table identifies the page number of the root of each
b-tree. The sqlite_master table itself is also a b-tree which is
always rooted on page 1.
--
The mailing list strips attachments as an anti-spam measure. Please
send the POC directly d...@sqlite.org.
On 8/15/19, Xingwei Lin wrote:
> Attach is the poc sql file.
> I used the following command:
--
D. Richard Hipp
d...@sqlite.org
___
sqlite3_interrupt() that compile-time
options matter?
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
"nm" (on many unix systems,
or the equivalent on Mac or Windows) on a compiled sqlite3.o file, and
seeing that "strftime" appears nowhere in the output, while library
routines that SQLite does use like "open", "read", and "mall
On 8/13/19, Jose Isaias Cabrera wrote:
>
> I see all of you smart programmers using this
> non-column matching behavior, and I ask myself why?
Because that's the way Dennis Richie did it. :-)
--
D. Richard Hipp
d...@sqlite.org
__
load and decompess the complete content of that
file as part of the UPDATE operation. sqlite3_vtab_nochange()
facilitates such optimizations.
But it never occurred to me that somebody might do this on the PRIMARY
KEY. I don't see any reason why it wouldn't work, though.
--
D. Richard Hipp
The documentation on transactions at
https://www.sqlite.org/lang_transaction.html was written long, long
ago, apparently long before WAL mode was available, and is in serious
need of updating and improvement. I'm working on that now
--
D. Richard Hipp
d...@sqlit
On 8/9/19, David Raymond wrote:
>
> I'm pretty sure you missed the bit where he said that there was only a read,
> and no changes were made or requested.
>
You are correct - I missed that part. In that case, it just drops the
SHARED lock.
--
D. Richard Hip
ry to make sure no
other connections are simultaneously reading the database, because it
would not work for the committer to change content out from under the
other readers. After the COMMIT, it falls back to unlocked.
--
D. Richard Hipp
d...@sqlite.org
___
pages it will add new
> indexes to smaller pages than older indexes?
It probably only works because your DB is vacuumed.
Seems to me that the rowid of the sqlite_master table entry for your
index would be a more reliable indicator. Larger rowids are newer
On 8/6/19, Olivier Mascia wrote:
> Using 3.29.0 with SQLITE_DQS.
Is this the problem that was fixed here:
https://www.sqlite.org/src/timeline?c=fcd937d9786a82ef
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-us
Lite builds in
its own optimal memory allocator that uses only memory from a single
big allocation you provide it at start-time. So you give SQLite 30MB
(or whatever you think is appropriate) to play with, and it uses that
and only that memory, and never goes to malloc().
--
D
uthorizer, then you will be fine. But if you mess up, and
accidentally use a prepared statement with an incorrect authorizer,
and that statement leaks information or allows unauthorized changes to
the database, then no tears.
--
D. Richard Hipp
d...@s
de
shown below fixes the problem, and report back.
https://www.sqlite.org/src/artifact/0fac710388?ln=81
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
p information. If it guesses
correctly, it can avoid reading a page from disk. But it has to
fallback to reading the page if it guesses incorrectly.
See the 22 lines of code here:
https://sqlite.org/src/artifact/58d002f71?ln=4626-4648
--
D. Richard Hi
st and maintain for the next 31
years. So it has a high cost and low benefit.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ider the things you wanted to do and whether it's worth providing a
> better way to do them.
Just to confirm: Simon is exactly correct.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http:/
the comments, or should we ever
need to work on that particular aspect of the implementation.
As with all of the internal representation, we might find a better way
to accomplish the same thing tomorrow, and totally eliminate the
IF_NULL_ROW operator from the code. So don't become too attach
; Urite mala mundi
> Ardente veritate
> Incendite tenebras mundi"
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_
> 0;
>
> sqlite> select sqlite_version();
> 3.18.2
>
> Am I doing anything obviously wrong? Or is this a known problem/limitation?
> Thanks!
> Minollo
>
> _______
> sqlite-us
t
the first 99 are unused.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 7/19/19, Gilles Pérez wrote:
> set tvalue true
This statement sets the TCL variable "tvalue" to the four-character
string "true", not to a boolean true.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users ma
le "break" statements with "assert(0)".
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
een -01-01 00:00:00 and
-12-31 23:59:59 (julian day numbers 1721059.5 through 5373484.5).
For dates outside that range, the results of these functions are
undefined."
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users ma
On 7/15/19, Jens Alfke wrote:
>
> If you’re going to keep your data in memory, there’s no good reason to use
> SQLite at all.
Yeah there is. SQLite has a high-level query language (SQL) that can
radically simplify application development.
--
D. Richard Hipp
d...@s
f the language.
The implementation is described by a LALR(1) grammar at
https://sqlite.org/src/file/src/parse.y if that is of any help to you.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.s
rs ago, but the generator script has not been keep
up-to-date and no longer
functions.
The file has been removed from the trunk check-in and should no longer
appear when you attempt to load it.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailin
y, for
sending them in. Please feel free to do so at any time. You can send
them directly to me if you don't want to send them to the mailing
list.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqli
y, for
sending them in. Please feel free to do so at any time. You can send
them directly to me if you don't want to send them to the mailing
list.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqli
EVERYONE: If you have personally experienced some unusual or
unexpected feature of SQLite that you think should be added to
"quirks.html", please follow-up to this thread, or send me private
email, so that I can consider adding it. Thanks.
-
On 7/11/19, David Raymond wrote:
> I don't think I'd ever seen the quirks page
> (https://sqlite.org/quirks.html) before. Is that new-ish?
It's been around for a little more than a year. See
https://www.sqlite.org/docsrc/finfo?ss=c&name=pages%2Fquirks.in
--
D. Ric
der to write to the database file, so that SQLite can
create a rollback journal for transaction control.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ication have exclusive access to the database file? If
so, then consider:
PRAGMA locking_mode=EXCLUSIVE;
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ook,
> 'total_notes', total_notes
>), ...etc
>
> results in:
>
> {"data":"[{\"type\":\"notebook\",\"id\":2,\"attributes\":{\"book\":\"brew\&
On 7/1/19, Thomas Kurz wrote:
>
> I really followed the 12-step ALTER TABLE schema and stumbled upon the
> following problem:
Step 3 and Step 8 need to be modified to also record the content of
VIEWs in addition to INDEXes and TRIGGERs. I am working on the
revised text now.
--
D. Ric
of type IMMEDIATE?
Yes.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
hen converts back to double upon retrieval. That round-trip
> would change -0.0 into +0.0." I was wondering when this changed?
You are right. I had forgotten about that point. This has not been
changed even now, and so -0.0 does get truncated to +0.0 when it is
stored in the database
> move to a SQLite version with this improvement.
SQLite version 3.0.0 from 2004-06-17.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
get me a temporary login on such
a system, however, I will debug it for you. Send private email to the
address below.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bi
On 6/12/19, James K. Lowden wrote:
> what kind of computation
> would lead to a value in memory representing -0,0?
0.0/-1.0
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.or
isting
database files obsolete.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ot;: PostgreSQL, MySQL, Oracle, SqlServer
So in my tests, programming languages do distinguish between +0.0 and
-0.0, but database engines do not.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http
s only the binary-to-text conversion
routine that is at question here. If you are reading back your
database content using sqlite3_column_double(), you get back
bit-for-bit exactly what you put in.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users m
ted enhancements.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
IEEE754 floating point numbers have separate representations for +0.0
and -0.0. As currently implemented, SQLite always display both
quantities as just "0.0".
Question: Should SQLite be enhanced to show -0.0 as "-0.0"? Or,
would that create unnecessary confusion?
-
t;
The parser in SQL is very forgiving. Does this cause some kind of problem?
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 6/9/19, Igor Korot wrote:
>
> Now I open this database in sqlite3 CLI binary and would like to insert some
> png
> file inside this BLOB field.
INSERT INTO tab1(blob1) VALUES(readfile('some.png'));
--
D. Richard Hipp
d...@sqlite.org
On 6/7/19, Ulrich Telle wrote:
> Would it be possible for the SQLite developers to adjust the variable names
> used in the extension shathree.c to avoid this name clash with the macro in
> termbits.h?
https://www.sqlite.org/src/timeline?c=3ec73711
--
D. Richard Hipp
d...@s
ARY KEY or UNIQUE
> constraint
>
> ingo
> _______
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 6/4/19, Mike Nicolino wrote:
>
> I am trying to determine which version CVE-2019-5018 is resolved in.
It appears to be 3.28.0, as best as I can tell.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite
ard-coded.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
he overall result set and not for the subquery.
>
>
> In the hope that this might help others.
> Thank you very much for your hard work!
>
>
> Cheers,
> Marco
>
>
> _______
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlit
also notice that your columns are named "column_one", "column_two",
"column_three", and so forth. Is that deliberate, or have you
post-processed the database to obfuscate these column names? If the
latter, might the missing rows have been deleted by th
abase?
No, not that I can think of.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
RIC),2) from t1
And the result is then:
1 3.26
2 3.26
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
originally called ".repair". I
do not recall why we created that command.
There will be a new ".recover" command in the next release (currently
available in the prerelease snapshot) which does a better job of
recovering content from a c
nce always round the same.
I do not know what the underlying representation for floating point
numbers is in Excel, but as your experiment shows, it is probably not
IEEE754 double-precision binary.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-us
tical inputs? How does it know which
answer to give?
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
double-precision
binary floating point number. So the system has to use an
approximation. The closest approximation is
3.25489341858963598497211933135986328125 and that value
rounds to 3.25.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users m
Thanks for the test case. This problem should now be fixed on trunk.
Please try it out and let us know if you encounter any additional
probglems.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
my mail. I've sent it again and will get back to
> you then. I'll also try out aarch64 in qemu in the meantime.
Thanks for verifying the fix for us!
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailingli
s: "Spaces are considered part of a field and should not be
ignored."
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 5/21/19, Faheem Mitha wrote:
> The ".import" command does not parse CSV correctly.
> somestuff, "some,stuff"
This is not valid CSV. There is an extra space character after the
comma and before the double-quote.
--
D. Ri
ify that it now works on OpenWrt armeb xscale devices and
report back, as we have no way of verifying this ourselves. Thanks.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.
nk in terms of offsets within a single page. You should get the
same answer in either case, but just know that you are looking at this
from a different angle.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailin
s the offset to the start of the cell from the beginning of the
page.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 5/9/19, Manuel Rigger wrote:
>
> I discovered a sequence of statements that results in a malformed database
> disk image:
>
Should be fixed now.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglist
point value can be represented by an integer. That
optimization works well when storing floating point values like 1.0
and 0.0, but might be running into round-off error problems when
storing 9223372036854775807.0. Still looking.
--
D. Richard Hipp
UPDATE OR REPLACE t1 SET c1 = 1;
> SELECT DISTINCT * FROM t1 WHERE (t1.c0 IS NULL);
>
> The last statement returns the following:
> |1.0
> Error: near line 5: database disk image is malformed
Ticket here: https://www.sqlite.org/src/tktview/6c1d3febc00b22d457
On 5/8/19, Richard Hipp wrote:
> On 5/8/19, Regina Wilson (regiwils) wrote:
>>
>> Here’s a copy of the report.
>
>
> Thanks! Is the "poc" file available for our inspection too?
If you want to keep the "poc" encrypted, you can log in at
https://s
On 5/8/19, Regina Wilson (regiwils) wrote:
>
> Here’s a copy of the report.
Thanks! Is the "poc" file available for our inspection too?
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists
On 5/8/19, Regina Wilson (regiwils) wrote:
> Hello D. Richard Hipp,
>
> To date, we have not received a response from point of contact handling
> security issues. Can you assist with the issues reported via the bug report
> site?
We don't do PGP here. But you can se
nts of
an inserted or updated row to change datatypes, which causes the row
to be constructed incorrectly. Fixed by check-in
https://www.sqlite.org/src/info/3f1c8051648a341d
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sql
1),
> (0, 2);
> REINDEX;;
> SELECT * FROM t0; -- returns 0|1
> SELECT * FROM t0 WHERE c1=1; -- returns nothing
>
> Best,
> Manuel
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.s
se <, <=, >, and
>=.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> Manuel
>>
> _______
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 5/3/19, Manuel Rigger wrote:
> I just tried the examples on the int-real branch,
> and it seems that they do not cause any errors.
>
The int-real branch has now been fully tested and merged to trunk.
--
D. Richard Hipp
d...@sqlite.org
_
I have your request.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
UUM is *highly* recommended for security if you take an unencrypted
database that has never before been encrypted and "rekey" it into an
encrypted database. That is a totally separate issue.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mai
the "/draft" from the middle of the URL in order to
get the officially released document.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
SQLite
regression tests.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
right this moment. I will return to that branch,
finish testing it, and perhaps merge it to trunk, when I get a chance.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 5/2/19, Manuel Rigger wrote:
> Hi everyone,
>
> I think that I found another issue related to type affinity on real columns:
The typeof() function corner-case you identified has been fixed in
check-in https://www.sqlite.org/src/timeline?c=48889530a9de22fe
--
D. Richard Hipp
d...@s
uot; Would it maybe be helpful to update the documentation to
> explicitly state that UPSERT does not apply to NOT NULL constraints, and
> that apart from this case DO NOTHING works in the same way as INSERT OR
> IGNORE?
>
> Best,
> Manuel
>
> On Thu, May 2, 2019 at 5:38 P
201 - 300 of 6449 matches
Mail list logo