I can't seem to query on a field of type "numeric".
'id' => array( 'description' => "ID", 'type' => 'numeric', 'unsigned' => TRUE, 'precision' => 20, 'scale' => 0, 'not null' => TRUE, 'default' => 0, ),
if I do something simple like the following code, I don't get anything.
$query = db_select('tablename', 't') ->fields('t', array('nid')) ->condition('id', $id, '=');
However, if I execute the following query on PHPMyAdmin, I get a row.
SELECT * FROM `tablename` WHERE id = 195755377227337728;
I did try to type cast the id with
(int) $id, but that didn't work either.
Do you have any thought?