What I mean to test is the bug that (as it turned out) was due to an older version of Perl. The test code is a much trimmed down version of some "real" code and as such may carry some baggage from the original context.

Although I'm pretty new to SQL, my reading of the MySQL and SQLite documentation indicates that the ALL is implied and optional, but that the * or some other select expression is required. In the original code there was a WHERE clause so the ALL was a nod to improved understanding by a neophyte (me). The ALL didn't affect the test nor cause undue visual clutter or confusion so it didn't get taken out.

DWIM is Perl's answer to Gödel

In reply to Re^2: Nastyness between DBI and Test::More by GrandFather
in thread Nastyness between DBI and Test::More by GrandFather

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.