Bug #111731 for DBD-Teradata: Negative Integer

There is a mismatch in one of the layers between perl and Teradata such that they have different ideas about SQL INTEGERs. This example from the perl debugger demonstrates the problem: DB<17> x $dbh->selectall_arrayref(q{select cast(-1 as integer) as foo}) 0 ARRAY(0x18a0790) 0 ARRAY(0x2295a38) 0 4294967295 <== Should be -1 Curiously, that's (2 * 2147483647) + 1, or one more than twice Td's max INTEGER value; I was expecting one less instead of one more. Craig Frooninckx, Manager American Express | Global Compliance & Ethics 18550 N 56th St | Phoenix, AZ 85054 O: 602-537-8966 | M: 602-525-1377 | craig.frooninckx@aexp.com<mailto:craig.frooninckx@aexp.com> [cid:image004.jpg@01D0AF99.5A30D070] American Express made the following annotations ****************************************************************************** "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you." American Express a ajouté le commentaire suivant le Ce courrier et toute pièce jointe qu'il contient sont réservés au seul destinataire indiqué et peuvent renfermer des renseignements confidentiels et privilégiés. Si vous n'êtes pas le destinataire prévu, toute divulgation, duplication, utilisation ou distribution du courrier ou de toute pièce jointe est interdite. Si vous avez reçu cette communication par erreur, veuillez nous en aviser par courrier et détruire immédiatement le courrier et les pièces jointes. Merci. ******************************************************************************