PageRenderTime 46ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/udf_unhex.q

#
text | 19 lines | 16 code | 3 blank | 0 comment | 0 complexity | 0b65d6d5d87685c865343cc15d34efc7 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. DESCRIBE FUNCTION unhex;
    2. 

  2. DESCRIBE FUNCTION EXTENDED unhex;
    3. 

  3. 

  4. -- Good inputs
    5. 

  5. 

  6. SELECT
    7. 

  7.   unhex('4D7953514C'),
    8. 

  8.   unhex('31323637'),
    9. 

  9.   unhex('61'),
    10. 

  10.   unhex('2D34'),
    11. 

  11.   unhex('')
    12. 

  12. FROM src limit 1;
    13. 

  13. 

  14. -- Bad inputs
    15. 

  15. SELECT
    16. 

  16.   unhex('MySQL'),
    17. 

  17.   unhex('G123'),
    18. 

  18.   unhex('\0')
    19. 

  19. FROM src limit 1;
    20. 

  20.