On Wednesday, March 30, 2016 at 1:38:42 PM UTC-7, Henry K wrote: > > Wasn't sure if it should go on github or here, so now its on both: > https://github.com/jeremyevans/sequel/issues/1163 > > Complete Description of Issue > > `(13.430000s) SELECT COLUMN1, COLUMN2, COLUMN3, COLUMN4 FROM TABLE WHERE > COLUMN1 > '2016-03-20' AND COLUMN1< '2016-03-26' {:level=>:info, > :file=>"WORKINGDIR/logstash-2.2.2/vendor/bundle/jruby/1.9/gems/sequel-4.31.0/lib/sequel/database/logging.rb", > > :line=>"72", :method=>"log_each"}←[0m > > Exception when executing JDBC query {:exception=># '3' is outside valid > range for the datatype INTEGER.>, :level=>:warn, > :file=>"WORKINGDIR/logstash-2.2.2/vendor/bundle/jruby/1.9/gems/logstash-i > nput-jdbc-3.0.0/lib/logstash/plugin_mixins/jdbc.rb", :line=>"201", > :method=>"execute_statement"}←[0m` > Simplest Possible Self-Contained Example Showing the Bug > > Trying to select data from a database (utilizing Sequel in the Logstash > JDBC input plugin), and one column has IP's stored as integers...some are > larger than 2147483648 (Max size for INT in MySQL). I'm not sure it should > be returning this error. I can query the data just fine in something like > MySQL Workbench. >
I can see why this was posted on GitHub Issues, as it does seem like a bug. However, from the exception you are getting, it doesn't seem like a bug in Sequel, but a bug in the jdbc/mysql driver. It's hard to say for sure unless you provide a self contained example. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
