diff options
Diffstat (limited to 'mysql-test/xml/tests')
27 files changed, 457 insertions, 0 deletions
diff --git a/mysql-test/xml/tests/sel000004.xml b/mysql-test/xml/tests/sel000004.xml new file mode 100644 index 00000000000..9c28c632c32 --- /dev/null +++ b/mysql-test/xml/tests/sel000004.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000004"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Simple arithmetic.</description> + <description>Testing MOD(), SIGN(), and arithmetic grouping.</description> + + <resultfile name="r/3.23/sel000004.result"> + <sql>SELECT 1+1,1-1,1+1*2,8/5,8%5,MOD(8,5),MOD(8,5)|0,-(1+1)*-2,SIGN(-5)</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000005.xml b/mysql-test/xml/tests/sel000005.xml new file mode 100644 index 00000000000..0bcddb2fbb6 --- /dev/null +++ b/mysql-test/xml/tests/sel000005.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000005"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Numeric functions.</description> + <description>Testing FLOOR(), CEILING(), ROUND().</description> + + <resultfile name="r/3.23/sel000005.result"> + <sql>SELECT FLOOR(5.5),FLOOR(-5.5),CEILING(5.5),CEILING(-5.5),ROUND(5.5),ROUND(-5.5)</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000006.xml b/mysql-test/xml/tests/sel000006.xml new file mode 100644 index 00000000000..3059f8bb7df --- /dev/null +++ b/mysql-test/xml/tests/sel000006.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000006"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Numeric functions.</description> + <description>Testing ROUND(); hundreths precision.</description> + + <resultfile name="r/3.23/sel000006.result"> + <sql>SELECT ROUND(5.64,1),ROUND(5.64,2),ROUND(5.64,-1),ROUND(5.64,-2)</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000007.xml b/mysql-test/xml/tests/sel000007.xml new file mode 100644 index 00000000000..8f8bb7162c3 --- /dev/null +++ b/mysql-test/xml/tests/sel000007.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000007"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Numeric functions.</description> + <description>Testing TRUNCATE().</description> + + <resultfile name="r/3.23/sel000007.result"> + <sql>SELECT TRUNCATE(52.64,1),TRUNCATE(52.64,2),TRUNCATE(52.64,-1),TRUNCATE(52.64,-2)</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000008.xml b/mysql-test/xml/tests/sel000008.xml new file mode 100644 index 00000000000..70a54a15d5b --- /dev/null +++ b/mysql-test/xml/tests/sel000008.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000008"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Numeric functions.</description> + <description>Testing ABS(), LOG(), LOG10(), EXP(), SQRT(), POW(), RAND(), POWER().</description> + + <resultfile name="r/3.23/sel000008.result"> + <sql>SELECT ABS(-10),LOG(EXP(10)),EXP(LOG(SQRT(10))*2),POW(10,LOG10(10)),RAND(999999),RAND(),POWER(2,4)</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000009.xml b/mysql-test/xml/tests/sel000009.xml new file mode 100644 index 00000000000..0c79f032112 --- /dev/null +++ b/mysql-test/xml/tests/sel000009.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000009"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Numeric functions.</description> + <description>Testing PI(), SIN(), COS(), TAN(), COT(), ASIN(), ACOS(), ATAN().</description> + + <resultfile name="r/3.23/sel000009.result"> + <sql>SELECT PI(),SIN(PI()/2),COS(PI()/2),TAN(PI()),COT(1),ASIN(1),ACOS(0),ATAN(1)</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000010.xml b/mysql-test/xml/tests/sel000010.xml new file mode 100644 index 00000000000..6954fef0750 --- /dev/null +++ b/mysql-test/xml/tests/sel000010.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000010"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Numeric bitwise comparisons.</description> + <description>Testing |, &, BIT_COUNT().</description> + + <resultfile name="r/3.23/sel000010.result"> + <sql>SELECT 1 | (1+1),5 & 3,BIT_COUNT(7)</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000011.xml b/mysql-test/xml/tests/sel000011.xml new file mode 100644 index 00000000000..5c981b2f85a --- /dev/null +++ b/mysql-test/xml/tests/sel000011.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000011"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Numeric bitmoving comparisons.</description> + <description>Testing <<, >>.</description> + + <resultfile name="r/3.23/sel000011.result"> + <sql>SELECT 1 << 32,1 << 63, 1 << 64, 4 >> 2, 4 >> 63, 1<< 63 >> 60</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000012.xml b/mysql-test/xml/tests/sel000012.xml new file mode 100644 index 00000000000..7abcc498164 --- /dev/null +++ b/mysql-test/xml/tests/sel000012.xml @@ -0,0 +1,16 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000012"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Numeric floating point.</description> + + <resultfile name="r/3.23/sel000012.result"> + <sql>SELECT 10,10.0,10.,.1e+2,100.0e-1</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000013.xml b/mysql-test/xml/tests/sel000013.xml new file mode 100644 index 00000000000..fbeca6663fc --- /dev/null +++ b/mysql-test/xml/tests/sel000013.xml @@ -0,0 +1,16 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000013"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Numeric floating point.</description> + + <resultfile name="r/3.23/sel000013.result"> + <sql>SELECT 6e-05, -6e-05, --6e-05, -6e-05+1.000000</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000014.xml b/mysql-test/xml/tests/sel000014.xml new file mode 100644 index 00000000000..96a51e671fc --- /dev/null +++ b/mysql-test/xml/tests/sel000014.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000014"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Numerics.</description> + <description>Testing pos/neg and zero padding.</description> + + <resultfile name="r/3.23/sel000014.result"> + <sql>SELECT 0,256,00000000000000065536,2147483647,-2147483648,2147483648,+4294967296</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000015.xml b/mysql-test/xml/tests/sel000015.xml new file mode 100644 index 00000000000..a339330e6b1 --- /dev/null +++ b/mysql-test/xml/tests/sel000015.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000015"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Numerics.</description> + <description>Testing big numbers.</description> + + <resultfile name="r/3.23/sel000015.result"> + <sql>SELECT 922337203685477580,92233720368547758000</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000016.xml b/mysql-test/xml/tests/sel000016.xml new file mode 100644 index 00000000000..ae971e6576a --- /dev/null +++ b/mysql-test/xml/tests/sel000016.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000016"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Numerics.</description> + <description>Testing big negative numbers.</description> + + <resultfile name="r/3.23/sel000016.result"> + <sql>SELECT -922337203685477580,-92233720368547758000</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000017.xml b/mysql-test/xml/tests/sel000017.xml new file mode 100644 index 00000000000..9d06d640ac3 --- /dev/null +++ b/mysql-test/xml/tests/sel000017.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000017"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Numerics.</description> + <description>Testing big pos/neg numbers.</description> + + <resultfile name="r/3.23/sel000017.result"> + <sql>SELECT 9223372036854775807,-009223372036854775808</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000018.xml b/mysql-test/xml/tests/sel000018.xml new file mode 100644 index 00000000000..909728599fa --- /dev/null +++ b/mysql-test/xml/tests/sel000018.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000018"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Numerics.</description> + <description>Testing big pos/neg numbers.</description> + + <resultfile name="r/3.23/sel000018.result"> + <sql>SELECT +9999999999999999999,-9999999999999999999</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000019.xml b/mysql-test/xml/tests/sel000019.xml new file mode 100644 index 00000000000..e0286ae2db7 --- /dev/null +++ b/mysql-test/xml/tests/sel000019.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000019"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Numerics.</description> + <description>Testing DEGREES(), RADIANS().</description> + + <resultfile name="r/3.23/sel000019.result"> + <sql>SELECT DEGREES(PI()),RADIANS(360)</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000020.xml b/mysql-test/xml/tests/sel000020.xml new file mode 100644 index 00000000000..41ad5981cb9 --- /dev/null +++ b/mysql-test/xml/tests/sel000020.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000020"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Strings.</description> + <description>Testing string comparisons; STRCMP(), =, >, >=, <=, !=.</description> + + <resultfile name="r/3.23/sel000020.result"> + <sql>SELECT 0=0,1>0,1>=1,1<0,1<=0,1!=0,STRCMP("abc","abcd"),STRCMP("b","a"),STRCMP("a","a")</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000021.xml b/mysql-test/xml/tests/sel000021.xml new file mode 100644 index 00000000000..ba2e8149abd --- /dev/null +++ b/mysql-test/xml/tests/sel000021.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000021"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Strings.</description> + <description>Testing string comparisons; =, >, >=, <=, <>.</description> + + <resultfile name="r/3.23/sel000021.result"> + <sql>SELECT "a"<"b","a"<="b","b">="a","b">"a","a"="A","a"<>"b"</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000022.xml b/mysql-test/xml/tests/sel000022.xml new file mode 100644 index 00000000000..3dca0eb9b7f --- /dev/null +++ b/mysql-test/xml/tests/sel000022.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000022"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Strings.</description> + <description>Testing string comparisons; =, >, <=.</description> + + <resultfile name="r/3.23/sel000022.result"> + <sql>SELECT "a "="A", "A "="a", "a " <= "A b"</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000023.xml b/mysql-test/xml/tests/sel000023.xml new file mode 100644 index 00000000000..7cceb4aabca --- /dev/null +++ b/mysql-test/xml/tests/sel000023.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000023"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Strings.</description> + <description>Testing string comparisons; LIKE, NOT LIKE, '%'.</description> + + <resultfile name="r/3.23/sel000023.result"> + <sql>SELECT "abc" LIKE "a%", "abc" NOT LIKE "%d%", "a%" LIKE "a\%","abc%" LIKE "a%\%","abcd" LIKE "a%b_%d", "a" LIKE "%%a","abcde" LIKE "a%_e","abc" LIKE "abc%"</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000024.xml b/mysql-test/xml/tests/sel000024.xml new file mode 100644 index 00000000000..5bf9c0be7dc --- /dev/null +++ b/mysql-test/xml/tests/sel000024.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000024"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Strings.</description> + <description>Testing string comparisons; LIKE, '%'.</description> + + <resultfile name="r/3.23/sel000024.result"> + <sql>SELECT "a" LIKE "%%b","a" LIKE "%%ab","ab" LIKE "a\%", "ab" LIKE "_", "ab" LIKE "ab_", "abc" LIKE "%_d", "abc" LIKE "abc%d"</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000025.xml b/mysql-test/xml/tests/sel000025.xml new file mode 100644 index 00000000000..4144b65775f --- /dev/null +++ b/mysql-test/xml/tests/sel000025.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000025"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Strings.</description> + <description>Testing string comparisons; LIKE, ESCAPE, '%'.</description> + + <resultfile name="r/3.23/sel000025.result"> + <sql>SELECT '?' LIKE '|%', '?' LIKE '|%' ESCAPE '|', '%' LIKE '|%', '%' LIKE '|%' ESCAPE '|', '%' LIKE '%'</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000026.xml b/mysql-test/xml/tests/sel000026.xml new file mode 100644 index 00000000000..afaa34009fa --- /dev/null +++ b/mysql-test/xml/tests/sel000026.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000026"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Strings.</description> + <description>Testing string comparisons; LIKE, '%'.</description> + + <resultfile name="r/3.23/sel000026.result"> + <sql>SELECT 'abc' LIKE '%c','abcabc' LIKE '%c', "ab" LIKE "", "ab" LIKE "a", "ab" LIKE "ab"</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000027.xml b/mysql-test/xml/tests/sel000027.xml new file mode 100644 index 00000000000..641d5d3a619 --- /dev/null +++ b/mysql-test/xml/tests/sel000027.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000027"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Strings.</description> + <description>Testing string comparisons; REGEXP.</description> + + <resultfile name="r/3.23/sel000027.result"> + <sql>SELECT "Det här är svenska" REGEXP "h[[:alpha:]]+r", "aba" REGEXP "^(a|b)*$"</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000028.xml b/mysql-test/xml/tests/sel000028.xml new file mode 100644 index 00000000000..c8db245c25d --- /dev/null +++ b/mysql-test/xml/tests/sel000028.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000028"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Strings.</description> + <description>Testing string comparisons; REGEXP, CONCAT().</description> + + <resultfile name="r/3.23/sel000028.result"> + <sql>SELECT "aba" REGEXP CONCAT("^","a")</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000029.xml b/mysql-test/xml/tests/sel000029.xml new file mode 100644 index 00000000000..84d12a44dc5 --- /dev/null +++ b/mysql-test/xml/tests/sel000029.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000029"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Strings.</description> + <description>Testing string comparisons; NOT, AND, OR, !, &&, ||.</description> + + <resultfile name="r/3.23/sel000029.result"> + <sql>SELECT !0,NOT 0=1,!(0=0),1 AND 1,1 && 0,0 OR 1,1 || NULL, 1=1 OR 1=1 AND 1=0</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000030.xml b/mysql-test/xml/tests/sel000030.xml new file mode 100644 index 00000000000..8a8a4d5e0d2 --- /dev/null +++ b/mysql-test/xml/tests/sel000030.xml @@ -0,0 +1,17 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000030"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>Control flow.</description> + <description>Testing control flow; IF()</description> + + <resultfile name="r/3.23/sel000030.result"> + <sql>SELECT IF(0,"ERROR","this"),IF(1,"is","ERROR"),IF(NULL,"ERROR","a"),IF(1,2,3)|0,IF(1,2.0,3.0)+0</sql> + </resultfile> + +</test> |