);
CREATE VIEW COMPANY_VIEW AS
SELECT ID, NAME, AGE
FROM COMPANY;
DROP table 'COMPANY';
pragma table_info('COMPANY_VIEW');
Error: Uncaught Error: no such table: main.COMPANY
As an option to automatically destroy all connected VIEW
--
Best regards,
Kirill
mailto:kir...@aidagw.com
On 08.01.2017 12:54, Clemens Ladisch wrote:
Kirill Müller wrote:
... there's no portable support for 64-bit integers.
That's what SQLite looks at SQLITE_INT64_TYPE.
The patch introduces SQLITE_UINT64_TYPE.
I'm working around this issue by using a struct of size 8
A struct of size 8 does
On 08.01.2017 21:24, Richard Hipp wrote:
On 1/7/17, Kirill Müller <krlmlr...@mailbox.org> wrote:
I'm in a situation [1] where I compile RSQLite as part of a C++ project
that still uses the C++98 standard.
Can you instead compile SQLite as a library (libsqlite3.a) using gcc
or clang, the
On 08.01.2017 17:38, Clemens Ladisch wrote:
Kirill Müller wrote:
... there's no portable support for 64-bit integers.
I'm working around this issue by using a struct of size 8
I'm open to alternatives.
What's wrong with SQLITE_INT64_TYPE?
(Even older C++ compilers should have the C .)
Thanks
On 08.01.2017 14:20, Clemens Ladisch wrote:
Kirill Müller wrote:
On 08.01.2017 12:54, Clemens Ladisch wrote:
Kirill Müller wrote:
... there's no portable support for 64-bit integers.
I'm working around this issue by using a struct of size 8
A struct of size 8 does not behave the same
On 08.01.2017 12:54, Clemens Ladisch wrote:
Kirill Müller wrote:
... there's no portable support for 64-bit integers.
That's what SQLite looks at SQLITE_INT64_TYPE.
The patch introduces SQLITE_UINT64_TYPE.
I'm working around this issue by using a struct of size 8
A struct of size 8 does
4-bit
type" separately.
Currently I'm applying the attached patch to the released SQLite3
sources. It uses the macro SQLITE_UINT64_TYPE if defined, instead of
"unsigned SQLITE_INT64_TYPE". Please consider merging. Thanks.
Best regards
Kirill
[1] https://github.c
On 30.05.2016 17:09, Richard Hipp wrote:
On 5/30/16, Kirill Müller <krlmlr...@mailbox.org> wrote:
I'd appreciate any pointers on bisecting
SQLite. Thanks.
(1) Make sure you have tclsh 8.5 or later installed on your system, as
there are various TCL scripts that SQLite makefile needs
On 30.05.2016 09:57, Stephan Beal wrote:
On Mon, May 30, 2016 at 8:35 AM, Kirill Müller <krlmlr...@mailbox.org>
wrote:
I can't reproduce the issue on Windows with the current command-line
client, but it is real in our environment. How can I help you replicate it?
Thanks.
-
I can't reproduce the issue on Windows with the current command-line
client, but it is real in our environment. How can I help you replicate
it? Thanks.
-Kirill
On 26.05.2016 14:57, Kirill Müller wrote:
Hi
In the R interface to SQLite [1], we observe that opening a database
with ":m
The
sqlite3_open_v2() function returns SQLITE_CANTOPEN, and is called with
(":memory:", a valid pointer to a sqlite3*, SQLITE_RWC, NULL) according
to code inspection. Please advise.
Best regards
Kirill
[1] https://github.com/rstats-db/RSQLite
__
On 27.11.2015 10:38, Clemens Ladisch wrote:
> Kirill M?ller wrote:
>> I see no reason why the following two queries can't be executed with the
>> same plans:
>>
>> ... t1 LEFT JOIN t2 ...
>> ... t1 LEFT JOIN (SELECT * FROM t2) ...
> In this case, the querie
Exactly. And I'd pretty much like SQLite to figure that out for me ;-)
-Kirill
On 27.11.2015 03:19, Keith Medcalf wrote:
> Would it not be more efficient to say:
>
> select 1 from t1 limit 1;
>
> ?
>
>> -Original Message-
>> From: sqlite-users-boun
On 26.11.2015 21:12, Clemens Ladisch wrote:
> Kirill M?ller wrote:
>> On 25.11.2015 16:32, Clemens Ladisch wrote:
>>> Kirill M?ller wrote:
>>>> For a left join with a subquery on the right-hand side, that subquery
>>>> doesn't seem to be flattened.
&g
On 25.11.2015 16:32, Clemens Ladisch wrote:
> Kirill M?ller wrote:
>> For a left join with a subquery on the right-hand side, that subquery
>> doesn't seem to be flattened.
> This is rule 3 of <http://www.sqlite.org/optoverview.html#flattening>.
Thanks, missed th
with and without subqueries. The third example seems to create a
suboptimal query plan and takes much longer than necessary to run. The
output on my system is below the message.
Thanks for your attention.
Best regards
Kirill
1|0|0|SCAN TABLE t1
0|0|0|SCAN SUBQUERY 1
1
real0m0.003s
Good day,
New version sqliteonline.com
add fiddle
* easy creation of links
* complete preservation of the entire structure
* no registration
* limit db 100kb
* If within three months no complaints data deleted
http://sqliteonline.com/#fiddle-546c6e508557d5350601fd78e686aaefc9104419fdcde14468
Good day,
Full line manager to work with sqlite directly
from the browser on any platform:
http://sqliteonline.com/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
or in the table data or
metadata make the problem disappear.
Tested with the latest sqlite binary from www.sqlite.org under Linux.
Thanks,
Kirill
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
m tbl1 where t1 like '%оф%'; - lowChar
софт - lowChar
:(
what do?:
sqlite> select * from tbl1 where t1 like '%оф%'; - lowChar
софт - lowChar
СОФТ - upChar
--
Best regards,
Kirill
mailto:[EMAIL PROTECTED]
Whether will be SqlLite in the future and under Mac OS if there will be that as
soon?
sorry :(
>> version:
>> 3.3.4 or 3.x
>>
>> System test:
>> Win2003(NTFS)
>>
>> Script:
>> select * from tResult where tex like '%ra%'
>> result = 0
>>
>> select tex from tResult where id = 3229
>> tex = "...Oracle..."
>>
>> Soft on broblem:
>> sqlite3explorer,
>> and my soft
version:
3.3.4 or 3.x
System test:
Win2003(NTFS)
Script:
select * from tResult where tex like '%ra%'
result = 0
select tex from tResult where id = 3229
tex = "...Oracle..."
Soft on broblem:
sqlite3explorer,
and my soft
sample db:
http://www.aidagw.com/files/dba.zip
dhc>
hello
select * from tResult where tex like '%ra%'
result = 0
select tex from tResult where id = 3229
tex = "...Oracle..."
bag?
--
Kirill
24 matches
Mail list logo