1-1 before test 2<No error> before test 3select otto from (select 1 as otto) as t1; 4otto 51 6select otto from (select 1 as otto) as t1; 7otto 81 9mysqltest: At line 1: query 'select friedrich from (select 1 as otto) as t1' failed: 1054: Unknown column 'friedrich' in 'field list' 10select friedrich from (select 1 as otto) as t1; 11ERROR 42S22: Unknown column 'friedrich' in 'field list' 12select otto from (select 1 as otto) as t1; 13otto 141 15mysqltest: At line 1: query 'select otto from (select 1 as otto) as t1' succeeded - should have failed with sqlstate 42S22... 16mysqltest: At line 1: expecting a SQL-state (00000) from query 'remove_file MYSQLTEST_VARDIR/tmp/test_nonexistent.tmp' which cannot produce one... 17select friedrich from (select 1 as otto) as t1; 18ERROR 42S22: Unknown column 'friedrich' in 'field list' 19mysqltest: At line 1: query 'select friedrich from (select 1 as otto) as t1' failed with wrong sqlstate 42S22: 'Unknown column 'friedrich' in 'field list'', instead of 00000... 20select otto from (select 1 as otto) as t1; 21otto 221 23 24select 0 as "after_successful_stmt_errno" ; 25after_successful_stmt_errno 260 27garbage ; 28ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 29ER_PARSE_ERROR 30select 1064 as "after_wrong_syntax_errno" ; 31after_wrong_syntax_errno 321064 33garbage ; 34ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 35ER_PARSE_ERROR 36select 1064 as "after_let_var_equal_value" ; 37after_let_var_equal_value 381064 39garbage ; 40ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 41set @my_var= 'abc' ; 42 43select 0 as "after_set_var_equal_value" ; 44after_set_var_equal_value 450 46garbage ; 47ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 48ER_PARSE_ERROR 49select 1064 as "after_disable_warnings_command" ; 50after_disable_warnings_command 511064 52drop table if exists t1 ; 53garbage ; 54ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 55drop table if exists t1 ; 56 57select 0 as "after_disable_warnings" ; 58after_disable_warnings 590 60garbage ; 61ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 62select 3 from t1 ; 63ERROR 42S02: Table 'test.t1' doesn't exist 64ER_NO_SUCH_TABLE 65select 1146 as "after_minus_masked" ; 66after_minus_masked 671146 68garbage ; 69ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 70select 3 from t1 ; 71ERROR 42S02: Table 'test.t1' doesn't exist 72ER_NO_SUCH_TABLE 73select 1146 as "after_!_masked" ; 74after_!_masked 751146 76garbage ; 77ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 78select -1 as "after_let_errno_equal_value" ; 79after_let_errno_equal_value 80-1 81garbage ; 82ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 83prepare stmt from "select 3 from t1" ; 84ERROR 42S02: Table 'test.t1' doesn't exist 85ER_NO_SUCH_TABLE 86select 1146 as "after_failing_prepare" ; 87after_failing_prepare 881146 89create table t1 ( f1 char(10)); 90garbage ; 91ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 92prepare stmt from "select 3 from t1" ; 93 94select 0 as "after_successful_prepare" ; 95after_successful_prepare 960 97garbage ; 98ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 99execute stmt; 1003 101 102select 0 as "after_successful_execute" ; 103after_successful_execute 1040 105drop table t1; 106garbage ; 107ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 108execute stmt; 109ERROR 42S02: Table 'test.t1' doesn't exist 110ER_NO_SUCH_TABLE 111select 1146 as "after_failing_execute" ; 112after_failing_execute 1131146 114garbage ; 115ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 116execute __stmt_; 117ERROR HY000: Unknown prepared statement handler (__stmt_) given to EXECUTE 118ER_UNKNOWN_STMT_HANDLER 119select 1243 as "after_failing_execute" ; 120after_failing_execute 1211243 122garbage ; 123ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 124deallocate prepare stmt; 125 126select 0 as "after_successful_deallocate" ; 127after_successful_deallocate 1280 129garbage ; 130ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 131deallocate prepare __stmt_; 132ERROR HY000: Unknown prepared statement handler (__stmt_) given to DEALLOCATE PREPARE 133ER_UNKNOWN_STMT_HANDLER 134select 1243 as "after_failing_deallocate" ; 135after_failing_deallocate 1361243 137garbage ; 138ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 139ER_PARSE_ERROR 140select 1064 as "after_--disable_abort_on_error" ; 141after_--disable_abort_on_error 1421064 143select 3 from t1 ; 144ERROR 42S02: Table 'test.t1' doesn't exist 145select 3 from t1 ; 146ERROR 42S02: Table 'test.t1' doesn't exist 147select 3 from t1 ; 148ERROR 42S02: Table 'test.t1' doesn't exist 149ER_NO_SUCH_TABLE 150select 1146 as "after_!errno_masked_error" ; 151after_!errno_masked_error 1521146 153mysqltest: At line 1: query 'select 3 from t1' failed with wrong errno 1146: 'Table 'test.t1' doesn't exist', instead of 1000... 154ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 155 is empty 156ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'nonsense' at line 1 157 is empty 158garbage ; 159ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 160ER_PARSE_ERROR 161select 1064 as "after_--enable_abort_on_error" ; 162after_--enable_abort_on_error 1631064 164select 3 from t1 ; 165ERROR 42S02: Table 'test.t1' doesn't exist 166mysqltest: At line 1: query 'select 3 from t1' failed with wrong errno 1146: 'Table 'test.t1' doesn't exist', instead of 1064... 167garbage; 168ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 169select 2; 170select 3; 1713 1723 173select 5; 174ERROR 42S02: Table 'test.t1' doesn't exist 175select 7; 1767 1777 178mysqltest: At line 1: End of line junk detected: "OCNE" 179connect con1,localhost,root,,; 180select 5 from t1; 181lower 182case 183name 184abc 185xyz 186 is empty 187 is empty 188"Yes it's empty" 189ER_FORBID_SCHEMA_CHANGE 1901105 191mysqltest: At line 1: Invalid error in input 192<Unknown> 193<Unknown> 194 1950 1960 197hello 198hello 199;;;;;;;; 200# MySQL: -- The 201mysqltest: At line 1: Extra argument '6' passed to 'sleep' 202mysqltest: At line 1: Extra argument '6' passed to 'sleep' 203mysqltest: At line 1: Extra argument 'A comment 204show status' passed to 'sleep' 205mysqltest: At line 1: End of line junk detected: "sleep 7 206# Another comment 207" 208mysqltest: At line 1: Extra argument 'comment 209# comment 3 210disable_query_log' passed to 'disconnect' 211mysqltest: At line 1: Extra argument 'comment 212# comment 3 213disable_query_log' passed to 'disconnect' 214mysqltest: At line 1: End of line junk detected: "disconnect default 215 216# 217# comment 218# comment2 219 220# comment 3 221--disable_query_log 222" 223mysqltest: At line 1: End of line junk detected: "disconnect default # comment 224# comment part2 225 226# comment 3 227--disable_query_log 228" 229mysqltest: At line 1: Extra delimiter ";" found 230mysqltest: At line 1: Extra delimiter ";" found 231mysqltest: At line 1: Spurious text after `query` expression 232mysqltest: At line 1: Spurious text after `query` expression 233mysqltest: At line 2: Spurious text after `query` expression 234mysqltest: At line 1: Missing argument(s) to 'error' 235mysqltest: At line 1: Missing argument(s) to 'error' 236mysqltest: At line 1: The sqlstate definition must start with an uppercase S 237mysqltest: At line 1: The error name definition must start with an uppercase E 238mysqltest: At line 1: Invalid argument to error: '9eeeee' - the errno may only consist of digits[0-9] 239mysqltest: At line 1: Invalid argument to error: '1sssss' - the errno may only consist of digits[0-9] 240mysqltest: At line 1: The sqlstate must be exactly 5 chars long 241mysqltest: At line 1: The sqlstate may only consist of digits[0-9] and _uppercase_ letters 242mysqltest: At line 1: The sqlstate must be exactly 5 chars long 243mysqltest: At line 1: Unknown SQL error name 'E9999' 244mysqltest: At line 1: Invalid argument to error: '999e9' - the errno may only consist of digits[0-9] 245mysqltest: At line 1: Invalid argument to error: '9b' - the errno may only consist of digits[0-9] 246mysqltest: At line 1: Too many errorcodes specified 247CREATE TABLE t1 (a INT); 248CREATE TABLE t1 (a INT); 249ERROR 42S01: Table 't1' already exists 250CREATE TABLE t1 (a INT); 251ERROR 42S01: Table 't1' already exists 252DROP TABLE t1; 253MySQL 254"MySQL" 255MySQL: The world''s most popular open source database 256"MySQL: The world's most popular open source database" 257MySQL: The world''s 258most popular open 259source database 260# MySQL: The world''s 261# most popular open 262# source database 263- MySQL: The world''s 264- most popular open 265- source database 266- MySQL: The world''s 267-- most popular 268-- open source database 269# MySQL: The 270--world''s 271# most popular 272-- open 273- source database 274"MySQL: The world's most popular; open source database" 275"MySQL: The world's most popular ; open source database" 276"MySQL: The world's most popular ;open source database" 277echo message echo message 278 279mysqltest: At line 1: Missing argument in exec 2801 2811 2822 2832 284X 2853 286MySQL 287"MySQL" 288MySQL: The 289world''s most 290popular open 291source database 292# MySQL: The 293# world''s most 294# popular open 295# source database 296-- MySQL: The 297-- world''s most 298-- popular 299-- open source database 300# MySQL: The 301- world''s most 302-- popular open 303# source database 304'# MySQL: The 305- world''s most 306-- popular open 307# source database' 308"# MySQL: The 309- world''s most 310-- popular open 311# source database" 312hej 313hej 314hej 3151 316 317 318a long variable content 319a long variable content 320a long a long variable content variable content 321a long \$where variable content 322 323banana = banana 324Not a banana: ba\$cat\$cat 325with\`some"escaped\'quotes 326with\`some"escaped\'quotes 327single'tick`backtick 328mysqltest: At line 1: Missing arguments to let 329mysqltest: At line 1: Missing variable name in let 330mysqltest: At line 1: Missing assignment operator in let 331mysqltest: At line 1: Missing assignment operator in let 332mysqltest: At line 1: Missing assignment operator in let 333mysqltest: At line 1: Missing variable name in let 334mysqltest: At line 1: Missing variable name in let 335mysqltest: At line 1: Missing assignment operator in let 336# Execute: --echo # <whatever> success: $success 337# <whatever> success: 1 338# Execute: echo # <whatever> success: $success ; 339# <whatever> success: 1 340# The next two variants work fine and expand the content of $success 341# Execute: --echo $success 3421 343# Execute: echo $success ; 3441 345# Check if let $B = $A is an assignment per value. 346let $A = initial value of A; 347let $B = initial value of B; 348let $B = $A 349# Content of $A is: initial value of B 350let $A = changed value of A; 351# Content of $B is: initial value of B 352let $B = changed value of B; 353# Content of $A is: changed value of A 354var2: content of variable 1 355var3: content of variable 1 content of variable 1 356length of var3 is longer than 0 357var1 358hi 1 hi there 359var2 3602 361var2 again 3622 363var3 two columns with same name 3641 2 3 365var4 from query that returns NULL 366var5 from query that returns no row 367failing query in let 368create table t1 (a varchar(100)); 369insert into t1 values ('`select 42`'); 370`select 42` 371insert into t1 values ('$dollar'); 372$dollar 373`select 42` 374drop table t1; 375mysqltest: At line 1: query 'let $var2= `failing query`' failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'failing query' at line 1 376mysqltest: At line 1: Missing required argument 'filename' to command 'source' 377mysqltest: At line 1: Could not open './non_existingFile' for reading, errno: 2 378mysqltest: In included file "MYSQLTEST_VARDIR/tmp/recursive.sql": 379included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: 380included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: 381included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: 382included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: 383included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: 384included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: 385included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: 386included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: 387included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: 388included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: 389included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: 390included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: 391included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: 392included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: 393included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: 394At line 1: Source directives are nesting too deep 395mysqltest: In included file "MYSQLTEST_VARDIR/tmp/error.sql": 396included from MYSQLTEST_VARDIR/tmp/error.sql at line 1: 397At line 1: query 'garbage ' failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 398 3992 = outer loop variable after while 400here is the sourced script 401 4022 = outer loop variable before dec 403 4041 = outer loop variable after dec 405 4061 = outer loop variable after while 407here is the sourced script 408 4091 = outer loop variable before dec 410 4110 = outer loop variable after dec 412outer=2 ifval=0 413outer=1 ifval=1 414here is the sourced script 415ERROR 42S02: Table 'test.nowhere' doesn't exist 416ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'else' at line 1 417 418In loop 419here is the sourced script 420 421In loop 422here is the sourced script 423 424In loop 425here is the sourced script 426 427In loop 428here is the sourced script 429 430In loop 431here is the sourced script 432 433In loop 434here is the sourced script 435 436In loop 437here is the sourced script 438 439In loop 440here is the sourced script 441 442In loop 443here is the sourced script 444here is the sourced script 445"hello" 446"hello" 447mysqltest: At line 2: Invalid argument to sleep "xyz" 448mysqltest: At line 2: Invalid argument to real_sleep "xyz" 449mysqltest: At line 1: Missing required argument 'sleep_delay' to command 'sleep' 450mysqltest: At line 1: Missing required argument 'sleep_delay' to command 'real_sleep' 451mysqltest: At line 1: Invalid argument to sleep "abc" 452mysqltest: At line 1: Invalid argument to real_sleep "abc" 4531 454101 455-99 456mysqltest: At line 1: Missing argument to inc 457mysqltest: At line 1: The argument to inc must be a variable (start with $) 458mysqltest: At line 1: Cannot perform inc/dec on a non-numeric value 459mysqltest: At line 1: End of line junk detected: "1000" 460mysqltest: At line 1: Cannot perform inc/dec on a non-numeric value 461mysqltest: At line 1: Cannot perform inc/dec on a non-numeric value 462-96 463-96 464-1 46599 466mysqltest: At line 1: Missing argument to dec 467mysqltest: At line 1: The argument to dec must be a variable (start with $) 468mysqltest: At line 1: Cannot perform inc/dec on a non-numeric value 469mysqltest: At line 1: End of line junk detected: "1000" 470mysqltest: At line 1: Cannot perform inc/dec on a non-numeric value 471mysqltest: At line 1: Cannot perform inc/dec on a non-numeric value 472mysqltest: At line 1: 'system' command is deprecated, use exec or 473 see the manual for portable commands to use 474test 475test2 476test3 477test4 478outer 479true-inner 480true-inner again 481true-outer 482Counter is greater than 0, (counter=10) 483Counter should still be 10, is 10 484Counter is not 0, (counter=0) 485Not space var works 486Counter is true, (counter=alpha) 487while with string, only once 4885<7 4895<7 again 4905<7 still 4915<6 4925>=5 4935>=5 again 4945>3 4955==5 4965!=8 4975!=five 4985==3+2 4995 == 5 500hello == hello 501hello == hello 502hello != goodbye 503'quoted' == ''quoted'' 504two words 505'two words' 506"two words" 507two words are two words 508right answer 509anything goes 5100 != string 511mysqltest: At line 2: Only == and != are supported for string values 512mysqltest: At line 2: Found junk '~= 6' after $variable in condition 513mysqltest: At line 2: Expression in if/while must beging with $, ` or a number 514mysqltest: At line 1: Missing right operand in comparison 515mysqltest: At line 1: Missing right operand in comparison 516counter is 2 517counter is 3 518counter is 4 519counter is 5 520counter is 6 521counter is 7 5221 523Testing while with not 524mysqltest: In included file "MYSQLTEST_VARDIR/tmp/mysqltest_while.inc": 525included from MYSQLTEST_VARDIR/tmp/mysqltest_while.inc at line 65: 526At line 64: Nesting too deeply 527mysqltest: At line 1: missing '(' in while 528mysqltest: At line 1: missing ')' in while 529mysqltest: At line 1: Missing '{' after while. Found "dec $i" 530mysqltest: At line 1: Stray '}' - end of block before beginning 531mysqltest: At line 1: Stray 'end' command - end of block before beginning 532mysqltest: At line 1: query '{' failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{' at line 1 533mysqltest: At line 1: Missing '{' after while. Found "echo hej" 534mysqltest: At line 3: Missing end of block 535mysqltest: At line 3: Missing end of block 536mysqltest: At line 1: missing '(' in if 537mysqltest: At line 1: Stray 'end' command - end of block before beginning 538select "b" bs col1, "c" bs col2; 539col1 col2 540b c 541seledt "b" bs dol1, "d" bs dol2; 542dol1 dol2 543b d 544mysqltest: At line 1: Wrong number of arguments to replace_result in 'replace_result a' 545mysqltest: At line 1: Wrong number of arguments to replace_result in 'replace_result a;' 546mysqltest: At line 1: Wrong number of arguments to replace_result in 'replace_result a' 547mysqltest: At line 1: Wrong number of arguments to replace_result in 'replace_result a ' 548OK 549mysqltest: At line 1: Wrong number of arguments to replace_result in 'replace_result a b c' 550mysqltest: At line 1: Wrong number of arguments to replace_result in 'replace_result a b c ' 551select "a" as col1, "c" as col2; 552col1 col2 553b c 554select "a" as col1, "c" as col2; 555col1 col2 556b d 557mysqltest: At line 1: Wrong column number to replace_column in 'replace_column a' 558mysqltest: At line 1: Wrong number of arguments to replace_column in 'replace_column 1' 559mysqltest: At line 1: Wrong column number to replace_column in 'replace_column a b' 560mysqltest: At line 1: Wrong column number to replace_column in 'replace_column a 1' 561mysqltest: At line 1: Wrong column number to replace_column in 'replace_column 1 b c ' 562select "LONG_STRING" as x; 563x 564LONG_STRING 565dog 566mysqltest: At line 1: Invalid integer argument "10!" 567mysqltest: At line 1: Invalid integer argument "a" 568mysqltest: At line 1: Missing required argument 'connection name' to command 'connect' 569mysqltest: At line 1: Missing required argument 'connection name' to command 'connect' 570mysqltest: At line 1: Missing required argument 'host' to command 'connect' 571mysqltest: At line 1: Missing required argument 'host' to command 'connect' 572mysqltest: At line 1: query 'connect con2,localhost,root,,illegal_db' failed: 1049: Unknown database 'illegal_db' 573mysqltest: At line 1: Illegal argument for port: 'illegal_port' 574mysqltest: At line 1: Illegal option to connect: SMTP 575200 connects succeeded 576mysqltest: In included file "MYSQLTEST_VARDIR/tmp/mysqltest.sql": 577included from MYSQLTEST_VARDIR/tmp/mysqltest.sql at line 3: 578At line 3: connection 'test_con1' not found in connection pool 579mysqltest: In included file "MYSQLTEST_VARDIR/tmp/mysqltest.sql": 580included from MYSQLTEST_VARDIR/tmp/mysqltest.sql at line 2: 581At line 2: Connection test_con1 already exists 582show tables; 583ERROR 3D000: No database selected 584connect con1,localhost,root,,; 585connection default; 586connection con1; 587disconnect con1; 588connection default; 589Output from mysqltest-x.inc 590Output from mysqltest-x.inc 591Output from mysqltest-x.inc 592mysqltest: Could not open './non_existing_file.inc' for reading, errno: 2 593failing_statement; 594ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'failing_statement' at line 1 595failing_statement; 596ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'failing_statement' at line 1 597SELECT 1 as a; 598a 5991 600select 1 as `a'b`, 2 as `a"b`; 601a'b a"b 6021 2 603select 'aaa\\','aa''a',"aa""a"; 604aaa\ aa'a aa"a 605aaa\ aa'a aa"a 606 607Here comes a message 608-------------------- 609 610root@localhost 611-------------- 612 613"Here comes a very very long message that 614 - is longer then 80 characters and 615 - consists of several lines" 616-------------------------------------------------------------------------------- 617 618. Here comes a very very long message that 619. - is longer then 80 characters and 620. - consists of several lines 621-------------------------------------------------------------------------------- 622this will be executed 623this will be executed 624mysqltest: The test didn't produce any output 625Failing multi statement query 626mysqltest: At line 3: query 'create table t1 (a int primary key); 627insert into t1 values (1); 628select 'select-me'; 629insertz 'error query'' failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insertz 'error query'' at line 1 630drop table t1; 631mysqltest: At line 3: query 'create table t1 (a int primary key); 632insert into t1 values (1); 633select 'select-me'; 634insertz 'error query'' failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insertz 'error query'' at line 1 635drop table t1; 636Multi statement using expected error 637create table t1 (a int primary key); 638insert into t1 values (1); 639select 'select-me'; 640insertz error query|||| 641select-me 642select-me 643ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insertz error query' at line 1 644drop table t1; 645drop table t1; 646sleep; 647ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sleep' at line 1 648sleep; 649ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sleep' at line 1 650; 651ERROR 42000: Query was empty 652select "b" as col1, "c" as col2; 653col1 col2 654b c 655select "b" as col1, "b" as col2, "c" as col3; 656col1 col2 col3 657b b c 658seled "b" bs col1, "d" bs col2; 659col1 col2 660b d 661select "raspberry and strawberry","blackberry","tomato"; 662raspberry and strawberry blackberry tomato 663raspberry and strawberry blackberry tomato 664mysqltest: At line 1: Error parsing replace_regex "a" 665mysqltest: At line 1: Error parsing replace_regex "a;" 666mysqltest: At line 1: Error parsing replace_regex "a" 667mysqltest: At line 1: Error parsing replace_regex "a " 668mysqltest: At line 1: Error parsing replace_regex "a b" 669mysqltest: At line 1: Error parsing replace_regex "/a b c" 670mysqltest: At line 1: Error parsing replace_regex "/a /b c " 671create table t1 (a int, b int); 672insert into t1 values (1,3); 673insert into t1 values (2,4); 674select * from t1; 675a D 6761 1 6771 4 678drop table t1; 679y 680txt 681b is b and more is more 682txt 683a is a and less is more 684create table t2 ( a char(10)); 685garbage; 686ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 687garbage; 688Got one of the listed errors 689garbage; 690Got one of the listed errors 691insert into t1 values ("Abcd"); 692Got one of the listed errors 693garbage; 694drop table t2; 695create table t1 ( f1 char(10)); 696insert into t1 values ("Abcd"); 697select * from t1; 698f1 699Abcd 700select * from t2;; 701ERROR 42S02: Table 'test.t2' doesn't exist 702select * from t1; 703f1 704Abcd 705select * from t1;; 706Result coming up 707f1 708Abcd 709select * from t1;; 710f1 711Abcd 712mysqltest: At line 2: Cannot run query on connection between send and reap 713select * from t1;; 714drop table t1; 715mysqltest: At line 1: Missing required argument 'filename' to command 'remove_file' 716mysqltest: At line 1: Missing required argument 'directory' to command 'remove_files_wildcard' 717mysqltest: At line 1: Missing required argument 'filename' to command 'write_file' 718mysqltest: At line 1: End of file encountered before 'EOF' delimiter was found 719Content for test_file1 720mysqltest: At line 1: File already exist: 'MYSQLTEST_VARDIR/tmp/test_file1.tmp' 721These lines should be repeated, 722if things work as expected 723These lines should be repeated, 724if things work as expected 725Some data 726for cat_file command 727of mysqltest 728mysqltest: At line 1: command "cat_file" failed with error 1. (my_errno) 729mysqltest: At line 1: Missing required argument 'filename' to command 'file_exists' 730mysqltest: At line 1: Missing required argument 'from_file' to command 'copy_file' 731mysqltest: At line 1: Missing required argument 'to_file' to command 'copy_file' 732mysqltest: At line 1: Missing required argument 'from_file' to command 'move_file' 733mysqltest: At line 1: Missing required argument 'to_file' to command 'move_file' 734mysqltest: At line 1: Missing required argument 'mode' to command 'chmod' 735mysqltest: At line 1: You must write a 4 digit octal number for mode 736mysqltest: At line 1: You must write a 4 digit octal number for mode 737mysqltest: At line 1: Missing required argument 'filename' to command 'chmod' 738mysqltest: At line 1: You must write a 4 digit octal number for mode 739mysqltest: At line 1: You must write a 4 digit octal number for mode 740hello 741hello 742hello 743mysqltest: At line 1: Max delimiter length(16) exceeded 744hello 745hello 746val is 5 747val is 5 748mysqltest: At line 1: test of die 749Some output 750create table t1( a int, b char(255), c timestamp); 751insert into t1 values(1, 'Line 1', '2007-04-05'), (2, "Part 2", '2007-04-05'); 752insert into t1 values(1, 'Line 1', '2007-04-05'), (2, "Part 3", '2007-04-05'); 753select * from t1; 754a b c 7551 Line 1 2007-04-05 00:00:00 7562 Part 2 2007-04-05 00:00:00 7571 Line 1 2007-04-05 00:00:00 7582 Part 3 2007-04-05 00:00:00 759select * from t1; 760a b c 7611 Line 1 2007-04-05 00:00:00 7621 Line 1 2007-04-05 00:00:00 7632 Part 2 2007-04-05 00:00:00 7642 Part 3 2007-04-05 00:00:00 765select * from t1; 766a b c 7671 Line 1 2007-04-05 00:00:00 7682 Part 2 2007-04-05 00:00:00 7691 Line 1 2007-04-05 00:00:00 7702 Part 3 2007-04-05 00:00:00 771select * from t1; 772select ''; 773 774 775select "h"; 776h 777h 778select "he"; 779he 780he 781select "hep"; 782hep 783hep 784select "hepp"; 785hepp 786hepp 787drop table t1; 788SELECT 2 as "my_col" 789UNION 790SELECT 1; 791my_col 7921 7932 794SELECT 2 as "my_col" UNION SELECT 1; 795my_col 7961 7972 798SELECT 2 as "my_col" 799UNION 800SELECT 1; 801my_col 8021 8032 804SELECT '2' as "3" 805UNION 806SELECT '1'; 8073 8081 8092 810CREATE TABLE t1( a CHAR); 811SELECT * FROM t1; 812a 813DROP TABLE t1; 814SELECT NULL as "my_col1",2 AS "my_col2" 815UNION 816SELECT NULL,1; 817my_col1 my_col2 818NULL 2 819NULL 1 820SELECT NULL as "my_col1",2 AS "my_col2" 821UNION 822SELECT NULL,1; 823my_col1 my_col2 824NULL 1 825NULL 2 826SELECT 2 as "my_col1",NULL AS "my_col2" 827UNION 828SELECT 1,NULL; 829my_col1 my_col2 8302 NULL 8311 NULL 832SELECT 2 as "my_col1",NULL AS "my_col2" 833UNION 834SELECT 1,NULL; 835my_col1 my_col2 8361 NULL 8372 NULL 838SET @a = 17; 839SELECT 2 as "my_col" 840UNION 841SELECT 1; 842my_col 8432 8441 845SELECT 2 as "my_col" 846UNION 847SELECT 1; 848my_col 8491 8502 851SELECT '2' as "my_col1",2 as "my_col2" 852UNION 853SELECT '1',1 from t2; 854ERROR 42S02: Table 'test.t2' doesn't exist 855SELECT '1' as "my_col1",2 as "my_col2" 856UNION 857SELECT '2',1; 858my_col1 my_col2 859# 1 860# 2 861CREATE TABLE t1 (f1 INT); 862INSERT INTO t1 SET f1 = 1024; 863INSERT INTO t1 SELECT f1 - 1 FROM t1; 864INSERT INTO t1 SELECT f1 - 2 FROM t1; 865INSERT INTO t1 SELECT f1 - 4 FROM t1; 866INSERT INTO t1 SELECT f1 - 8 FROM t1; 867INSERT INTO t1 SELECT f1 - 16 FROM t1; 868INSERT INTO t1 SELECT f1 - 32 FROM t1; 869INSERT INTO t1 SELECT f1 - 64 FROM t1; 870INSERT INTO t1 SELECT f1 - 128 FROM t1; 871INSERT INTO t1 SELECT f1 - 256 FROM t1; 872INSERT INTO t1 SELECT f1 - 512 FROM t1; 873SELECT * FROM t1; 874DROP TABLE t1; 875select "500g bl�b�rsyltet�y" as "will be lower cased"; 876will be lower cased 877500g bl�b�rsyltet�y 878SELECT "UPPER" AS "WILL NOT BE lower cased"; 879WILL NOT BE lower cased 880UPPER 881UP 882SELECT 0 as "UP AGAIN"; 883UP AGAIN 8840 885select "abcdef" as "uvwxyz"; 886uvwxyz 887abcdef 888select "xyz" as name union select "abc" as name order by name desc; 889name 890abc 891xyz 892select 1 as "some new text"; 893some new text 8941 895select 0 as "will not lower case ���"; 896will not lower case ��� 8970 898CREATE TABLE t1( 899a int, b varchar(255), c datetime 900); 901SHOW COLUMNS FROM t1; 902Field Type Null Key Default Extra 903a int(11) YES NULL 904b varchar(255) YES NULL 905c datetime YES NULL 906statement=SHOW COLUMNS FROM t1 row_number=1, column_name="Type", Value=int(11) 907statement="SHOW COLUMNS FROM t1" row_number=1, column_name="Type", Value=int(11) 908statement=SHOW COLUMNS FROM t1 row_number=1, column_name=Default, Value=NULL 909value= ->A B<- 910value= 1 911value= 2 912mysqltest: At line 1: query_get_value - argument list started with '(' must be ended with ')' 913mysqltest: At line 1: Missing required argument 'query' to command 'query_get_value' 914mysqltest: At line 1: Missing required argument 'column name' to command 'query_get_value' 915mysqltest: At line 1: Missing required argument 'row number' to command 'query_get_value' 916value= No such row 917value= No such row 918mysqltest: At line 1: Invalid row number: 'notnumber' 919mysqltest: At line 1: Could not find column 'column_not_exists' in the result of 'SHOW COLUMNS FROM t1' 920mysqltest: At line 1: Query 'SET @A = 1' didn't return a result set 921mysqltest: At line 1: Could not find column '1 AS B' in the result of 'SELECT 1 AS A' 922value= No such row 923mysqltest: At line 1: query 'let $value= query_get_value(SHOW COLNS FROM t1, Field, 1)' failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLNS FROM t1' at line 1 924 925Field Type Null Key Default Extra 926a int(11) YES -><- NULL 927b varchar(255) YES -><- NULL 928c datetime YES -><- NULL 929 930Number of columns with Default NULL: 3 931 932SHOW COLUMNS FROM t1; 933Field Type Null Key Default Extra 934a int(11) YES NULL 935b varchar(255) YES NULL 936c datetime YES NULL 937drop table t1; 938mysqltest: At line 1: query 'change_user root,,inexistent' failed: 1049: Unknown database 'inexistent' 939mysqltest: At line 1: query 'change_user inexistent,,test' failed: 1045: Access denied for user 'inexistent'@'localhost' (using password: NO) 940mysqltest: At line 1: query 'change_user root,inexistent,test' failed: 1045: Access denied for user 'root'@'localhost' (using password: YES) 941REPLACED_FILE1.txt 942file1.txt 943file2.txt 944prefix1.txt 945prefix2.txt 946prefix3.txt 947SELECT "bla bla file" as x; 948x 949bla bla file 950file11.txt 951dir-list.txt 952SELECT 'c:\\a.txt' AS col; 953col 954z 955select 1; 9561 9571 958select 1; 9591 9601 961-- a comment for the server; 962mysqltest: At line 1: Found line beginning with -- that didn't contain a valid mysqltest command, check your syntax or use # if you intended to write a comment 963con1 964con2 965default 966con1 967con2 968con1 969con2 970con2 971-closed_connection- 972# 973# Test that a query failed with ER_NO_SUCH_THREAD causes mysqltest to dump the processlist before dying 974# 975mysqltest: query 'KILL QUERY 276447231 returned ER_NO_SUCH_THREAD, dumping processlist 976=== SHOW PROCESSLIST === 977---- 1. ---- 978Id MASKED 979User root 980Host localhost 981db test 982Command Sleep 983Time MASKED 984State 985Info 986Rows_sent 1 987Rows_examined 0 988---- 2. ---- 989Id MASKED 990User root 991Host localhost 992db test 993Command Query 994Time MASKED 995State init 996Info SHOW PROCESSLIST 997Rows_sent 0 998Rows_examined 0 999======================== 1000 1001mysqltest: At line 1: query 'KILL QUERY 276447231' failed: 1094: 1002# PROCESSLIST should not be dumped if error was expected 1003KILL QUERY 276447231; 1004ERROR HY000: Unknown thread id: 276447231 1005# PROCESSLIST should be dumped if a different error was expected 1006mysqltest: query 'KILL QUERY 276447231 returned ER_NO_SUCH_THREAD, dumping processlist 1007=== SHOW PROCESSLIST === 1008---- 1. ---- 1009Id MASKED 1010User root 1011Host localhost 1012db test 1013Command Sleep 1014Time MASKED 1015State 1016Info 1017Rows_sent 1 1018Rows_examined 0 1019---- 2. ---- 1020Id MASKED 1021User root 1022Host localhost 1023db test 1024Command Query 1025Time MASKED 1026State init 1027Info SHOW PROCESSLIST 1028Rows_sent 0 1029Rows_examined 0 1030======================== 1031 1032mysqltest: At line 1: query 'KILL QUERY 276447231' failed with wrong errno 1094: '', instead of 1064... 1033End of tests 1034