Advertisement
Guest User

Regexp Conditional Error Messages

a guest
Oct 4th, 2013
2,813
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.89 KB | None | 0 0
  1. QUERY: SELECT 1 REGEXP ''
  2. ERROR: Got error 'empty (sub)expression' FROM REGEXP
  3.  
  4. QUERY: SELECT 1 REGEXP '('
  5. ERROR: Got error 'parentheses not balanced' FROM REGEXP
  6.  
  7. QUERY: SELECT 1 REGEXP '['
  8. ERROR: Got error 'brackets ([ ]) not balanced' FROM REGEXP
  9.  
  10. QUERY: SELECT 1 REGEXP '\\'
  11. ERROR: Got error 'trailing backslash (\)' FROM REGEXP
  12.  
  13. QUERY: SELECT 1 REGEXP '*'
  14. ERROR: Got error 'repetition-operator operand invalid' FROM REGEXP
  15.  
  16. QUERY: SELECT 1 REGEXP 'a{1,1,1}'
  17. ERROR: Got error 'invalid repetition count(s)' FROM REGEXP
  18.  
  19. QUERY: SELECT 1 REGEXP '[a-9]'
  20. ERROR: Got error 'invalid character range' FROM REGEXP
  21.  
  22. QUERY: SELECT 1 REGEXP 'a{1,'
  23. ERROR: Got error 'braces not balanced' FROM REGEXP
  24.  
  25. QUERY: SELECT 1 REGEXP '[[.ab.]]'
  26. ERROR: Got error 'invalid collating element' FROM REGEXP
  27.  
  28. QUERY: SELECT 1 REGEXP '[[:ab:]]'
  29. ERROR: Got error 'invalid character class' FROM REGEXP
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement