Re: IN in WHERE-clause is not being parsed correctly using SQL::Statement
[email protected] (Jens Rehsack) Tue, 12 May 2020 21:50:31 +0200
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <[email protected]> |
> Am 12.05.2020 um 21:49 schrieb Provensal, Jerome <[email protected]>: > > Hi Jens, > I was hoping that you could help me with an issue I’m having with SQL::Statement. > > My goal is to make transitioning from Sybase to MySQL a breeze by converting Sybase-like SQL statements into MySQL statements. > For that, I was planning on using SQL::Statement. > > While evaluating the module, I ran into an issue with the “IN” predicate. > I posted a “request for help” on SO: https://stackoverflow.com/questions/61743167/in-in-where-clause-is-not-being-parsed-correctly-using-sqlstatement <https://stackoverflow.com/questions/61743167/in-in-where-clause-is-not-being-parsed-correctly-using-sqlstatement> but so far without much luck. > I was hoping that going to the “source” (i.e. you) would help. > > Please help. Any insight would be greatly appreciated! > > Thanks! > > > This message, including any attachments, is intended only for the personal and confidential use of the designated recipient(s) to which it is addressed. This communication may contain information that constitutes attorney work product, is privileged, confidential or otherwise protected from disclosure. If the reader of this message is not the designated recipient, you are hereby notified that you have received this communication in error, and that any review, dissemination, retention, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us by e-mail reply to the sender, and discard any paper copies and delete all electronic files of this communication. Virtu Financial LLC <http://www.virtu.com/>. > > FOR CANADIAN RECIPIENTS: Securities products and services provided to Canadian investors are offered by Virtu ITG Canada Corp., a subsidiary of Virtu Financial, Inc. and member Canadian Investment Protection Fund (“CIPF”) and the Investment Industry Regulatory Organization of Canada (“IIROC”). In accordance with Canadian Anti-Spam Legislation, this communication has been sent to you on the basis that Virtu ITG Canada Corp. or its affiliates (collectively, “Virtu”) has implied consent from you as a member of the investment community, with whom Virtu has an established business relationship or through which your email address has been made available to Virtu. However, if you wish to stop receiving electronic communications from Virtu ITG Canada Corp. or its affiliates, please click here <mailto:[email protected]?subject=Unsubscribe%20request>. Please note that we may not be able to accommodate this request for existing clients, where Virtu is required under securities laws or any other applicable regulations to send certain electronic communications related to your account. > -- Jens Rehsack - [email protected]
signature.asc
(application/pgp-signature, 833 B)
-----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEGutaqWUYV+tvC/mCRJmWrtzlCp0FAl66/gcACgkQRJmWrtzl Cp1DIQ//ZzaL20FswhO8BQPKkrJRuiZ80ea3pw9wx2z+dcg3YWFNz19MP2eb5jGa V0e8Gpiz2b04gUnQj+5sbnzYHhTQujlLQUzVAJWF8L+DC/weGbh0UaZIzlNDZYhP xRKuIyIv8Xa9X1AL+js2uLhDZ2xSu5mug2xLBEVGz9ScfEPxEFVgEO5zAP9O1ctq tvwmZ4CddGvh55mqrcvS24tVD0hqrwT1hzXT+ZX6STjCEzDRC41t8BJgNPF/Hqev yWrET6I3d7Fr1ao/ZVuABdlahfPeFlkn0QUjgVRKu4we0iTKj0MqRk2JVc+8BPqU ahPwlk3Wgl5SGMYfB1D1tWrcp8ZmSLnppwKMMRRkaK6F3RjAZ5FiimtfnwfShfmb aQXDRAwZv5EjCfQqWqzSSqSI8RDJgzmJr8GbNUpiC3GGcMbQ6lx23TQmPuKqXl9t r9ovAEp4JPYtbizAelrQfpq3NKNsHq2LobeSIv7zI4Ks6R7sqXZ8BgV0bfc+vR8w DkDxNVD74MTwpQa4zAOmIP4lqGgD5nXHpRXwFurS2mDFjb+t6ZBUPMnfKf047CKU 0mBLX9DPxSvRZn1Px8Fk0R+TAG67YHbo64de0JYVGdxOWqplen52Nvxfh+XiMXJv Gr7n+/n6B8NtTvnc66ynS0cEB/vWku/pK47UWpHp5Pwgxg/DeZI= =U7dm -----END PGP SIGNATURE-----