Skip to main content

    Data Warehouse

    Planned

    HashBytes returns incorrect length in Fabric DW

    Vote (7) Share
    Bob Duffy's profile image

    Bob Duffy on 22 Aug 2023 11:35:45

    HASHBYTES returns the wrong length on Fabric DW as compared to SqlPool or SqlDbEngine


    For example

    SELECT len(HASHBYTES('MD5', 'a'))


    returns 10 on Fabric which is not as expected but returns 16 on other SQL Editions.


    Note that the length issue affects all algorithms not just MD5




    Mariya Ali (administrator) on 31 Aug 2023 17:35:19

    Thanks for raising this issue. We are actively investigating further.