[sqlite] Feature request: degenerates in Lemon's report

2018-07-09 Thread Cezary H. Noweta
if( ap->type==RRCONFLICT ) break; + } + if( ap==0 ) continue; + fprintf(fp,"Degenerated state %d:\n",stp->statenum); +} else { + fprintf(fp,"State %d:\n",stp->statenum); +} if( lemp->basisflag ) cfp=stp->bp;

[sqlite] Minor parser bug

2018-07-01 Thread Cezary H. Noweta
{ (missing ``n'' before ``exprlist''). Desired effect is achieved (i.e. error, because that statement is not preparable), however the message is misleading. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists

[sqlite] https://www.sqlite.org/cgi/src/info/7fa8f16e586a52ac

2018-06-20 Thread Cezary H. Noweta
ating-point value equal to Y*pow(2,Z). 0 * 2^?? == 0. Zero times positive, finite number gives zero always. There is no Inf in i64 type to produce NaN from 0 * 2^Inf. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@

Re: [sqlite] sqlite3AtoF Handling of high numbers

2018-05-17 Thread Cezary H. Noweta
value inside the database ( executed with the sqlite c++ api without usage of prepared parameters) 4. Due to 3. if an above query had been working, it would not have returned any records/rows. -- best regards Cezary H. Noweta ___ sqlite-users mailing

Re: [sqlite] Is this really the best way to do this?

2018-05-17 Thread Cezary H. Noweta
person not existing literally; A NULL column (blocking) ``action'' in a table ``blocked'' is an error and should be avoided -- it means ``you are blocked, but I do not know how''. If someone wants a (lately bound) default action, let the name be ``DEFAULT'' -- not NULL. -- best regards Cezary H. Nowet

[sqlite] UPSERT and overlapping UNIQUE indices

2018-05-16 Thread Cezary H. Noweta
g what is not strictly designed to enforce an uniqueness) should be non-UNIQUE ones. IMHO, this fact is worth of recalling in the doc of UPSERT clause as the fact can become a source of a confusion. -- best regards Cezary H. Noweta ___ sqlite-users mailin

Re: [sqlite] Problem b building sqlite on macOS android.

2018-05-14 Thread Cezary H. Noweta
ou prefer, ...), or * - defining BIONIC_IOCTL_NO_SIGNEDNESS_OVERLOAD, which will make the * overloading go away. '' -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bi

Re: [sqlite] probably recursive?

2018-05-04 Thread Cezary H. Noweta
urther fire UPDATE TRIGGERs of *axis, which in turn further do (4a) or (4b). I do not want to provide specified DDL statements as they would require a bit of testing -- unfortunately I cannot test SQLite now. -- best regards Cezary H. Noweta ___ sq

Re: [sqlite] probably recursive?

2018-05-04 Thread Cezary H. Noweta
Hello, On 2018-05-04 03:07, R Smith wrote: On 2018/05/04 1:54 AM, Cezary H. Noweta wrote: At the beginning I would like to agree with that the problem is iterative rather then recursive one. However LOL, that might be the hackiest query I ever seen, but kudos mate, that's bloody

Re: [sqlite] probably recursive?

2018-05-03 Thread Cezary H. Noweta
STR(elem, ' ')) AS INTEGER) y FROM main WHERE elem IS NOT NULL; == If you have received an empty set then you will have to decrease nX/nY, append more points or generate new ``points'' table. ... just for fun. -- best regards Cezary H. Noweta _

Re: [sqlite] Missing several important tricks in partial indexes

2018-02-27 Thread Cezary H. Noweta
system operates on trillion records dbs taken from a heaven and executes fancy queries -- there are also systems which update/insert something and run many relatively simple queries on a relatively small data. -- best regards Cezary H. Noweta _

Re: [sqlite] Strange concatenation result

2018-02-27 Thread Cezary H. Noweta
Hello, On 2018-02-27 08:46, Simon Slavin wrote: What should substr('abcd',0,-2) return? 'cd' or just 'd'? Or maybe just an empty string? NULL Why? -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Strange concatenation result

