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

# · text · 29 lines · 26 code · 3 blank · 0 comment · 0 complexity · 6ad819e43c7b94e6987f3218c9897ab3 MD5 · raw file 

    

  1. drop table tstsrc;
    2. 

  2. create table tstsrc like src;
    3. 

  3. insert overwrite table tstsrc select key, value from src;
    4. 

  4. 

  5. SHOW LOCKS;
    6. 

  6. SHOW LOCKS tstsrc;
    7. 

  7. 

  8. LOCK TABLE tstsrc shared;
    9. 

  9. SHOW LOCKS;
    10. 

  10. SHOW LOCKS tstsrc;
    11. 

  11. SHOW LOCKS tstsrc extended;
    12. 

  12. 

  13. UNLOCK TABLE tstsrc;
    14. 

  14. SHOW LOCKS;
    15. 

  15. SHOW LOCKS extended;
    16. 

  16. SHOW LOCKS tstsrc;
    17. 

  17. lock TABLE tstsrc SHARED;
    18. 

  18. SHOW LOCKS;
    19. 

  19. SHOW LOCKS extended;
    20. 

  20. SHOW LOCKS tstsrc;
    21. 

  21. LOCK TABLE tstsrc SHARED;
    22. 

  22. SHOW LOCKS;
    23. 

  23. SHOW LOCKS extended;
    24. 

  24. SHOW LOCKS tstsrc;
    25. 

  25. UNLOCK TABLE tstsrc;
    26. 

  26. SHOW LOCKS;
    27. 

  27. SHOW LOCKS extended;
    28. 

  28. SHOW LOCKS tstsrc;
    29. 

  29. drop table tstsrc;
    30.