CAST function get removed after compiling the SQL expression

[Siddhesh Naik]

Hi,

I am compiling SQL expression using IBM_DB_SA dialect. In my sql expression I am using the CAST function in select query. When I compile that expression , compiler return query without CAST.

Before compile: SELECT concat (CAST(:param_1 AS VARCHAR), CUSTOMER_ID) AS concat_1 FROM "CUSTOMERS"

After Compile:   SELECT concat (?,  CUSTOMER_ID) AS concat_1 FROM "CUSTOMERS"

Please help.

[Siddhesh Naik]

Sample program to recreate issue:

import ibm_db_sa
from sqlalchemy.sql import select
from sqlalchemy.sql import literal, literal_column
from sqlalchemy.sql.expression import cast
from sqlalchemy import String
from sqlalchemy.sql.functions import func
from sqlalchemy import Table, MetaData

column_list = [cast(literal("CUSTOMER_ID"), String),
               func.concat(cast(literal("CUSTOMER_NAME: "), String), literal_column("CUSTOMER_NAME"))]
table_name = Table("CUSTOMERS", MetaData())
query = select(column_list, distinct=False).select_from(table_name)

query_str = query.compile(dialect=ibm_db_sa.dialect())
print(query)
print("param list: ", query_str.params)
print(query_str.__str__().replace("\n", ""))

[Abhinav Radke]

Hi Siddhesh,

Thankyou for your sample program.

I am able to reproduce. I am working on it.

Thanks,

Abhinav