2018-02-26 Thread Cezary H. Noweta
sible data even for nonsense input" as design goals, mapping substr(x,0,z) to substr(x,1,z-1) seems quite a benign solution. ... and as such, that design could be documented. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mai

Re: [sqlite] Strange concatenation result

2018-02-26 Thread Cezary H. Noweta
to it) and on your code's side. Additionally, the behavior is consistent and predictable -- it gives advantages only. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi

Re: [sqlite] Improper error message

2018-02-20 Thread Cezary H. Noweta
desired effect (i.e. ``no such function'' message), then copy block ``expr(A) ::= id(X) LP distinct(D) exprlist(Y) RP. {...}'' in ``parse.y'' replacing ``id'' with ``JOIN_KW'', otherwise the parser is expecting that an expression contains the sole ``left''/``right'' or a syntax error occurs. --

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

2018-02-19 Thread Cezary H. Noweta
as numbers of UTF-8 chars -- not bytes. ``SELECT length(printf ('%4ls', 'äöü'));'' will give 4. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] invalid date time

2018-02-19 Thread Cezary H. Noweta
Hello, On 2018-02-19 13:08, Joe Mistachkin wrote: Cezary H. Noweta wrote: Use ``Flags=GetAllAsText'' when creating a SQLiteConnection. Excellent suggestion. Alternatively, you could use the GetString method on the SQLiteDataReader class. Indeed, however OP posted that ``GetString()'' does

Re: [sqlite] invalid date time

2018-02-19 Thread Cezary H. Noweta
oid this internal cast and just get this information as a text string, no matter its inside format ? Use ``Flags=GetAllAsText'' when creating a SQLiteConnection. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

2018-02-19 Thread Cezary H. Noweta
les the situation (look at the end of ``s'' conversion specifier together with ``l'' flag): ``In no case is a partial multibyte character written.''. Is there somebody who things about a byte content of buffers, when he is writing a software at a SQL level? -- best re

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

2018-02-17 Thread Cezary H. Noweta
le (``UTF-8'') for LC_CTYPE? Behavior entirely unsurprising: there is conversion from L"äöü" using "UTF-8" LC_CTYPE. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] LIMIT versus sqlite3_step LIMIT times

2018-02-16 Thread Cezary H. Noweta
ed. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] LIMIT versus sqlite3_step LIMIT times

2018-02-16 Thread Cezary H. Noweta
pLimit */ -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Groups in C API

2018-01-29 Thread Cezary H. Noweta
t numbers of bytes passed. I.e. sqlite3_aggregate_context(ctx, 1) will return 1byte size memory -- subsequent call (while in the same group of GROUP BY) sqlite3_aggregate_context(ctx, 100) will return the same 1byte size memory. -- best regards Cezary

Re: [sqlite] Atoi64 bug(s)

2018-01-25 Thread Cezary H. Noweta
ne other (me for sure) then the team. On the other side, the problem with saturation is completely resolvable by adding 5 characters to ``Atoi64()''. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sql

Re: [sqlite] Atoi64 bug(s)

2018-01-25 Thread Cezary H. Noweta
, please give me a few hours to cut my new not-so-completely implemented functionalities from my draft version. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

Re: [sqlite] Atoi64 bug(s)

2018-01-25 Thread Cezary H. Noweta
roposed a solution. What are you trying to say? That [NSQRN] as a result of conversion of a 'bignumstring' is better that saturated value MIN/MAX. That needless loss of info without any benefits is good? -- best regards Cezary H. Noweta ___ sqlite-

Re: [sqlite] Atoi64 bug(s)

2018-01-25 Thread Cezary H. Noweta
g to a vacuum. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Atoi64 bug(s)

2018-01-25 Thread Cezary H. Noweta
INT64 ){ *pNum = neg ? SMALLEST_INT64 : LARGEST_INT64; }else if( neg ){ *pNum = -(i64)u; == -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .DUMP displays floats differently from SELECT

2018-01-24 Thread Cezary H. Noweta
e databases, so this breaks it completely, and I currently had to pin sqlite to an older version which isn't desired. IMHO, a better and more concise way is to rem out the following line: p->mode = p->cMode = MODE_Insert; in ``shell.c'' and to recompile i

Re: [sqlite] .DUMP displays floats differently from SELECT

2018-01-22 Thread Cezary H. Noweta
486;2^-485>n<10^-146;10^-145>): 1.FF999x2^-486 => 1.0002594838824945E-146, 1.FF99Ax2^-486 => 1.0002594838824946E-146, 1.FF9999999999Bx2^-486 => 1.0002594838824947E-146. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sql

