diff options
Diffstat (limited to 'test/scanners/sql/reference.in.sql')
-rw-r--r-- | test/scanners/sql/reference.in.sql | 109 |
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 |