dev.ed.am
sqlite3cc
Go to the previous open issue
Go to the previous issue (open or closed)
star_faded.png
Please log in to bookmark issues
icon_project.png sqlite3cc / Open Bug report #1 Update on row open in a query fails without error
action_vote_minus_faded.png
0
Votes
 action_vote_plus_faded.png
Go to the next issue (open or closed)
Go to the next open issue
Issue basics
  • Type of issue
    Bug report
  • Targetted for
    0.2 release
  • Status
    Closed
  • Progress
  • Priority
    Not determined
User pain
  • Type of bug
    Not triaged
  • Likelihood
    Not triaged
  • Effect
    Not triaged
Affected by this issue (0)
There are no items
People involved
Times and dates
  • Posted at
  • Last updated
Issue details
  • Resolution
    CAN'T REPRODUCE
  • Reproducability
    Not determined
  • Severity
    Not determined
Attachments (0)
There is nothing attached to this issue
Duplicate issues (0)
This issue does not have any duplicates
Show / hide more details »
Description
While iterating through the results of a query, an update against the row being iterated over fails (I assume because of row/table locking). But no error is thrown and the result code of the operation is that of a success!

If this is sqlite3's behaviour, then so be it, I guess. But it is not behaviour that sqlite3cc should exhibit otherwise.
Steps to reproduce this issue
<source lang="c++">// perform query
sqlite::query q( m_db,
"SELECT whatever "
"FROM table "
"WHERE id = ?" );
q << id;
sqlite::query::iterator i = q.begin();
if( i != q.end() )
{
// while query is open, perform update on same row
sqlite::command c( m_db,
"UPDATE table "
"SET whatever = 'whatever' "
"WHERE id = ?" );
c << id << sqlite::exec; // DOES NOTHING, BUT THERE'S NO ERROR
}</source>
Todos (0 / 0)
Options
Issue created



Selected syntax: Markdown  

Don't worry about URLs - they will automatically be transformed to links.
See more formatting tips in MarkdownFormatting.

To create a bulleted list, start one or more lines with a star ("* bulleted list item"). You can create a numbered list by using the hash/pund sign instead ("# numbered list item").
See more formatting tips in MarkdownFormatting.

The Bug Genie will automatically add new lines when you add two new lines in your text, whereas one new line is used for formatting as you type. To force a new line, use the <br> tag: "There is a new<br>line here".
See more formatting tips in WikiFormatting.

Cancel
I am unable to reproduce this error. In particular, if I compile the example program that you provided, it works just fine!

What version of sqlite3cc are you using?



Selected syntax: Markdown  

To auto-link to an existing issue, write "issue", "bug", "ticket" or the issue type (like "bug report" or "enhancement") followed by the issue number (ex: "ticket #3" or "bug report MYPROJ-1"). Enclose sourcecode samples between two "~~~~" lines.
See more formatting tips in MarkdownFormatting.

Don't worry about URLs - they will automatically be transformed to links.
See more formatting tips in MarkdownFormatting.

To create a bulleted list, start one or more lines with a star ("* bulleted list item"). You can create a numbered list by using the hash/pund sign instead ("# numbered list item").
See more formatting tips in WikiFormatting.

Cancel
The issue was updated with the following change(s):
  • The status has been updated, from New to Closed.
  • The resolution has been updated, from Not determined to CAN'T REPRODUCE.



Selected syntax: Markdown  

To auto-link to an existing issue, write "issue", "bug", "ticket" or the issue type (like "bug report" or "enhancement") followed by the issue number (ex: "ticket #3" or "bug report MYPROJ-1"). Enclose sourcecode samples between two "~~~~" lines.
See more formatting tips in MarkdownFormatting.

Code samples are best presented between two "~~~~"-lines. The Bug Genie can automatically apply syntax highlighting with support for over 100 languages! (<source lang="php"><?php echo "fu"; ?></source>)
See more formatting tips in MarkdownFormatting.

If you have certain text you don't want to be formatted, enclose it in <nowiki></nowiki> tags: "'''formatted''' text <nowiki>'''non-formatted''' text</nowiki>.
See more formatting tips in WikiFormatting.

Cancel
The issue was updated with the following change(s):
  • The milestone has been updated, from Not determined to 0.2 release.
footer_logo.png The Bug Genie 4.3.1 | Support | Feedback spinning_16.gif