[sqlite] automatic index on sqlite_sq_#######

[Yongil Jang]

Dear developers,

I've found that following log string when using sub-query.

"automatic index on sqlite_sq_9F222470(STAT_DATA_ID)"

"sqlite_sq_#" looks like a temporary table name of sub-query result.
And "STAT_DATA_ID" is a alias name of some column in table.

I don't know whether this issue is normal or not.
But, in my opinion, "sqlite_sq_#" is not easy to recognize.

Regards,
Yongil Jang.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug

[GB]

As Marc already stated, this mailing List doesn't allow attachments.

Please also note that SQLite does not support something like a "Date" 
Type. See http://www.sqlite.org/datatype3.html 
.


You may store date attributes in a numeric or TEXT format. See 
http://www.sqlite.org/lang_datefunc.html for more information. 
Personally, I prefer ISO-Strings since they are human readable without 
any transformation.


hth

regards
Gerd
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug

[Marc L. Allen]

I think attachments are dropped. If the SQL is reasonable size, just post it. 

Otherwise, you'll need to host the screen shot somewhere and link to it. 


> On Nov 19, 2014, at 10:00 PM, Josef Handsuch  wrote:
> 
> Dear developer, I'd like to thank you for you brilliant software. There
> just seems to be one little bug to report. If I filter a field that I have
> dedicated to date, the result is always wrong. Please take a look at the
> screenshot (attached) to see what I mean. What you can see there is that I
> was trying to view records that were made on November 19th and there should
> only be 19 records. The progam says there have been made over 150 thousand
> records that day... Whatever date I try to filter, the result is always
> wrong like this.
> Would you please fix this issue?
> Kind regards, Josef
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


This email and any attachments are only for use by the intended recipient(s) 
and may contain legally privileged, confidential, proprietary or otherwise 
private information. Any unauthorized use, reproduction, dissemination, 
distribution or other disclosure of the contents of this e-mail or its 
attachments is strictly prohibited. If you have received this email in error, 
please notify the sender immediately and delete the original.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Bug

[Josef Handsuch]

Dear developer, I'd like to thank you for you brilliant software. There
just seems to be one little bug to report. If I filter a field that I have
dedicated to date, the result is always wrong. Please take a look at the
screenshot (attached) to see what I mean. What you can see there is that I
was trying to view records that were made on November 19th and there should
only be 19 records. The progam says there have been made over 150 thousand
records that day... Whatever date I try to filter, the result is always
wrong like this.
Would you please fix this issue?
Kind regards, Josef
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqliteonline + Fiddle

[Kirill]

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

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users