Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Comment on

( #3333=superdoc: print w/replies, xml ) Need Help??

That would surely fix the problem in my case, but it's a very incomplete fix. Simply removing the quotes is too minimalistic. That fix would remove some (maybe all) false negatives, but would introduce false positives. Specifically, the following name column pairs become indistinguishable:

  • "foo.bar".baz and foo."bar.baz"
  • "foo.bar" and foo.bar
  • "*" and *

The simplest solution might be to *add* quotes everywhere internally.

That said, I'll use the previously suggested SELECT * rather than applying this incomplete patch.


In reply to Re^4: SQL::Statement confusing literals and identifiers (now with workaround!) by ikegami
in thread SQL::Statement confusing literals and identifiers by ikegami

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?
    [ambrus]: Corion: Maybe I'm not explaining the situation clearly enough, maybe I'm just wrong and he's right and we can compute that data,
    [ambrus]: but hopefully he just wants to think it through himself his way and understand why it's impossible rather than blindly accept my argument.
    choroba quickly peeps in from a café
    [1nickt]: Good morning Monks of the world!
    [Corion]: ambrus: Yeah, hopefully it's that
    [1nickt]: I am stumped, maybe someone brainy can clear my mind?
    [1nickt]: This code does what I expect on the CLI: perl -wE 'sub x { 0 and 1 } say x()'
    [1nickt]: (prints "0")

    How do I use this? | Other CB clients
    Other Users?
    Others browsing the Monastery: (10)
    As of 2017-12-12 13:34 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?
      What programming language do you hate the most?




















      Results (332 votes). Check out past polls.

      Notices?