Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Comment on

( #3333=superdoc: print w/replies, xml ) Need Help??
However, selecting two or more columns and then fetching only one is a plain waste of resources. If you need to fetch only the first column of a query, I recommend that you be specific and ask for that column only.

In some databases (I'm thinking of Informix in particular), fields in the ORDER BY clause must be in the SELECT clause, so maybe you want to select the customer with the highest balance, but don't really need the balance itself, so you fetch the first field of the first row of this:

select customer, balance from customers order by balance desc

In reply to Re: DBI specification change by runrig
in thread DBI specification change by gmax

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, 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, 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.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Chatterbox?
    [choroba]: or nobody bothered...
    [choroba]: The problem was bigger, as the test tried to call a method that didn't exist anymore
    [marinersk]: :: ducking ::
    [choroba]: because, someone renamed the method, but didn't notice it was used in the test, as the test was skipped
    [marinersk]: Well, if the method doesn't exist, it would be hard to pass the test.
    [choroba]: later, someone removed the new method, as all its usage places were safe, but didn't notice the test still used the old name
    [choroba]: fortunately, it wasn't that hard to replace the method and fix a few remaining failures due to the changes we did to the codebase over the years
    [marinersk]: choroba Sounds like a process improvement opportunity; tests may not all need to be run, but they should all be compiled with perl -c before check-in/promotion happens.
    [choroba]: so, now I have the test, so I can start making changes in the code. Back to the original ticket, yay!
    [marinersk]: I definitely love it when my $current_taask=& taskPop(); if ($current_task eq $original_task) { } is true.

    How do I use this? | Other CB clients
    Other Users?
    Others having an uproarious good time at the Monastery: (15)
    As of 2017-05-25 15:12 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?