On 2015-07-23 04:56 PM, Igor Tandetnik wrote:
> On 7/23/2015 10:47 AM, Bernardo Sulzbach wrote:
>>> select * from tbl1 where substr(col1,1,1) in ('A','a') and col1 like
>>> 'a_c%';
>>
>> Just adding to Igor's answer:
>> col1 between 'a' and 'b' or col1 between 'A' and 'B'
>
> That's not quite
Since Igor's response I've been studying "The SQLite Query Planner" with
great interest.
Staffan
On Thu, Jul 23, 2015 at 4:59 PM, Bernardo Sulzbach <
mafagafogigante at gmail.com> wrote:
> > That's not quite the same. BETWEEN is inclusive of both ends. ('b'
> BETWEEN 'a' and 'b') is true.
>
> Y
Thanks, I wasn't aware.
On Thu, Jul 23, 2015 at 4:21 PM, Igor Tandetnik wrote:
> On 7/23/2015 10:17 AM, Staffan Tylen wrote:
>
>> Please consider this:
>>
>> create table tbl1 (col1 text primary key);
>> insert ...
>> select * from tbl1 where substr(col1,1,1)='a';
>>
>
> Make it
>
> WHERE col1>
Please consider this:
create table tbl1 (col1 text primary key);
insert ...
select * from tbl1 where substr(col1,1,1)='a';
select * from tbl1 where col1='a';
According to explain (I'm on 3.8.6), the first select above causes a scan
of the entire table, while the second select uses the index. My t
TZ is not used and is not set in our environment.
Using "GetLocalTime()" instead of "localtime()" should solve the problem.
-Urspr?ngliche Nachricht-
Von: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Igor
Tandet
Richard,
He wrote (ans I wasted my time reading)
> If you are reading this email, but you are not gcc-help administrator,
> please, please, forward this email to the administrator or simple reply to
> all. GCC-help should know what to do with this message.
He seems to be trying to contact the
> That's not quite the same. BETWEEN is inclusive of both ends. ('b' BETWEEN
> 'a' and 'b') is true.
Yes, you are right. I'm sorry for that, just wanted to point out that
(as most would expect) .. >= 'a' and .. < 'b' would not match
uppercase beginnings.
> select * from tbl1 where substr(col1,1,1) in ('A','a') and col1 like 'a_c%';
Just adding to Igor's answer:
col1 between 'a' and 'b' or col1 between 'A' and 'B'
if you need this case sensitive behavior
On 7/23/15, papa at arbolone.ca wrote:
> I have unsubscribe many, many times, but you have a serious problem
> receiving the message. I am papa at arbolone.ca, please, please unsubscribe
> me.
You are not a subscriber.
If you are still receiving messages, it probably means that you
subscribed us
On 7/23/2015 10:47 AM, Bernardo Sulzbach wrote:
>> select * from tbl1 where substr(col1,1,1) in ('A','a') and col1 like 'a_c%';
>
> Just adding to Igor's answer:
> col1 between 'a' and 'b' or col1 between 'A' and 'B'
That's not quite the same. BETWEEN is inclusive of both ends. ('b'
BETWEEN 'a'
I have unsubscribe many, many times, but you have a serious problem
receiving the message. I am papa at arbolone.ca, please, please unsubscribe me.
This mailing list is useless to me, if this continues I will take more
offensive action, which is something both of us are trying to avoid.
If you a
I have unsubscribe many, many times, but you have a serious problem
receiving the message. I am papa at arbolone.ca, please, please unsubscribe me.
This mailing list is useless to me, if this continues I will take more
offensive action, which is something both of us are trying to avoid.
If you a
On 7/23/15, Viktor Jancik wrote:
> Hi, I am trying to create a patch for sqlite in RHEL6 to backport a security
> fix:
> https://www.sqlite.org/src/info/aeca95ac77f6f320
>
> That is to sqlite version 3.6.20, and I can't understand why the expected
> result of do_test printf-1.17.4 is /.*/
The res
Hi, I am trying to create a patch for sqlite in RHEL6 to backport a security
fix:
https://www.sqlite.org/src/info/aeca95ac77f6f320
That is to sqlite version 3.6.20, and I can't understand why the expected
result of do_test printf-1.17.4 is /.*/
The test is added in the commit I linked.
Could yo
On 7/23/2015 10:17 AM, Staffan Tylen wrote:
> Please consider this:
>
> create table tbl1 (col1 text primary key);
> insert ...
> select * from tbl1 where substr(col1,1,1)='a';
Make it
WHERE col1>='a' and col1 < 'b'
This should use the index.
--
Igor Tandetnik
This makes SQLite unusable for such a use case
I propose to introduce a compile time option so that the actual time zone
settings are always respected.
-Urspr?ngliche Nachricht-
Von: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org]
On 7/23/2015 9:10 AM, Bruno Schw?gli (CTModule AG) wrote:
> TZ is not used and is not set in our environment.
It is, however, used and set by C run-time, which is in turn used by
SQLite. In any case, _tzset() is how you tell C run-time to re-read time
zone settings from the OS.
--
Igor Tandetni
AFAICT the windows implementation of localtime() will honour the settings of
the environment variables TZ, _timezone, _daylight and _tzname. The environment
variables of a process are set (copied from the parent process) on process
creation. Subsequent changes in the parent process are NOT refle
On 7/23/2015 4:11 AM, Bruno Schw?gli (CTModule AG) wrote:
> We use SQLite in an environment (ships) where a time zone change can happen
> during normal operation. We then set the time zone of the system (windows)
> accordingly.
> Running SQLite instances do not respect this change. So Time('now')
Hello
We use SQLite in an environment (ships) where a time zone change can happen
during normal operation. We then set the time zone of the system (windows)
accordingly.
Running SQLite instances do not respect this change. So Time('now') and
Time('now', 'localtime') still return the same value
On 7/22/15, Bernardo Sulzbach wrote:
> I guess this site is not a responsibility of sqlite.org, right?
Correct. The sqlite.phxsoftware.com is not controlled by the SQLite
development team. It is a 3rd-party site.
--
D. Richard Hipp
drh at sqlite.org
On 7/22/15, Jean Chevalier wrote:
> Hi Richard,
>
> Could you check that a bug report I emailed to you two days ago containing
> two attachments has reached you? Double-checking in case there might have
> been a mail malfunction or the original email got caught by a spam filter.
>
I have just re
select time( 'now', 'localtime' ) does to something to trigger reading
tzres.dll (windows library for timezone stuff?), but does not change the
time updated after a timezone change.
but I have a function to mimic sqlite now() function which returns
localtime... this function works and is based on
23 matches
Mail list logo
