SUBSTRING() function must have integers for arg2 and arg3.

Hi,

I'm unsure if this is the correct project to post this to but seeing as it appears to be SQL server specific I thought I would start here. It appears that after installing sqlsrv with Drupal 7, and then setting up the Views module (version 7.x-3.0-beta3), that some of the default Views do not work.

For example, enabling the 'Glossary' view causes the following:

Debug:
'Exception: SQLSTATE[07002]: [Microsoft][SQL Server Native Client 10.0]COUNT field incorrect or syntax error'
in views_plugin_query_default->execute() (line 1356 of C:\inetpub\sites\-\sites\all\modules\views\plugins\views_plugin_query_default.inc).
Error message


SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Argument data type nvarchar is invalid for argument 3 of substring function.

I've run the SQL profiler while this is happening and found the following query being created:

exec sp_executesql N'SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
drupal_node node
INNER JOIN drupal_users users ON node.uid = users.uid
WHERE ( (( (SUBSTRING(node.title, 1, @P1) = @P2) )) )) subquery',N'@P1 nvarchar(1),@P2 nvarchar(1)',N'1',N'A'

It's easy to see here what is wrong; @P1 is being declared as nvarchar(1) which is incompatible with the type expected for the third parameter of SUBSTRING - it should be a numerical value. Simply changing @P1 to type int and running the query manually works.

I've only been playing with Drupal for about a week so I'm not at all up to play with it's internals yet.. I've had a big of a dig through the code but the DB abstractions make it difficult to find why this is happening without knowing a whole lot more about the codebase. Is this likely to be a sqlsrv issue or a Views issue?

Any help or tips would be great, I'll keep looking too and report back if I find anything. Cheers.