diff options
Diffstat (limited to 'test/scanners/sql/selects.expected.raydebug')
| -rw-r--r-- | test/scanners/sql/selects.expected.raydebug | 46 |
1 files changed, 46 insertions, 0 deletions
diff --git a/test/scanners/sql/selects.expected.raydebug b/test/scanners/sql/selects.expected.raydebug new file mode 100644 index 0000000..4bbd89d --- /dev/null +++ b/test/scanners/sql/selects.expected.raydebug @@ -0,0 +1,46 @@ +comment(--RANDOM SQL QUERIES THAT DO NOTHING INTERESTING) +comment(--Copyright (C\) 2009 - Keith Pitt <keith@keithpitt.com>) + +comment(--This program is free software: you can redistribute it and/or modify) +comment(--it under the terms of the GNU General Public License as published by) +comment(--the Free Software Foundation, either version 3 of the License, or) +comment(--(at your option\) any later version.) + +comment(--This program is distributed in the hope that it will be useful,) +comment(--but WITHOUT ANY WARRANTY; without even the implied warranty of) +comment(--MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the) +comment(--GNU General Public License for more details.) + +comment(--You should have received a copy of the GNU General Public License) +comment(--along with this program. If not, see <http://www.gnu.org/licenses/>.) + +reserved(SELECT) operator(*) reserved(FROM) (users)operator(;) + +reserved(select) operator(*) reserved(from) (users)operator(;) + +reserved(SELECT) string<delimiter(`)content(First Name)delimiter(`)>operator(,) string<delimiter(`)content(Last Name)delimiter(`)> reserved(FROM) string<delimiter(`)content(User Table)delimiter(`)>operator(;) + +reserved(select) (first_name)operator(,) (last_name) reserved(FROM) (users)operator(;) + +reserved(select) (first_name) operator(|)operator(|) string<delimiter(')content( )delimiter(')> operator(|)operator(|) (last_name) reserved(from) (users)operator(;) + +reserved(select) (first_name) operator(|)operator(|) string<delimiter(")content( )delimiter(")> operator(|)operator(|) (last_name) reserved(from) (users)operator(;) + +reserved(SELECT) operator(*) reserved(FROM) (users) reserved(JOIN) (companies) reserved(USING) operator(()(company_id)operator(\)) reserved(WHERE) (company_type) operator(=) string<delimiter(')content(Fortune 500)delimiter(')>operator(;) + +reserved(SELECT) operator(*) reserved(FROM) (users) reserved(WHERE) (name_first) reserved(LIKE) string<delimiter(')content(%Keith%)delimiter(')>operator(;) + +reserved(SELECT) reserved(CASE) reserved(WHEN) (foo)operator(.)(bar) operator(=) string<delimiter(')content(PY)delimiter(')> + reserved(THEN) string<delimiter(')content(BAR)delimiter(')> + reserved(ELSE) string<delimiter(')content(FOO)delimiter(')> + reserved(END) reserved(as) (bar_type)operator(,) + (user_id)operator(,) + (company_id)operator(,) + predefined(sum)operator(() + reserved(case) reserved(when) (foo)operator(.)(bar) operator(=) string<delimiter(')content(PY)delimiter(')> + reserved(then) operator(-)(amt) reserved(else) (amt) + reserved(end) + operator(\)) (over) operator(()reserved(order) reserved(by) (id)operator(,) (amt)operator(\)) reserved(as) (balance)operator(;) + +reserved(SELECT) (users)operator(.)operator(*)operator(,) operator(()reserved(SELECT) (company_name) reserved(FROM) (companies) reserved(WHERE) (company_id) operator(=) (users)operator(.)(company_id)operator(\)) reserved(FROM) (users)operator(;) + |