summaryrefslogtreecommitdiff
path: root/test/scanners/sql/reference.in.sql
diff options
context:
space:
mode:
Diffstat (limited to 'test/scanners/sql/reference.in.sql')
-rw-r--r--test/scanners/sql/reference.in.sql109
1 files changed, 0 insertions, 109 deletions
diff --git a/test/scanners/sql/reference.in.sql b/test/scanners/sql/reference.in.sql
deleted file mode 100644
index e301570..0000000
--- a/test/scanners/sql/reference.in.sql
+++ /dev/null
@@ -1,109 +0,0 @@
-# All of the values below are valid MySQL syntax accoring to
-# the Reference Manual:
-# http://dev.mysql.com/doc/refman/5.1/en/language-structure.html
-# unless stated otherwise.
-
-# strings
-SELECT 'a string';
-SELECT "another string";
-
-SELECT _latin1'string';
-SELECT _latin1'string' COLLATE latin1_danish_ci;
-
-SELECT N'some text';
-SELECT n'some text';
-SELECT _utf8'some text';
-
-SELECT "\0\'\"''""\b\n\r\t\Z\\\%\_"; # "
-SELECT '\0\'\"''""\b\n\r\t\Z\\\%\_'; # '
-
-SELECT "\B\x"; # "
-SELECT '\B\x'; # '
-
-SELECT 'hello', '"hello"', '""hello""', 'hel''lo', '\'hello'; -- '
-SELECT "hello", "'hello'", "''hello''", "hel""lo", "\"hello"; -- "
-
-SELECT 'This\nIs\nFour\nLines';
-SELECT 'disappearing\ backslash';
-
-# numbers
-select 1221;
-select 0;
-select -32:
-
-select 294.42:
-select -32032.6809e+10;
-select 148.00;
-
-select 10e+10;
-select 10e10;
-
-# hexadecimal
-SELECT X'4D7953514C';
-SELECT 0x0a+0;
-SELECT 0x5061756c;
-SELECT 0x41, CAST(0x41 AS UNSIGNED);
-SELECT HEX('cat');
-SELECT 0x636174;
-insert into t (md5) values (0xad65);
-SELECT * FROM SomeTable WHERE BinaryColumn = CAST( x'a0f44ef7a52411de' AS BINARY );
-select x'000bdddc0e9153f5a93447fc3310f710', x'0bdddc0e9153f5a93447fc3310f710';
-
-SELECT TRUE, true, FALSE, false;
-SELECT NULL, null, nuLL, \N;
-SELECT \n; # invalid!
-
-# bit-field
-CREATE TABLE t (b BIT(8));
-INSERT INTO t SET b = b'11111111';
-INSERT INTO t SET b = b'1010';
-INSERT INTO t SET b = b'0101';
-SELECT b+0, BIN(b+0), OCT(b+0), HEX(b+0) FROM t;
-
-SET @v1 = b'1000001';
-SET @v2 = CAST(b'1000001' AS UNSIGNED), @v3 = b'1000001'+0;
-SELECT @v1, @v2, @v3;
-
-INSERT INTO my_table (phone) VALUES (NULL);
-INSERT INTO my_table (phone) VALUES ('');
-
-# schema object names
-SELECT * FROM `select` WHERE `select`.id > 100;
-
-CREATE TABLE `a``b` (`c"d` INT);
-SELECT 1 AS `one`, 2 AS 'two';
-
-select foo from foo;
-select `foo` from foo;
-select foo.bar from foo;
-select `foo`.bar from foo;
-select foo.`bar` from foo;
-select `foo.bar` from foo;
-select `foo`.`bar` from foo;
-
-# How to handle ANSI_QUOTES?
-CREATE TABLE "test" (col INT);
-SET sql_mode='ANSI_QUOTES';
-CREATE TABLE "test" (col INT);
-
-# identifiers
-SELECT * FROM my_table WHERE MY_TABLE.col=1;
-SHOW COLUMNS FROM `#mysql50#a@b`;
-
-# Function Name Parsing and Resolution
-
-
-SELECT COUNT(*) FROM mytable; -- the first reference to count is a function call
-CREATE TABLE count (i INT); -- whereas the second reference is a table name
-CREATE TABLE `count`(i INT); -- this too
-CREATE TABLE `count` (i INT); -- this too
-
-# IGNORE_SPACE
-SELECT COUNT(*) FROM mytable;
-SELECT COUNT (*) FROM mytable;
-
-# reserved words
-CREATE TABLE interval (begin INT, end INT); -- errror
-CREATE TABLE `interval` (begin INT, end INT); -- valid
-CREATE TABLE mydb.interval (begin INT, end INT); -- valid
-SELECT `foo`, `bar` FROM `baz` WHERE `bal` = `quiche`; -- valid