Re: [sqlite] Retrieving constraint name

2018-01-08 Thread Cezary H. Noweta
is trivial also. At least for me, thus, by implication, for the team. I think that the reason for not extending the pragma lies elsewhere. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] difference between 'ID IS NULL' and 'ID = NULL'

2018-01-07 Thread Cezary H. Noweta
; ID). The pk has only 1 field (ID) so why not use that, particularly in the case where ‘ORDER BY ID’ was included in the query? OK - your creation statement causes that ``ID'' is an alias for ``rowid''. Why PK is not used, was mentioned by me: On 2018-01-06 14:01, Cezary H. Noweta w

Re: [sqlite] difference between 'ID IS NULL' and 'ID = NULL'

2018-01-06 Thread Cezary H. Noweta
regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] difference between 'ID IS NULL' and 'ID = NULL'

2018-01-06 Thread Cezary H. Noweta
DEX ...'' means that your index is used. Order by does not apply as it is the same as PK. Scanning by using PK results in ORDERed BY PK records. There is no need to use separate INDEX for ORDER BY clause. -- best regards Cezary H. Noweta ___ sqlite-us

Re: [sqlite] difference between 'ID IS NULL' and 'ID = NULL'

2018-01-05 Thread Cezary H. Noweta
0 9 Goto 0 1 000 Run Time: real 0.000 user 0.00 sys 0.00 ??? My 3.21 checks if NULL is NULL and exits: 2 Null 0 1 3 IsNull 1 9 ... 9 Halt 0 0 -- best regards Cezary H. Now

Re: [sqlite] difference between 'ID IS NULL' and 'ID = NULL'

2018-01-05 Thread Cezary H. Noweta
. :-) I’m sure I’ve read something before about this but can’t find it in the documentation? STH IS STH allows NULLs and returns 1 if both are NULLs, 0 otherwise. http://sqlite.org/lang_expr.html#isisnot -- best regards Cezary H. Noweta ___ sqlite

Re: [sqlite] Query optimizer and recursive common table expressions

2018-01-03 Thread Cezary H. Noweta
ble (at 9223372036854775808 -- still much time :-). ``We are programmers and responsible for programming. -O99 is responsible for thinking. Who in the hell implemented -O when there had not been -O?'' :-) -- best regards Cezary H. Noweta ___ sql

Re: [sqlite] [SPAM] Re: Emulate right-join

2018-01-03 Thread Cezary H. Noweta
running joins, one of which goes to a vacuum. I can see real, however negative, computational advantage. Although that way is a very good academic illustration of OUTER joins. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users

Re: [sqlite] GROUP_CONCAT with DISTINCT bug

