Project

General

Profile

Download (8.67 KB)

Bug #27134 » FIELD_IN_SET-concatenation-query.txt

$clauseArray to reproduce the bug - Georg Schönweger, 2011-05-30 10:29

 
Array
(
[parameters] => Array
(
)
[type] => SELECT
[STRAIGHT_JOIN] =>
[SELECT] => Array
(
[0] => Array
(
[comments] =>
[distinct] =>
[type] => field
[table] => fe_users
[field] => *
)
)
[FROM] => Array
(
[0] => Array
(
[table] => fe_users
)
)
[WHERE] => Array
(
[0] => Array
(
[sub] => Array
(
[0] => Array
(
[sub] => Array
(
[0] => Array
(
[sub] => Array
(
[0] => Array
(
[modifier] =>
[func] => Array
(
[type] => FIND_IN_SET
[str] => Array
(
[0] => 4
)
[table] => fe_users
[field] => usergroup
)
[comparator] =>
)
[1] => Array
(
[operator] => AND
[modifier] =>
[table] => fe_users
[field] => uid
[calc] =>
[comparator] => =
[value] => Array
(
[0] => 2
[1] => '
)
)
)
)
[1] => Array
(
[operator] => AND
[modifier] =>
[table] => fe_users
[field] => uid
[calc] =>
[comparator] => =
[value] => Array
(
[0] => 1
[1] => '
)
)
)
)
[1] => Array
(
[operator] => AND
[modifier] =>
[func] => Array
(
[type] => FIND_IN_SET
[str] => Array
(
[0] => 5
)
[table] => fe_users
[field] => usergroup
)
[comparator] =>
)
)
)
[1] => Array
(
[operator] => AND
[sub] => Array
(
[0] => Array
(
[modifier] =>
[table] => fe_users
[field] => tx_extbase_type
[calc] =>
[comparator] => =
[value] => Array
(
[0] => 0
[1] => '
)
)
)
)
[2] => Array
(
[operator] => AND
[modifier] =>
[table] => fe_users
[field] => deleted
[calc] =>
[comparator] => =
[value] => Array
(
[0] => 0
)
)
[3] => Array
(
[operator] => AND
[modifier] =>
[table] => fe_users
[field] => disable
[calc] =>
[comparator] => =
[value] => Array
(
[0] => 0
)
)
[4] => Array
(
[operator] => AND
[modifier] =>
[table] => fe_users
[field] => starttime
[calc] =>
[comparator] => <=
[value] => Array
(
[0] => 1306743720
)
)
[5] => Array
(
[operator] => AND
[sub] => Array
(
[0] => Array
(
[modifier] =>
[table] => fe_users
[field] => endtime
[calc] =>
[comparator] => =
[value] => Array
(
[0] => 0
)
)
[1] => Array
(
[operator] => OR
[modifier] =>
[table] => fe_users
[field] => endtime
[calc] =>
[comparator] => >
[value] => Array
(
[0] => 1306743720
)
)
)
)
)
[parseString] =>
)
    (1-1/1)