# 3904 Comparing an INTEGER Value to a FLOAT/DECIMAL Value Results in Automatic Truncation of FLOAT/DECIMAL

---

I wanted to reduce the amount of data in one of the tabkes I'm preparing for the demo of my query generator. I decided a sufficiently "random" method would be to divide the id column by 11 and wherever it was divisible exactly by 11 keep that. _ID is an autoinc (or more formally "_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL,)

My first attempt is below.

The first two columns are there to see what's going on because I was astounded that the entire table was selected. To give an idea the first row is

90909, 90909.1818181818

to me that says NOT EQUAL but there they are bold as brass! At this point I thought it looks as though when comparing a float to an integer the float is truncated.