Hello.
The PRAGMA integrity_check is telling me that "row 2 missing from
index tbvk". This is reproducible with the following commands.
Should I be getting this message? Or is it a bug?
SQLite version 3.9.2 2015-11-02 18:31:45
Enter ".help" for usage hints.
Connected to a transient in-memory
Yuri wrote:
> I am looking for a way to have a parametrized query, when parameter is passed
> through the command line.
Isn't the query itself passed through the command line? Show some example.
Regards,
Clemens
> On 5 Nov 2015, at 10:13pm, Yuri wrote:
>
> In my case script is like this:
> #!/bin/sh
> (cat $1 && echo ";") | sqlite3 my-db.sqlite
>
> Command to run it:
> ./my-sql-run sqls/my-query.sql
>
> I need to pass some parameter, like "select * from table where
> kind=%%MYPARAM%%"
Use echo or
On 2015/11/05 4:55 PM, Richard Hipp wrote:
> On 11/5/15, Zsb?n Ambrus wrote:
>> Dear SQLite,
>>
>> It seems that equality of numeric values isn't transitive, when both
>> integers and reals are involved. Here's an example output from the
>> shell, which shows that the numeric value in the 'c'
On Thu, Nov 5, 2015 at 3:36 PM, Zsb?n Ambrus wrote:
> It seems that equality of numeric values isn't transitive, when both
> integers and reals are involved.
See this really, really, really, really long thread on that topic from a
couple weeks ago for far, far, far more information than you
Dear SQLite,
It seems that equality of numeric values isn't transitive, when both
integers and reals are involved. Here's an example output from the
shell, which shows that the numeric value in the 'c' row is equal to
both the value in the 'b' and the 'd' rows, but the value in the 'b'
row isn't
On 11/05/2015 14:00, Clemens Ladisch wrote:
> Isn't the query itself passed through the command line? Show some example.
In my case script is like this:
#!/bin/sh
(cat $1 && echo ";") | sqlite3 my-db.sqlite
Command to run it:
./my-sql-run sqls/my-query.sql
I need to pass some parameter, like
I am looking for a way to have a parametrized query, when parameter is
passed through the command line. Much like a prepared statement and '?'
parameters.
Is this possible? I can't find anything like this in the sqlite3 man page.
Another way would be if sqlite had a function to access the
On 11/5/15, Zsb?n Ambrus wrote:
> Dear SQLite,
>
> It seems that equality of numeric values isn't transitive, when both
> integers and reals are involved. Here's an example output from the
> shell, which shows that the numeric value in the 'c' row is equal to
> both the value in the 'b' and the
IX, and openSUSE
http://mirrors.develooper.com/hpux/http://www.test-smoke.org/
http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/
-- next part --
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 490 bytes
Desc: OpenPGP digital signature
URL:
<http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20151105/8debea4e/attachment.pgp>
On 11/5/15, H.Merijn Brand wrote:
> I am not a list member, so please Cc me if you reply
>
> I was asked to post the problem here by charsbar, after I noted that
> DBD::SQLite started to fail on HP-UX 64bit IPF (Itanium 64bit)
>
> charsbar asked me to build sqlite3 from source and retry the fail
11 matches
Mail list logo