Добрый вечер, столкнулся с проблемой. что при подключение чере ODBC скрипт может содержать только определенное количество символов, как с этим бороться?
Код вызывает ошибку Type mismatch
К примеру
Этот скрипт работает нормально:
select email 'Email', count(case when email like '%lamoda.ru' then null else email end), email,email,email,email, email,email, email,email, email,email, email,email, email,email, email,email, email,email, 'email count' from marketing_subscriber limit 5
А тут выдаёт ошибку
select email 'Email', count(case when email like '%lamoda.ru' then null else email end), email,email,email,email, email,email, email,email, email,email, email,email, email,email, email,email, email,email, email,email 'email count' from marketing_subscriber limit 5
Код вызывает ошибку Type mismatch
К примеру
Этот скрипт работает нормально:
select email 'Email', count(case when email like '%lamoda.ru' then null else email end), email,email,email,email, email,email, email,email, email,email, email,email, email,email, email,email, email,email, 'email count' from marketing_subscriber limit 5
А тут выдаёт ошибку
select email 'Email', count(case when email like '%lamoda.ru' then null else email end), email,email,email,email, email,email, email,email, email,email, email,email, email,email, email,email, email,email, email,email 'email count' from marketing_subscriber limit 5
