[sqlite] sqlite bug report

2019-04-10 Thread richard parkins
Summary Alter table rename to fails if the database contains a view which selects from a nonexistent table. Seen on sqlite 3.27.2. Script to reproduce it: create view view_1 as select * from table_1; create table table_2 (col_1 text, col_2 text); alter table table_2 rename to table_3; The

[sqlite] sqlite bug report

2016-01-08 Thread txjem...@sina.com
Bug report I downloaded sqlite 3.10.0 released in 2016-1-6, earlier I downloaded sqlite 3.9.2 and earlier version. I found below 2 bugs: bug1: Database directory which contains Simplified Chinese Character not support. bug2: Simplified Chinese Character in database table display error. bug1:

Re: [sqlite] sqlite bug report

2014-11-13 Thread Richard Hipp
On Thu, Nov 13, 2014 at 4:41 PM, Hinrichsen, John wrote: > In this example, bad data is returned. There is no assert. valgrind does > not complain either. > It asserts if you recompile with -DSQLITE_DEBUG > > Is there an ETA on when 3.8.7.2 will be released? > Next

Re: [sqlite] sqlite bug report

2014-11-13 Thread Hinrichsen, John
In this example, bad data is returned. There is no assert. valgrind does not complain either. Is there an ETA on when 3.8.7.2 will be released? On Thu, Nov 13, 2014 at 1:12 PM, Richard Hipp wrote: > This is https://www.sqlite.org/src/info/094d39a4c95ee4 which has been >

Re: [sqlite] sqlite bug report

2014-11-13 Thread Richard Hipp
This is https://www.sqlite.org/src/info/094d39a4c95ee4 which has been fixed in trunk and will be fixed in 3.8.7.2. On Thu, Nov 13, 2014 at 1:05 PM, Hinrichsen, John wrote: > The following SQL produces an incorrect result with sqlite-3.8.7.1: > > CREATE TABLE A( > symbol

[sqlite] sqlite bug report

2014-11-13 Thread Hinrichsen, John
The following SQL produces an incorrect result with sqlite-3.8.7.1: CREATE TABLE A( symbol TEXT, type TEXT ); INSERT INTO A VALUES('ABCDEFG','chars'); INSERT INTO A VALUES('1234567890','num'); CREATE TABLE B( chars TEXT, num TEXT ); CREATE TABLE IF NOT EXISTS C AS SELECT A.symbol AS

Re: [sqlite] SQLite bug report: type mismatch security issue in sqlite3.c version 3.7.13

2014-07-25 Thread Richard Hipp
On Fri, Jul 25, 2014 at 9:50 AM, Yunjiao Xue wrote: > To whom it may concern, > > We are using SQLite 3.7.13 with an amalgamation version of sqlite3.c. We > discovered a type mismatch security issue with a recent Fortify scan. The > problem is on lines 22407, 51807,

[sqlite] SQLite bug report: type mismatch security issue in sqlite3.c version 3.7.13

2014-07-25 Thread Yunjiao Xue
To whom it may concern, We are using SQLite 3.7.13 with an amalgamation version of sqlite3.c. We discovered a type mismatch security issue with a recent Fortify scan. The problem is on lines 22407, 51807, 63005, 93150 of sqlite3.c. For example, the function strHash() in sqlite3.c is declared

Re: [sqlite] Sqlite Bug Report!

2012-03-02 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > When I compile sqlite3 in VC++6.0, it does not work, but in VS2010 it > can work. http://www.beiww.com/doc/oss/smart-questions.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux)

[sqlite] Sqlite Bug Report!

2012-03-02 Thread liaoyan
Hello. (I am Chinese, not good at English. ^_^) When I compile sqlite3 in VC++6.0, it does not work, but in VS2010 it can work. It report a runtime errro. My code as following. #include #include #include #include #include "sqlite3.h" #include #include int main() { char db[] = "db.db";

[sqlite] SQLite bug report: Bad truncation in column mode with non ASCII characters

2010-08-09 Thread François Bonzon
In ".mode column", the function used to compute the length of the string to print does not account for multi-byte characters, resulting in a shorter string, and all remaining fields in the line shifted to the left. Example: sqlite> select * from test limit 3; namename2 name3

Re: [sqlite] SQLite bug report - large databases only - 'database or disk is full'

2009-12-12 Thread pirx
- From: Filip Navara <filip.nav...@gmail.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Thu, Dec 10, 2009 1:35 am Subject: Re: [sqlite] SQLite bug report - large databases only - 'database or disk is full' On Mon, Dec 7, 2009 at 10:21 PM, <p...@

Re: [sqlite] SQLite bug report - large databases only - 'database or disk is full'

2009-12-10 Thread Filip Navara
On Mon, Dec 7, 2009 at 10:21 PM, wrote: > > SQLite bug report > > Summary: > -- > > error message: > >       Error: near line 2: database or disk is full > > It happens with plenty of disk space available and with 'unlimited' database > size. > It does not happen on

Re: [sqlite] SQLite bug report - large databases only - 'database or disk is full'

2009-12-08 Thread Filip Navara
On Mon, Dec 7, 2009 at 10:21 PM, wrote: > > SQLite bug report > > Summary: > -- > > error message: > >       Error: near line 2: database or disk is full > > It happens with plenty of disk space available and with 'unlimited' database > size. > It does not happen on

[sqlite] SQLite bug report - large databases only - 'database or disk is full'

2009-12-07 Thread pirx
SQLite bug report   Summary: -- error message: Error: near line 2: database or disk is full It happens with plenty of disk space available and with 'unlimited' database size. It does not happen on all systems. It does not happen on small databases.   Details: --