Fix Long Table Name Error Detection and Add Diagnostic Function

Fixes an error detection when a table name is too long. Provide a diagnostic telling the maximum length. Add a new function getMaxTableNameLengthForDatabase. #70810 (Yarik Briukhovetskyi).