• Could you increase the max length of column name in a future release?

    By Tommy Valand 1 decade ago

    In com.ibm.domino.domsql.sqlite.driver.meta.DatabaseDefinition, the immutable field MAX_COLUMNNAMELENGTH is set to 16.

    It took me a while to track down why my column names were truncated.

    If there's no specific reason to have this limit, I hope you would consider removal of this restriction in future releases. The headroom for the select query is quite large.

    The maximum number of bytes in the text of an SQL statement is limited to SQLITE_MAX_SQL_LENGTH which defaults to 1000000. You can redefine this limit to be as large as the smaller of SQLITE_MAX_LENGTH and 1073741824.

    http://www.sqlite.org/limits.html

    (I have no idea how to create my own build/plugin from the source code)

    • 128...

      By Philippe Riand 1 decade ago

      I'll push that to 128 in the next release. I'll post it soon. Can you please test it for you particular use case?

      • Will do

        By Tommy Valand 1 decade ago

        I will update the plugin/test the app I'm working on tomorrow.

        Thanks :)

      • By Tommy Valand 1 decade ago

        I've updated the plugin, and the field names are no longer truncated.