mysql2

mysql2 copied to clipboard

I want to process a huge result set until certain condition is reached. However ```ruby result = conn.query("...", stream: true, cache_rows: false) result.each do |row| break end ``` does not...

fxn

Mysql2::Error: Incorrect integer value: '' for column 'id' at row 1

4

I am using **find_or_create_by** method for creating/upating the table entry with dynamic data. I am getting this error with auto_increment column in INSERT/UPDATE query : **Mysql2::Error: Incorrect integer value: ''...

selvamanisampath

cast_boolean does not work when using UNION

2

Hi, We recently discovered that when using the mysql2 gem (version: 0.4.10) that UNION SELECT statements provide results that do not cast tinyint columns to booleans successfully. You can find...

Samze

version 5.3.0 fails to build on Centos and ruby 2.7

10

Hi I'm unable to install version 0.5.3 on centos and ruby 2.7. I see following error. I'm interested in this version because it has keyword arguments fixes. As you can...

snehaso

Problem with Aborted_clients

5

I have a problem with mysql2 gem 0.3.21 with ever-increasing Aborted_clients values. My rails version is 3.2.22. sudo mysql -e "SHOW GLOBAL STATUS LIKE 'aborted_clients'"; +-----------------+-------+ | Variable_name | Value...

teacplusplus

Fix with --with-mysql-dir or --with-mysql-lib or --with-mysql-include

5

Hi there, As per @sodabrew recommendation I'm opening a new issue. I'm facing some error as in issue #952 with mysql2-0.5.3 when trying to install Redmine on CentOS 8. I...

glouton

0.2.x update for ruby 2.5

6

Mysql2 0.2.24 does not compile in ruby 2.5 due to extra check this ruby performs on rb_funcall. In particular, file result.c had a bug - wrong number (6) of arguments...

pavelvasev

MySQL2 LOCAL INFILE should be disabled by default.

1

MySQL LOCAL INFILE has been leveraged to perform file exfiltration in the [past][1]. Official [documentation][2] advise to disable this capability unless it is explicitly enabled. ``` To avoid LOAD DATA...

thypon

Segmentation fault at ruby 2.5.8p224

1

I'm currently trying to deploy to AWS Lambda. I'm using Ruby -v 2.5.8 and `mysql2` 0.5.2 version. ``` FROM lambci/lambda:build-ruby2.5 WORKDIR /var/task # Install MySQL RUN yum -y install mysql-devel...

theasteve

Multiple statements + Streaming may need a mysql2 API adjustment

6

The `:streaming` flag controls whether the `query` method should call the mysqlclient C API's `use_result` or `store_result` for the first result. When multiple results are enabled, this still happens for...

sodabrew