You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When filter some data where type of column bit(1) (like true, false) and filter true then request return nothing.
$db->run("SELECT t2.`comment_id` AS `comment_id`, t2.`text` AS `text`, BIT_COUNT(t2.`public`) AS `public`, t2.`updated` AS `updated`, t2.`created` AS `created`, BIT_COUNT(t2.`archived`) AS `archived`FROM `tasks_comments` AS t2WHERE t2.`task_id` = ? AND (t2.`public` = ?)ORDER BY t2.`comment_id` ASC", 24408, true);
But when make request without include value of filter in function, request return correct data
$db->run("SELECT t2.`comment_id` AS `comment_id`, t2.`text` AS `text`, BIT_COUNT(t2.`public`) AS `public`, t2.`updated` AS `updated`, t2.`created` AS `created`, BIT_COUNT(t2.`archived`) AS `archived`FROM `tasks_comments` AS t2WHERE t2.`task_id` = ? AND (t2.`public` = 1)ORDER BY t2.`comment_id` ASC", 24408);
When filter some data where type of column bit(1) (like true, false) and filter
true
then request return nothing.But when make request without include value of filter in function, request return correct data
How I understand, it's bug because
All values are treated as PDO::PARAM_STR.
When set filter
false
, it works current. But withtrue
incorrect.How can fix it? When need to use as argument in function?
PHP 7.4. MySQL 8.0
The text was updated successfully, but these errors were encountered: