Re: [sqlite] SLOW execution: Simple Query Uses More than 1 min

2019-12-06 Thread Octopus ZHANG
I fully understand the query now. Thank you all :) Simon Slavin 于2019年12月7日周六 下午1:23写道: > On 7 Dec 2019, at 5:10am, Octopus ZHANG wrote: > > > I received no error from the execution. Could I know how to emit the > error message if it is over length? > > There was no erro

Re: [sqlite] SLOW execution: Simple Query Uses More than 1 min

2019-12-06 Thread Octopus ZHANG
Hi, I received no error from the execution. Could I know how to emit the error message if it is over length? Richard Hipp 于2019年12月6日周五 下午9:24写道: > On 12/6/19, Octopus ZHANG wrote: > > Hi all, > > > > > > I'm trying to fuzz sqlite, and I found the following query

[sqlite] SLOW execution: Simple Query Uses More than 1 min

2019-12-06 Thread Octopus ZHANG
Hi all, I'm trying to fuzz sqlite, and I found the following query was executed for more than one minute. (./sqlite3 < query.sql) >> SELECT printf('%*.*c',9||00600&66,1003)""WHERE""/""; I also turned on the timer, but no time was printed. So I used `time` to record:

Re: [sqlite] No feedback for executing a mathematical expression

2020-03-10 Thread Octopus ZHANG
ion like: 10 div 5 = 2. > > > On 10.03.2020 08:21, Octopus ZHANG wrote: > > Hi all, > > > > > > I try to run a simple math expression, but SQLite gives no feedback : > > > > sqlite> select 99-(55/(30/57)); > > > > > > > > > &g

[sqlite] No feedback for executing a mathematical expression

2020-03-10 Thread Octopus ZHANG
Hi all, I try to run a simple math expression, but SQLite gives no feedback : sqlite> select 99-(55/(30/57)); Should I expect it to return nothing? Thank you -- Yushan ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] No feedback for executing a mathematical expression

2020-03-10 Thread Octopus ZHANG
Thanks for the detailed explanation! Keith Medcalf 于2020年3月10日周二 下午3:58写道: > > On Tuesday, 10 March, 2020 01:22, Octopus ZHANG > wrote: > > >I try to run a simple math expression, but SQLite gives no feedback : > > >sqlite> select 99-(55/(30/57)); > > &

Re: [sqlite] No feedback for executing a mathematical expression

2020-03-10 Thread Octopus ZHANG
I will use floating point as you all suggested. Thank you! Simon Slavin 于2020年3月10日周二 下午3:25写道: > On 10 Mar 2020, at 7:21am, Octopus ZHANG wrote: > > > sqlite> select 99-(55/(30/57)); > > > > Should I expect it to return nothing? > > That's going in my list