2018-01-02 Thread Cezary H. Noweta
Hello, On 2018-01-03 01:44, Cezary H. Noweta wrote: MySQL has a separator specified by a distinct clause. I'm sorry -- I meant ``distinct'' == ``separate/different'' (a clause named ``SEPARATOR''). Not to be confused with ``DISTINCT'' clause in SQLite's ``group_concat(DISTINCT

Re: [sqlite] GROUP_CONCAT with DISTINCT bug

2018-01-02 Thread Cezary H. Noweta
2>2879787174<=7821300466>-9054357747<=3166199899>-4120363042<=8151009951>-7018229290<=4454709919<=8212308797 -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailingli

Re: [sqlite] GROUP_CONCAT with DISTINCT bug

2018-01-02 Thread Cezary H. Noweta
a GROUP BY NULL; Hello;world AND shmorld Hopefully, SELECT FROM SELECT DISTINCT mentioned previously by Scott, resolves the problem in an easy & painless way. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailingli

Re: [sqlite] sqlite3AtoF()

2017-12-31 Thread Cezary H. Noweta
Hello, On 2017-12-29 02:25, Richard Hipp wrote: Please test the latest trunk version (or any version after check-in https://www.sqlite.org/src/timeline?c=fd2e0e7a) and confirm that the modifications work for you. It works as expected. Thank you. -- best regards Cezary H. Noweta

[sqlite] sqlite3AtoF()

2017-12-24 Thread Cezary H. Noweta
if( esign<0 ){ result = s / scale; }else{ == -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] DateTime kind stored as undefined

2017-12-16 Thread Cezary H. Noweta
... DateTime: 2017-12-16 15:48:40 DateTime.Kind: Utc DateTime: 2017-12-16 15:48:40 DateTime.Kind: Utc == It looks that your app behaves as if it had default settings: ISO8601/Unspecified, which results in Local/Unspecified. The sole thing I have in min

Re: [sqlite] DateTime kind stored as undefined

2017-12-14 Thread Cezary H. Noweta
id UTC DateTime, which is stored as INTEGER. Could you provide your connection string? -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Retrieving constraint name

2017-12-11 Thread Cezary H. Noweta
. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Retrieving constraint name

2017-12-10 Thread Cezary H. Noweta
Hello, On 2017-12-11 01:04, Igor Korot wrote: On Sun, Dec 10, 2017 at 5:01 PM, Cezary H. Noweta <c...@poczta.onet.pl> wrote: On 2017-12-10 07:21, Igor Korot wrote: The CREATE TABLE statement supports the following syntax: CREATE TABLE( , CONSTRAINT FOREIGN KEY() REFE

Re: [sqlite] Retrieving constraint name

2017-12-10 Thread Cezary H. Noweta
name. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] VFS FCNTL question

2017-12-03 Thread Cezary H. Noweta
-consuming I/O without wasting a time for retrieving/writing a data which would be finally discarded due to an interrupt. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi

Re: [sqlite] UTF8-BOM not disregarded in CSV import

2017-06-27 Thread Cezary H. Noweta
is the difference between UCS-2 and UTF-16?.) :-) -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] UTF8-BOM not disregarded in CSV import

2017-06-27 Thread Cezary H. Noweta
e, Clemens' arguments are very stringent -- I hope SQLite shell's behavior will not change. For the sake of the standard conformance, thus predictability and determinedness. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sq

Re: [sqlite] UTF8-BOM not disregarded in CSV import

2017-06-25 Thread Cezary H. Noweta
to extend an import's functionality in such a way that it ignores the initial 0xFEFF. However, an import should allow ZWNBSP as the first character, in its basic form, to be conforming to the standard. -- best regards Cezary H. Noweta ___ sqlite-users mailing

Re: [sqlite] sqlite3_open_v2("",... schema name?

2017-05-01 Thread Cezary H. Noweta
name(). I agree, that a minor DOC improvement would be nice in this case. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] gnu gcc address sanitizer finds stack-use-after-scope in sqlite3VdbeExec

2017-04-20 Thread Cezary H. Noweta
. Regardless of all, the original problem concerns GCC rather then SQLite itself. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] gnu gcc address sanitizer finds stack-use-after-scope in sqlite3VdbeExec

2017-04-20 Thread Cezary H. Noweta
a pointer to ``res'', and (d) a huge size of ``switch(...)''. - best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] VT table behavior change between 3.10 and 3.17

2017-03-29 Thread Cezary H. Noweta
increase. AFAIK, your intention was to remove unnecessary OP_Close (in case of virtual table cursors). The dangling, problematic OP_Close is at the very end of ``update.c'' (updateVirtualTable(...)): sqlite3VdbeAddOp2(v, OP_Close, ephemTab, 0); -- best regards Cezary H. Noweta

Re: [sqlite] VT table behavior change between 3.10 and 3.17

2017-03-29 Thread Cezary H. Noweta
separately so it could be easy adjusted for consistency. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] VT table behavior change between 3.10 and 3.17

2017-03-29 Thread Cezary H. Noweta
Close should be omitted as in SELECT/DELETE? -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] VT table behavior change between 3.10 and 3.17

