1

Topic: What for an error in SQL?

When you write request:

SELECT t.*
FROM transshipment t
WHERE t.id IN (168839,168842,168878,168958,169134,169315)

Deduces 6 records.
And when the same you transfer through parameter:

SELECT t.*
FROM transshipment t
WHERE t.id IN (:a)

Then a: = 168839,168842,168878,168958,169134,169315
That produces only the first record.
???

2

Re: What for an error in SQL?

When you transfer parameter the request turns out not such as it is shown. And here the such:

SELECT t.*
FROM transshipment t
WHERE t.id IN (' 168839,168842,168878,168958,169134,169315 ')

Agree, slightly not that.
If you very much would like to transfer the CSV-list as parameter, it is necessary to use function:

SELECT t.*
FROM transshipment t
WHERE FIND_IN_SET (t.id:a)

However it is the guaranteed index-ftopku and accordingly .

3

Re: What for an error in SQL?

Akina;
Made simply insert in the SQL query text.