I recently upgraded some software using SQL::Statement v 1.17 to 1.27 After fixing the obvious documented changes around the column_names struct I have come across a problem with a null buildCondition.

I upgraded further to 1.33 but the problem persists. Specifically,my code which only uses SQL::Statement to parse and rewrite SQL for an existing external database, returns the error:

Can't call method "buildCondition" on an undefined value at.... SQL::S
+tatement.pm line 121

[download]
When a where clause is used in the SQL.

Its not possible that all DB structures will be known to the perl subsystem and my program likes to know nothing about column specifics. Any ideas about how I can correct this behavior are greatly appreciated.

Regards, Randolph

Update Resolved- thanks

In reply to SQL::Statement1.33 appearsbuggy when only parsing SQL by Vlad, the IM-perler

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.