2017-03-29 Thread Cezary H. Noweta
Hello, On 2017-03-29 13:07, Hick Gunter wrote: -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Cezary H. Noweta Gesendet: Mittwoch, 29. März 2017 12:37 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.

Re: [sqlite] VT table behavior change between 3.10 and 3.17

2017-03-29 Thread Cezary H. Noweta
until now. It is not the best to rely on the assumption that xOpen-ed cursor is read-only, or have I missed something? Why xOpen-ed cursor cannot be used to write to a table? -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Error using multiline command line argument with dot-command

2017-03-08 Thread Cezary H. Noweta
obably requires a bit more work, but due to a shell's thrift it is quite easy (there is a simple, non--forking flow: main => process_input => one_input_line => local_getline => fgets). -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] confused getting started

2017-03-07 Thread Cezary H. Noweta
oneyDisp, NULL, ); if ( SQLITE_OK != result ) { /* select error handling */ } sqlite3_free(errMsg); result = sqlite3_close(db); if ( SQLITE_OK != result ) { /* close error handling */ } } return 0; } ====== 4. Compile

Re: [sqlite] last_insert_rowid() returns wrong value after insert in a fts5 virtual table.

2017-02-27 Thread Cezary H. Noweta
by allowing to disable lastRowid's updating temporarily). I'm not as fluent in SQLite as to see an ``append-one-line'' solution. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] last_insert_rowid() returns wrong value after insert in a fts5 virtual table.

2017-02-26 Thread Cezary H. Noweta
in BEGIN/COMMIT. Until you exec COMMIT, f5_data is not updated and last_insert_rowid() returns a value set by ``VUpdate'' opcode -- not overwritten by xSync/xCommit updates. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Unresolved External sqlite3_user_add

2017-02-22 Thread Cezary H. Noweta
r side, an encryption does not ensure an user separation -- the encryption concerns a whole db-file, so one user having access to an encrypted db-file could virtually read other user's data. -- best regards Cezary H. Noweta ___ sqlite-users mailin

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

2017-02-21 Thread Cezary H. Noweta
Hello, On 2017-02-21 07:32, Green Fields wrote: cl sqlite3.c -link -dll -out:sqlite3.dll cl sqlite3.c -DSQLITE_API=__declspec(dllexport) -link -dll -out:sqlite3.dll nmake /f makefile.msc nmake /f makefile.msc DYNAMIC_SHELL=1 -- best regards Cezary H. Noweta

Re: [sqlite] Compile Windows dll with MinGW with stdcall calling convention?

2017-02-20 Thread Cezary H. Noweta
make macro). You can build the amalgamation in such a way that those macros will appear. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compile Windows dll with MinGW with stdcall calling convention?

2017-02-20 Thread Cezary H. Noweta
H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compile Windows dll with MinGW with stdcall calling convention?

2017-02-20 Thread Cezary H. Noweta
then a lot of new problems including a nuclear launch :-). -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compile Windows dll with MinGW with stdcall calling convention?

