MOON
Server: Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
System: Linux vps.panamaemb.org.sg 3.10.0-1160.80.1.vz7.191.4 #1 SMP Thu Dec 15 20:31:06 MSK 2022 x86_64
User: panama (500)
PHP: 5.2.17
Disabled: NONE
Upload Files
File: //proc/3/cwd/usr/share/mysql-test/t/comments.test
#
# Testing of comments
#

select 1+2/*hello*/+3;
select 1 /* long
multi line comment */;
--error 1065
 ;
select 1 /*!32301 +1 */;
select 1 /*!52301 +1 */;
select 1--1;
# Note that the following returns 4 while it should return 2
# This is because the mysqld server doesn't parse -- comments
select 1 --2
+1;
select 1 # The rest of the row will be ignored
;
/* line with only comment */;

# End of 4.1 tests

#
# Bug#25411 (trigger code truncated)
#

--error ER_PARSE_ERROR
select 1/*!2*/;

--error ER_PARSE_ERROR
select 1/*!000002*/;

select 1/*!999992*/;

select 1 + /*!00000 2 */ + 3 /*!99999 noise*/ + 4;

#
# Bug#28779 (mysql_query() allows execution of statements with unbalanced
# comments)
#

--disable_warnings
drop table if exists table_28779;
--enable_warnings

create table table_28779 (a int);

--error 1064
prepare bar from "DELETE FROM table_28779 WHERE a = 7 OR 1=1/*' AND b = 'bar';";

--error 1064
prepare bar from "DELETE FROM table_28779 WHERE a = 7 OR 1=1/*' AND b = 'bar';*";

--error 1064
prepare bar from "DELETE FROM table_28779 WHERE a = 7 OR 1=1/*! AND 2=2;";

--error 1064
prepare bar from "DELETE FROM table_28779 WHERE a = 7 OR 1=1/*! AND 2=2;*";

--error 1064
prepare bar from "DELETE FROM table_28779 WHERE a = 7 OR 1=1/*!98765' AND b = 'bar';";

--error 1064
prepare bar from "DELETE FROM table_28779 WHERE a = 7 OR 1=1/*!98765' AND b = 'bar';*";

drop table table_28779;