fix: Handle merging of SQL types when character column lengths are less than the max

[BuzzCutNorman]

This is an attempt to fix merge_sql_type to handle instances when all passed character column lengths are less than max. SDK 0.13.1 needs PR #1168 present to reach this fix.

fixes #1170

---

📚 Documentation preview 📚: https://meltano-sdk--1172.org.readthedocs.build/en/1172/

[BuzzCutNorman]

@edgarrmondragon @aaronsteers I merged the latest main containing PR 1168 into this branch ran my tests locally. The code is working as planned and I am past the error:

ValueError: Unable to merge sql types: VARCHAR(64) COLLATE "SQL_Latin1_General_CP1_CI_AS", VARCHAR(64)

[BuzzCutNorman]

I just ran into an issue with this. If the current_type.length is None since it is set to max and the opt_len is anything greater than 0 you get a TypeError.

or (opt_len >= current_type.length) 
TypeError: '>=' not supported between instances of 'int' and 'NoneType' 

[BuzzCutNorman]

I put in place a fix for the TypeError that I ran into.

cc: @edgarrmondragon @aaronsteers @cjohnhanson

[codecov]

Codecov Report

Merging #1172 (ecda7b5) into main (61eecbf) will increase coverage by 0.01%.
The diff coverage is 100.00%.

@@            Coverage Diff             @@
##             main    #1172      +/-   ##
==========================================
+ Coverage   85.71%   85.73%   +0.01%     
==========================================
  Files          57       57              
  Lines        4691     4689       -2     
  Branches      802      801       -1     
==========================================
- Hits         4021     4020       -1     
  Misses        481      481              
+ Partials      189      188       -1     

Impacted Files	Coverage Δ
singer_sdk/connectors/sql.py	85.45% <100.00%> (+0.25%)	⬆️

📣 We’re building smart automated test selection to slash your CI/CD build times. Learn more

[edgarrmondragon]

Thanks @BuzzCutNorman and sorry for the delay in reviews!

[BuzzCutNorman]

@edgarrmondragon, no worries. Thanks for all your great guidance.