2017-02-19 Thread Cezary H. Noweta
and configurations, but without a success. :-( ``-mrtd'' is not working as good as MSVS' ``-Gz''. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] Decrypt .db file

2017-02-18 Thread Cezary H. Noweta
password never exceeded 2 weeks, but often it fit in minutes, in case of ``normal'' (i.e. not like ``kaksj8ooY^*&^O*&*%P'') passwords. Good luck. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mail

Re: [sqlite] FTS3 tokenize unicode61 does not remove diacritics correctly?

2017-02-16 Thread Cezary H. Noweta
not provide a decomposition mapping for ``ł'', or ``Ł''. Even if it is a bug, then it will concern the Unicode standard rather then SQLite FTS3 itself, as the latter is using the character database provided by the Unicode standard. -- best regards Cezary H. Noweta

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

2017-02-14 Thread Cezary H. Noweta
Hello, On 2017-02-15 01:56, Bart Smissaert wrote: Downloaded again and now it looks more healthy: [...] b0245450e4f27eeefc0da4a871833eb1 sqlite3.c Still not an original one! MD5 of an original ``sqlite3.c'' is 1efd683943e0d2bce1495b3413e2e235. -- best regards Cezary H. Noweta

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

2017-02-14 Thread Cezary H. Noweta
Hello, On 2017-02-15 01:26, Bart Smissaert wrote: OK, that gives this: [...] bd6dfd8b2b566ca64ff9f4c637e533f6 That means, you are not using an original, unmodified sqlite3.c file. Download/unpack an original autoconf package and try once again. -- best regards Cezary H. Noweta

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

2017-02-14 Thread Cezary H. Noweta
-verifier-utility then run from VS command prompt: fciv sqlite3.c && nmake /f Makefile.msc then send the output? You have run a similar command in a response to DRH. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqli

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

2017-02-14 Thread Cezary H. Noweta
immediately follows a backslash, because \ is not recognized as a line continuation. A splicing physical lines to establish logical ones is done at the very early stage of translation, even before spaces/comments are removed. -- best regards Cezary H. Noweta

Re: [sqlite] Bug: CREATE TABLE AS with GROUP BY preserves backticks in generated column name

2017-02-13 Thread Cezary H. Noweta
) && ALWAYS(pColExpr->pTab!=0) ){ -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 2 consecutive rises in value

2016-10-19 Thread Cezary H. Noweta
n operators in the final WHERE clause because one operation cancels an effect of other. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Using sqlite3_errcode()

2016-10-06 Thread Cezary H. Noweta
(regardless of what the called function returned: 0/0.0/NULL or not) then an error has not occurred. -- best regards Cezary H. Noweta ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman

[sqlite] Patch that add table alias capability to delete/update statements.

2016-04-15 Thread Cezary H. Noweta
Hello, Would you be so kind as to use ``Write e-mail'' instead of ``Reply'' when you are beginning a new thread? Thank you in advance. -- best regards Cezary H. Noweta

[sqlite] sqlite3_close does not propagate the error from sqlite3_io_methods.xClose

2016-04-14 Thread Cezary H. Noweta
ll xClose releases some resources we would need to know when they > fail. You should consider redesigning of your VFS driver architecture in such a way that releasing is always successful. -- best regards Cezary H. Noweta

[sqlite] sqlite3_close does not propagate the error from sqlite3_io_methods.xClose

2016-04-14 Thread Cezary H. Noweta
MA synchronous = OFF'' (http://sqlite.org/pragma.html#pragma_synchronous). That is a designed behavior of a VFS driver. If you didn't comply with that schema, you would play on your own with SQLite's sources. -- best regards Cezary H. Noweta

[sqlite] Broken database after experiments with fts.

2016-04-09 Thread Cezary H. Noweta
s rather serious bug which makes a database file corrupted in such a way that it cannot be repaired. (It can be repaired by copying all data to a new database or by binary editing of the database file.) -- best regards Cezary H. Noweta

[sqlite] regression in 3.12.0 vs. 3.11.0, column type information in PRAGMA missing

2016-04-06 Thread Cezary H. Noweta
goes even farther then 3.11.x because it keeps column's declared type when view's column name has changed (CREATE VIEW v(newname) ...). Thank you. -- best regards Cezary H. Noweta

[sqlite] regression in 3.12.0 vs. 3.11.0, column type information in PRAGMA missing

2016-04-06 Thread Cezary H. Noweta
you can exploit the explicit column list that is optional > in a CREATE VIEW: > >CREATE VIEW v3 (foo NUMERIC) AS SELECT w+x+y+z AS foo FROM t2; Syntax error. Did you mean: CREATE VIEW v3 (foo) AS SELECT CAST(w+x+y+z AS NUMERIC) FROM t2; -- best regards Cezary H. Noweta

[sqlite] regression in 3.12.0 vs. 3.11.0, column type information in PRAGMA missing

2016-04-05 Thread Cezary H. Noweta
that the "type" of > columns in a VIEW should always be an empty string. If so, Mike's postulate is arguable. This fact could be mentioned in a description of ``table_info'' PRAGMA: in case of views only id and a name of a column is meaningful. -- best regards Cezary H. Noweta

[sqlite] regression in 3.12.0 vs. 3.11.0, column type information in PRAGMA missing

2016-04-05 Thread Cezary H. Noweta
3.11.x too) is not meaningful in case of read-only views, then ``affinity'' info is still important (for comparision). > Otherwise if this is an unexpected regression then I hope a ticket can > be filed. +1. -- best regards Cezary H. Noweta

[sqlite] regression in 3.12.0 vs. 3.11.0, column type information in PRAGMA missing

2016-04-05 Thread Cezary H. Noweta
an empty set, while it returns ``2'' (as in SQLite 3.11.x). IMHO, this described by you behavior can be considered as a bug in ``PRAGMA table_info'', which takes column's affinity from ``CREATE TABLE'' command only as for now. -- best regards Cezary H. Noweta

[sqlite] Broken database after experiments with fts.

2016-03-29 Thread Cezary H. Noweta
Hello, On 2016-03-29 20:36, Cezary H. Noweta wrote: > I'm sorry, if I've missed something, but what about Parse::isMultiWrite? > AFAIK, Parse::mayAbort is used solely in conjunction with > Parse::isMultiWrite. How can lone Parse::mayAbort influence on > OP_Transaction (or on any ot

[sqlite] Broken database after experiments with fts.

2016-03-29 Thread Cezary H. Noweta
ng at the SQLite's repository. -- best regards Cezary H. Noweta

[sqlite] Broken database after experiments with fts.

2016-03-29 Thread Cezary H. Noweta
``CREATE VIRTUAL TABLE'' does not produce any of ``abortable'' opcodes. -- best regards Cezary H. Noweta

[sqlite] report a bug

2016-03-23 Thread Cezary H. Noweta
1]; sqlite3Fts5IsBareword(*z2); z2++) { if ( isLastCharOfWord(z2) ) { z2 = [numberOfBytesOfChar(z2)]; break; } } pToken->n = (z2 - z); == However you must notice, that such correction breaks rules mentioned by Dan Kennedy and have an impact on a whole FTS5 mechanism. -- best regards Cezary H. Noweta

