fix: Cast SQL Server len() expression to BIGINT#1590
Conversation
|
/gcbrun |
|
Neil, This resolves the issue of string lengths adding up over the size of the integer. However, even int32 columns have the same issue. It may be best to focus on the issues raised by customers - so we know we are fixing things that need to be fixed. Thank you. Sundar Mudupalli |
This was raised by a customer, but directly to me and I created the issue on their behalf. The same customer did raise the "int32 columns" issue with me (#1584) but I realised we already had an option to cater for it so closed it. I think we should automate the option in the future because it is unnecessary but I haven't created an issue for that (yet). |
Description of changes
Casts SQL Server len/datalength expressions to bigint to prevent column validations on large tables from overflowing the int data type.
Issues to be closed
Closes #1589
Checklist
CONTRIBUTINGGuide.tests/local_check.shscript)