[sqlite] Article about pointer abuse in SQLite

2016-03-22 Thread Cezary H. Noweta
Hello, On 2016-03-22 00:35, James K. Lowden wrote: >[...] An example from Clang's discussion is > > int i = 10 << 31; Could you provide a link for that discussion? (Or google's phrase to retrieve such link?) -- best regards Cezary H. Noweta

[sqlite] Reserved column names

2016-03-21 Thread Cezary H. Noweta
te.org/lang_keywords.html -- best regards Cezary H. Noweta

[sqlite] CAST STRING => INTEGER

2016-03-16 Thread Cezary H. Noweta
NUMBER? BWT. The implementation is not broken --- nobody uses broken things. :) -- best regards Cezary H. Noweta

[sqlite] CAST STRING => INTEGER

2016-03-16 Thread Cezary H. Noweta
or followed by a sign... */ '+' == zNum[i + 1] ) && [i + 2] < zEnd && '0' <= zNum[i + 2] && /* and digits */ '9' >= zNum[i + 2] ) ) ); return hasRealSyntax ? 1 : 3; } == -- best regards Cezary H. Noweta

[sqlite] How to read data from mem?

2016-03-16 Thread Cezary H. Noweta
t found its offset in ``pData->z'' and extract data from this offset. If you want to take a control over particular data inserted into a table then the best method is to use triggers. -- best regards Cezary H. Noweta

[sqlite] CAST STRING => INTEGER

2016-03-15 Thread Cezary H. Noweta
t could introduce many new inconsistencies. -- best regards Cezary H. Noweta

[sqlite] CAST STRING => INTEGER

2016-03-14 Thread Cezary H. Noweta
Hello, On 2016-03-14 13:25, Clemens Ladisch wrote: > Cezary H. Noweta wrote: >> Is your opinion > > Why would my opinion matter, as opposed to what SQLite actually does? Because, SQLite behaves in a bit strange manner, which is opposite to extreme carefulness of SQLite in o

[sqlite] CAST STRING => INTEGER

2016-03-14 Thread Cezary H. Noweta
-- best regards Cezary H. Noweta

  1   2   >