sql_yacc.yy 129 KB
Newer Older
1
/* Copyright (C) 2000-2003 MySQL AB
2

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3 4 5 6
   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; either version 2 of the License, or
   (at your option) any later version.
7

bk@work.mysql.com's avatar
bk@work.mysql.com committed
8 9 10 11
   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.
12

bk@work.mysql.com's avatar
bk@work.mysql.com committed
13 14 15 16
   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */

tim@cane.mysql.fi's avatar
tim@cane.mysql.fi committed
17
/* sql_yacc.yy */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
18 19

%{
20 21 22
/* thd is passed as an arg to yyparse(), and subsequently to yylex().
** The type will be void*, so it must be  cast to (THD*) when used.
** Use the YYTHD macro for this.
23 24
*/
#define YYPARSE_PARAM yythd
25
#define YYLEX_PARAM yythd
26 27
#define YYTHD ((THD *)yythd)

bk@work.mysql.com's avatar
bk@work.mysql.com committed
28 29 30
#define MYSQL_YACC
#define YYINITDEPTH 100
#define YYMAXDEPTH 3200				/* Because of 64K stack */
31
#define Lex (&(YYTHD->lex))
32
#define Select Lex->current_select
bk@work.mysql.com's avatar
bk@work.mysql.com committed
33
#include "mysql_priv.h"
34
#include "slave.h"
bk@work.mysql.com's avatar
bk@work.mysql.com committed
35 36
#include "sql_acl.h"
#include "lex_symbol.h"
37
#include "item_create.h"
bk@work.mysql.com's avatar
bk@work.mysql.com committed
38
#include <myisam.h>
39
#include <myisammrg.h>
40

bk@work.mysql.com's avatar
bk@work.mysql.com committed
41
extern void yyerror(const char*);
42
int yylex(void *yylval, void *yythd);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
43

44
#define yyoverflow(A,B,C,D,E,F) if (my_yyoverflow((B),(D),(int*) (F))) { yyerror((char*) (A)); return 2; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
45

46
inline Item *or_or_concat(THD *thd, Item* A, Item* B)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
47
{
48
  return (thd->variables.sql_mode & MODE_PIPES_AS_CONCAT ?
bk@work.mysql.com's avatar
bk@work.mysql.com committed
49 50 51 52 53 54 55
          (Item*) new Item_func_concat(A,B) : (Item*) new Item_cond_or(A,B));
}

%}
%union {
  int  num;
  ulong ulong_num;
56
  ulonglong ulonglong_number;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
57 58 59 60 61 62 63 64
  LEX_STRING lex_str;
  LEX_STRING *lex_str_ptr;
  LEX_SYMBOL symbol;
  Table_ident *table;
  char *simple_string;
  Item *item;
  List<Item> *item_list;
  List<String> *string_list;
65 66 67 68 69 70
  String *string;
  key_part_spec *key_part;
  TABLE_LIST *table_list;
  udf_func *udf;
  LEX_USER *lex_user;
  sys_var *variable;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
71
  Key::Keytype key_type;
72
  enum ha_key_alg  key_alg;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
73 74
  enum db_type db_type;
  enum row_type row_type;
monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi committed
75
  enum ha_rkey_function ha_rkey_mode;
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
76
  enum enum_tx_isolation tx_isolation;
77
  enum Cast_target cast_type;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
78
  enum Item_udftype udf_type;
79
  CHARSET_INFO *charset;
80
  thr_lock_type lock_type;
81
  interval_type interval;
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
82
  st_select_lex *select_lex;
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
83
  chooser_compare_func_creator boolfunc2creator;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
84 85 86 87 88 89 90 91 92 93
}

%{
bool my_yyoverflow(short **a, YYSTYPE **b,int *yystacksize);
%}

%pure_parser					/* We have threads */

%token	END_OF_INPUT

94 95 96 97 98 99
%token CLOSE_SYM
%token HANDLER_SYM
%token LAST_SYM
%token NEXT_SYM
%token PREV_SYM

100
%token	DIV_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
101 102
%token	EQ
%token	EQUAL_SYM
103
%token	SOUNDS_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
104 105 106 107 108 109
%token	GE
%token	GT_SYM
%token	LE
%token	LT
%token	NE
%token	IS
110
%token	MOD_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
111 112 113 114
%token	SHIFT_LEFT
%token	SHIFT_RIGHT
%token  SET_VAR

115
%token	ABORT_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
116 117
%token	ADD
%token	AFTER_SYM
118 119
%token	ALTER
%token	ANALYZE_SYM
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
120
%token	ANY_SYM
121 122 123
%token	AVG_SYM
%token	BEGIN_SYM
%token	BINLOG_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
124
%token	CHANGE
125 126 127 128
%token	CLIENT_SYM
%token	COMMENT_SYM
%token	COMMIT_SYM
%token	COUNT_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
129 130
%token	CREATE
%token	CROSS
131
%token  CUBE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
132
%token	DELETE_SYM
133
%token	DUAL_SYM
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
134
%token	DO_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
135
%token	DROP
136 137
%token	EVENTS_SYM
%token	EXECUTE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
138
%token	FLUSH_SYM
139
%token  HELP_SYM
140
%token	INSERT
141
%token	RELAY_THREAD
bk@work.mysql.com's avatar
bk@work.mysql.com committed
142 143
%token	KILL_SYM
%token	LOAD
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
144
%token	LOCKS_SYM
145 146 147 148
%token	LOCK_SYM
%token	MASTER_SYM
%token	MAX_SYM
%token	MIN_SYM
149
%token	NONE_SYM
150 151 152 153 154 155
%token	OPTIMIZE
%token	PURGE
%token	REPAIR
%token	REPLICATION
%token	RESET_SYM
%token	ROLLBACK_SYM
156
%token  ROLLUP_SYM
157 158 159 160 161 162
%token	SELECT_SYM
%token	SHOW
%token	SLAVE
%token	SQL_THREAD
%token	START_SYM
%token	STD_SYM
163
%token  VARIANCE_SYM
164 165
%token	STOP_SYM
%token	SUM_SYM
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
166
%token	ADDDATE_SYM
167 168
%token	SUPER_SYM
%token	TRUNCATE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
169
%token	UNLOCK_SYM
170
%token	UPDATE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
171 172 173 174 175 176 177

%token	ACTION
%token	AGGREGATE_SYM
%token	ALL
%token	AND
%token	AS
%token	ASC
178
%token	AUTO_INC
bk@work.mysql.com's avatar
bk@work.mysql.com committed
179
%token	AVG_ROW_LENGTH
180
%token	BACKUP_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
181 182 183 184
%token	BERKELEY_DB_SYM
%token	BINARY
%token	BIT_SYM
%token	BOOL_SYM
185
%token	BOOLEAN_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
186
%token	BOTH
187
%token	BTREE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
188
%token	BY
189
%token	BYTE_SYM
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
190
%token	CACHE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
191
%token	CASCADE
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
192
%token	CAST_SYM
193
%token	CHARSET
bk@work.mysql.com's avatar
bk@work.mysql.com committed
194 195
%token	CHECKSUM_SYM
%token	CHECK_SYM
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
196
%token	COMMITTED_SYM
197
%token	COLLATE_SYM
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
198
%token	COLLATION_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
199 200
%token	COLUMNS
%token	COLUMN_SYM
201
%token	CONCURRENT
bk@work.mysql.com's avatar
bk@work.mysql.com committed
202
%token	CONSTRAINT
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
203
%token	CONVERT_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
204 205 206 207 208 209 210
%token	DATABASES
%token	DATA_SYM
%token	DEFAULT
%token	DELAYED_SYM
%token	DELAY_KEY_WRITE_SYM
%token	DESC
%token	DESCRIBE
211
%token	DES_KEY_FILE
212
%token	DISABLE_SYM
213
%token	DISTINCT
214
%token  DUPLICATE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
215
%token	DYNAMIC_SYM
216
%token	ENABLE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
217 218
%token	ENCLOSED
%token	ESCAPED
219
%token	DIRECTORY_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
220 221 222
%token	ESCAPE_SYM
%token	EXISTS
%token	EXTENDED_SYM
223
%token	FALSE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
224 225 226 227
%token	FILE_SYM
%token	FIRST_SYM
%token	FIXED_SYM
%token	FLOAT_NUM
228
%token	FORCE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
229 230 231
%token	FOREIGN
%token	FROM
%token	FULL
232 233
%token	FULLTEXT_SYM
%token	GLOBAL_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
234 235 236 237 238
%token	GRANT
%token	GRANTS
%token	GREATEST_SYM
%token	GROUP
%token	HAVING
239
%token	HASH_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
240 241 242 243 244 245 246
%token	HEAP_SYM
%token	HEX_NUM
%token	HIGH_PRIORITY
%token	HOSTS_SYM
%token	IDENT
%token	IGNORE_SYM
%token	INDEX
247
%token	INDEXES
bk@work.mysql.com's avatar
bk@work.mysql.com committed
248 249
%token	INFILE
%token	INNER_SYM
250
%token	INNOBASE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
251 252
%token	INTO
%token	IN_SYM
253
%token	ISOLATION
bk@work.mysql.com's avatar
bk@work.mysql.com committed
254 255 256 257 258 259
%token	ISAM_SYM
%token	JOIN_SYM
%token	KEYS
%token	KEY_SYM
%token	LEADING
%token	LEAST_SYM
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
260
%token	LEAVES
261
%token	LEVEL_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
262 263 264 265
%token	LEX_HOSTNAME
%token	LIKE
%token	LINES
%token	LOCAL_SYM
266
%token	LOG_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
267 268 269 270
%token	LOGS_SYM
%token	LONG_NUM
%token	LONG_SYM
%token	LOW_PRIORITY
271 272 273 274 275 276 277 278 279 280
%token	MASTER_HOST_SYM
%token	MASTER_USER_SYM
%token	MASTER_LOG_FILE_SYM
%token	MASTER_LOG_POS_SYM
%token	MASTER_PASSWORD_SYM
%token	MASTER_PORT_SYM
%token	MASTER_CONNECT_RETRY_SYM
%token	MASTER_SERVER_ID_SYM
%token	RELAY_LOG_FILE_SYM
%token	RELAY_LOG_POS_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
281 282
%token	MATCH
%token	MAX_ROWS
283 284 285
%token	MAX_CONNECTIONS_PER_HOUR
%token	MAX_QUERIES_PER_HOUR
%token	MAX_UPDATES_PER_HOUR
286
%token	MEDIUM_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
287
%token	MERGE_SYM
288
%token	MEMORY_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
289 290
%token	MIN_ROWS
%token	MYISAM_SYM
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
291
%token	NAMES_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
292 293
%token	NATIONAL_SYM
%token	NATURAL
294
%token	NEW_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
295
%token	NCHAR_SYM
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
296
%token	NCHAR_STRING
bk@work.mysql.com's avatar
bk@work.mysql.com committed
297 298 299 300
%token	NOT
%token	NO_SYM
%token	NULL_SYM
%token	NUM
301
%token	OFFSET_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
302
%token	ON
303
%token	OPEN_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
304 305 306
%token	OPTION
%token	OPTIONALLY
%token	OR
307
%token	OR_OR_CONCAT
bk@work.mysql.com's avatar
bk@work.mysql.com committed
308 309 310
%token	ORDER_SYM
%token	OUTER
%token	OUTFILE
311
%token	DUMPFILE
bk@work.mysql.com's avatar
bk@work.mysql.com committed
312 313 314 315 316 317
%token	PACK_KEYS_SYM
%token	PARTIAL
%token	PRIMARY_SYM
%token	PRIVILEGES
%token	PROCESS
%token	PROCESSLIST_SYM
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
318
%token	QUERY_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
319
%token	RAID_0_SYM
320 321
%token	RAID_STRIPED_SYM
%token	RAID_TYPE
bk@work.mysql.com's avatar
bk@work.mysql.com committed
322 323 324 325 326 327 328 329
%token	RAID_CHUNKS
%token	RAID_CHUNKSIZE
%token	READ_SYM
%token	REAL_NUM
%token	REFERENCES
%token	REGEXP
%token	RELOAD
%token	RENAME
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
330
%token	REPEATABLE_SYM
tonu@x153.internalnet's avatar
tonu@x153.internalnet committed
331
%token	REQUIRE_SYM
332 333
%token	RESOURCES
%token	RESTORE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
334 335 336 337 338
%token	RESTRICT
%token	REVOKE
%token	ROWS_SYM
%token	ROW_FORMAT_SYM
%token	ROW_SYM
339
%token	RTREE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
340
%token	SET
341
%token  SEPARATOR_SYM
342
%token	SERIAL_SYM
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
343 344
%token	SERIALIZABLE_SYM
%token	SESSION_SYM
345
%token	SIMPLE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
346
%token	SHUTDOWN
347
%token	SPATIAL_SYM
348
%token  SSL_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
349 350 351
%token	STARTING
%token	STATUS_SYM
%token	STRAIGHT_JOIN
tonu@x153.internalnet's avatar
tonu@x153.internalnet committed
352
%token	SUBJECT_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
353 354 355 356 357
%token	TABLES
%token	TABLE_SYM
%token	TEMPORARY
%token	TERMINATED
%token	TEXT_STRING
358 359 360
%token	TO_SYM
%token	TRAILING
%token	TRANSACTION_SYM
361
%token	TRUE_SYM
362
%token	TYPE_SYM
363
%token  TYPES_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
364 365 366 367
%token	FUNC_ARG0
%token	FUNC_ARG1
%token	FUNC_ARG2
%token	FUNC_ARG3
368 369 370
%token	UDF_RETURNS_SYM
%token	UDF_SONAME_SYM
%token	UDF_SYM
371
%token	UNCOMMITTED_SYM
372
%token	UNDERSCORE_CHARSET
373
%token	UNICODE_SYM
374 375 376
%token	UNION_SYM
%token	UNIQUE_SYM
%token	USAGE
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
377
%token	USE_FRM
378 379
%token	USE_SYM
%token	USING
380
%token	VALUE_SYM
381
%token	VALUES
bk@work.mysql.com's avatar
bk@work.mysql.com committed
382 383 384 385
%token	VARIABLES
%token	WHERE
%token	WITH
%token	WRITE_SYM
386
%token  NO_WRITE_TO_BINLOG
387
%token	X509_SYM
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
388
%token	XOR
389
%token	COMPRESSED_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
390

391 392 393
%token  ERRORS
%token  WARNINGS

bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
394
%token	ASCII_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
395 396 397
%token	BIGINT
%token	BLOB_SYM
%token	CHAR_SYM
398
%token	CHANGED
bk@work.mysql.com's avatar
bk@work.mysql.com committed
399 400 401 402 403 404
%token	COALESCE
%token	DATETIME
%token	DATE_SYM
%token	DECIMAL_SYM
%token	DOUBLE_SYM
%token	ENUM
405
%token	FAST_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
406
%token	FLOAT_SYM
407
%token  GEOMETRY_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
408 409 410 411 412 413 414 415 416
%token	INT_SYM
%token	LIMIT
%token	LONGBLOB
%token	LONGTEXT
%token	MEDIUMBLOB
%token	MEDIUMINT
%token	MEDIUMTEXT
%token	NUMERIC_SYM
%token	PRECISION
417
%token	QUICK
bk@work.mysql.com's avatar
bk@work.mysql.com committed
418
%token	REAL
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
419
%token	SIGNED_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
420 421 422 423 424 425 426 427
%token	SMALLINT
%token	STRING_SYM
%token	TEXT_SYM
%token	TIMESTAMP
%token	TIME_SYM
%token	TINYBLOB
%token	TINYINT
%token	TINYTEXT
428
%token	ULONGLONG_NUM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
429
%token	UNSIGNED
430 431 432
%token	VARBINARY
%token	VARCHAR
%token	VARYING
bk@work.mysql.com's avatar
bk@work.mysql.com committed
433 434
%token	ZEROFILL

gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
435
%token	ADDDATE_SYM
436
%token	AGAINST
bk@work.mysql.com's avatar
bk@work.mysql.com committed
437 438 439 440 441 442
%token	ATAN
%token	BETWEEN_SYM
%token	BIT_AND
%token	BIT_OR
%token	CASE_SYM
%token	CONCAT
443
%token	CONCAT_WS
bk@work.mysql.com's avatar
bk@work.mysql.com committed
444 445 446 447 448 449
%token	CURDATE
%token	CURTIME
%token	DATABASE
%token	DATE_ADD_INTERVAL
%token	DATE_SUB_INTERVAL
%token	DAY_HOUR_SYM
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
450
%token	DAY_MICROSECOND_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
451 452 453 454
%token	DAY_MINUTE_SYM
%token	DAY_SECOND_SYM
%token	DAY_SYM
%token	DECODE_SYM
455 456
%token	DES_ENCRYPT_SYM
%token	DES_DECRYPT_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
457 458 459 460 461 462 463 464 465 466
%token	ELSE
%token	ELT_FUNC
%token	ENCODE_SYM
%token	ENCRYPT
%token	EXPORT_SET
%token	EXTRACT_SYM
%token	FIELD_FUNC
%token	FORMAT_SYM
%token	FOR_SYM
%token	FROM_UNIXTIME
467 468
%token	GEOMCOLLFROMTEXT
%token	GEOMFROMTEXT
ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
469
%token	GEOMFROMWKB
470
%token  GEOMETRYCOLLECTION
471
%token  GROUP_CONCAT_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
472
%token	GROUP_UNIQUE_USERS
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
473
%token	HOUR_MICROSECOND_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
474 475 476 477 478
%token	HOUR_MINUTE_SYM
%token	HOUR_SECOND_SYM
%token	HOUR_SYM
%token	IDENTIFIED_SYM
%token	IF
479
%token	INSERT_METHOD
bk@work.mysql.com's avatar
bk@work.mysql.com committed
480 481 482
%token	INTERVAL_SYM
%token	LAST_INSERT_ID
%token	LEFT
483
%token	LINEFROMTEXT
484
%token  LINESTRING
bk@work.mysql.com's avatar
bk@work.mysql.com committed
485 486
%token	LOCATE
%token	MAKE_SET_SYM
487
%token	MASTER_POS_WAIT
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
488 489
%token  MICROSECOND_SYM
%token	MINUTE_MICROSECOND_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
490 491
%token	MINUTE_SECOND_SYM
%token	MINUTE_SYM
492
%token	MODE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
493 494
%token	MODIFY_SYM
%token	MONTH_SYM
495 496 497
%token	MLINEFROMTEXT
%token	MPOINTFROMTEXT
%token	MPOLYFROMTEXT
498 499 500
%token  MULTILINESTRING
%token  MULTIPOINT
%token  MULTIPOLYGON
bk@work.mysql.com's avatar
bk@work.mysql.com committed
501 502
%token	NOW_SYM
%token	PASSWORD
503
%token	POINTFROMTEXT
504
%token	POINT_SYM
505
%token	POLYFROMTEXT
506
%token  POLYGON
bk@work.mysql.com's avatar
bk@work.mysql.com committed
507 508 509 510 511 512 513
%token	POSITION_SYM
%token	PROCEDURE
%token	RAND
%token	REPLACE
%token	RIGHT
%token	ROUND
%token	SECOND_SYM
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
514
%token	SECOND_MICROSECOND_SYM
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
515
%token	SHARE_SYM
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
516
%token	SUBDATE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
517 518 519 520 521 522 523 524 525 526 527 528 529 530
%token	SUBSTRING
%token	SUBSTRING_INDEX
%token	TRIM
%token	UDA_CHAR_SUM
%token	UDA_FLOAT_SUM
%token	UDA_INT_SUM
%token	UDF_CHAR_FUNC
%token	UDF_FLOAT_FUNC
%token	UDF_INT_FUNC
%token	UNIQUE_USERS
%token	UNIX_TIMESTAMP
%token	USER
%token	WEEK_SYM
%token	WHEN_SYM
531
%token	WORK_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
532 533 534
%token	YEAR_MONTH_SYM
%token	YEAR_SYM
%token	YEARWEEK
535 536 537
%token	BENCHMARK_SYM
%token	END
%token	THEN_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
538

539 540 541 542
%token	SQL_BIG_RESULT
%token	SQL_CACHE_SYM
%token	SQL_CALC_FOUND_ROWS
%token	SQL_NO_CACHE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
543
%token	SQL_SMALL_RESULT
544
%token  SQL_BUFFER_RESULT
bk@work.mysql.com's avatar
bk@work.mysql.com committed
545

546 547
%token  ISSUER_SYM
%token  SUBJECT_SYM
548
%token  CIPHER_SYM
549

550
%token  HELP
551
%token  BEFORE_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
552 553 554 555 556 557 558 559 560
%left   SET_VAR
%left	OR_OR_CONCAT OR
%left	AND
%left	BETWEEN_SYM CASE_SYM WHEN_SYM THEN_SYM ELSE
%left	EQ EQUAL_SYM GE GT_SYM LE LT NE IS LIKE REGEXP IN_SYM
%left	'|'
%left	'&'
%left	SHIFT_LEFT SHIFT_RIGHT
%left	'-' '+'
561
%left	'*' '/' '%' DIV_SYM MOD_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
562
%left	NEG '~'
563 564
%left   XOR
%left   '^'
bk@work.mysql.com's avatar
bk@work.mysql.com committed
565
%right	NOT
566
%right	BINARY COLLATE_SYM
567

bk@work.mysql.com's avatar
bk@work.mysql.com committed
568 569
%type <lex_str>
	IDENT TEXT_STRING REAL_NUM FLOAT_NUM NUM LONG_NUM HEX_NUM LEX_HOSTNAME
570
	ULONGLONG_NUM field_ident select_alias ident ident_or_text
571
        UNDERSCORE_CHARSET IDENT_sys TEXT_STRING_sys TEXT_STRING_literal
572
	NCHAR_STRING opt_component
bk@work.mysql.com's avatar
bk@work.mysql.com committed
573 574 575 576 577

%type <lex_str_ptr>
	opt_table_alias

%type <table>
578
	table_ident references
bk@work.mysql.com's avatar
bk@work.mysql.com committed
579 580

%type <simple_string>
581
	remember_name remember_end opt_ident opt_db text_or_password
bk@work.mysql.com's avatar
bk@work.mysql.com committed
582 583 584
	opt_escape

%type <string>
585
	text_string opt_gconcat_separator
bk@work.mysql.com's avatar
bk@work.mysql.com committed
586 587

%type <num>
588
	type int_type real_type order_dir opt_field_spec lock_option
bk@work.mysql.com's avatar
bk@work.mysql.com committed
589
	udf_type if_exists opt_local opt_table_options table_options
590
	table_option opt_if_not_exists opt_no_write_to_binlog opt_var_type opt_var_ident_type
591
	delete_option opt_temporary all_or_any opt_distinct opt_ignore_leaves
bk@work.mysql.com's avatar
bk@work.mysql.com committed
592 593

%type <ulong_num>
594
	ULONG_NUM raid_types merge_insert_types
bk@work.mysql.com's avatar
bk@work.mysql.com committed
595

596 597
%type <ulonglong_number>
	ulonglong_num
bk@work.mysql.com's avatar
bk@work.mysql.com committed
598

599 600 601
%type <lock_type>
	replace_lock_option opt_low_priority insert_lock_option load_data_lock

bk@work.mysql.com's avatar
bk@work.mysql.com committed
602
%type <item>
603
	literal text_literal insert_ident order_ident
bk@work.mysql.com's avatar
bk@work.mysql.com committed
604
	simple_ident select_item2 expr opt_expr opt_else sum_expr in_sum_expr
605
	table_wild no_in_expr expr_expr simple_expr no_and_expr
606
	using_list expr_or_default set_expr_or_default interval_expr
607
	param_marker singlerow_subselect singlerow_subselect_init
608
	exists_subselect exists_subselect_init
bk@work.mysql.com's avatar
bk@work.mysql.com committed
609 610

%type <item_list>
611
	expr_list udf_expr_list when_list ident_list ident_list_arg
bk@work.mysql.com's avatar
bk@work.mysql.com committed
612 613

%type <key_type>
614
	key_type opt_unique_or_fulltext
bk@work.mysql.com's avatar
bk@work.mysql.com committed
615

616 617 618
%type <key_alg>
	key_alg opt_btree_or_rtree

bk@work.mysql.com's avatar
bk@work.mysql.com committed
619
%type <string_list>
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
620
	key_usage_list 
bk@work.mysql.com's avatar
bk@work.mysql.com committed
621 622 623 624 625

%type <key_part>
	key_part

%type <table_list>
626
	join_table_list  join_table
bk@work.mysql.com's avatar
bk@work.mysql.com committed
627 628 629 630 631 632 633 634 635 636 637

%type <udf>
	UDF_CHAR_FUNC UDF_FLOAT_FUNC UDF_INT_FUNC
	UDA_CHAR_SUM UDA_FLOAT_SUM UDA_INT_SUM

%type <interval> interval

%type <db_type> table_types

%type <row_type> row_types

638
%type <tx_isolation> isolation_types
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
639

monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi committed
640 641
%type <ha_rkey_mode> handler_rkey_mode

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
642 643
%type <cast_type> cast_type

bk@work.mysql.com's avatar
bk@work.mysql.com committed
644 645 646 647 648 649
%type <udf_type> udf_func_type

%type <symbol> FUNC_ARG0 FUNC_ARG1 FUNC_ARG2 FUNC_ARG3 keyword

%type <lex_user> user grant_user

650
%type <charset>
651
	opt_collate
652 653
	charset_name
	charset_name_or_default
654 655
	old_or_new_charset_name
	old_or_new_charset_name_or_default
656 657
	collation_name
	collation_name_or_default
658

659 660
%type <variable> internal_variable_name

bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
661 662
%type <select_lex> in_subselect in_subselect_init

bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
663 664
%type <boolfunc2creator> comp_op

bk@work.mysql.com's avatar
bk@work.mysql.com committed
665
%type <NONE>
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
666
	query verb_clause create change select do drop insert replace insert2
667
	insert_values update delete truncate rename
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
668
	show describe load alter optimize preload flush
669
	reset purge begin commit rollback slave master_def master_defs
670
	repair restore backup analyze check start
671
	field_list field_list_item field_spec kill column_def key_def
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
672
	preload_list preload_keys
bk@work.mysql.com's avatar
bk@work.mysql.com committed
673
	select_item_list select_item values_list no_braces
674
	opt_limit_clause delete_limit_clause fields opt_values values
bk@work.mysql.com's avatar
bk@work.mysql.com committed
675
	procedure_list procedure_list2 procedure_item
676
	when_list2 expr_list2  handler
bk@work.mysql.com's avatar
bk@work.mysql.com committed
677 678
	opt_precision opt_ignore opt_column opt_restrict
	grant revoke set lock unlock string_list field_options field_option
679
	field_opt_list opt_binary table_lock_list table_lock
680
	ref_list opt_on_delete opt_on_delete_list opt_on_delete_item use
681
	opt_delete_options opt_delete_option varchar nchar nvarchar
682
	opt_outer table_list table_name opt_option opt_place
bk@work.mysql.com's avatar
bk@work.mysql.com committed
683 684
	opt_attribute opt_attribute_list attribute column_list column_list_id
	opt_column_list grant_privileges opt_table user_list grant_option
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
685
	grant_privilege grant_privilege_list
686
	flush_options flush_option
bk@work.mysql.com's avatar
bk@work.mysql.com committed
687 688
	equal optional_braces opt_key_definition key_usage_list2
	opt_mi_check_type opt_to mi_check_types normal_join
689
	table_to_table_list table_to_table opt_table_list opt_as
monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi committed
690
	handler_rkey_function handler_read_or_scan
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
691
	single_multi table_wild_list table_wild_one opt_wild
692
	union_clause union_list union_option
693
	precision subselect_start opt_and charset
694
	subselect_end select_var_list select_var_list_init help opt_len
695
END_OF_INPUT
bk@work.mysql.com's avatar
bk@work.mysql.com committed
696 697 698

%type <NONE>
	'-' '+' '*' '/' '%' '(' ')'
699 700
	',' '!' '{' '}' '&' '|' AND OR OR_OR_CONCAT BETWEEN_SYM CASE_SYM
	THEN_SYM WHEN_SYM DIV_SYM MOD_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
701 702 703 704 705
%%


query:
	END_OF_INPUT
706
	{
707
	   THD *thd= YYTHD;
708
	   if (!thd->bootstrap &&
709
	      (!(thd->lex.select_lex.options & OPTION_FOUND_COMMENT)))
710
	   {
711
	     send_error(thd,ER_EMPTY_QUERY);
712
	     YYABORT;
713
	   }
714 715 716 717
	   else
	   {
	     thd->lex.sql_command = SQLCOM_EMPTY_QUERY;
	   }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
718
	}
719
	| verb_clause END_OF_INPUT {};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
720 721 722 723

verb_clause:
	  alter
	| analyze
724
	| backup
bk@work.mysql.com's avatar
bk@work.mysql.com committed
725 726 727 728 729 730 731
	| begin
	| change
	| check
	| commit
	| create
	| delete
	| describe
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
732
	| do
bk@work.mysql.com's avatar
bk@work.mysql.com committed
733 734 735 736 737 738 739 740
	| drop
	| grant
	| insert
	| flush
	| load
	| lock
	| kill
	| optimize
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
741
	| preload
742
	| purge
743
	| rename
bk@work.mysql.com's avatar
bk@work.mysql.com committed
744 745
        | repair
	| replace
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
746
	| reset
747
	| restore
bk@work.mysql.com's avatar
bk@work.mysql.com committed
748 749 750 751
	| revoke
	| rollback
	| select
	| set
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
752
	| slave
753
	| start
bk@work.mysql.com's avatar
bk@work.mysql.com committed
754
	| show
755
	| truncate
756
	| handler
bk@work.mysql.com's avatar
bk@work.mysql.com committed
757 758
	| unlock
	| update
759 760
	| use
	| help;
761

762 763
/* help */

764
help:
765
       HELP_SYM ident_or_text
766
       {
767 768 769
	  LEX *lex= Lex;
	  lex->sql_command= SQLCOM_HELP;
	  lex->help_arg= $2.str;
770
       };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
771 772 773 774

/* change master */

change:
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
775
       CHANGE MASTER_SYM TO_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
776 777 778
        {
	  LEX *lex = Lex;
	  lex->sql_command = SQLCOM_CHANGE_MASTER;
779
	  bzero((char*) &lex->mi, sizeof(lex->mi));
780 781 782 783
        }
       master_defs
	{}
       ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
784 785 786

master_defs:
       master_def
787
       | master_defs ',' master_def;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
788

bk@work.mysql.com's avatar
bk@work.mysql.com committed
789
master_def:
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
790
       MASTER_HOST_SYM EQ TEXT_STRING_sys
bk@work.mysql.com's avatar
bk@work.mysql.com committed
791 792 793 794
       {
	 Lex->mi.host = $3.str;
       }
       |
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
795
       MASTER_USER_SYM EQ TEXT_STRING_sys
bk@work.mysql.com's avatar
bk@work.mysql.com committed
796 797 798 799
       {
	 Lex->mi.user = $3.str;
       }
       |
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
800
       MASTER_PASSWORD_SYM EQ TEXT_STRING_sys
bk@work.mysql.com's avatar
bk@work.mysql.com committed
801 802 803 804
       {
	 Lex->mi.password = $3.str;
       }
       |
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
805
       MASTER_LOG_FILE_SYM EQ TEXT_STRING_sys
bk@work.mysql.com's avatar
bk@work.mysql.com committed
806 807 808 809
       {
	 Lex->mi.log_file_name = $3.str;
       }
       |
810
       MASTER_PORT_SYM EQ ULONG_NUM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
811 812 813 814
       {
	 Lex->mi.port = $3;
       }
       |
815
       MASTER_LOG_POS_SYM EQ ulonglong_num
bk@work.mysql.com's avatar
bk@work.mysql.com committed
816 817
       {
	 Lex->mi.pos = $3;
818 819 820 821 822 823 824 825 826 827 828 829
         /* 
            If the user specified a value < BIN_LOG_HEADER_SIZE, adjust it
            instead of causing subsequent errors. 
            We need to do it in this file, because only there we know that 
            MASTER_LOG_POS has been explicitely specified. On the contrary
            in change_master() (sql_repl.cc) we cannot distinguish between 0
            (MASTER_LOG_POS explicitely specified as 0) and 0 (unspecified),
            whereas we want to distinguish (specified 0 means "read the binlog
            from 0" (4 in fact), unspecified means "don't change the position
            (keep the preceding value)").
         */
         Lex->mi.pos = max(BIN_LOG_HEADER_SIZE, Lex->mi.pos);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
830 831
       }
       |
832
       MASTER_CONNECT_RETRY_SYM EQ ULONG_NUM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
833 834 835
       {
	 Lex->mi.connect_retry = $3;
       }
836
       |
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
837
       RELAY_LOG_FILE_SYM EQ TEXT_STRING_sys
838 839 840 841 842 843 844
       {
	 Lex->mi.relay_log_name = $3.str;
       }
       |
       RELAY_LOG_POS_SYM EQ ULONG_NUM
       {
	 Lex->mi.relay_log_pos = $3;
845 846
         /* Adjust if < BIN_LOG_HEADER_SIZE (same comment as Lex->mi.pos) */
         Lex->mi.relay_log_pos = max(BIN_LOG_HEADER_SIZE, Lex->mi.relay_log_pos);
847 848
       }
       ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
849

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
850

bk@work.mysql.com's avatar
bk@work.mysql.com committed
851 852 853 854 855
/* create a table */

create:
	CREATE opt_table_options TABLE_SYM opt_if_not_exists table_ident
	{
856
	  THD *thd= YYTHD;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
857 858
	  LEX *lex=Lex;
	  lex->sql_command= SQLCOM_CREATE_TABLE;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
859
	  if (!lex->select_lex.add_table_to_list(thd,$5,
860
						 ($2 &
861 862
						  HA_LEX_CREATE_TMP_TABLE ?
						  &tmp_table_alias :
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
863 864
						  (LEX_STRING*) 0),
						 TL_OPTION_UPDATING,
865 866 867
						 ((using_update_log)?
						  TL_READ_NO_INSERT:
						  TL_READ)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
868 869 870 871 872 873 874
	    YYABORT;
	  lex->create_list.empty();
	  lex->key_list.empty();
	  lex->col_list.empty();
	  lex->change=NullS;
	  bzero((char*) &lex->create_info,sizeof(lex->create_info));
	  lex->create_info.options=$2 | $4;
875
	  lex->create_info.db_type= (enum db_type) lex->thd->variables.table_type;
876
	  lex->create_info.table_charset= thd->variables.character_set_database;
venu@myvenu.com's avatar
venu@myvenu.com committed
877
	  lex->name=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
878 879
	}
	create2
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
880
	{}
881
	| CREATE opt_unique_or_fulltext INDEX ident key_alg ON table_ident
bk@work.mysql.com's avatar
bk@work.mysql.com committed
882
	  {
883 884
	    LEX *lex=Lex;
	    lex->sql_command= SQLCOM_CREATE_INDEX;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
885 886
	    if (!lex->current_select->add_table_to_list(lex->thd, $7, NULL,
							TL_OPTION_UPDATING))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
887
	      YYABORT;
888 889 890 891
	    lex->create_list.empty();
	    lex->key_list.empty();
	    lex->col_list.empty();
	    lex->change=NullS;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
892
	  }
893
	   '(' key_list ')'
bk@work.mysql.com's avatar
bk@work.mysql.com committed
894
	  {
895
	    LEX *lex=Lex;
896

897
	    lex->key_list.push_back(new Key($2,$4.str, $5, lex->col_list));
898
	    lex->col_list.empty();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
899
	  }
900 901 902
	| CREATE DATABASE opt_if_not_exists ident 
	  { Lex->create_info.table_charset=NULL; }
	  opt_create_database_options
bk@work.mysql.com's avatar
bk@work.mysql.com committed
903
	  {
904 905 906 907
	    LEX *lex=Lex;
	    lex->sql_command=SQLCOM_CREATE_DB;
	    lex->name=$4.str;
            lex->create_info.options=$3;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
908
	  }
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
909
	| CREATE udf_func_type UDF_SYM IDENT_sys
bk@work.mysql.com's avatar
bk@work.mysql.com committed
910
	  {
911 912
	    LEX *lex=Lex;
	    lex->sql_command = SQLCOM_CREATE_FUNCTION;
913
	    lex->udf.name = $4;
914
	    lex->udf.type= $2;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
915
	  }
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
916
	  UDF_RETURNS_SYM udf_type UDF_SONAME_SYM TEXT_STRING_sys
bk@work.mysql.com's avatar
bk@work.mysql.com committed
917
	  {
918 919 920
	    LEX *lex=Lex;
	    lex->udf.returns=(Item_result) $7;
	    lex->udf.dl=$9.str;
921 922
	  }
          ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
923 924

create2:
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
925
	'(' field_list ')' opt_create_table_options create3 {}
926
	| opt_create_table_options create3 {}
venu@myvenu.com's avatar
venu@myvenu.com committed
927 928 929 930 931 932
	| LIKE table_ident
      	  {
      	    LEX *lex=Lex;
     	    if (!(lex->name= (char *)$2))
              YYABORT;
    	  }
933 934 935 936 937 938 939
	| '(' LIKE table_ident ')'
      	  {
      	    LEX *lex=Lex;
     	    if (!(lex->name= (char *)$3))
              YYABORT;
    	  }
          ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
940 941

create3:
942 943
	/* empty */ {}
	| opt_duplicate opt_as SELECT_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
944
          {
945 946 947
	    LEX *lex=Lex;
	    lex->lock_option= (using_update_log) ? TL_READ_NO_INSERT : TL_READ;
	    mysql_init_select(lex);
948
	    lex->current_select->parsing_place= SELECT_LEX_NODE::SELECT_LIST;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
949
          }
950 951 952 953 954
          select_options select_item_list
	  {
	    Select->parsing_place= SELECT_LEX_NODE::NO_MATTER;
	  }
	  opt_select_from union_clause {}
955
          ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
956

957 958
opt_as:
	/* empty */ {}
959
	| AS	    {};
960

961 962 963 964 965 966 967 968 969 970 971
opt_create_database_options:
	/* empty */			{}
	| create_database_options	{};

create_database_options:
	create_database_option					{}
	| create_database_options create_database_option	{};

create_database_option:
	  COLLATE_SYM collation_name_or_default	
	  { Lex->create_info.table_charset=$2; }
972 973 974
	| opt_default charset charset_name_or_default
	  { Lex->create_info.table_charset=$3; }
	;
975

bk@work.mysql.com's avatar
bk@work.mysql.com committed
976
opt_table_options:
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
977
	/* empty */	 { $$= 0; }
978
	| table_options  { $$= $1;};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
979 980 981

table_options:
	table_option	{ $$=$1; }
982
	| table_option table_options { $$= $1 | $2; };
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
983

bk@work.mysql.com's avatar
bk@work.mysql.com committed
984
table_option:
985
	TEMPORARY	{ $$=HA_LEX_CREATE_TMP_TABLE; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
986 987

opt_if_not_exists:
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
988
	/* empty */	 { $$= 0; }
989
	| IF NOT EXISTS	 { $$=HA_LEX_CREATE_IF_NOT_EXISTS; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
990 991 992

opt_create_table_options:
	/* empty */
993
	| create_table_options;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
994

995 996 997 998
create_table_options_space_separated:
	create_table_option
	| create_table_option create_table_options_space_separated;

bk@work.mysql.com's avatar
bk@work.mysql.com committed
999 1000
create_table_options:
	create_table_option
1001
	| create_table_option     create_table_options
1002
	| create_table_option ',' create_table_options;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1003 1004

create_table_option:
1005 1006 1007 1008
	TYPE_SYM opt_equal table_types          { Lex->create_info.db_type= $3; }
	| MAX_ROWS opt_equal ulonglong_num	{ Lex->create_info.max_rows= $3; Lex->create_info.used_fields|= HA_CREATE_USED_MAX_ROWS;}
	| MIN_ROWS opt_equal ulonglong_num	{ Lex->create_info.min_rows= $3; Lex->create_info.used_fields|= HA_CREATE_USED_MIN_ROWS;}
	| AVG_ROW_LENGTH opt_equal ULONG_NUM	{ Lex->create_info.avg_row_length=$3; Lex->create_info.used_fields|= HA_CREATE_USED_AVG_ROW_LENGTH;}
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1009 1010
	| PASSWORD opt_equal TEXT_STRING_sys	{ Lex->create_info.password=$3.str; }
	| COMMENT_SYM opt_equal TEXT_STRING_sys	{ Lex->create_info.comment=$3.str; }
1011 1012 1013 1014 1015 1016 1017 1018 1019 1020
	| AUTO_INC opt_equal ulonglong_num	{ Lex->create_info.auto_increment_value=$3; Lex->create_info.used_fields|= HA_CREATE_USED_AUTO;}
	| PACK_KEYS_SYM opt_equal ULONG_NUM	{ Lex->create_info.table_options|= $3 ? HA_OPTION_PACK_KEYS : HA_OPTION_NO_PACK_KEYS; Lex->create_info.used_fields|= HA_CREATE_USED_PACK_KEYS;}
	| PACK_KEYS_SYM opt_equal DEFAULT	{ Lex->create_info.table_options&= ~(HA_OPTION_PACK_KEYS | HA_OPTION_NO_PACK_KEYS); Lex->create_info.used_fields|= HA_CREATE_USED_PACK_KEYS;}
	| CHECKSUM_SYM opt_equal ULONG_NUM	{ Lex->create_info.table_options|= $3 ? HA_OPTION_CHECKSUM : HA_OPTION_NO_CHECKSUM; }
	| DELAY_KEY_WRITE_SYM opt_equal ULONG_NUM { Lex->create_info.table_options|= $3 ? HA_OPTION_DELAY_KEY_WRITE : HA_OPTION_NO_DELAY_KEY_WRITE; }
	| ROW_FORMAT_SYM opt_equal row_types	{ Lex->create_info.row_type= $3; }
	| RAID_TYPE opt_equal raid_types	{ Lex->create_info.raid_type= $3; Lex->create_info.used_fields|= HA_CREATE_USED_RAID;}
	| RAID_CHUNKS opt_equal ULONG_NUM	{ Lex->create_info.raid_chunks= $3; Lex->create_info.used_fields|= HA_CREATE_USED_RAID;}
	| RAID_CHUNKSIZE opt_equal ULONG_NUM	{ Lex->create_info.raid_chunksize= $3*RAID_BLOCK_SIZE; Lex->create_info.used_fields|= HA_CREATE_USED_RAID;}
	| UNION_SYM opt_equal '(' table_list ')'
1021 1022 1023
	  {
	    /* Move the union list to the merge_list */
	    LEX *lex=Lex;
1024 1025
	    TABLE_LIST *table_list= lex->select_lex.get_table_list();
	    lex->create_info.merge_list= lex->select_lex.table_list;
1026 1027
	    lex->create_info.merge_list.elements--;
	    lex->create_info.merge_list.first= (byte*) (table_list->next);
1028 1029
	    lex->select_lex.table_list.elements=1;
	    lex->select_lex.table_list.next= (byte**) &(table_list->next);
1030
	    table_list->next=0;
1031
	    lex->create_info.used_fields|= HA_CREATE_USED_UNION;
1032
	  }
1033
	| opt_default charset opt_equal charset_name_or_default
1034
	  {
1035 1036 1037
	    Lex->create_info.table_charset= $4;
	    Lex->create_info.used_fields|= HA_CREATE_USED_CHARSET;
	  }
1038 1039 1040 1041 1042
	| COLLATE_SYM opt_equal collation_name_or_default
	  {
	    Lex->create_info.table_charset= $3;
	    Lex->create_info.used_fields|= HA_CREATE_USED_CHARSET;
	  }
1043
	| INSERT_METHOD opt_equal merge_insert_types   { Lex->create_info.merge_insert_method= $3; Lex->create_info.used_fields|= HA_CREATE_USED_INSERT_METHOD;}
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1044 1045 1046
	| DATA_SYM DIRECTORY_SYM opt_equal TEXT_STRING_sys
	  { Lex->create_info.data_file_name= $4.str; }
	| INDEX DIRECTORY_SYM opt_equal TEXT_STRING_sys { Lex->create_info.index_file_name= $4.str; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1047 1048 1049 1050 1051 1052

table_types:
	ISAM_SYM	{ $$= DB_TYPE_ISAM; }
	| MYISAM_SYM	{ $$= DB_TYPE_MYISAM; }
	| MERGE_SYM	{ $$= DB_TYPE_MRG_MYISAM; }
	| HEAP_SYM	{ $$= DB_TYPE_HEAP; }
1053
	| MEMORY_SYM	{ $$= DB_TYPE_HEAP; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1054
	| BERKELEY_DB_SYM { $$= DB_TYPE_BERKELEY_DB; }
1055
	| INNOBASE_SYM  { $$= DB_TYPE_INNODB; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1056 1057 1058 1059 1060

row_types:
	DEFAULT		{ $$= ROW_TYPE_DEFAULT; }
	| FIXED_SYM	{ $$= ROW_TYPE_FIXED; }
	| DYNAMIC_SYM	{ $$= ROW_TYPE_DYNAMIC; }
1061
	| COMPRESSED_SYM { $$= ROW_TYPE_COMPRESSED; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1062 1063 1064 1065

raid_types:
	RAID_STRIPED_SYM { $$= RAID_TYPE_0; }
	| RAID_0_SYM	 { $$= RAID_TYPE_0; }
1066
	| ULONG_NUM	 { $$=$1;};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1067

1068 1069 1070
merge_insert_types:
       NO_SYM            { $$= MERGE_INSERT_DISABLED; }
       | FIRST_SYM       { $$= MERGE_INSERT_TO_FIRST; }
1071
       | LAST_SYM        { $$= MERGE_INSERT_TO_LAST; };
1072

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1073
opt_select_from:
1074
	opt_limit_clause {}
1075
	| FROM DUAL_SYM {}
1076
	| select_from select_lock_type;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1077 1078 1079

udf_func_type:
	/* empty */ 	{ $$ = UDFTYPE_FUNCTION; }
1080
	| AGGREGATE_SYM { $$ = UDFTYPE_AGGREGATE; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1081 1082 1083 1084

udf_type:
	STRING_SYM {$$ = (int) STRING_RESULT; }
	| REAL {$$ = (int) REAL_RESULT; }
1085
	| INT_SYM {$$ = (int) INT_RESULT; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1086 1087 1088

field_list:
	  field_list_item
1089
	| field_list ',' field_list_item;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1090 1091 1092


field_list_item:
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1093
	   column_def
1094 1095 1096 1097
         | key_def
         ;

column_def:
1098
	  field_spec check_constraint
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1099 1100 1101 1102
	| field_spec references
	  {
	    Lex->col_list.empty();		/* Alloced by sql_alloc */
	  }
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1103
	;
1104 1105

key_def:
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1106
	key_type opt_ident key_alg '(' key_list ')'
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1107
	  {
1108
	    LEX *lex=Lex;
1109
	    lex->key_list.push_back(new Key($1,$2, $3, lex->col_list));
1110
	    lex->col_list.empty();		/* Alloced by sql_alloc */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1111
	  }
1112
	| opt_constraint FOREIGN KEY_SYM opt_ident '(' key_list ')' references
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1113
	  {
1114 1115 1116 1117 1118 1119 1120 1121
	    LEX *lex=Lex;
	    lex->key_list.push_back(new foreign_key($4, lex->col_list,
				    $8,
				    lex->ref_list,
				    lex->fk_delete_opt,
				    lex->fk_update_opt,
				    lex->fk_match_option));
	    lex->col_list.empty();		/* Alloced by sql_alloc */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1122
	  }
1123
	| opt_constraint check_constraint
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1124 1125
	  {
	    Lex->col_list.empty();		/* Alloced by sql_alloc */
1126 1127 1128 1129 1130 1131 1132
	  }
	;

check_constraint:
	/* empty */
	| CHECK_SYM expr
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1133 1134 1135

opt_constraint:
	/* empty */
1136
	| CONSTRAINT opt_ident;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1137 1138 1139 1140

field_spec:
	field_ident
	 {
1141 1142
	   LEX *lex=Lex;
	   lex->length=lex->dec=0; lex->type=0; lex->interval=0;
1143
	   lex->default_value=lex->comment=0;
1144
	   lex->charset=NULL;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1145 1146 1147
	 }
	type opt_attribute
	{
1148
	  LEX *lex=Lex;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1149
	  if (add_field_to_list(lex->thd, $1.str,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1150
				(enum enum_field_types) $3,
1151
				lex->length,lex->dec,lex->type,
1152
				lex->default_value, lex->comment,
1153 1154
				lex->change,lex->interval,lex->charset,
				lex->uint_geom_type))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1155
	    YYABORT;
1156
	};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1157 1158

type:
1159
	int_type opt_len field_options	{ $$=$1; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1160 1161 1162 1163 1164 1165
	| real_type opt_precision field_options { $$=$1; }
	| FLOAT_SYM float_options field_options { $$=FIELD_TYPE_FLOAT; }
	| BIT_SYM opt_len		{ Lex->length=(char*) "1";
					  $$=FIELD_TYPE_TINY; }
	| BOOL_SYM			{ Lex->length=(char*) "1";
					  $$=FIELD_TYPE_TINY; }
1166 1167
	| BOOLEAN_SYM			{ Lex->length=(char*) "1";
					  $$=FIELD_TYPE_TINY; }
1168
	| char '(' NUM ')' opt_binary	{ Lex->length=$3.str;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1169 1170 1171
					  $$=FIELD_TYPE_STRING; }
	| char opt_binary		{ Lex->length=(char*) "1";
					  $$=FIELD_TYPE_STRING; }
1172 1173
	| nchar '(' NUM ')'		{ Lex->length=$3.str;
					  $$=FIELD_TYPE_STRING; 
1174
					  Lex->charset=national_charset_info; }
1175 1176
	| nchar				{ Lex->length=(char*) "1";
					  $$=FIELD_TYPE_STRING; 
1177
					  Lex->charset=national_charset_info; }
1178
	| BINARY '(' NUM ')'		{ Lex->length=$3.str;
1179
					  Lex->charset=&my_charset_bin;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1180 1181 1182
					  $$=FIELD_TYPE_STRING; }
	| varchar '(' NUM ')' opt_binary { Lex->length=$3.str;
					  $$=FIELD_TYPE_VAR_STRING; }
1183 1184
	| nvarchar '(' NUM ')'		{ Lex->length=$3.str;
					  $$=FIELD_TYPE_VAR_STRING;
1185
					  Lex->charset=national_charset_info; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1186
	| VARBINARY '(' NUM ')' 	{ Lex->length=$3.str;
1187
					  Lex->charset=&my_charset_bin;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1188
					  $$=FIELD_TYPE_VAR_STRING; }
1189
	| YEAR_SYM opt_len field_options { $$=FIELD_TYPE_YEAR; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1190 1191
	| DATE_SYM			{ $$=FIELD_TYPE_DATE; }
	| TIME_SYM			{ $$=FIELD_TYPE_TIME; }
1192 1193
	| TIMESTAMP
	  {
1194
	    if (YYTHD->variables.sql_mode & MODE_SAPDB)
1195 1196
	      $$=FIELD_TYPE_DATETIME;
	    else
1197
	      $$=FIELD_TYPE_TIMESTAMP;
1198
	   }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1199 1200 1201
	| TIMESTAMP '(' NUM ')'		{ Lex->length=$3.str;
					  $$=FIELD_TYPE_TIMESTAMP; }
	| DATETIME			{ $$=FIELD_TYPE_DATETIME; }
1202
	| TINYBLOB			{ Lex->charset=&my_charset_bin;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1203
					  $$=FIELD_TYPE_TINY_BLOB; }
1204
	| BLOB_SYM opt_len		{ Lex->charset=&my_charset_bin;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1205
					  $$=FIELD_TYPE_BLOB; }
1206
	| GEOMETRY_SYM			{ Lex->charset=&my_charset_bin;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1207
					  Lex->uint_geom_type= (uint) Field::GEOM_GEOMETRY;
1208
					  $$=FIELD_TYPE_GEOMETRY; }
1209
	| GEOMETRYCOLLECTION		{ Lex->charset=&my_charset_bin;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1210
					  Lex->uint_geom_type= (uint) Field::GEOM_GEOMETRYCOLLECTION;
1211
					  $$=FIELD_TYPE_GEOMETRY; }
1212
	| POINT_SYM			{ Lex->charset=&my_charset_bin;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1213
					  Lex->uint_geom_type= (uint) Field::GEOM_POINT;
1214 1215
					  $$=FIELD_TYPE_GEOMETRY; }
	| MULTIPOINT			{ Lex->charset=&my_charset_bin;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1216
					  Lex->uint_geom_type= (uint) Field::GEOM_MULTIPOINT;
1217 1218
					  $$=FIELD_TYPE_GEOMETRY; }
	| LINESTRING			{ Lex->charset=&my_charset_bin;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1219
					  Lex->uint_geom_type= (uint) Field::GEOM_LINESTRING;
1220 1221
					  $$=FIELD_TYPE_GEOMETRY; }
	| MULTILINESTRING		{ Lex->charset=&my_charset_bin;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1222
					  Lex->uint_geom_type= (uint) Field::GEOM_MULTILINESTRING;
1223 1224
					  $$=FIELD_TYPE_GEOMETRY; }
	| POLYGON			{ Lex->charset=&my_charset_bin;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1225
					  Lex->uint_geom_type= (uint) Field::GEOM_POLYGON;
1226 1227
					  $$=FIELD_TYPE_GEOMETRY; }
	| MULTIPOLYGON			{ Lex->charset=&my_charset_bin;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1228
					  Lex->uint_geom_type= (uint) Field::GEOM_MULTIPOLYGON;
1229
					  $$=FIELD_TYPE_GEOMETRY; }
1230
	| MEDIUMBLOB			{ Lex->charset=&my_charset_bin;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1231
					  $$=FIELD_TYPE_MEDIUM_BLOB; }
1232
	| LONGBLOB			{ Lex->charset=&my_charset_bin;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1233
					  $$=FIELD_TYPE_LONG_BLOB; }
1234
	| LONG_SYM VARBINARY		{ Lex->charset=&my_charset_bin;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1235
					  $$=FIELD_TYPE_MEDIUM_BLOB; }
1236 1237
	| LONG_SYM varchar opt_binary	{ $$=FIELD_TYPE_MEDIUM_BLOB; }
	| TINYTEXT opt_binary		{ $$=FIELD_TYPE_TINY_BLOB; }
1238
	| TEXT_SYM opt_len opt_binary	{ $$=FIELD_TYPE_BLOB; }
1239 1240
	| MEDIUMTEXT opt_binary		{ $$=FIELD_TYPE_MEDIUM_BLOB; }
	| LONGTEXT opt_binary		{ $$=FIELD_TYPE_LONG_BLOB; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1241 1242 1243 1244
	| DECIMAL_SYM float_options field_options
					{ $$=FIELD_TYPE_DECIMAL;}
	| NUMERIC_SYM float_options field_options
					{ $$=FIELD_TYPE_DECIMAL;}
1245 1246
	| FIXED_SYM float_options field_options
					{ $$=FIELD_TYPE_DECIMAL;}
1247
	| ENUM {Lex->interval_list.empty();} '(' string_list ')' opt_binary
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1248
	  {
1249 1250
	    LEX *lex=Lex;
	    lex->interval=typelib(lex->interval_list);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1251 1252
	    $$=FIELD_TYPE_ENUM;
	  }
1253
	| SET { Lex->interval_list.empty();} '(' string_list ')' opt_binary
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1254
	  {
1255 1256
	    LEX *lex=Lex;
	    lex->interval=typelib(lex->interval_list);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1257
	    $$=FIELD_TYPE_SET;
1258
	  }
1259
	| LONG_SYM opt_binary		{ $$=FIELD_TYPE_MEDIUM_BLOB; }
1260 1261 1262 1263 1264 1265
	| SERIAL_SYM
	  {
	    $$=FIELD_TYPE_LONGLONG;
	    Lex->type|= (AUTO_INCREMENT_FLAG | NOT_NULL_FLAG | UNSIGNED_FLAG |
		         UNIQUE_FLAG);
	  }
1266
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1267 1268 1269

char:
	CHAR_SYM {}
1270 1271 1272 1273 1274 1275
	;

nchar:
	NCHAR_SYM {}
	| NATIONAL_SYM CHAR_SYM {}
	;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1276

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1277 1278 1279
varchar:
	char VARYING {}
	| VARCHAR {}
1280 1281 1282 1283 1284 1285 1286 1287
	;

nvarchar:
	NATIONAL_SYM VARCHAR {}
	| NCHAR_SYM VARCHAR {}
	| NATIONAL_SYM CHAR_SYM VARYING {}
	| NCHAR_SYM VARYING {}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1288 1289 1290 1291 1292 1293

int_type:
	INT_SYM		{ $$=FIELD_TYPE_LONG; }
	| TINYINT	{ $$=FIELD_TYPE_TINY; }
	| SMALLINT	{ $$=FIELD_TYPE_SHORT; }
	| MEDIUMINT	{ $$=FIELD_TYPE_INT24; }
1294
	| BIGINT	{ $$=FIELD_TYPE_LONGLONG; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1295 1296

real_type:
1297
	REAL		{ $$= YYTHD->variables.sql_mode & MODE_REAL_AS_FLOAT ?
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1298 1299
			      FIELD_TYPE_FLOAT : FIELD_TYPE_DOUBLE; }
	| DOUBLE_SYM	{ $$=FIELD_TYPE_DOUBLE; }
1300
	| DOUBLE_SYM PRECISION { $$=FIELD_TYPE_DOUBLE; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1301 1302 1303 1304 1305


float_options:
	/* empty */		{}
	| '(' NUM ')'		{ Lex->length=$2.str; }
1306
	| precision		{};
1307 1308 1309 1310 1311 1312

precision:
	'(' NUM ',' NUM ')'
	{
	  LEX *lex=Lex;
	  lex->length=$2.str; lex->dec=$4.str;
1313
	};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1314 1315 1316

field_options:
	/* empty */		{}
1317
	| field_opt_list	{};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1318 1319 1320

field_opt_list:
	field_opt_list field_option {}
1321
	| field_option {};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1322 1323

field_option:
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1324
	SIGNED_SYM	{}
1325
	| UNSIGNED	{ Lex->type|= UNSIGNED_FLAG;}
1326
	| ZEROFILL	{ Lex->type|= UNSIGNED_FLAG | ZEROFILL_FLAG; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1327 1328

opt_len:
1329 1330
	/* empty */	{ Lex->length=(char*) 0; } /* use default length */
	| '(' NUM ')'	{ Lex->length= $2.str; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1331 1332 1333

opt_precision:
	/* empty */	{}
1334
	| precision	{};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1335 1336 1337

opt_attribute:
	/* empty */ {}
1338
	| opt_attribute_list {};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1339 1340 1341

opt_attribute_list:
	opt_attribute_list attribute {}
1342
	| attribute;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1343 1344 1345 1346 1347 1348

attribute:
	NULL_SYM	  { Lex->type&= ~ NOT_NULL_FLAG; }
	| NOT NULL_SYM	  { Lex->type|= NOT_NULL_FLAG; }
	| DEFAULT literal { Lex->default_value=$2; }
	| AUTO_INC	  { Lex->type|= AUTO_INCREMENT_FLAG | NOT_NULL_FLAG; }
1349
	| SERIAL_SYM DEFAULT VALUE_SYM
1350 1351
	  { Lex->type|= AUTO_INCREMENT_FLAG | NOT_NULL_FLAG | UNIQUE_FLAG; }
	| opt_primary KEY_SYM { Lex->type|= PRI_KEY_FLAG | NOT_NULL_FLAG; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1352
	| UNIQUE_SYM	  { Lex->type|= UNIQUE_FLAG; }
1353
	| UNIQUE_SYM KEY_SYM { Lex->type|= UNIQUE_KEY_FLAG; }
1354
	| COMMENT_SYM text_literal { Lex->comment= $2; }
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1355 1356
	| COLLATE_SYM collation_name 
	  { 
1357
	    if (Lex->charset && !my_charset_same(Lex->charset,$2))
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368
	    {
	      net_printf(YYTHD,ER_COLLATION_CHARSET_MISMATCH,
			 $2->name,Lex->charset->csname);
	      YYABORT;
	    }
	    else
	    {
	      Lex->charset=$2;
	    }
	  }
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1369

1370 1371 1372 1373
charset:
	CHAR_SYM SET	{}
	| CHARSET	{}
	;
1374

1375
charset_name:
1376
	ident_or_text
1377
	{
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1378
	  if (!($$=get_charset_by_csname($1.str,MY_CS_PRIMARY,MYF(0))))
1379
	  {
1380
	    net_printf(YYTHD,ER_UNKNOWN_CHARACTER_SET,$1.str);
1381 1382
	    YYABORT;
	  }
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1383 1384 1385
	}
	| BINARY { $$= &my_charset_bin; }
	;
1386

1387 1388 1389
charset_name_or_default:
	charset_name { $$=$1;   }
	| DEFAULT    { $$=NULL; } ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1390

1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408

old_or_new_charset_name:
	ident_or_text
	{
	  if (!($$=get_charset_by_csname($1.str,MY_CS_PRIMARY,MYF(0))) &&
	      !($$=get_old_charset_by_name($1.str)))
	  {
	    net_printf(YYTHD,ER_UNKNOWN_CHARACTER_SET,$1.str);
	    YYABORT;
	  }
	}
	| BINARY { $$= &my_charset_bin; }
	;

old_or_new_charset_name_or_default:
	old_or_new_charset_name { $$=$1;   }
	| DEFAULT    { $$=NULL; } ;

1409
collation_name:
1410
	ident_or_text
1411 1412 1413 1414 1415 1416 1417 1418
	{
	  if (!($$=get_charset_by_name($1.str,MYF(0))))
	  {
	    net_printf(YYTHD,ER_UNKNOWN_CHARACTER_SET,$1.str);
	    YYABORT;
	  }
	};

1419 1420
opt_collate:
	/* empty */	{ $$=NULL; }
1421
	| COLLATE_SYM collation_name_or_default { $$=$2; }
1422 1423
	;

1424 1425 1426 1427
collation_name_or_default:
	collation_name { $$=$1;   }
	| DEFAULT    { $$=NULL; } ;

1428 1429 1430 1431
opt_default:
	/* empty */	{}
	| DEFAULT	{};

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1432
opt_binary:
1433
	/* empty */			{ Lex->charset=NULL; }
1434 1435 1436
	| ASCII_SYM			{ Lex->charset=&my_charset_latin1; }
	| BYTE_SYM			{ Lex->charset=&my_charset_bin; }
	| BINARY			{ Lex->charset=&my_charset_bin; }
1437 1438
	| UNICODE_SYM
	{
1439
	  if (!(Lex->charset=get_charset_by_csname("ucs2",MY_CS_PRIMARY,MYF(0))))
1440 1441 1442 1443 1444
	  {
	    net_printf(YYTHD,ER_UNKNOWN_CHARACTER_SET,"ucs2");
	    YYABORT;
	  }
	}
1445
	| charset charset_name	{ Lex->charset=$2; } ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1446

1447 1448 1449
opt_primary:
	/* empty */
	| PRIMARY_SYM
1450
	;
1451

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1452
references:
1453 1454
	REFERENCES table_ident
	{
1455
	  LEX *lex=Lex;
1456 1457 1458 1459 1460 1461
	  lex->fk_delete_opt= lex->fk_update_opt= lex->fk_match_option= 0;
	  lex->ref_list.empty();
	}
	opt_ref_list
	{
	  $$=$2;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1462
	};
1463

1464
opt_ref_list:
1465
	/* empty */ opt_on_delete {}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1466
	| '(' ref_list ')' opt_on_delete {};
1467 1468 1469

ref_list:
	ref_list ',' ident	{ Lex->ref_list.push_back(new key_part_spec($3.str)); }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1470
	| ident			{ Lex->ref_list.push_back(new key_part_spec($1.str)); };
1471

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1472 1473 1474

opt_on_delete:
	/* empty */ {}
1475
	| opt_on_delete_list {};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1476 1477 1478

opt_on_delete_list:
	opt_on_delete_list opt_on_delete_item {}
1479
	| opt_on_delete_item {};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1480 1481

opt_on_delete_item:
1482 1483 1484 1485
	ON DELETE_SYM delete_option   { Lex->fk_delete_opt= $3; }
	| ON UPDATE_SYM delete_option { Lex->fk_update_opt= $3; }
	| MATCH FULL	{ Lex->fk_match_option= foreign_key::FK_MATCH_FULL; }
	| MATCH PARTIAL { Lex->fk_match_option= foreign_key::FK_MATCH_PARTIAL; }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1486
	| MATCH SIMPLE_SYM { Lex->fk_match_option= foreign_key::FK_MATCH_SIMPLE; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1487 1488

delete_option:
1489 1490 1491 1492
	RESTRICT	 { $$= (int) foreign_key::FK_OPTION_RESTRICT; }
	| CASCADE	 { $$= (int) foreign_key::FK_OPTION_CASCADE; }
	| SET NULL_SYM   { $$= (int) foreign_key::FK_OPTION_SET_NULL; }
	| NO_SYM ACTION  { $$= (int) foreign_key::FK_OPTION_NO_ACTION; }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1493
	| SET DEFAULT    { $$= (int) foreign_key::FK_OPTION_DEFAULT;  };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1494 1495 1496 1497

key_type:
	opt_constraint PRIMARY_SYM KEY_SYM  { $$= Key::PRIMARY; }
	| key_or_index			    { $$= Key::MULTIPLE; }
1498 1499
	| FULLTEXT_SYM			    { $$= Key::FULLTEXT; }
	| FULLTEXT_SYM key_or_index	    { $$= Key::FULLTEXT; }
1500 1501
	| SPATIAL_SYM			    { $$= Key::SPATIAL; }
	| SPATIAL_SYM key_or_index	    { $$= Key::SPATIAL; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1502
	| opt_constraint UNIQUE_SYM	    { $$= Key::UNIQUE; }
1503
	| opt_constraint UNIQUE_SYM key_or_index { $$= Key::UNIQUE; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1504 1505 1506

key_or_index:
	KEY_SYM {}
1507
	| INDEX {};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1508 1509 1510 1511

keys_or_index:
	KEYS {}
	| INDEX {}
1512
	| INDEXES {};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1513

1514
opt_unique_or_fulltext:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1515 1516
	/* empty */	{ $$= Key::MULTIPLE; }
	| UNIQUE_SYM	{ $$= Key::UNIQUE; }
serg@serg.mylan's avatar
serg@serg.mylan committed
1517 1518 1519
	| FULLTEXT_SYM	{ $$= Key::FULLTEXT;}
	| SPATIAL_SYM	{ $$= Key::SPATIAL; }
        ;
1520 1521

key_alg:
1522
	/* empty */		   { $$= HA_KEY_ALG_UNDEF; }
1523
	| USING opt_btree_or_rtree { $$= $2; }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1524
	| TYPE_SYM opt_btree_or_rtree  { $$= $2; };
1525 1526 1527 1528

opt_btree_or_rtree:
	BTREE_SYM	{ $$= HA_KEY_ALG_BTREE; }
	| RTREE_SYM	{ $$= HA_KEY_ALG_RTREE; }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1529
	| HASH_SYM	{ $$= HA_KEY_ALG_HASH; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1530 1531 1532

key_list:
	key_list ',' key_part order_dir { Lex->col_list.push_back($3); }
1533
	| key_part order_dir		{ Lex->col_list.push_back($1); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1534 1535 1536

key_part:
	ident			{ $$=new key_part_spec($1.str); }
1537
	| ident '(' NUM ')'	{ $$=new key_part_spec($1.str,(uint) atoi($3.str)); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1538 1539 1540

opt_ident:
	/* empty */	{ $$=(char*) 0; }	/* Defaultlength */
1541
	| field_ident	{ $$=$1.str; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1542

1543 1544 1545 1546
opt_component:
	/* empty */	 { $$.str= 0; $$.length= 0; }
	| '.' ident	 { $$=$2; };
	
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1547 1548
string_list:
	text_string			{ Lex->interval_list.push_back($1); }
1549
	| string_list ',' text_string	{ Lex->interval_list.push_back($3); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1550 1551 1552 1553 1554 1555 1556 1557

/*
** Alter table
*/

alter:
	ALTER opt_ignore TABLE_SYM table_ident
	{
1558
	  THD *thd= YYTHD;
1559
	  LEX *lex=&thd->lex;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1560 1561
	  lex->sql_command = SQLCOM_ALTER_TABLE;
	  lex->name=0;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1562 1563
	  if (!lex->select_lex.add_table_to_list(thd, $4, NULL,
						 TL_OPTION_UPDATING))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1564 1565 1566 1567 1568 1569 1570
	    YYABORT;
	  lex->drop_primary=0;
	  lex->create_list.empty();
	  lex->key_list.empty();
	  lex->col_list.empty();
	  lex->drop_list.empty();
	  lex->alter_list.empty();
1571
          lex->select_lex.init_order();
1572
	  lex->select_lex.db=lex->name=0;
1573
	  bzero((char*) &lex->create_info,sizeof(lex->create_info));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1574
	  lex->create_info.db_type= DB_TYPE_DEFAULT;
1575
	  lex->create_info.table_charset= thd->variables.character_set_database;
1576
	  lex->create_info.row_type= ROW_TYPE_NOT_USED;
1577 1578
          lex->alter_keys_onoff=LEAVE_AS_IS;
          lex->simple_alter=1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1579
	}
1580 1581
	alter_list
	{}
1582
	| ALTER DATABASE ident opt_create_database_options
1583 1584 1585 1586
	  {
	    LEX *lex=Lex;
	    lex->sql_command=SQLCOM_ALTER_DB;
	    lex->name=$3.str;
1587
	  };
1588 1589


bk@work.mysql.com's avatar
bk@work.mysql.com committed
1590
alter_list:
1591
        | alter_list_item
1592
	| alter_list ',' alter_list_item;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1593 1594

add_column:
1595
	ADD opt_column { Lex->change=0; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1596 1597

alter_list_item:
1598 1599
	add_column column_def opt_place { Lex->simple_alter=0; }
	| ADD key_def { Lex->simple_alter=0; }
1600
	| add_column '(' field_list ')'      { Lex->simple_alter=0; }
1601 1602 1603 1604 1605
	| CHANGE opt_column field_ident
	  {
	     LEX *lex=Lex;
	     lex->change= $3.str; lex->simple_alter=0;
	  }
1606
          field_spec opt_place
1607 1608 1609 1610 1611
        | MODIFY_SYM opt_column field_ident
          {
            LEX *lex=Lex;
            lex->length=lex->dec=0; lex->type=0; lex->interval=0;
            lex->default_value=lex->comment=0;
1612
	    lex->charset= NULL;
1613
            lex->simple_alter=0;
1614 1615 1616 1617
          }
          type opt_attribute
          {
            LEX *lex=Lex;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1618
            if (add_field_to_list(lex->thd,$3.str,
1619 1620 1621
                                  (enum enum_field_types) $5,
                                  lex->length,lex->dec,lex->type,
                                  lex->default_value, lex->comment,
1622 1623
				  $3.str, lex->interval, lex->charset,
				  lex->uint_geom_type))
1624 1625 1626
	       YYABORT;
          }
          opt_place
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1627
	| DROP opt_column field_ident opt_restrict
1628 1629 1630 1631 1632 1633 1634 1635 1636 1637
	  {
	    LEX *lex=Lex;
	    lex->drop_list.push_back(new Alter_drop(Alter_drop::COLUMN,
					    $3.str)); lex->simple_alter=0;
	  }
	| DROP PRIMARY_SYM KEY_SYM
	  {
	    LEX *lex=Lex;
	    lex->drop_primary=1; lex->simple_alter=0;
	  }
1638
	| DROP FOREIGN KEY_SYM opt_ident { Lex->simple_alter=0; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1639
	| DROP key_or_index field_ident
1640 1641 1642 1643 1644 1645
	  {
	    LEX *lex=Lex;
	    lex->drop_list.push_back(new Alter_drop(Alter_drop::KEY,
						    $3.str));
	    lex->simple_alter=0;
	  }
1646 1647
	| DISABLE_SYM KEYS { Lex->alter_keys_onoff=DISABLE; }
	| ENABLE_SYM KEYS  { Lex->alter_keys_onoff=ENABLE; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1648
	| ALTER opt_column field_ident SET DEFAULT literal
1649 1650 1651 1652 1653
	  {
	    LEX *lex=Lex;
	    lex->alter_list.push_back(new Alter_column($3.str,$6));
	    lex->simple_alter=0;
	  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1654
	| ALTER opt_column field_ident DROP DEFAULT
1655 1656 1657 1658 1659
	  {
	    LEX *lex=Lex;
	    lex->alter_list.push_back(new Alter_column($3.str,(Item*) 0));
	    lex->simple_alter=0;
	  }
1660
	| RENAME opt_to table_ident
1661
	  {
1662
	    LEX *lex=Lex;
1663
	    lex->select_lex.db=$3->db.str;
1664
	    lex->name= $3->table.str;
1665
	  }
1666
        | create_table_options_space_separated { Lex->simple_alter=0; }
1667
	| order_clause         { Lex->simple_alter=0; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1668 1669 1670

opt_column:
	/* empty */	{}
1671
	| COLUMN_SYM	{};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1672 1673 1674

opt_ignore:
	/* empty */	{ Lex->duplicates=DUP_ERROR; }
1675
	| IGNORE_SYM	{ Lex->duplicates=DUP_IGNORE; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1676 1677 1678 1679

opt_restrict:
	/* empty */	{}
	| RESTRICT	{}
1680
	| CASCADE	{};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1681 1682 1683 1684

opt_place:
	/* empty */	{}
	| AFTER_SYM ident { store_position_for_column($2.str); }
1685
	| FIRST_SYM	  { store_position_for_column(first_keyword); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1686 1687 1688 1689

opt_to:
	/* empty */	{}
	| TO_SYM	{}
1690
	| EQ		{}
1691
	| AS		{};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1692

nick@mysql.com's avatar
nick@mysql.com committed
1693
/*
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1694 1695 1696
  The first two deprecate the last two--delete the last two for 4.1 release
*/

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1697
slave:
1698
	START_SYM SLAVE slave_thread_opts
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710
        {
	  LEX *lex=Lex;
          lex->sql_command = SQLCOM_SLAVE_START;
	  lex->type = 0;
        }
        | STOP_SYM SLAVE slave_thread_opts
          {
	    LEX *lex=Lex;
            lex->sql_command = SQLCOM_SLAVE_STOP;
	    lex->type = 0;
          }
	;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1711

1712 1713 1714 1715 1716
start:
	START_SYM TRANSACTION_SYM { Lex->sql_command = SQLCOM_BEGIN;}
	{}
	;

1717
slave_thread_opts:
1718 1719
	{ Lex->slave_thd_opt= 0; }
	slave_thread_opt_list
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1720
	;
1721 1722

slave_thread_opt_list:
1723
	slave_thread_opt
1724 1725
	| slave_thread_opt_list ',' slave_thread_opt
	;
1726 1727

slave_thread_opt:
1728
	/*empty*/	{}
1729
	| SQL_THREAD	{ Lex->slave_thd_opt|=SLAVE_SQL; }
1730
	| RELAY_THREAD 	{ Lex->slave_thd_opt|=SLAVE_IO; }
1731
	;
1732

1733 1734 1735 1736 1737
restore:
	RESTORE_SYM table_or_tables
	{
	   Lex->sql_command = SQLCOM_RESTORE_TABLE;
	}
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1738
	table_list FROM TEXT_STRING_sys
1739 1740
        {
	  Lex->backup_dir = $6.str;
1741
        };
1742

1743 1744 1745 1746 1747
backup:
	BACKUP_SYM table_or_tables
	{
	   Lex->sql_command = SQLCOM_BACKUP_TABLE;
	}
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1748
	table_list TO_SYM TEXT_STRING_sys
1749 1750
        {
	  Lex->backup_dir = $6.str;
1751
        };
1752

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1753
repair:
1754
	REPAIR opt_no_write_to_binlog table_or_tables
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1755
	{
1756 1757
	   LEX *lex=Lex;
	   lex->sql_command = SQLCOM_REPAIR;
1758
           lex->no_write_to_binlog= $2;
1759
	   lex->check_opt.init();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1760
	}
1761 1762 1763
	table_list opt_mi_repair_type
	{}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1764

serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
1765
opt_mi_repair_type:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1766
	/* empty */ { Lex->check_opt.flags = T_MEDIUM; }
1767
	| mi_repair_types {};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1768

serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
1769 1770
mi_repair_types:
	mi_repair_type {}
1771
	| mi_repair_type mi_repair_types {};
1772

serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
1773
mi_repair_type:
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
1774
	QUICK          { Lex->check_opt.flags|= T_QUICK; }
1775
	| EXTENDED_SYM { Lex->check_opt.flags|= T_EXTEND; }
1776
        | USE_FRM      { Lex->check_opt.sql_flags|= TT_USEFRM; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1777 1778

analyze:
1779
	ANALYZE_SYM opt_no_write_to_binlog table_or_tables
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1780
	{
1781 1782
	   LEX *lex=Lex;
	   lex->sql_command = SQLCOM_ANALYZE;
1783
           lex->no_write_to_binlog= $2;
1784
	   lex->check_opt.init();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1785
	}
1786 1787 1788
	table_list opt_mi_check_type
	{}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1789 1790

check:
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1791
	CHECK_SYM table_or_tables
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1792
	{
1793 1794 1795
	   LEX *lex=Lex;
	   lex->sql_command = SQLCOM_CHECK;
	   lex->check_opt.init();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1796
	}
1797 1798 1799
	table_list opt_mi_check_type
	{}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1800

serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
1801 1802
opt_mi_check_type:
	/* empty */ { Lex->check_opt.flags = T_MEDIUM; }
1803
	| mi_check_types {};
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
1804 1805 1806

mi_check_types:
	mi_check_type {}
1807
	| mi_check_type mi_check_types {};
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
1808 1809 1810 1811 1812 1813

mi_check_type:
	QUICK      { Lex->check_opt.flags|= T_QUICK; }
	| FAST_SYM { Lex->check_opt.flags|= T_FAST; }
	| MEDIUM_SYM { Lex->check_opt.flags|= T_MEDIUM; }
	| EXTENDED_SYM { Lex->check_opt.flags|= T_EXTEND; }
1814
	| CHANGED  { Lex->check_opt.flags|= T_CHECK_ONLY_CHANGED; };
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
1815

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1816
optimize:
1817
	OPTIMIZE opt_no_write_to_binlog table_or_tables
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1818
	{
1819 1820
	   LEX *lex=Lex;
	   lex->sql_command = SQLCOM_OPTIMIZE;
1821
           lex->no_write_to_binlog= $2;        
1822
	   lex->check_opt.init();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1823
	}
1824 1825 1826
	table_list opt_mi_check_type
	{}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1827

1828 1829 1830
opt_no_write_to_binlog:
	/* empty */        { $$= 0; }
	| NO_WRITE_TO_BINLOG  { $$= 1; }
1831
	| LOCAL_SYM  { $$= 1; }
1832 1833
	;

1834 1835 1836 1837 1838
rename:
	RENAME table_or_tables
	{
	   Lex->sql_command=SQLCOM_RENAME_TABLE;
	}
1839 1840 1841
	table_to_table_list
	{}
	;
1842 1843 1844

table_to_table_list:
	table_to_table
1845
	| table_to_table_list ',' table_to_table;
1846 1847 1848

table_to_table:
	table_ident TO_SYM table_ident
1849
	{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1850 1851
	  LEX *lex=Lex;	  
	  SELECT_LEX_NODE *sl= lex->current_select;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1852 1853 1854 1855
	  if (!sl->add_table_to_list(lex->thd, $1,NULL,TL_OPTION_UPDATING,
				     TL_IGNORE) ||
	      !sl->add_table_to_list(lex->thd, $3,NULL,TL_OPTION_UPDATING,
				     TL_IGNORE))
1856
	    YYABORT;
1857
	};
1858

igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
1859
preload:
1860
	LOAD INDEX INTO CACHE_SYM
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873
	{
	  LEX *lex=Lex;
	  lex->sql_command=SQLCOM_PRELOAD_KEYS;
	}
	preload_list
	{}
	;

preload_list:
	preload_keys
	| preload_list ',' preload_keys;

preload_keys:
1874
	table_ident preload_keys_spec opt_ignore_leaves
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
1875 1876 1877 1878 1879 1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 1891 1892 1893 1894 1895 1896 1897 1898 1899 1900 1901
	{
	  LEX *lex=Lex;
	  SELECT_LEX *sel= &lex->select_lex;
	  if (!sel->add_table_to_list(lex->thd, $1, NULL, $3, 
                                      TL_READ, 
                                      sel->get_use_index(),
                                      (List<String> *)0))
            YYABORT;
	}
	;

preload_keys_spec:
	keys_or_index { Select->select_lex()->interval_list.empty(); }
	preload_key_list_or_empty 
	{
	  LEX *lex=Lex;
	  SELECT_LEX *sel= &lex->select_lex;
	  sel->use_index= sel->interval_list;
	  sel->use_index_ptr= &sel->use_index;
	}          
	;

preload_key_list_or_empty:
	/* empty */
	| '(' key_usage_list2 ')' {}
	;

1902
opt_ignore_leaves:
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
1903 1904 1905 1906 1907
	/* empty */
	{ $$= 0; }
	| IGNORE_SYM LEAVES { $$= TL_OPTION_IGNORE_LEAVES; }
	;

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1908
/*
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1909
  Select : retrieve data from table
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1910 1911 1912 1913
*/


select:
1914
	select_init { Lex->sql_command=SQLCOM_SELECT; };
1915

1916
/* Need select_init2 for subselects. */
1917
select_init:
1918
	SELECT_SYM select_init2
1919
	|
1920 1921
	'(' SELECT_SYM select_part2 ')'
	  {
1922
	    LEX *lex= Lex;
Sinisa@sinisa.nasamreza.org's avatar
Sinisa@sinisa.nasamreza.org committed
1923
            SELECT_LEX * sel= lex->current_select->select_lex();
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1924
	    if (sel->set_braces(1))
1925 1926 1927 1928
	    {
	      send_error(lex->thd, ER_SYNTAX_ERROR);
	      YYABORT;
	    }
1929 1930
	  if (sel->linkage == UNION_TYPE &&
	      !sel->master_unit()->first_select()->braces)
Sinisa@sinisa.nasamreza.org's avatar
Sinisa@sinisa.nasamreza.org committed
1931 1932 1933 1934
	  {
	    send_error(lex->thd, ER_SYNTAX_ERROR);
	    YYABORT;
	  }
1935
            /* select in braces, can't contain global parameters */
1936
            sel->master_unit()->global_parameters=
1937
               sel->master_unit();
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
1938
          } union_opt;
1939

1940 1941
select_init2:
	select_part2
1942
        {
1943
	  LEX *lex= Lex;
Sinisa@sinisa.nasamreza.org's avatar
Sinisa@sinisa.nasamreza.org committed
1944
          SELECT_LEX * sel= lex->current_select->select_lex();
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1945
          if (lex->current_select->set_braces(0))
1946 1947 1948 1949
	  {
	    send_error(lex->thd, ER_SYNTAX_ERROR);
	    YYABORT;
	  }
1950 1951
	  if (sel->linkage == UNION_TYPE &&
	      sel->master_unit()->first_select()->braces)
Sinisa@sinisa.nasamreza.org's avatar
Sinisa@sinisa.nasamreza.org committed
1952 1953 1954 1955
	  {
	    send_error(lex->thd, ER_SYNTAX_ERROR);
	    YYABORT;
	  }
1956
	}
1957
	union_clause
1958 1959
	;

1960
select_part2:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1961 1962
	{
	  LEX *lex=Lex;
Sinisa@sinisa.nasamreza.org's avatar
Sinisa@sinisa.nasamreza.org committed
1963
	  SELECT_LEX * sel= lex->current_select->select_lex();
1964
	  if (lex->current_select == &lex->select_lex)
1965
	    lex->lock_option= TL_READ; /* Only for global SELECT */
1966 1967
	  if (sel->linkage != UNION_TYPE)
	    mysql_init_select(lex);
1968 1969 1970 1971 1972
	  lex->current_select->parsing_place= SELECT_LEX_NODE::SELECT_LIST;
	}
	select_options select_item_list
	{
	  Select->parsing_place= SELECT_LEX_NODE::NO_MATTER;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1973
	}
1974
	select_into select_lock_type;
1975

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1976
select_into:
1977 1978 1979 1980 1981 1982
	opt_limit_clause {}
	| FROM DUAL_SYM /* oracle compatibility: oracle always requires FROM
                           clause, and DUAL is system table without fields.
                           Is "SELECT 1 FROM DUAL" any better than
                           "SELECT 1" ? Hmmm :) */
        | into
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1983
	| select_from
1984 1985
	| into select_from
	| select_from into;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1986 1987

select_from:
1988
	FROM join_table_list where_clause group_clause having_clause opt_order_clause opt_limit_clause procedure_clause;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1989 1990 1991

select_options:
	/* empty*/
1992
	| select_option_list;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1993 1994 1995

select_option_list:
	select_option_list select_option
1996
	| select_option;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1997 1998

select_option:
1999
	STRAIGHT_JOIN { Select->options|= SELECT_STRAIGHT_JOIN; }
2000 2001 2002 2003 2004 2005
	| HIGH_PRIORITY
	  {
	    if (check_simple_select())
	      YYABORT;
	    Lex->lock_option= TL_READ_HIGH_PRIORITY;
	  }
2006 2007 2008
	| DISTINCT	{ Select->options|= SELECT_DISTINCT; }
	| SQL_SMALL_RESULT { Select->options|= SELECT_SMALL_RESULT; }
	| SQL_BIG_RESULT { Select->options|= SELECT_BIG_RESULT; }
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
	| SQL_BUFFER_RESULT
	  {
	    if (check_simple_select())
	      YYABORT;
	    Select->options|= OPTION_BUFFER_RESULT;
	  }
	| SQL_CALC_FOUND_ROWS
	  {
	    if (check_simple_select())
	      YYABORT;
	    Select->options|= OPTION_FOUND_ROWS;
	  }
2021
	| SQL_NO_CACHE_SYM { Lex->uncacheable(); }
2022 2023 2024 2025
	| SQL_CACHE_SYM
	  {
	    Lex->select_lex.options|= OPTION_TO_QUERY_CACHE;
	  }
2026 2027
	| ALL		{}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2028

monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
2029 2030 2031
select_lock_type:
	/* empty */
	| FOR_SYM UPDATE_SYM
2032 2033
	  {
	    LEX *lex=Lex;
2034
	    lex->current_select->set_lock_for_tables(TL_WRITE);
2035
	    lex->safe_to_cache_query=0;
2036
	  }
2037
	| LOCK_SYM IN_SYM SHARE_SYM MODE_SYM
2038 2039
	  {
	    LEX *lex=Lex;
2040 2041
	    lex->current_select->
	      set_lock_for_tables(TL_READ_WITH_SHARED_LOCKS);
2042
	    lex->safe_to_cache_query=0;
2043 2044
	  }
	;
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
2045

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2046 2047 2048 2049 2050
select_item_list:
	  select_item_list ',' select_item
	| select_item
	| '*'
	  {
2051 2052
	    THD *thd= YYTHD;
	    if (add_item_to_list(thd, new Item_field(NULL, NULL, "*")))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2053
	      YYABORT;
2054
	    (thd->lex.current_select->select_lex()->with_wild)++;
2055
	  };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2056 2057 2058 2059 2060


select_item:
	  remember_name select_item2 remember_end select_alias
	  {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2061
	    if (add_item_to_list(YYTHD, $2))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2062 2063
	      YYABORT;
	    if ($4.str)
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
2064
	      $2->set_name($4.str,$4.length,system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2065
	    else if (!$2->name)
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
2066
	      $2->set_name($1,(uint) ($3 - $1), YYTHD->charset());
2067
	  };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2068 2069

remember_name:
2070
	{ $$=(char*) Lex->tok_start; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2071 2072

remember_end:
2073
	{ $$=(char*) Lex->tok_end; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2074 2075 2076

select_item2:
	table_wild	{ $$=$1; } /* table.* */
2077
	| expr		{ $$=$1; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2078 2079

select_alias:
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
2080 2081 2082 2083 2084 2085
	/* empty */		{ $$.str=0;}
	| AS ident		{ $$=$2; }
	| AS TEXT_STRING_sys	{ $$=$2; }
	| ident			{ $$=$1; }
	| TEXT_STRING_sys	{ $$=$1; }
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2086 2087 2088

optional_braces:
	/* empty */ {}
2089
	| '(' ')' {};
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
2090

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2091
/* all possible expressions */
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2092 2093 2094 2095
expr:	
	expr_expr	{ $$= $1; }
	| simple_expr	{ $$= $1; }
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2096

bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108
comp_op:  EQ		{ $$ = &comp_eq_creator; }
	| GE		{ $$ = &comp_ge_creator; }
	| GT_SYM	{ $$ = &comp_gt_creator; }
	| LE		{ $$ = &comp_le_creator; }
	| LT		{ $$ = &comp_lt_creator; }
	| NE		{ $$ = &comp_ne_creator; }
	;

all_or_any: ALL     { $$ = 1; }
        |   ANY_SYM { $$ = 0; }
        ;

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2109 2110
/* expressions that begin with 'expr' */
expr_expr:
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2111
	 expr IN_SYM '(' expr_list ')'
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2112 2113 2114
	  { $$= new Item_func_in($1,*$4); }
	| expr NOT IN_SYM '(' expr_list ')'
	  { $$= new Item_func_not(new Item_func_in($1,*$5)); }
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2115
        | expr IN_SYM in_subselect
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2116
          { $$= new Item_in_subselect(YYTHD, $1, $3); }
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2117
	| expr NOT IN_SYM in_subselect
2118
          {
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2119
            $$= new Item_func_not(new Item_in_subselect(YYTHD, $1, $4));
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2120
          }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2121 2122 2123 2124
	| expr BETWEEN_SYM no_and_expr AND expr
	  { $$= new Item_func_between($1,$3,$5); }
	| expr NOT BETWEEN_SYM no_and_expr AND expr
	  { $$= new Item_func_not(new Item_func_between($1,$4,$6)); }
2125
	| expr OR_OR_CONCAT expr { $$= or_or_concat(YYTHD, $1,$3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2126
	| expr OR expr		{ $$= new Item_cond_or($1,$3); }
2127
        | expr XOR expr		{ $$= new Item_cond_xor($1,$3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2128
	| expr AND expr		{ $$= new Item_cond_and($1,$3); }
2129
	| expr SOUNDS_SYM LIKE expr { $$= Item_bool_func2::eq_creator(new Item_func_soundex($1), new Item_func_soundex($4));}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2130 2131 2132 2133 2134 2135 2136
	| expr LIKE simple_expr opt_escape { $$= new Item_func_like($1,$3,$4); }
	| expr NOT LIKE simple_expr opt_escape	{ $$= new Item_func_not(new Item_func_like($1,$4,$5));}
	| expr REGEXP expr { $$= new Item_func_regex($1,$3); }
	| expr NOT REGEXP expr { $$= new Item_func_not(new Item_func_regex($1,$4)); }
	| expr IS NULL_SYM	{ $$= new Item_func_isnull($1); }
	| expr IS NOT NULL_SYM { $$= new Item_func_isnotnull($1); }
	| expr EQUAL_SYM expr	{ $$= new Item_func_equal($1,$3); }
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2137 2138 2139
	| expr comp_op expr %prec EQ	{ $$= (*((*$2)(0)))($1,$3); }
	| expr comp_op all_or_any in_subselect %prec EQ
	{
2140
	  Item_allany_subselect *it=
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2141
	    new Item_allany_subselect(YYTHD, $1, (*$2)($3), $4);
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2142 2143 2144 2145 2146
	  if ($3)
	    $$ = new Item_func_not(it);	/* ALL */
	  else
	    $$ = it;			/* ANY/SOME */
	}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2147 2148 2149 2150 2151 2152
	| expr SHIFT_LEFT expr	{ $$= new Item_func_shift_left($1,$3); }
	| expr SHIFT_RIGHT expr { $$= new Item_func_shift_right($1,$3); }
	| expr '+' expr		{ $$= new Item_func_plus($1,$3); }
	| expr '-' expr		{ $$= new Item_func_minus($1,$3); }
	| expr '*' expr		{ $$= new Item_func_mul($1,$3); }
	| expr '/' expr		{ $$= new Item_func_div($1,$3); }
2153 2154
	| expr DIV_SYM expr	{ $$= new Item_func_int_div($1,$3); }
	| expr MOD_SYM expr	{ $$= new Item_func_mod($1,$3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2155
	| expr '|' expr		{ $$= new Item_func_bit_or($1,$3); }
2156
        | expr '^' expr		{ $$= new Item_func_bit_xor($1,$3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2157 2158
	| expr '&' expr		{ $$= new Item_func_bit_and($1,$3); }
	| expr '%' expr		{ $$= new Item_func_mod($1,$3); }
2159 2160 2161 2162
	| expr '+' interval_expr interval
	  { $$= new Item_date_add_interval($1,$3,$4,0); }
	| expr '-' interval_expr interval
	  { $$= new Item_date_add_interval($1,$3,$4,1); }
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
2163
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2164 2165 2166 2167 2168 2169 2170

/* expressions that begin with 'expr' that do NOT follow IN_SYM */
no_in_expr:
	no_in_expr BETWEEN_SYM no_and_expr AND expr
	  { $$= new Item_func_between($1,$3,$5); }
	| no_in_expr NOT BETWEEN_SYM no_and_expr AND expr
	  { $$= new Item_func_not(new Item_func_between($1,$4,$6)); }
2171
	| no_in_expr OR_OR_CONCAT expr	{ $$= or_or_concat(YYTHD, $1,$3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2172
	| no_in_expr OR expr		{ $$= new Item_cond_or($1,$3); }
2173
        | no_in_expr XOR expr		{ $$= new Item_cond_xor($1,$3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2174
	| no_in_expr AND expr		{ $$= new Item_cond_and($1,$3); }
2175
	| no_in_expr SOUNDS_SYM LIKE expr { $$= Item_bool_func2::eq_creator(new Item_func_soundex($1), new Item_func_soundex($4));}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2176 2177 2178 2179 2180 2181 2182
	| no_in_expr LIKE simple_expr opt_escape { $$= new Item_func_like($1,$3,$4); }
	| no_in_expr NOT LIKE simple_expr opt_escape { $$= new Item_func_not(new Item_func_like($1,$4,$5)); }
	| no_in_expr REGEXP expr { $$= new Item_func_regex($1,$3); }
	| no_in_expr NOT REGEXP expr { $$= new Item_func_not(new Item_func_regex($1,$4)); }
	| no_in_expr IS NULL_SYM	{ $$= new Item_func_isnull($1); }
	| no_in_expr IS NOT NULL_SYM { $$= new Item_func_isnotnull($1); }
	| no_in_expr EQUAL_SYM expr	{ $$= new Item_func_equal($1,$3); }
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2183 2184 2185
	| no_in_expr comp_op expr %prec EQ	{ $$= (*((*$2)(0)))($1,$3); }
	| no_in_expr comp_op all_or_any in_subselect %prec EQ
	{
2186
	  Item_allany_subselect *it=
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2187
	    new Item_allany_subselect(YYTHD, $1, (*$2)($3), $4);
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2188 2189 2190 2191 2192
	  if ($3)
	    $$ = new Item_func_not(it);	/* ALL */
	  else
	    $$ = it;			/* ANY/SOME */
	}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2193 2194 2195 2196 2197 2198
	| no_in_expr SHIFT_LEFT expr  { $$= new Item_func_shift_left($1,$3); }
	| no_in_expr SHIFT_RIGHT expr { $$= new Item_func_shift_right($1,$3); }
	| no_in_expr '+' expr		{ $$= new Item_func_plus($1,$3); }
	| no_in_expr '-' expr		{ $$= new Item_func_minus($1,$3); }
	| no_in_expr '*' expr		{ $$= new Item_func_mul($1,$3); }
	| no_in_expr '/' expr		{ $$= new Item_func_div($1,$3); }
2199
	| no_in_expr DIV_SYM expr	{ $$= new Item_func_int_div($1,$3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2200
	| no_in_expr '|' expr		{ $$= new Item_func_bit_or($1,$3); }
2201
        | no_in_expr '^' expr		{ $$= new Item_func_bit_xor($1,$3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2202 2203
	| no_in_expr '&' expr		{ $$= new Item_func_bit_and($1,$3); }
	| no_in_expr '%' expr		{ $$= new Item_func_mod($1,$3); }
2204
	| no_in_expr MOD_SYM expr	{ $$= new Item_func_mod($1,$3); }
2205 2206 2207 2208
	| no_in_expr '+' interval_expr interval
	  { $$= new Item_date_add_interval($1,$3,$4,0); }
	| no_in_expr '-' interval_expr interval
	  { $$= new Item_date_add_interval($1,$3,$4,1); }
2209
	| simple_expr;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2210 2211 2212

/* expressions that begin with 'expr' that does NOT follow AND */
no_and_expr:
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2213 2214
	  no_and_expr IN_SYM '(' expr_list ')'
	  { $$= new Item_func_in($1,*$4); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2215 2216
	| no_and_expr NOT IN_SYM '(' expr_list ')'
	  { $$= new Item_func_not(new Item_func_in($1,*$5)); }
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2217
        | no_and_expr IN_SYM in_subselect
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2218
          { $$= new Item_in_subselect(YYTHD, $1, $3); }
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2219
	| no_and_expr NOT IN_SYM in_subselect
2220
          {
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2221
            $$= new Item_func_not(new Item_in_subselect(YYTHD, $1, $4));
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2222
          }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2223 2224 2225 2226
	| no_and_expr BETWEEN_SYM no_and_expr AND expr
	  { $$= new Item_func_between($1,$3,$5); }
	| no_and_expr NOT BETWEEN_SYM no_and_expr AND expr
	  { $$= new Item_func_not(new Item_func_between($1,$4,$6)); }
2227
	| no_and_expr OR_OR_CONCAT expr	{ $$= or_or_concat(YYTHD, $1,$3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2228
	| no_and_expr OR expr		{ $$= new Item_cond_or($1,$3); }
2229
        | no_and_expr XOR expr		{ $$= new Item_cond_xor($1,$3); }
2230
	| no_and_expr SOUNDS_SYM LIKE expr { $$= Item_bool_func2::eq_creator(new Item_func_soundex($1), new Item_func_soundex($4));}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2231 2232 2233 2234 2235 2236 2237
	| no_and_expr LIKE simple_expr opt_escape { $$= new Item_func_like($1,$3,$4); }
	| no_and_expr NOT LIKE simple_expr opt_escape	{ $$= new Item_func_not(new Item_func_like($1,$4,$5)); }
	| no_and_expr REGEXP expr { $$= new Item_func_regex($1,$3); }
	| no_and_expr NOT REGEXP expr { $$= new Item_func_not(new Item_func_regex($1,$4)); }
	| no_and_expr IS NULL_SYM	{ $$= new Item_func_isnull($1); }
	| no_and_expr IS NOT NULL_SYM { $$= new Item_func_isnotnull($1); }
	| no_and_expr EQUAL_SYM expr	{ $$= new Item_func_equal($1,$3); }
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2238 2239 2240
	| no_and_expr comp_op expr %prec EQ { $$= (*((*$2)(0)))($1,$3); }
	| no_and_expr comp_op all_or_any in_subselect %prec EQ
	{
2241
	  Item_allany_subselect *it=
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2242
	    new Item_allany_subselect(YYTHD, $1, (*$2)($3), $4);
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2243 2244 2245 2246 2247
	  if ($3)
	    $$ = new Item_func_not(it);	/* ALL */
	  else
	    $$ = it;			/* ANY/SOME */
	}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2248 2249 2250 2251 2252 2253
	| no_and_expr SHIFT_LEFT expr  { $$= new Item_func_shift_left($1,$3); }
	| no_and_expr SHIFT_RIGHT expr { $$= new Item_func_shift_right($1,$3); }
	| no_and_expr '+' expr		{ $$= new Item_func_plus($1,$3); }
	| no_and_expr '-' expr		{ $$= new Item_func_minus($1,$3); }
	| no_and_expr '*' expr		{ $$= new Item_func_mul($1,$3); }
	| no_and_expr '/' expr		{ $$= new Item_func_div($1,$3); }
2254
	| no_and_expr DIV_SYM expr	{ $$= new Item_func_int_div($1,$3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2255
	| no_and_expr '|' expr		{ $$= new Item_func_bit_or($1,$3); }
2256
        | no_and_expr '^' expr		{ $$= new Item_func_bit_xor($1,$3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2257 2258
	| no_and_expr '&' expr		{ $$= new Item_func_bit_and($1,$3); }
	| no_and_expr '%' expr		{ $$= new Item_func_mod($1,$3); }
2259
	| no_and_expr MOD_SYM expr	{ $$= new Item_func_mod($1,$3); }
2260 2261 2262 2263
	| no_and_expr '+' interval_expr interval
	  { $$= new Item_date_add_interval($1,$3,$4,0); }
	| no_and_expr '-' interval_expr interval
	  { $$= new Item_date_add_interval($1,$3,$4,1); }
2264
	| simple_expr;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2265

2266
interval_expr:
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
2267
         INTERVAL_SYM expr { $$=$2; }
2268 2269
        ;

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2270 2271
simple_expr:
	simple_ident
2272 2273
 	| simple_expr COLLATE_SYM ident_or_text %prec NEG
	  { 
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2274 2275 2276 2277
	    $$= new Item_func_set_collation($1,
					    new Item_string($3.str,
							    $3.length,
					    		    YYTHD->charset()));
2278
	  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2279
	| literal
2280
	| param_marker
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2281
	| '@' ident_or_text SET_VAR expr
2282 2283
	  {
	    $$= new Item_func_set_user_var($2,$4);
2284
	    Lex->uncacheable();
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2285
	  }
2286
	| '@' ident_or_text
2287 2288
	  {
	    $$= new Item_func_get_user_var($2);
2289
	    Lex->uncacheable();
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2290
	  }
2291
	| '@' '@' opt_var_ident_type ident_or_text opt_component
2292
	  {
2293
	    if (!($$= get_system_var(YYTHD, (enum_var_type) $3, $4, $5)))
2294
	      YYABORT;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2295
	  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2296 2297 2298 2299 2300 2301
	| sum_expr
	| '-' expr %prec NEG	{ $$= new Item_func_neg($2); }
	| '~' expr %prec NEG	{ $$= new Item_func_bit_neg($2); }
	| NOT expr %prec NEG	{ $$= new Item_func_not($2); }
	| '!' expr %prec NEG	{ $$= new Item_func_not($2); }
	| '(' expr ')'		{ $$= $2; }
2302 2303 2304 2305 2306
	| '(' expr ',' expr_list ')'
	  {
	    $4->push_front($2);
	    $$= new Item_row(*$4);
	  }
2307
	| ROW_SYM '(' expr ',' expr_list ')'
2308
	  {
2309 2310
	    $5->push_front($3);
	    $$= new Item_row(*$5);
2311
	  }
2312
	| EXISTS exists_subselect { $$= $2; }
2313
	| singlerow_subselect   { $$= $1; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2314
	| '{' ident expr '}'	{ $$= $3; }
2315
        | MATCH ident_list_arg AGAINST '(' expr ')'
2316
          { Select->add_ftfunc_to_list((Item_func_match *)
2317
                   ($$=new Item_func_match_nl(*$2,$5))); }
2318
        | MATCH ident_list_arg AGAINST '(' expr IN_SYM BOOLEAN_SYM MODE_SYM ')'
2319
          { Select->add_ftfunc_to_list((Item_func_match *)
2320
                   ($$=new Item_func_match_bool(*$2,$5))); }
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
2321
	| ASCII_SYM '(' expr ')' { $$= new Item_func_ascii($3); }
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
2322 2323
	| BINARY expr %prec NEG 
	  {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2324 2325
	    $$= new Item_func_set_collation($2,new Item_string(binary_keyword,
					    6, &my_charset_latin1));
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
2326
	  }
2327 2328
	| CAST_SYM '(' expr AS cast_type ')'
	  { $$= create_func_cast($3, $5, Lex->charset); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2329
	| CASE_SYM opt_expr WHEN_SYM when_list opt_else END
2330
	  { $$= new Item_func_case(* $4, $2, $5 ); }
2331 2332
	| CONVERT_SYM '(' expr ',' cast_type ')'
	  { $$= create_func_cast($3, $5, Lex->charset); }
2333 2334
	| CONVERT_SYM '(' expr USING charset_name ')'
	  { $$= new Item_func_conv_charset($3,$5); }
2335
	| CONVERT_SYM '(' expr ',' expr ',' expr ')'
2336
	  { $$= new Item_func_conv_charset3($3,$7,$5); }
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2337 2338
	| DEFAULT '(' simple_ident ')'
	  { $$= new Item_default_value($3); }
2339 2340
	| VALUES '(' simple_ident ')'
	  { $$= new Item_insert_value($3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2341 2342 2343 2344 2345 2346 2347 2348
	| FUNC_ARG0 '(' ')'
	  { $$= ((Item*(*)(void))($1.symbol->create_func))();}
	| FUNC_ARG1 '(' expr ')'
	  { $$= ((Item*(*)(Item*))($1.symbol->create_func))($3);}
	| FUNC_ARG2 '(' expr ',' expr ')'
	  { $$= ((Item*(*)(Item*,Item*))($1.symbol->create_func))($3,$5);}
	| FUNC_ARG3 '(' expr ',' expr ',' expr ')'
	  { $$= ((Item*(*)(Item*,Item*,Item*))($1.symbol->create_func))($3,$5,$7);}
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
2349 2350 2351 2352
	| ADDDATE_SYM '(' expr ',' expr ')'
	  { $$= new Item_date_add_interval($3, $5, INTERVAL_DAY, 0);}
	| ADDDATE_SYM '(' expr ',' INTERVAL_SYM expr interval ')'
	  { $$= new Item_date_add_interval($3, $6, $7, 0); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2353 2354 2355 2356 2357 2358
	| ATAN	'(' expr ')'
	  { $$= new Item_func_atan($3); }
	| ATAN	'(' expr ',' expr ')'
	  { $$= new Item_func_atan($3,$5); }
	| CHAR_SYM '(' expr_list ')'
	  { $$= new Item_func_char(*$3); }
2359 2360
	| CHARSET '(' expr ')'
	  { $$= new Item_func_charset($3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2361 2362
	| COALESCE '(' expr_list ')'
	  { $$= new Item_func_coalesce(* $3); }
2363 2364
	| COLLATION_SYM '(' expr ')'
	  { $$= new Item_func_collation($3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2365 2366 2367 2368 2369
	| CONCAT '(' expr_list ')'
	  { $$= new Item_func_concat(* $3); }
	| CONCAT_WS '(' expr ',' expr_list ')'
	  { $$= new Item_func_concat_ws($3, *$5); }
	| CURDATE optional_braces
2370
	  { $$= new Item_func_curdate(); Lex->safe_to_cache_query=0; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2371
	| CURTIME optional_braces
2372
	  { $$= new Item_func_curtime(); Lex->safe_to_cache_query=0; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2373
	| CURTIME '(' expr ')'
2374 2375
	  {
	    $$= new Item_func_curtime($3);
2376
	    Lex->safe_to_cache_query=0;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2377
	  }
2378 2379 2380 2381
	| DATE_ADD_INTERVAL '(' expr ',' interval_expr interval ')'
	  { $$= new Item_date_add_interval($3,$5,$6,0); }
	| DATE_SUB_INTERVAL '(' expr ',' interval_expr interval ')'
	  { $$= new Item_date_add_interval($3,$5,$6,1); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2382
	| DATABASE '(' ')'
2383
	  {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2384
	    $$= new Item_func_database();
2385
            Lex->safe_to_cache_query=0;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2386
	  }
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
2387
	| DATE_SYM '(' expr ')'
2388
	  { $$= new Item_date_typecast($3); }
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
2389 2390
	| DAY_SYM '(' expr ')'
	  { $$= new Item_func_dayofmonth($3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2391 2392 2393 2394
	| ELT_FUNC '(' expr ',' expr_list ')'
	  { $$= new Item_func_elt($3, *$5); }
	| MAKE_SET_SYM '(' expr ',' expr_list ')'
	  { $$= new Item_func_make_set($3, *$5); }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2395 2396 2397
	| ENCRYPT '(' expr ')'
	  {
	    $$= new Item_func_encrypt($3);
2398
	    Lex->uncacheable();
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2399
	  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2400
	| ENCRYPT '(' expr ',' expr ')'   { $$= new Item_func_encrypt($3,$5); }
2401
	| DECODE_SYM '(' expr ',' TEXT_STRING_literal ')'
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2402
	  { $$= new Item_func_decode($3,$5.str); }
2403
	| ENCODE_SYM '(' expr ',' TEXT_STRING_literal ')'
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2404
	 { $$= new Item_func_encode($3,$5.str); }
2405
	| DES_DECRYPT_SYM '(' expr ')'
2406
        { $$= new Item_func_des_decrypt($3); }
2407
	| DES_DECRYPT_SYM '(' expr ',' expr ')'
2408
        { $$= new Item_func_des_decrypt($3,$5); }
2409
	| DES_ENCRYPT_SYM '(' expr ')'
2410
        { $$= new Item_func_des_encrypt($3); }
2411
	| DES_ENCRYPT_SYM '(' expr ',' expr ')'
2412
        { $$= new Item_func_des_encrypt($3,$5); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2413 2414 2415 2416 2417 2418
	| EXPORT_SET '(' expr ',' expr ',' expr ')'
		{ $$= new Item_func_export_set($3, $5, $7); }
	| EXPORT_SET '(' expr ',' expr ',' expr ',' expr ')'
		{ $$= new Item_func_export_set($3, $5, $7, $9); }
	| EXPORT_SET '(' expr ',' expr ',' expr ',' expr ',' expr ')'
		{ $$= new Item_func_export_set($3, $5, $7, $9, $11); }
2419 2420
	| FALSE_SYM
	  { $$= new Item_int((char*) "FALSE",0,1); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2421 2422 2423 2424 2425 2426
	| FORMAT_SYM '(' expr ',' NUM ')'
	  { $$= new Item_func_format($3,atoi($5.str)); }
	| FROM_UNIXTIME '(' expr ')'
	  { $$= new Item_func_from_unixtime($3); }
	| FROM_UNIXTIME '(' expr ',' expr ')'
	  {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2427
	    $$= new Item_func_date_format (new Item_func_from_unixtime($3),$5,0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2428 2429 2430
	  }
	| FIELD_FUNC '(' expr ',' expr_list ')'
	  { $$= new Item_func_field($3, *$5); }
2431
	| GEOMFROMTEXT '(' expr ')'
2432
	  { $$= new Item_func_geometry_from_text($3); }
2433
	| GEOMFROMTEXT '(' expr ',' expr ')'
ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
2434 2435 2436 2437 2438
	  { $$= new Item_func_geometry_from_text($3, $5); }
	| GEOMFROMWKB '(' expr ')'
	  { $$= new Item_func_geometry_from_wkb($3); }
	| GEOMFROMWKB '(' expr ',' expr ')'
	  { $$= new Item_func_geometry_from_wkb($3, $5); }
2439
	| GEOMETRYCOLLECTION '(' expr_list ')'
2440 2441
	  { $$= new Item_func_spatial_collection(* $3,
                       Geometry::wkbGeometryCollection,
2442
                       Geometry::wkbPoint); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2443 2444 2445 2446 2447 2448
	| HOUR_SYM '(' expr ')'
	  { $$= new Item_func_hour($3); }
	| IF '(' expr ',' expr ',' expr ')'
	  { $$= new Item_func_if($3,$5,$7); }
	| INSERT '(' expr ',' expr ',' expr ',' expr ')'
	  { $$= new Item_func_insert($3,$5,$7,$9); }
2449
	| interval_expr interval '+' expr
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2450
	  /* we cannot put interval before - */
2451 2452 2453 2454 2455 2456 2457 2458 2459 2460
	  { $$= new Item_date_add_interval($4,$1,$2,0); }
	| interval_expr
	  {
            if ($1->type() != Item::ROW_ITEM)
            {
              send_error(Lex->thd, ER_SYNTAX_ERROR);
              YYABORT;
            }
            $$= new Item_func_interval((Item_row *)$1);
          }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2461 2462
	| LAST_INSERT_ID '(' ')'
	  {
2463
	    $$= get_system_var(YYTHD, OPT_SESSION, "last_insert_id", 14,
2464
			      "last_insert_id()");
2465
	    Lex->safe_to_cache_query= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2466 2467 2468 2469
	  }
	| LAST_INSERT_ID '(' expr ')'
	  {
	    $$= new Item_func_set_last_insert_id($3);
2470
	    Lex->safe_to_cache_query= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2471 2472 2473
	  }
	| LEFT '(' expr ',' expr ')'
	  { $$= new Item_func_left($3,$5); }
2474
	| LINESTRING '(' expr_list ')'
2475
	  { $$= new Item_func_spatial_collection(* $3,
2476
               Geometry::wkbLineString, Geometry::wkbPoint); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2477 2478 2479 2480
	| LOCATE '(' expr ',' expr ')'
	  { $$= new Item_func_locate($5,$3); }
	| LOCATE '(' expr ',' expr ',' expr ')'
	  { $$= new Item_func_locate($5,$3,$7); }
2481
 	| GEOMCOLLFROMTEXT '(' expr ')'
2482
	  { $$= new Item_func_geometry_from_text($3); }
2483
	| GEOMCOLLFROMTEXT '(' expr ',' expr ')'
ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
2484
	  { $$= new Item_func_geometry_from_text($3, $5); }
2485
	| GREATEST_SYM '(' expr ',' expr_list ')'
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2486 2487 2488
	  { $5->push_front($3); $$= new Item_func_max(*$5); }
	| LEAST_SYM '(' expr ',' expr_list ')'
	  { $5->push_front($3); $$= new Item_func_min(*$5); }
2489
	| LOG_SYM '(' expr ')'
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2490
	  { $$= new Item_func_log($3); }
2491
	| LOG_SYM '(' expr ',' expr ')'
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2492
	  { $$= new Item_func_log($3, $5); }
2493
 	| LINEFROMTEXT '(' expr ')'
2494
	  { $$= new Item_func_geometry_from_text($3); }
2495
	| LINEFROMTEXT '(' expr ',' expr ')'
ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
2496
	  { $$= new Item_func_geometry_from_text($3, $5); }
2497 2498 2499
	| MASTER_POS_WAIT '(' expr ',' expr ')'
	  { 
	    $$= new Item_master_pos_wait($3, $5);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2500 2501
	    Lex->safe_to_cache_query=0; 
		  }
2502 2503 2504
	| MASTER_POS_WAIT '(' expr ',' expr ',' expr ')'
	  { 
	    $$= new Item_master_pos_wait($3, $5, $7);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2505
	    Lex->safe_to_cache_query=0; 
2506
	  }
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
2507 2508
	| MICROSECOND_SYM '(' expr ')'
	  { $$= new Item_func_microsecond($3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2509 2510
	| MINUTE_SYM '(' expr ')'
	  { $$= new Item_func_minute($3); }
2511 2512
	| MOD_SYM '(' expr ',' expr ')'
	  { $$ = new Item_func_mod( $3, $5); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2513 2514
	| MONTH_SYM '(' expr ')'
	  { $$= new Item_func_month($3); }
2515
 	| MULTILINESTRING '(' expr_list ')'
2516
 	  { $$= new Item_func_spatial_collection(* $3,
2517
                    Geometry::wkbMultiLineString, Geometry::wkbLineString); }
2518
 	| MLINEFROMTEXT '(' expr ')'
2519
	  { $$= new Item_func_geometry_from_text($3); }
2520
	| MLINEFROMTEXT '(' expr ',' expr ')'
ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
2521
	  { $$= new Item_func_geometry_from_text($3, $5); }
2522
	| MPOINTFROMTEXT '(' expr ')'
2523
	  { $$= new Item_func_geometry_from_text($3); }
2524
	| MPOINTFROMTEXT '(' expr ',' expr ')'
ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
2525
	  { $$= new Item_func_geometry_from_text($3, $5); }
2526
	| MPOLYFROMTEXT '(' expr ')'
2527
	  { $$= new Item_func_geometry_from_text($3); }
2528
	| MPOLYFROMTEXT '(' expr ',' expr ')'
ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
2529
	  { $$= new Item_func_geometry_from_text($3, $5); }
2530
	| MULTIPOINT '(' expr_list ')'
2531
	  { $$= new Item_func_spatial_collection(* $3,
2532 2533
                    Geometry::wkbMultiPoint, Geometry::wkbPoint); }
 	| MULTIPOLYGON '(' expr_list ')'
2534
	  { $$= new Item_func_spatial_collection(* $3,
2535
                       Geometry::wkbMultiPolygon, Geometry::wkbPolygon ); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2536
	| NOW_SYM optional_braces
2537
	  { $$= new Item_func_now(); Lex->safe_to_cache_query=0;}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2538
	| NOW_SYM '(' expr ')'
2539
	  { $$= new Item_func_now($3); Lex->safe_to_cache_query=0;}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2540
	| PASSWORD '(' expr ')'
peter@mysql.com's avatar
SCRUM  
peter@mysql.com committed
2541 2542 2543
	  { $$= new Item_func_password($3); }
        | PASSWORD '(' expr ',' expr ')'
          { $$= new Item_func_password($3,$5); }
2544
	| POINT_SYM '(' expr ',' expr ')'
2545
	  { $$= new Item_func_point($3,$5); }
2546
 	| POINTFROMTEXT '(' expr ')'
2547
	  { $$= new Item_func_geometry_from_text($3); }
2548
	| POINTFROMTEXT '(' expr ',' expr ')'
ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
2549
	  { $$= new Item_func_geometry_from_text($3, $5); }
2550
	| POLYFROMTEXT '(' expr ')'
2551
	  { $$= new Item_func_geometry_from_text($3); }
2552
	| POLYFROMTEXT '(' expr ',' expr ')'
ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
2553
	  { $$= new Item_func_geometry_from_text($3, $5); }
2554
	| POLYGON '(' expr_list ')'
2555
	  { $$= new Item_func_spatial_collection(* $3,
2556
			Geometry::wkbPolygon, Geometry::wkbLineString); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2557 2558
	| POSITION_SYM '(' no_in_expr IN_SYM expr ')'
	  { $$ = new Item_func_locate($5,$3); }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2559
	| RAND '(' expr ')'
2560
	  { $$= new Item_func_rand($3); Lex->uncacheable();}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2561
	| RAND '(' ')'
2562
	  { $$= new Item_func_rand(); Lex->uncacheable();}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2563 2564 2565 2566 2567 2568 2569
	| REPLACE '(' expr ',' expr ',' expr ')'
	  { $$= new Item_func_replace($3,$5,$7); }
	| RIGHT '(' expr ',' expr ')'
	  { $$= new Item_func_right($3,$5); }
	| ROUND '(' expr ')'
	  { $$= new Item_func_round($3, new Item_int((char*)"0",0,1),0); }
	| ROUND '(' expr ',' expr ')' { $$= new Item_func_round($3,$5,0); }
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
2570 2571 2572 2573
	| SUBDATE_SYM '(' expr ',' expr ')'
	  { $$= new Item_date_add_interval($3, $5, INTERVAL_DAY, 1);}
	| SUBDATE_SYM '(' expr ',' INTERVAL_SYM expr interval ')'
	  { $$= new Item_date_add_interval($3, $6, $7, 1); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2574 2575 2576 2577 2578 2579 2580 2581 2582 2583 2584 2585
	| SECOND_SYM '(' expr ')'
	  { $$= new Item_func_second($3); }
	| SUBSTRING '(' expr ',' expr ',' expr ')'
	  { $$= new Item_func_substr($3,$5,$7); }
	| SUBSTRING '(' expr ',' expr ')'
	  { $$= new Item_func_substr($3,$5); }
	| SUBSTRING '(' expr FROM expr FOR_SYM expr ')'
	  { $$= new Item_func_substr($3,$5,$7); }
	| SUBSTRING '(' expr FROM expr ')'
	  { $$= new Item_func_substr($3,$5); }
	| SUBSTRING_INDEX '(' expr ',' expr ',' expr ')'
	  { $$= new Item_func_substr_index($3,$5,$7); }
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
2586
	| TIME_SYM '(' expr ')'
2587 2588 2589
	  { $$= new Item_time_typecast($3); }
	| TIMESTAMP '(' expr ')'
	  { $$= new Item_datetime_typecast($3); }
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
2590
	| TIMESTAMP '(' expr ',' expr ')'
2591
	  { $$= new Item_func_add_time($3, $5, 1, 0); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2592
	| TRIM '(' expr ')'
2593 2594
	  { $$= new Item_func_trim($3); }
	| TRIM '(' LEADING expr FROM expr ')'
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2595
	  { $$= new Item_func_ltrim($6,$4); }
2596
	| TRIM '(' TRAILING expr FROM expr ')'
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2597
	  { $$= new Item_func_rtrim($6,$4); }
2598
	| TRIM '(' BOTH expr FROM expr ')'
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2599
	  { $$= new Item_func_trim($6,$4); }
2600 2601 2602 2603 2604 2605
	| TRIM '(' LEADING FROM expr ')'
	 { $$= new Item_func_ltrim($5); }
	| TRIM '(' TRAILING FROM expr ')'
	  { $$= new Item_func_rtrim($5); }
	| TRIM '(' BOTH FROM expr ')'
	  { $$= new Item_func_trim($5); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2606 2607
	| TRIM '(' expr FROM expr ')'
	  { $$= new Item_func_trim($5,$3); }
2608 2609
	| TRUNCATE_SYM '(' expr ',' expr ')'
	  { $$= new Item_func_round($3,$5,1); }
2610 2611
	| TRUE_SYM
	  { $$= new Item_int((char*) "TRUE",1,1); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2612 2613 2614 2615 2616 2617 2618 2619 2620 2621 2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639 2640 2641 2642 2643 2644 2645 2646 2647 2648 2649 2650 2651 2652 2653 2654
	| UDA_CHAR_SUM '(' udf_expr_list ')'
	  {
	    if ($3 != NULL)
	      $$ = new Item_sum_udf_str($1, *$3);
	    else
	      $$ = new Item_sum_udf_str($1);
	  }
	| UDA_FLOAT_SUM '(' udf_expr_list ')'
	  {
	    if ($3 != NULL)
	      $$ = new Item_sum_udf_float($1, *$3);
	    else
	      $$ = new Item_sum_udf_float($1);
	  }
	| UDA_INT_SUM '(' udf_expr_list ')'
	  {
	    if ($3 != NULL)
	      $$ = new Item_sum_udf_int($1, *$3);
	    else
	      $$ = new Item_sum_udf_int($1);
	  }
	| UDF_CHAR_FUNC '(' udf_expr_list ')'
	  {
	    if ($3 != NULL)
	      $$ = new Item_func_udf_str($1, *$3);
	    else
	      $$ = new Item_func_udf_str($1);
	  }
	| UDF_FLOAT_FUNC '(' udf_expr_list ')'
	  {
	    if ($3 != NULL)
	      $$ = new Item_func_udf_float($1, *$3);
	    else
	      $$ = new Item_func_udf_float($1);
	  }
	| UDF_INT_FUNC '(' udf_expr_list ')'
	  {
	    if ($3 != NULL)
	      $$ = new Item_func_udf_int($1, *$3);
	    else
	      $$ = new Item_func_udf_int($1);
	  }
	| UNIQUE_USERS '(' text_literal ',' NUM ',' NUM ',' expr_list ')'
2655
	  {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2656 2657
            $$= new Item_func_unique_users($3,atoi($5.str),atoi($7.str), * $9);
	  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2658
	| UNIX_TIMESTAMP '(' ')'
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2659 2660
	  {
	    $$= new Item_func_unix_timestamp();
2661
	    Lex->safe_to_cache_query=0;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2662
	  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2663 2664 2665
	| UNIX_TIMESTAMP '(' expr ')'
	  { $$= new Item_func_unix_timestamp($3); }
	| USER '(' ')'
2666
	  { $$= new Item_func_user(); Lex->safe_to_cache_query=0; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2667
	| WEEK_SYM '(' expr ')'
2668 2669 2670 2671
	  { 
            $$= new Item_func_week($3,new Item_int((char*) "0",
				   YYTHD->variables.default_week_format,1)); 
          }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2672 2673 2674 2675 2676 2677 2678 2679 2680
	| WEEK_SYM '(' expr ',' expr ')'
	  { $$= new Item_func_week($3,$5); }
	| YEAR_SYM '(' expr ')'
	  { $$= new Item_func_year($3); }
	| YEARWEEK '(' expr ')'
	  { $$= new Item_func_yearweek($3,new Item_int((char*) "0",0,1)); }
	| YEARWEEK '(' expr ',' expr ')'
	  { $$= new Item_func_yearweek($3, $5); }
	| BENCHMARK_SYM '(' ULONG_NUM ',' expr ')'
2681
	  {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2682
	    $$=new Item_func_benchmark($3,$5);
2683
	    Lex->uncacheable();
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2684
	  }
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
2685
	| EXTRACT_SYM '(' interval FROM expr ')'
2686
	{ $$=new Item_extract( $3, $5); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2687 2688 2689

udf_expr_list:
	/* empty */	{ $$= NULL; }
2690
	| expr_list	{ $$= $1;};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2691 2692 2693 2694 2695 2696 2697 2698

sum_expr:
	AVG_SYM '(' in_sum_expr ')'
	  { $$=new Item_sum_avg($3); }
	| BIT_AND  '(' in_sum_expr ')'
	  { $$=new Item_sum_and($3); }
	| BIT_OR  '(' in_sum_expr ')'
	  { $$=new Item_sum_or($3); }
2699
	| COUNT_SYM '(' opt_all '*' ')'
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2700 2701 2702
	  { $$=new Item_sum_count(new Item_int((int32) 0L,1)); }
	| COUNT_SYM '(' in_sum_expr ')'
	  { $$=new Item_sum_count($3); }
2703
	| COUNT_SYM '(' DISTINCT
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2704
	  { Select->select_lex()->in_sum_expr++; }
2705
	   expr_list
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2706
	  { Select->select_lex()->in_sum_expr--; }
2707 2708
	  ')'
	  { $$=new Item_sum_count_distinct(* $5); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2709 2710 2711 2712 2713 2714 2715 2716
	| GROUP_UNIQUE_USERS '(' text_literal ',' NUM ',' NUM ',' in_sum_expr ')'
	  { $$= new Item_sum_unique_users($3,atoi($5.str),atoi($7.str),$9); }
	| MIN_SYM '(' in_sum_expr ')'
	  { $$=new Item_sum_min($3); }
	| MAX_SYM '(' in_sum_expr ')'
	  { $$=new Item_sum_max($3); }
	| STD_SYM '(' in_sum_expr ')'
	  { $$=new Item_sum_std($3); }
2717 2718
	| VARIANCE_SYM '(' in_sum_expr ')'
	  { $$=new Item_sum_variance($3); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2719
	| SUM_SYM '(' in_sum_expr ')'
2720 2721 2722 2723 2724 2725 2726 2727 2728 2729 2730 2731
	  { $$=new Item_sum_sum($3); }
	| GROUP_CONCAT_SYM '(' opt_distinct expr_list opt_gorder_clause opt_gconcat_separator ')'
	  { 
	    $$=new Item_func_group_concat($3,$4,Lex->gorder_list,$6); 
	    $4->empty();
	  };

opt_distinct:
    /* empty */ { $$ = 0; }
    |DISTINCT   { $$ = 1; };

opt_gconcat_separator:
2732
    /* empty */        { $$ = new String(",",1,default_charset_info); }
2733 2734 2735 2736 2737 2738 2739 2740 2741 2742 2743 2744 2745 2746 2747 2748
    |SEPARATOR_SYM text_string  { $$ = $2; };
   

opt_gorder_clause:
    /* empty */ 
      {
        LEX *lex=Lex;
        lex->gorder_list = NULL;
      }
    | order_clause
      {
        LEX *lex=Lex;
        lex->gorder_list= (SQL_LIST*) sql_memdup((char*) &lex->current_select->order_list,sizeof(st_sql_list));
        lex->current_select->order_list.empty();
      };
	  
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2749 2750

in_sum_expr:
2751
	opt_all
2752 2753 2754 2755 2756
	{
	  LEX *lex= Lex;
	  if (lex->current_select->inc_in_sum_expr())
	  {
	    send_error(lex->thd, ER_SYNTAX_ERROR);
2757
	    YYABORT;
2758 2759
	  }
	}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2760 2761
	expr
	{
2762
	  Select->select_lex()->in_sum_expr--;
2763
	  $$= $3;
2764
	};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2765

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2766
cast_type:
2767 2768 2769 2770 2771 2772 2773 2774 2775
	BINARY			{ $$=ITEM_CAST_BINARY; Lex->charset= NULL; }
	| CHAR_SYM opt_binary	{ $$=ITEM_CAST_CHAR; }
	| SIGNED_SYM		{ $$=ITEM_CAST_SIGNED_INT; Lex->charset= NULL; }
	| SIGNED_SYM INT_SYM	{ $$=ITEM_CAST_SIGNED_INT; Lex->charset= NULL; }
	| UNSIGNED		{ $$=ITEM_CAST_UNSIGNED_INT; Lex->charset= NULL; }
	| UNSIGNED INT_SYM	{ $$=ITEM_CAST_UNSIGNED_INT; Lex->charset= NULL; }
	| DATE_SYM		{ $$=ITEM_CAST_DATE; Lex->charset= NULL; }
	| TIME_SYM		{ $$=ITEM_CAST_TIME; Lex->charset= NULL; }
	| DATETIME		{ $$=ITEM_CAST_DATETIME; Lex->charset= NULL; }
2776
	;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2777

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2778
expr_list:
2779
	{ Select->expr_list.push_front(new List<Item>); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2780
	expr_list2
2781
	{ $$= Select->expr_list.pop(); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2782 2783

expr_list2:
2784
	expr { Select->expr_list.head()->push_back($1); }
2785
	| expr_list2 ',' expr { Select->expr_list.head()->push_back($3); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2786

2787 2788
ident_list_arg:
          ident_list          { $$= $1; }
2789
        | '(' ident_list ')'  { $$= $2; };
2790

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2791
ident_list:
2792
        { Select->expr_list.push_front(new List<Item>); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2793
        ident_list2
2794
        { $$= Select->expr_list.pop(); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2795 2796

ident_list2:
2797
        simple_ident { Select->expr_list.head()->push_back($1); }
2798
        | ident_list2 ',' simple_ident { Select->expr_list.head()->push_back($3); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2799 2800 2801

opt_expr:
	/* empty */      { $$= NULL; }
2802
	| expr         	 { $$= $1; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2803 2804 2805

opt_else:
	/* empty */    { $$= NULL; }
2806
	| ELSE expr    { $$= $2; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2807 2808

when_list:
Sinisa@sinisa.nasamreza.org's avatar
Sinisa@sinisa.nasamreza.org committed
2809
        { Select->when_list.push_front(new List<Item>); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2810
	when_list2
2811
	{ $$= Select->when_list.pop(); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2812 2813

when_list2:
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
2814
	expr THEN_SYM expr
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2815
	  {
2816
	    SELECT_LEX_NODE *sel=Select;
2817 2818
	    sel->when_list.head()->push_back($1);
	    sel->when_list.head()->push_back($3);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2819
	}
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
2820
	| when_list2 WHEN_SYM expr THEN_SYM expr
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2821
	  {
2822
	    SELECT_LEX_NODE *sel=Select;
2823 2824
	    sel->when_list.head()->push_back($3);
	    sel->when_list.head()->push_back($5);
2825
	  };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2826 2827 2828 2829

join_table_list:
	'(' join_table_list ')'	{ $$=$2; }
	| join_table		{ $$=$1; }
2830
	| join_table_list ',' join_table_list { $$=$3; }
2831
	| join_table_list normal_join join_table_list { $$=$3; }
2832
	| join_table_list STRAIGHT_JOIN join_table_list
2833
	  { $$=$3 ; $1->next->straight=1; }
2834 2835 2836 2837
	| join_table_list normal_join join_table_list ON expr
	  { add_join_on($3,$5); $$=$3; }
	| join_table_list normal_join join_table_list
	  USING 
2838
	  {
2839
	    SELECT_LEX *sel= Select->select_lex();
2840
	    sel->db1=$1->db; sel->table1=$1->alias;
2841
	    sel->db2=$3->db; sel->table2=$3->alias;
2842
	  }
2843 2844 2845
	  '(' using_list ')'
	  { add_join_on($3,$7); $$=$3; }

2846
	| join_table_list LEFT opt_outer JOIN_SYM join_table_list ON expr
2847
	  { add_join_on($5,$7); $5->outer_join|=JOIN_TYPE_LEFT; $$=$5; }
2848
	| join_table_list LEFT opt_outer JOIN_SYM join_table_list
2849
	  {
2850
	    SELECT_LEX *sel= Select->select_lex();
2851 2852
	    sel->db1=$1->db; sel->table1=$1->alias;
	    sel->db2=$5->db; sel->table2=$5->alias;
2853
	  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2854
	  USING '(' using_list ')'
2855
	  { add_join_on($5,$9); $5->outer_join|=JOIN_TYPE_LEFT; $$=$5; }
2856
	| join_table_list NATURAL LEFT opt_outer JOIN_SYM join_table_list
2857 2858 2859 2860 2861
	  {
	    add_join_natural($1,$1->next);
	    $1->next->outer_join|=JOIN_TYPE_LEFT;
	    $$=$6;
	  }
2862
	| join_table_list RIGHT opt_outer JOIN_SYM join_table_list ON expr
2863
	  { add_join_on($1,$7); $1->outer_join|=JOIN_TYPE_RIGHT; $$=$5; }
2864
	| join_table_list RIGHT opt_outer JOIN_SYM join_table_list
2865
	  {
2866
	    SELECT_LEX *sel= Select->select_lex();
2867 2868
	    sel->db1=$1->db; sel->table1=$1->alias;
	    sel->db2=$5->db; sel->table2=$5->alias;
2869
	  }
2870
	  USING '(' using_list ')'
2871
	  { add_join_on($1,$9); $1->outer_join|=JOIN_TYPE_RIGHT; $$=$5; }
2872
	| join_table_list NATURAL RIGHT opt_outer JOIN_SYM join_table_list
2873 2874 2875 2876 2877
	  {
	    add_join_natural($1->next,$1);
	    $1->outer_join|=JOIN_TYPE_RIGHT;
	    $$=$6;
	  }
2878
	| join_table_list NATURAL JOIN_SYM join_table_list
2879
	  { add_join_natural($1,$1->next); $$=$4; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2880 2881

normal_join:
2882 2883 2884 2885
	JOIN_SYM		{}
	| INNER_SYM JOIN_SYM	{}
	| CROSS JOIN_SYM	{}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2886 2887

join_table:
2888
	{
2889
	  SELECT_LEX *sel= Select->select_lex();
2890
	  sel->use_index_ptr=sel->ignore_index_ptr=0;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2891
	  sel->table_join_options= 0;
2892
	}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2893
        table_ident opt_table_alias opt_key_definition
2894
	{
2895 2896
	  LEX *lex= Lex;
	  SELECT_LEX_NODE *sel= lex->current_select;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2897
	  if (!($$= sel->add_table_to_list(lex->thd, $2, $3,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2898
					   sel->get_table_join_options(),
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2899
					   lex->lock_option,
2900 2901
					   sel->get_use_index(),
					   sel->get_ignore_index())))
2902
	    YYABORT;
2903
	}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2904
	| '{' ident join_table LEFT OUTER JOIN_SYM join_table ON expr '}'
2905
	  { add_join_on($7,$9); $7->outer_join|=JOIN_TYPE_LEFT; $$=$7; }
2906
        | '(' SELECT_SYM select_derived ')' opt_table_alias
2907 2908
	{
	  LEX *lex=Lex;
2909 2910 2911
	  SELECT_LEX_UNIT *unit= lex->current_select->master_unit();
	  lex->current_select= unit->outer_select();
	  if (!($$= lex->current_select->
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2912
                add_table_to_list(lex->thd, new Table_ident(unit), $5, 0,
2913
				  TL_READ,(List<String> *)0,
Sinisa@sinisa.nasamreza.org's avatar
Sinisa@sinisa.nasamreza.org committed
2914 2915
	                          (List<String> *)0)))

2916
	    YYABORT;
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2917
	};
2918

2919
select_derived:
2920
        {
2921
	  LEX *lex= Lex;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2922
	  lex->derived_tables= 1;
2923 2924 2925 2926 2927 2928
	  if (((int)lex->sql_command >= (int)SQLCOM_HA_OPEN && 
	       lex->sql_command <= (int)SQLCOM_HA_READ) || lex->sql_command == (int)SQLCOM_KILL)
	  {	
	    send_error(lex->thd, ER_SYNTAX_ERROR);
	    YYABORT;
	  }
2929
	  if (lex->current_select->linkage == GLOBAL_OPTIONS_TYPE ||
2930
              mysql_new_select(lex, 1))
2931 2932
	    YYABORT;
	  mysql_init_select(lex);
2933
	  lex->current_select->linkage= DERIVED_TABLE_TYPE;
2934
	}
2935
        select_options select_item_list opt_select_from union_opt
2936
        ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2937 2938 2939

opt_outer:
	/* empty */	{}
2940
	| OUTER		{};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2941 2942 2943 2944

opt_key_definition:
	/* empty */	{}
	| USE_SYM    key_usage_list
2945
          {
2946
	    SELECT_LEX *sel= Select->select_lex();
2947 2948 2949
	    sel->use_index= *$2;
	    sel->use_index_ptr= &sel->use_index;
	  }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2950 2951 2952 2953 2954 2955 2956
	| FORCE_SYM key_usage_list
          {
	    SELECT_LEX *sel= Select->select_lex();
	    sel->use_index= *$2;
	    sel->use_index_ptr= &sel->use_index;
	    sel->table_join_options|= TL_OPTION_FORCE_INDEX;
	  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2957
	| IGNORE_SYM key_usage_list
2958
	  {
2959
	    SELECT_LEX *sel= Select->select_lex();
2960 2961
	    sel->ignore_index= *$2;
	    sel->ignore_index_ptr= &sel->ignore_index;
2962
	  };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2963 2964

key_usage_list:
2965
	key_or_index { Select->select_lex()->interval_list.empty(); }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2966 2967 2968 2969 2970 2971 2972 2973
        '(' key_list_or_empty ')'
        { $$= &Select->select_lex()->interval_list; }
	;

key_list_or_empty:
	/* empty */ 		{}
	| key_usage_list2	{}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2974 2975 2976

key_usage_list2:
	key_usage_list2 ',' ident
2977
        { Select->select_lex()->
2978
	    interval_list.push_back(new String((const char*) $3.str, $3.length,
2979
				    system_charset_info)); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2980
	| ident
2981
        { Select->select_lex()->
2982
	    interval_list.push_back(new String((const char*) $1.str, $1.length,
2983
				    system_charset_info)); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2984
	| PRIMARY_SYM
2985
        { Select->select_lex()->
2986
	    interval_list.push_back(new String("PRIMARY", 7,
2987
				    system_charset_info)); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2988 2989 2990

using_list:
	ident
2991
	  {
2992
	    SELECT_LEX *sel= Select->select_lex();
2993 2994 2995 2996
	    if (!($$= new Item_func_eq(new Item_field(sel->db1, sel->table1,
						      $1.str),
				       new Item_field(sel->db2, sel->table2,
						      $1.str))))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2997 2998 2999 3000
	      YYABORT;
	  }
	| using_list ',' ident
	  {
3001
	    SELECT_LEX *sel= Select->select_lex();
3002
	    if (!($$= new Item_cond_and(new Item_func_eq(new Item_field(sel->db1,sel->table1,$3.str), new Item_field(sel->db2,sel->table2,$3.str)), $1)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3003
	      YYABORT;
3004
	  };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3005 3006 3007

interval:
	 DAY_HOUR_SYM		{ $$=INTERVAL_DAY_HOUR; }
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
3008
	| DAY_MICROSECOND_SYM	{ $$=INTERVAL_DAY_MICROSECOND; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3009 3010 3011
	| DAY_MINUTE_SYM	{ $$=INTERVAL_DAY_MINUTE; }
	| DAY_SECOND_SYM	{ $$=INTERVAL_DAY_SECOND; }
	| DAY_SYM		{ $$=INTERVAL_DAY; }
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
3012
	| HOUR_MICROSECOND_SYM	{ $$=INTERVAL_HOUR_MICROSECOND; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3013 3014 3015
	| HOUR_MINUTE_SYM	{ $$=INTERVAL_HOUR_MINUTE; }
	| HOUR_SECOND_SYM	{ $$=INTERVAL_HOUR_SECOND; }
	| HOUR_SYM		{ $$=INTERVAL_HOUR; }
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
3016 3017
	| MICROSECOND_SYM	{ $$=INTERVAL_MICROSECOND; }
	| MINUTE_MICROSECOND_SYM	{ $$=INTERVAL_MINUTE_MICROSECOND; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3018 3019 3020
	| MINUTE_SECOND_SYM	{ $$=INTERVAL_MINUTE_SECOND; }
	| MINUTE_SYM		{ $$=INTERVAL_MINUTE; }
	| MONTH_SYM		{ $$=INTERVAL_MONTH; }
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
3021
	| SECOND_MICROSECOND_SYM	{ $$=INTERVAL_SECOND_MICROSECOND; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3022 3023
	| SECOND_SYM		{ $$=INTERVAL_SECOND; }
	| YEAR_MONTH_SYM	{ $$=INTERVAL_YEAR_MONTH; }
3024
	| YEAR_SYM		{ $$=INTERVAL_YEAR; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3025 3026 3027 3028

table_alias:
	/* empty */
	| AS
3029
	| EQ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3030 3031 3032 3033

opt_table_alias:
	/* empty */		{ $$=0; }
	| table_alias ident
3034
	  { $$= (LEX_STRING*) sql_memdup(&$2,sizeof(LEX_STRING)); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3035

3036 3037 3038 3039
opt_all:
	/* empty */
	| ALL
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3040 3041

where_clause:
3042
	/* empty */  { Select->select_lex()->where= 0; }
3043 3044
	| WHERE expr
	  {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3045
	    Select->select_lex()->where= $2;
3046 3047 3048
	    if ($2)
	      $2->top_level_item();
	  }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3049
 	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3050 3051 3052

having_clause:
	/* empty */
3053 3054 3055 3056 3057
	| HAVING
	  {
	    Select->select_lex()->parsing_place= SELECT_LEX_NODE::IN_HAVING;
          }
	  expr
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3058 3059
	  {
	    SELECT_LEX *sel= Select->select_lex();
3060 3061
	    sel->having= $3;
	    sel->parsing_place= SELECT_LEX_NODE::NO_MATTER;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3062 3063 3064
	    if ($3)
	      $3->top_level_item();
	  }
3065
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3066 3067

opt_escape:
3068
	ESCAPE_SYM TEXT_STRING_literal	{ $$= $2.str; }
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
3069
	| /* empty */			{ $$= (char*) "\\"; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3070 3071 3072


/*
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3073
   group by statement in select
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3074 3075 3076 3077
*/

group_clause:
	/* empty */
3078
	| GROUP BY group_list olap_opt;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3079 3080

group_list:
3081
	group_list ',' order_ident order_dir
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3082
	  { if (add_group_to_list(YYTHD, $3,(bool) $4)) YYABORT; }
3083
	| order_ident order_dir
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3084
	  { if (add_group_to_list(YYTHD, $1,(bool) $2)) YYABORT; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3085

3086 3087
olap_opt:
	/* empty */ {}
3088
	| WITH CUBE_SYM
3089
          {
3090
	    LEX *lex=Lex;
3091 3092 3093 3094 3095 3096
	    if (lex->current_select->linkage == GLOBAL_OPTIONS_TYPE)
	    {
	      net_printf(lex->thd, ER_WRONG_USAGE, "WITH CUBE",
		       "global union parameters");
	      YYABORT;
	    }
3097
	    lex->current_select->select_lex()->olap= CUBE_TYPE;
3098
	    net_printf(lex->thd, ER_NOT_SUPPORTED_YET, "CUBE");
3099
	    YYABORT;	/* To be deleted in 5.1 */
3100
	  }
3101
	| WITH ROLLUP_SYM
3102
          {
3103 3104 3105 3106 3107 3108 3109
	    LEX *lex= Lex;
	    if (lex->current_select->linkage == GLOBAL_OPTIONS_TYPE)
	    {
	      net_printf(lex->thd, ER_WRONG_USAGE, "WITH ROLLUP",
		       "global union parameters");
	      YYABORT;
	    }
3110
	    lex->current_select->select_lex()->olap= ROLLUP_TYPE;
3111
	  }
3112
	;
3113

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3114
/*
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3115
   Order by statement in select
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3116 3117
*/

3118
opt_order_clause:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3119
	/* empty */
3120
	| order_clause;
3121 3122

order_clause:
3123 3124
	ORDER_SYM BY
        {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3125
	  LEX *lex=Lex;
3126
	  if (lex->current_select->linkage != GLOBAL_OPTIONS_TYPE &&
3127
	      lex->current_select->select_lex()->olap !=
3128
	      UNSPECIFIED_OLAP_TYPE)
3129
	  {
3130
	    net_printf(lex->thd, ER_WRONG_USAGE,
3131 3132 3133 3134
		       "CUBE/ROLLUP",
		       "ORDER BY");
	    YYABORT;
	  }
3135
	} order_list;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3136 3137 3138

order_list:
	order_list ',' order_ident order_dir
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3139
	  { if (add_order_to_list(YYTHD, $3,(bool) $4)) YYABORT; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3140
	| order_ident order_dir
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3141
	  { if (add_order_to_list(YYTHD, $1,(bool) $2)) YYABORT; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3142 3143 3144

order_dir:
	/* empty */ { $$ =  1; }
3145
	| ASC  { $$ =1; }
3146
	| DESC { $$ =0; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3147 3148


3149 3150 3151 3152 3153 3154 3155
opt_limit_clause_init:
	/* empty */
	{
	  SELECT_LEX_NODE *sel= Select;
          sel->offset_limit= 0L;
          sel->select_limit= Lex->thd->variables.select_limit;
	}
3156 3157 3158
	| limit_clause {}
	;

3159 3160 3161 3162 3163
opt_limit_clause:
	/* empty */	{}
	| limit_clause	{}
	;

3164
limit_clause:
3165
	LIMIT limit_options {}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3166
	;
3167 3168 3169

limit_options:
	ULONG_NUM
3170
	  {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3171
            SELECT_LEX_NODE *sel= Select;
3172 3173 3174 3175 3176
            sel->select_limit= $1;
            sel->offset_limit= 0L;
	  }
	| ULONG_NUM ',' ULONG_NUM
	  {
3177
	    SELECT_LEX_NODE *sel= Select;
3178 3179
	    sel->select_limit= $3;
	    sel->offset_limit= $1;
3180
	  }
3181
	| ULONG_NUM OFFSET_SYM ULONG_NUM
3182
	  {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3183
	    SELECT_LEX_NODE *sel= Select;
3184 3185 3186 3187
	    sel->select_limit= $1;
	    sel->offset_limit= $3;
	  }
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3188 3189 3190 3191 3192


delete_limit_clause:
	/* empty */
	{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3193
	  LEX *lex=Lex;
3194
	  lex->current_select->select_limit= HA_POS_ERROR;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3195
	}
3196
	| LIMIT ulonglong_num
3197
	{ Select->select_limit= (ha_rows) $2; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3198 3199

ULONG_NUM:
3200
	NUM	    { $$= strtoul($1.str,NULL,10); }
3201
	| LONG_NUM  { $$= (ulong) strtoll($1.str,NULL,10); }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3202
	| ULONGLONG_NUM { $$= (ulong) strtoull($1.str,NULL,10); }
3203
	| REAL_NUM  { $$= strtoul($1.str,NULL,10); }
3204
	| FLOAT_NUM { $$= strtoul($1.str,NULL,10); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3205

3206
ulonglong_num:
3207
	NUM	    { $$= (ulonglong) strtoul($1.str,NULL,10); }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3208
	| ULONGLONG_NUM { $$= strtoull($1.str,NULL,10); }
3209
	| LONG_NUM  { $$= (ulonglong) strtoll($1.str,NULL,10); }
3210
	| REAL_NUM  { $$= strtoull($1.str,NULL,10); }
3211
	| FLOAT_NUM { $$= strtoull($1.str,NULL,10); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3212 3213 3214 3215 3216 3217

procedure_clause:
	/* empty */
	| PROCEDURE ident			/* Procedure name */
	  {
	    LEX *lex=Lex;
3218 3219 3220 3221 3222 3223 3224
	    if (&lex->select_lex != lex->current_select)
	    {
	      net_printf(lex->thd, ER_WRONG_USAGE,
			  "PROCEDURE",
			  "subquery");
	      YYABORT;
	    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3225 3226 3227
	    lex->proc_list.elements=0;
	    lex->proc_list.first=0;
	    lex->proc_list.next= (byte**) &lex->proc_list.first;
3228
	    if (add_proc_to_list(lex->thd, new Item_field(NULL,NULL,$2.str)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3229
	      YYABORT;
3230
	    Lex->uncacheable();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3231
	  }
3232
	  '(' procedure_list ')';
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3233 3234 3235 3236


procedure_list:
	/* empty */ {}
3237
	| procedure_list2 {};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3238 3239 3240

procedure_list2:
	procedure_list2 ',' procedure_item
3241
	| procedure_item;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3242 3243 3244 3245

procedure_item:
	  remember_name expr
	  {
3246 3247
	    LEX *lex= Lex;
	    if (add_proc_to_list(lex->thd, $2))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3248 3249
	      YYABORT;
	    if (!$2->name)
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
3250
	      $2->set_name($1,(uint) ((char*) lex->tok_end - $1), YYTHD->charset());
3251 3252 3253 3254 3255 3256
	  }
          ;


select_var_list_init:
	   {
3257 3258
             LEX *lex=Lex;
	     if (!lex->describe && (!(lex->result= new select_dumpvar())))
3259 3260
	        YYABORT;
	   }
3261
	   select_var_list
3262
	   {}
3263
           ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3264

Sinisa@sinisa.nasamreza.org's avatar
Sinisa@sinisa.nasamreza.org committed
3265
select_var_list:
3266 3267 3268 3269 3270
	   select_var_list ',' select_var_ident
	   | select_var_ident {}
           ;

select_var_ident:  '@' ident_or_text
Sinisa@sinisa.nasamreza.org's avatar
Sinisa@sinisa.nasamreza.org committed
3271
           {
3272
             LEX *lex=Lex;
3273
	     if (lex->result && ((select_dumpvar *)lex->result)->var_list.push_back((LEX_STRING*) sql_memdup(&$2,sizeof(LEX_STRING))))
Sinisa@sinisa.nasamreza.org's avatar
Sinisa@sinisa.nasamreza.org committed
3274 3275
	       YYABORT;
	   }
3276
           ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3277

3278
into:
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
3279
        INTO OUTFILE TEXT_STRING_sys
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3280
	{
3281
	  LEX *lex=Lex;
3282 3283
	  if (!lex->describe)
	  {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3284
	    lex->uncacheable();
3285 3286 3287 3288 3289
	    if (!(lex->exchange= new sql_exchange($3.str,0)))
	      YYABORT;
	    if (!(lex->result= new select_export(lex->exchange)))
	      YYABORT;
	  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3290 3291
	}
	opt_field_term opt_line_term
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
3292
	| INTO DUMPFILE TEXT_STRING_sys
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3293
	{
3294
	  LEX *lex=Lex;
3295 3296
	  if (!lex->describe)
	  {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3297
	    lex->uncacheable();
3298 3299 3300 3301 3302
	    if (!(lex->exchange= new sql_exchange($3.str,1)))
	      YYABORT;
	    if (!(lex->result= new select_dump(lex->exchange)))
	      YYABORT;
	  }
Sinisa@sinisa.nasamreza.org's avatar
Sinisa@sinisa.nasamreza.org committed
3303
	}
3304
        | INTO select_var_list_init
Sinisa@sinisa.nasamreza.org's avatar
Sinisa@sinisa.nasamreza.org committed
3305
	{
3306
	  Lex->uncacheable();
3307 3308
	}
        ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3309

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3310 3311 3312
/*
  DO statement
*/
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3313

3314
do:	DO_SYM
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3315 3316 3317 3318 3319 3320
	{
	  LEX *lex=Lex;
	  lex->sql_command = SQLCOM_DO;
	  if (!(lex->insert_list = new List_item))
	    YYABORT;
	}
3321 3322 3323 3324
	values
	{}
	;

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3325
/*
3326
  Drop : delete tables or index or user
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3327 3328 3329
*/

drop:
3330
	DROP opt_temporary TABLE_SYM if_exists table_list opt_restrict
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3331
	{
3332 3333
	  LEX *lex=Lex;
	  lex->sql_command = SQLCOM_DROP_TABLE;
3334 3335
	  lex->drop_temporary= $2;
	  lex->drop_if_exists= $4;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3336 3337 3338
	}
	| DROP INDEX ident ON table_ident {}
	  {
3339 3340 3341 3342
	     LEX *lex=Lex;
	     lex->sql_command= SQLCOM_DROP_INDEX;
	     lex->drop_list.empty();
	     lex->drop_list.push_back(new Alter_drop(Alter_drop::KEY,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3343
						     $3.str));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3344 3345
	     if (!lex->current_select->add_table_to_list(lex->thd, $5, NULL,
							TL_OPTION_UPDATING))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3346 3347 3348 3349
	      YYABORT;
	  }
	| DROP DATABASE if_exists ident
	  {
3350 3351 3352 3353
	    LEX *lex=Lex;
	    lex->sql_command= SQLCOM_DROP_DB;
	    lex->drop_if_exists=$3;
	    lex->name=$4.str;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3354
	 }
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
3355
	| DROP UDF_SYM IDENT_sys
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3356
	  {
3357 3358
	    LEX *lex=Lex;
	    lex->sql_command = SQLCOM_DROP_FUNCTION;
3359
	    lex->udf.name = $3;
3360 3361 3362 3363 3364 3365 3366 3367 3368 3369
	  }
	| DROP USER
	  {
	    LEX *lex=Lex;
	    lex->sql_command = SQLCOM_DROP_USER;
	    lex->users_list.empty();
	  } 
	  user_list
	  {}
	  ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3370 3371 3372


table_list:
3373
	table_name
3374
	| table_list ',' table_name;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3375

3376
table_name:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3377
	table_ident
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3378 3379 3380 3381 3382
	{
	  if (!Select->add_table_to_list(YYTHD, $1, NULL, TL_OPTION_UPDATING))
	    YYABORT;
	}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3383 3384

if_exists:
3385
	/* empty */ { $$= 0; }
3386 3387
	| IF EXISTS { $$= 1; }
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3388

3389 3390 3391 3392
opt_temporary:
	/* empty */ { $$= 0; }
	| TEMPORARY { $$= 1; }
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3393 3394 3395 3396 3397
/*
** Insert : add new data to table
*/

insert:
3398 3399 3400 3401 3402 3403
	INSERT
	{
	  LEX *lex= Lex;
	  lex->sql_command = SQLCOM_INSERT;
	  /* for subselects */
          lex->lock_option= (using_update_log) ? TL_READ_NO_INSERT : TL_READ;
3404
	  lex->select_lex.insert_select= 1;
3405
	} insert_lock_option
3406
	opt_ignore insert2
3407
	{
3408
	  Select->set_lock_for_tables($3);
3409
	}
3410
	insert_field_spec opt_insert_update
3411
	{}
3412
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3413 3414

replace:
3415 3416
	REPLACE
	{
3417
	  LEX *lex=Lex;
3418 3419
	  lex->sql_command = SQLCOM_REPLACE;
	  lex->duplicates= DUP_REPLACE;
3420
	  lex->select_lex.insert_select= 1;
3421
	}
3422 3423
	replace_lock_option insert2
	{
3424
	  Select->set_lock_for_tables($3);
3425 3426
	}
	insert_field_spec
3427
	{}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3428
	{}
3429
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3430 3431

insert_lock_option:
3432 3433 3434 3435
	/* empty */	{ $$= TL_WRITE_CONCURRENT_INSERT; }
	| LOW_PRIORITY	{ $$= TL_WRITE_LOW_PRIORITY; }
	| DELAYED_SYM	{ $$= TL_WRITE_DELAYED; }
	| HIGH_PRIORITY { $$= TL_WRITE; }
3436
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3437 3438

replace_lock_option:
3439 3440
	opt_low_priority { $$= $1; }
	| DELAYED_SYM	 { $$= TL_WRITE_DELAYED; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3441 3442 3443

insert2:
	INTO insert_table {}
3444
	| insert_table {};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3445 3446

insert_table:
3447
	table_name
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3448
	{
3449 3450 3451 3452
	  LEX *lex=Lex;
	  lex->field_list.empty();
	  lex->many_values.empty();
	  lex->insert_list=0;
3453
	};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3454 3455 3456 3457 3458

insert_field_spec:
	opt_field_spec insert_values {}
	| SET
	  {
3459 3460 3461
	    LEX *lex=Lex;
	    if (!(lex->insert_list = new List_item) ||
		lex->many_values.push_back(lex->insert_list))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3462 3463
	      YYABORT;
	   }
3464
	   ident_eq_list;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3465 3466 3467 3468

opt_field_spec:
	/* empty */	  { }
	| '(' fields ')'  { }
3469
	| '(' ')'	  { };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3470 3471 3472

fields:
	fields ',' insert_ident { Lex->field_list.push_back($3); }
3473
	| insert_ident		{ Lex->field_list.push_back($1); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3474 3475 3476

insert_values:
	VALUES	values_list  {}
3477
	| VALUE_SYM values_list  {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3478 3479 3480 3481 3482
	| SELECT_SYM
	  {
	    LEX *lex=Lex;
	    lex->sql_command = (lex->sql_command == SQLCOM_INSERT ?
				SQLCOM_INSERT_SELECT : SQLCOM_REPLACE_SELECT);
3483
	    lex->lock_option= (using_update_log) ? TL_READ_NO_INSERT : TL_READ;
3484
	    mysql_init_select(lex);
3485 3486 3487 3488 3489
	    /*
	      it is not simple select => table list will be
              preprocessed before passing to handle_select
	    */
	    lex->select_lex.insert_select= 0;
3490
	    lex->current_select->parsing_place= SELECT_LEX_NODE::SELECT_LIST;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3491
	  }
3492 3493 3494
	  select_options select_item_list
	  {
	    Select->parsing_place= SELECT_LEX_NODE::NO_MATTER;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3495
	  }
3496
	  opt_select_from select_lock_type
3497
          union_clause {}
3498
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3499 3500 3501

values_list:
	values_list ','  no_braces
3502
	| no_braces;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3503 3504 3505 3506

ident_eq_list:
	ident_eq_list ',' ident_eq_value
	|
3507
	ident_eq_value;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3508 3509

ident_eq_value:
3510
	simple_ident equal expr_or_default
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3511
	 {
3512 3513 3514
	  LEX *lex=Lex;
	  if (lex->field_list.push_back($1) ||
	      lex->insert_list->push_back($3))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3515
	    YYABORT;
3516
	 };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3517 3518

equal:	EQ		{}
3519 3520 3521 3522 3523 3524 3525
	| SET_VAR	{}
	;

opt_equal:
	/* empty */	{}
	| equal		{}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3526 3527 3528 3529 3530 3531 3532 3533 3534

no_braces:
	 '('
	 {
	    if (!(Lex->insert_list = new List_item))
	      YYABORT;
	 }
	 opt_values ')'
	 {
3535 3536
	  LEX *lex=Lex;
	  if (lex->many_values.push_back(lex->insert_list))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3537
	    YYABORT;
3538
	 };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3539 3540 3541

opt_values:
	/* empty */ {}
3542
	| values;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3543 3544

values:
3545
	values ','  expr_or_default
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3546 3547 3548 3549
	{
	  if (Lex->insert_list->push_back($3))
	    YYABORT;
	}
3550 3551 3552 3553 3554 3555 3556 3557
	| expr_or_default
	  {
	    if (Lex->insert_list->push_back($1))
	      YYABORT;
	  }
	;

expr_or_default:
3558
	expr	  { $$= $1;}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3559
	| DEFAULT {$$= new Item_default_value(); }
3560
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3561

3562 3563
opt_insert_update:
        /* empty */
3564
        | ON DUPLICATE_SYM
3565 3566 3567 3568 3569 3570 3571 3572 3573
          { /* for simplisity, let's forget about
               INSERT ... SELECT ... UPDATE
               for a moment */
	    if (Lex->sql_command != SQLCOM_INSERT)
            {
	      send_error(Lex->thd, ER_SYNTAX_ERROR);
              YYABORT;
            }
          }
3574
          KEY_SYM UPDATE_SYM update_list
3575 3576
        ;

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3577 3578 3579
/* Update rows in a table */

update:
3580 3581
	UPDATE_SYM
	{
3582
	  LEX *lex= Lex;
3583
	  mysql_init_select(lex);
3584
          lex->sql_command= SQLCOM_UPDATE;
3585
        }
3586 3587 3588
        opt_low_priority opt_ignore join_table_list
	SET update_list where_clause opt_order_clause delete_limit_clause
	{
3589
	  LEX *lex= Lex;
3590
	  Select->set_lock_for_tables($3);
3591
          if (lex->select_lex.table_list.elements > 1)
3592
            lex->sql_command= SQLCOM_UPDATE_MULTI;
3593 3594
	}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3595 3596

update_list:
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3597
	update_list ',' simple_ident equal expr_or_default
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3598
	{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3599
	  if (add_item_to_list(YYTHD, $3) || add_value_to_list(YYTHD, $5))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3600 3601
	    YYABORT;
	}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3602
	| simple_ident equal expr_or_default
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3603
	  {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3604
	    if (add_item_to_list(YYTHD, $1) || add_value_to_list(YYTHD, $3))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3605
	      YYABORT;
3606
	  };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3607 3608

opt_low_priority:
3609
	/* empty */	{ $$= YYTHD->update_lock_default; }
3610
	| LOW_PRIORITY	{ $$= TL_WRITE_LOW_PRIORITY; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3611 3612 3613 3614

/* Delete rows from a table */

delete:
3615
	DELETE_SYM
3616
	{
3617 3618
	  LEX *lex= Lex;
	  lex->sql_command= SQLCOM_DELETE;
3619
	  lex->lock_option= lex->thd->update_lock_default;
3620
	  lex->select_lex.init_order();
3621
	}
3622 3623
	opt_delete_options single_multi {}
	;
3624 3625

single_multi:
3626 3627
 	FROM table_ident
	{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3628 3629
	  if (!Select->add_table_to_list(YYTHD, $2, NULL, TL_OPTION_UPDATING,
					 Lex->lock_option))
3630 3631 3632
	    YYABORT;
	}
	where_clause opt_order_clause
3633
	delete_limit_clause {}
3634
	| table_wild_list
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3635
	  { mysql_init_multi_delete(Lex); }
3636
          FROM join_table_list where_clause
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3637 3638
	| FROM table_wild_list
	  { mysql_init_multi_delete(Lex); }
3639 3640 3641
	  USING join_table_list where_clause
	  {}
	;
3642 3643 3644

table_wild_list:
	  table_wild_one {}
3645
	  | table_wild_list ',' table_wild_one {};
3646 3647

table_wild_one:
Sinisa@sinisa.nasamreza.org's avatar
Sinisa@sinisa.nasamreza.org committed
3648
	ident opt_wild opt_table_alias
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3649
	{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3650 3651
	  if (!Select->add_table_to_list(YYTHD, new Table_ident($1), $3,
					 TL_OPTION_UPDATING, Lex->lock_option))
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3652 3653
	    YYABORT;
        }
Sinisa@sinisa.nasamreza.org's avatar
Sinisa@sinisa.nasamreza.org committed
3654
	| ident '.' ident opt_wild opt_table_alias
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3655
	  {
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3656 3657
	    if (!Select->add_table_to_list(YYTHD,
					   new Table_ident(YYTHD, $1, $3, 0),
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3658 3659
					   $5, TL_OPTION_UPDATING,
					   Lex->lock_option))
3660
	      YYABORT;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3661
	  }
3662
	;
3663 3664

opt_wild:
3665
	/* empty */	{}
3666
	| '.' '*'	{};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3667 3668


3669
opt_delete_options:
3670
	/* empty */	{}
3671
	| opt_delete_option opt_delete_options {};
3672 3673

opt_delete_option:
3674
	QUICK		{ Select->options|= OPTION_QUICK; }
3675
	| LOW_PRIORITY	{ Lex->lock_option= TL_WRITE_LOW_PRIORITY; };
3676

3677
truncate:
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
3678
	TRUNCATE_SYM opt_table_sym table_name
3679
	{
3680
	  LEX* lex= Lex;
3681
	  lex->sql_command= SQLCOM_TRUNCATE;
3682
	  lex->select_lex.options= 0;
3683
	  lex->select_lex.init_order();
3684 3685
	}
	;
3686

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
3687 3688
opt_table_sym:
	/* empty */
3689
	| TABLE_SYM;
3690

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3691 3692
/* Show things */

3693 3694
show:	SHOW
	{
3695 3696 3697 3698
	  LEX *lex=Lex;
	  lex->wild=0;
	  bzero((char*) &lex->create_info,sizeof(lex->create_info));
	}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3699
	show_param
3700 3701
	{}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3702 3703 3704 3705 3706

show_param:
	DATABASES wild
	  { Lex->sql_command= SQLCOM_SHOW_DATABASES; }
	| TABLES opt_db wild
3707
	  {
3708
	    LEX *lex= Lex;
3709
	    lex->sql_command= SQLCOM_SHOW_TABLES;
3710 3711
	    lex->select_lex.db= $2;
	    lex->select_lex.options= 0;
3712
	   }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3713
	| TABLE_SYM STATUS_SYM opt_db wild
3714
	  {
3715
	    LEX *lex= Lex;
3716
	    lex->sql_command= SQLCOM_SHOW_TABLES;
3717 3718
	    lex->select_lex.options|= SELECT_DESCRIBE;
	    lex->select_lex.db= $3;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3719
	  }
3720
	| OPEN_SYM TABLES opt_db wild
3721
	  {
3722
	    LEX *lex= Lex;
3723
	    lex->sql_command= SQLCOM_SHOW_OPEN_TABLES;
3724 3725
	    lex->select_lex.db= $3;
	    lex->select_lex.options= 0;
3726
	  }
3727
	| opt_full COLUMNS from_or_in table_ident opt_db wild
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3728 3729
	  {
	    Lex->sql_command= SQLCOM_SHOW_FIELDS;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
3730 3731
	    if ($5)
	      $4->change_db($5);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3732
	    if (!Select->add_table_to_list(YYTHD, $4, NULL, 0))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3733 3734
	      YYABORT;
	  }
3735
        | NEW_SYM MASTER_SYM FOR_SYM SLAVE WITH MASTER_LOG_FILE_SYM EQ
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
3736
	  TEXT_STRING_sys AND MASTER_LOG_POS_SYM EQ ulonglong_num
3737
	  AND MASTER_SERVER_ID_SYM EQ
3738 3739 3740 3741 3742
	ULONG_NUM
          {
	    Lex->sql_command = SQLCOM_SHOW_NEW_MASTER;
	    Lex->mi.log_file_name = $8.str;
	    Lex->mi.pos = $12;
3743
	    Lex->mi.server_id = $16;
3744
          }
3745
        | master_or_binary LOGS_SYM
3746 3747
          {
	    Lex->sql_command = SQLCOM_SHOW_BINLOGS;
3748 3749 3750 3751 3752
          }
        | SLAVE HOSTS_SYM
          {
	    Lex->sql_command = SQLCOM_SHOW_SLAVE_HOSTS;
          }
3753
        | BINLOG_SYM EVENTS_SYM binlog_in binlog_from
3754
          {
3755 3756
	    LEX *lex= Lex;
	    lex->sql_command= SQLCOM_SHOW_BINLOG_EVENTS;
3757
          } opt_limit_clause_init
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3758 3759 3760 3761 3762
	| keys_or_index FROM table_ident opt_db
	  {
	    Lex->sql_command= SQLCOM_SHOW_KEYS;
	    if ($4)
	      $3->change_db($4);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3763
	    if (!Select->add_table_to_list(YYTHD, $3, NULL, 0))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3764 3765
	      YYABORT;
	  }
3766 3767 3768 3769 3770 3771 3772 3773 3774 3775 3776 3777 3778 3779 3780
	| COLUMN_SYM TYPES_SYM
	  {
	    LEX *lex=Lex;
	    lex->sql_command= SQLCOM_SHOW_COLUMN_TYPES;
	  }
	| TABLE_SYM TYPES_SYM
	  {
	    LEX *lex=Lex;
	    lex->sql_command= SQLCOM_SHOW_TABLE_TYPES;
	  }
	| PRIVILEGES
	  {
	    LEX *lex=Lex;
	    lex->sql_command= SQLCOM_SHOW_PRIVILEGES;
	  }
3781
        | COUNT_SYM '(' '*' ')' WARNINGS
3782
          { (void) create_select_for_variable("warning_count"); }
3783
        | COUNT_SYM '(' '*' ')' ERRORS
3784
	  { (void) create_select_for_variable("error_count"); }
3785
        | WARNINGS opt_limit_clause_init
3786
          { Lex->sql_command = SQLCOM_SHOW_WARNS;}
3787
        | ERRORS opt_limit_clause_init
3788
          { Lex->sql_command = SQLCOM_SHOW_ERRORS;}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3789 3790
	| STATUS_SYM wild
	  { Lex->sql_command= SQLCOM_SHOW_STATUS; }
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3791 3792
        | INNOBASE_SYM STATUS_SYM
          { Lex->sql_command = SQLCOM_SHOW_INNODB_STATUS;}
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
3793 3794
	| opt_full PROCESSLIST_SYM
	  { Lex->sql_command= SQLCOM_SHOW_PROCESSLIST;}
3795
	| opt_var_type VARIABLES wild
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3796
	  {
3797
	    THD *thd= YYTHD;
3798
	    thd->lex.sql_command= SQLCOM_SHOW_VARIABLES;
3799
	    thd->lex.option_type= (enum_var_type) $1;
3800
	  }
3801
	| charset wild
3802
	  { Lex->sql_command= SQLCOM_SHOW_CHARSETS; }
3803 3804
	| COLLATION_SYM wild
	  { Lex->sql_command= SQLCOM_SHOW_COLLATIONS; }
3805 3806
	| BERKELEY_DB_SYM LOGS_SYM
	  { Lex->sql_command= SQLCOM_SHOW_LOGS; }
tim@cane.mysql.fi's avatar
tim@cane.mysql.fi committed
3807 3808
	| LOGS_SYM
	  { Lex->sql_command= SQLCOM_SHOW_LOGS; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3809
	| GRANTS FOR_SYM user
3810 3811 3812 3813 3814 3815
	  {
	    LEX *lex=Lex;
	    lex->sql_command= SQLCOM_SHOW_GRANTS;
	    lex->grant_user=$3;
	    lex->grant_user->password.str=NullS;
	  }
3816
	| CREATE DATABASE opt_if_not_exists ident
3817 3818
	  {
	    Lex->sql_command=SQLCOM_SHOW_CREATE_DB;
3819 3820
	    Lex->create_info.options=$3;
	    Lex->name=$4.str;
3821
	  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3822 3823 3824
        | CREATE TABLE_SYM table_ident
          {
	    Lex->sql_command = SQLCOM_SHOW_CREATE;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3825
	    if (!Select->add_table_to_list(YYTHD, $3, NULL,0))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3826 3827 3828 3829 3830
	      YYABORT;
	  }
        | MASTER_SYM STATUS_SYM
          {
	    Lex->sql_command = SQLCOM_SHOW_MASTER_STAT;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
3831
          }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3832 3833 3834
        | SLAVE STATUS_SYM
          {
	    Lex->sql_command = SQLCOM_SHOW_SLAVE_STAT;
3835
          };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3836

3837 3838 3839 3840
master_or_binary:
	MASTER_SYM
	| BINARY;

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3841 3842
opt_db:
	/* empty */  { $$= 0; }
3843
	| from_or_in ident { $$= $2.str; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3844 3845 3846

wild:
	/* empty */
3847
	| LIKE text_string { Lex->wild= $2; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3848

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
3849 3850
opt_full:
	/* empty */ { Lex->verbose=0; }
3851
	| FULL	    { Lex->verbose=1; };
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
3852

3853 3854
from_or_in:
	FROM
3855
	| IN_SYM;
3856

3857 3858
binlog_in:
	/* empty */ { Lex->mi.log_file_name = 0; }
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
3859
        | IN_SYM TEXT_STRING_sys { Lex->mi.log_file_name = $2.str; };
3860 3861 3862

binlog_from:
	/* empty */ { Lex->mi.pos = 4; /* skip magic number */ }
3863
        | FROM ulonglong_num { Lex->mi.pos = $2; };
3864 3865


bk@work.mysql.com's avatar
bk@work.mysql.com committed
3866 3867 3868 3869
/* A Oracle compatible synonym for show */
describe:
	describe_command table_ident
	{
3870 3871 3872 3873
	  LEX *lex=Lex;
	  lex->wild=0;
	  lex->verbose=0;
	  lex->sql_command=SQLCOM_SHOW_FIELDS;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3874
	  if (!Select->add_table_to_list(lex->thd, $2, NULL,0))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3875 3876
	    YYABORT;
	}
3877
	opt_describe_column {}
3878
	| describe_command { Lex->describe=1; } select
3879
          {
3880
	    LEX *lex=Lex;
3881
	    lex->select_lex.options|= SELECT_DESCRIBE;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3882 3883
	  }
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3884 3885 3886

describe_command:
	DESC
3887
	| DESCRIBE;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3888 3889 3890 3891

opt_describe_column:
	/* empty */	{}
	| text_string	{ Lex->wild= $1; }
3892
	| ident
3893
	  { Lex->wild= new String((const char*) $1.str,$1.length,system_charset_info); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3894 3895 3896 3897 3898


/* flush things */

flush:
3899
	FLUSH_SYM opt_no_write_to_binlog
3900 3901 3902
	{
	  LEX *lex=Lex;
	  lex->sql_command= SQLCOM_FLUSH; lex->type=0;
3903
          lex->no_write_to_binlog= $2; 
3904
	}
3905 3906 3907
	flush_options
	{}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3908 3909 3910

flush_options:
	flush_options ',' flush_option
3911
	| flush_option;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3912 3913

flush_option:
3914
	table_or_tables	{ Lex->type|= REFRESH_TABLES; } opt_table_list {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3915
	| TABLES WITH READ_SYM LOCK_SYM { Lex->type|= REFRESH_TABLES | REFRESH_READ_LOCK; }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3916
	| QUERY_SYM CACHE_SYM { Lex->type|= REFRESH_QUERY_CACHE_FREE; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3917 3918 3919 3920
	| HOSTS_SYM	{ Lex->type|= REFRESH_HOSTS; }
	| PRIVILEGES	{ Lex->type|= REFRESH_GRANT; }
	| LOGS_SYM	{ Lex->type|= REFRESH_LOG; }
	| STATUS_SYM	{ Lex->type|= REFRESH_STATUS; }
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
3921 3922
        | SLAVE         { Lex->type|= REFRESH_SLAVE; }
        | MASTER_SYM    { Lex->type|= REFRESH_MASTER; }
3923 3924
	| DES_KEY_FILE	{ Lex->type|= REFRESH_DES_KEY_FILE; }
 	| RESOURCES     { Lex->type|= REFRESH_USER_RESOURCES; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3925

3926
opt_table_list:
3927 3928
	/* empty */  {;}
	| table_list {;};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3929

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
3930
reset:
3931 3932 3933 3934
	RESET_SYM
	{
	  LEX *lex=Lex;
	  lex->sql_command= SQLCOM_RESET; lex->type=0;
3935 3936 3937 3938
	} reset_options
	{}
	;

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
3939 3940
reset_options:
	reset_options ',' reset_option
3941
	| reset_option;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
3942 3943

reset_option:
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3944 3945
        SLAVE                 { Lex->type|= REFRESH_SLAVE; }
        | MASTER_SYM          { Lex->type|= REFRESH_MASTER; }
3946
	| QUERY_SYM CACHE_SYM { Lex->type|= REFRESH_QUERY_CACHE;};
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
3947

3948
purge:
3949 3950 3951 3952
	PURGE
	{
	  LEX *lex=Lex;
	  lex->type=0;
3953 3954 3955 3956 3957
	} purge_options
	{}
	;

purge_options:
3958
	master_or_binary LOGS_SYM purge_option
3959
	;
3960 3961

purge_option:
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
3962
        TO_SYM TEXT_STRING_sys
3963 3964 3965 3966 3967 3968 3969 3970 3971 3972 3973 3974 3975
        {
	   Lex->sql_command = SQLCOM_PURGE;
	   Lex->to_log = $2.str;
        }
	| BEFORE_SYM expr
	{
	  if ($2->check_cols(1) || $2->fix_fields(Lex->thd, 0, &$2))
	  {
	    net_printf(Lex->thd, ER_WRONG_ARGUMENTS, "PURGE LOGS BEFORE");
	    YYABORT;	  
	  }
	  Item *tmp= new Item_func_unix_timestamp($2);
	  Lex->sql_command = SQLCOM_PURGE_BEFORE;
3976
	  Lex->purge_time= (ulong) tmp->val_int();
3977
	}
3978
	;
3979

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3980 3981 3982
/* kill threads */

kill:
3983
	KILL_SYM expr
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3984
	{
3985
	  LEX *lex=Lex;
3986
	  if ($2->fix_fields(lex->thd, 0, &$2) || $2->check_cols(1))
3987
	  {
3988
	    send_error(lex->thd, ER_SET_CONSTANTS_ONLY);
3989 3990 3991 3992
	    YYABORT;
	  }
          lex->sql_command=SQLCOM_KILL;
	  lex->thread_id= (ulong) $2->val_int();
3993
	};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3994 3995 3996 3997

/* change database */

use:	USE_SYM ident
3998 3999
	{
	  LEX *lex=Lex;
4000 4001
	  lex->sql_command=SQLCOM_CHANGE_DB;
	  lex->select_lex.db= $2.str;
4002
	};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4003 4004 4005

/* import, export of files */

bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4006
load:	LOAD DATA_SYM load_data_lock opt_local INFILE TEXT_STRING_sys
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4007
	{
4008 4009
	  LEX *lex=Lex;
	  lex->sql_command= SQLCOM_LOAD;
4010 4011
	  lex->lock_option= $3;
	  lex->local_file=  $4;
4012
	  if (!(lex->exchange= new sql_exchange($6.str,0)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4013
	    YYABORT;
4014
	  lex->field_list.empty();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4015 4016 4017 4018
	}
	opt_duplicate INTO TABLE_SYM table_ident opt_field_term opt_line_term
	opt_ignore_lines opt_field_spec
	{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4019
	  if (!Select->add_table_to_list(YYTHD, $11, NULL, TL_OPTION_UPDATING))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4020 4021 4022
	    YYABORT;
	}
        |
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
4023
	LOAD TABLE_SYM table_ident FROM MASTER_SYM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4024 4025
        {
	  Lex->sql_command = SQLCOM_LOAD_MASTER_TABLE;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4026
	  if (!Select->add_table_to_list(YYTHD, $3, NULL, TL_OPTION_UPDATING))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4027
	    YYABORT;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
4028 4029

        }
4030 4031 4032 4033
        |
	LOAD DATA_SYM FROM MASTER_SYM
        {
	  Lex->sql_command = SQLCOM_LOAD_MASTER_DATA;
4034
        };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4035 4036 4037

opt_local:
	/* empty */	{ $$=0;}
4038
	| LOCAL_SYM	{ $$=1;};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4039

4040
load_data_lock:
4041
	/* empty */	{ $$= YYTHD->update_lock_default; }
4042 4043
	| CONCURRENT	{ $$= TL_WRITE_CONCURRENT_INSERT ; }
	| LOW_PRIORITY	{ $$= TL_WRITE_LOW_PRIORITY; };
4044 4045


bk@work.mysql.com's avatar
bk@work.mysql.com committed
4046 4047 4048
opt_duplicate:
	/* empty */	{ Lex->duplicates=DUP_ERROR; }
	| REPLACE	{ Lex->duplicates=DUP_REPLACE; }
4049
	| IGNORE_SYM	{ Lex->duplicates=DUP_IGNORE; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4050 4051 4052

opt_field_term:
	/* empty */
4053
	| COLUMNS field_term_list;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4054 4055 4056

field_term_list:
	field_term_list field_term
4057
	| field_term;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4058 4059 4060 4061

field_term:
	TERMINATED BY text_string { Lex->exchange->field_term= $3;}
	| OPTIONALLY ENCLOSED BY text_string
4062 4063 4064 4065 4066
	  {
	    LEX *lex=Lex;
	    lex->exchange->enclosed= $4;
	    lex->exchange->opt_enclosed=1;
	  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4067
	| ENCLOSED BY text_string { Lex->exchange->enclosed= $3;}
4068
	| ESCAPED BY text_string  { Lex->exchange->escaped= $3;};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4069 4070 4071

opt_line_term:
	/* empty */
4072
	| LINES line_term_list;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4073 4074 4075

line_term_list:
	line_term_list line_term
4076
	| line_term;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4077 4078 4079

line_term:
	TERMINATED BY text_string { Lex->exchange->line_term= $3;}
4080
	| STARTING BY text_string { Lex->exchange->line_start= $3;};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4081 4082 4083 4084

opt_ignore_lines:
	/* empty */
	| IGNORE_SYM NUM LINES
4085
	  { Lex->exchange->skip_lines=atol($2.str); };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4086 4087 4088 4089

/* Common definitions */

text_literal:
4090
	TEXT_STRING_literal
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4091 4092
	{
	  THD *thd= YYTHD;
4093
	  $$ = new Item_string($1.str,$1.length,thd->variables.collation_connection);
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4094
	}
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4095
	| NCHAR_STRING
4096
	{ $$=  new Item_string($1.str,$1.length,national_charset_info); }
4097
	| UNDERSCORE_CHARSET TEXT_STRING
4098
	  { $$ = new Item_string($2.str,$2.length,Lex->charset); }
4099
	| text_literal TEXT_STRING_literal
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4100 4101
	  { ((Item_string*) $1)->append($2.str,$2.length); }
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4102 4103

text_string:
4104
	TEXT_STRING_literal
4105
	{ $$=  new String($1.str,$1.length,YYTHD->variables.collation_connection); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4106 4107
	| HEX_NUM
	  {
4108
	    Item *tmp = new Item_varbinary($1.str,$1.length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4109
	    $$= tmp ? tmp->val_str((String*) 0) : (String*) 0;
4110 4111 4112
	  }
	;

4113
param_marker:
4114
        '?'
4115
        {
4116
	  LEX *lex=Lex;
4117
          if (YYTHD->prepare_command)
4118
          {
4119
            lex->param_list.push_back($$=new Item_param((uint)(lex->tok_start-(uchar *)YYTHD->query)));
4120
            lex->param_count++;
4121
          }
4122
          else
4123 4124 4125 4126
          {
            yyerror("You have an error in your SQL syntax");
            YYABORT;
          }
4127 4128 4129
        }
	;

bk@work.mysql.com's avatar
bk@work.mysql.com committed
4130 4131
literal:
	text_literal	{ $$ =	$1; }
4132 4133
	| NUM		{ $$ =	new Item_int($1.str, (longlong) strtol($1.str, NULL, 10),$1.length); }
	| LONG_NUM	{ $$ =	new Item_int($1.str, (longlong) strtoll($1.str,NULL,10), $1.length); }
4134
	| ULONGLONG_NUM	{ $$ =	new Item_uint($1.str, $1.length); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4135 4136 4137
	| REAL_NUM	{ $$ =	new Item_real($1.str, $1.length); }
	| FLOAT_NUM	{ $$ =	new Item_float($1.str, $1.length); }
	| NULL_SYM	{ $$ =	new Item_null();
4138
			  Lex->next_state=MY_LEX_OPERATOR_OR_IDENT;}
4139
	| HEX_NUM	{ $$ =	new Item_varbinary($1.str,$1.length);}
4140 4141 4142 4143
	| UNDERSCORE_CHARSET HEX_NUM
	  { 
	    Item *tmp= new Item_varbinary($2.str,$2.length);
	    String *str= tmp ? tmp->val_str((String*) 0) : (String*) 0;
4144 4145
	    $$ = new Item_string(str ? str->ptr() : "", str ? str->length() : 0, 
				 Lex->charset);
4146
	  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4147 4148
	| DATE_SYM text_literal { $$ = $2; }
	| TIME_SYM text_literal { $$ = $2; }
4149
	| TIMESTAMP text_literal { $$ = $2; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4150 4151 4152 4153 4154 4155 4156

/**********************************************************************
** Createing different items.
**********************************************************************/

insert_ident:
	simple_ident	 { $$=$1; }
4157
	| table_wild	 { $$=$1; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4158 4159

table_wild:
4160 4161 4162 4163 4164
	ident '.' '*' 
	{
	  $$ = new Item_field(NullS,$1.str,"*");
	  Lex->current_select->select_lex()->with_wild++;
	}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4165
	| ident '.' ident '.' '*'
4166 4167 4168 4169 4170 4171 4172
	{
	  $$ = new Item_field((YYTHD->client_capabilities &
   			     CLIENT_NO_SCHEMA ? NullS : $1.str),
			     $3.str,"*");
	  Lex->current_select->select_lex()->with_wild++;
	}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4173 4174

order_ident:
4175
	expr { $$=$1; };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4176 4177 4178

simple_ident:
	ident
4179
	{
4180
	  SELECT_LEX_NODE *sel=Select;
4181 4182 4183 4184
	  $$= (sel->parsing_place != SELECT_LEX_NODE::IN_HAVING ||
	       sel->get_in_sum_expr() > 0) ?
              (Item*) new Item_field(NullS,NullS,$1.str) :
	      (Item*) new Item_ref(NullS,NullS,$1.str);
4185
	}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4186
	| ident '.' ident
4187
	{
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
4188 4189 4190 4191 4192 4193 4194 4195 4196
	  THD *thd= YYTHD;
	  LEX *lex= &thd->lex;
	  SELECT_LEX_NODE *sel= lex->current_select;
	  if (sel->no_table_names_allowed)
	  {
	    my_printf_error(ER_TABLENAME_NOT_ALLOWED_HERE, 
			    ER(ER_TABLENAME_NOT_ALLOWED_HERE),
			    MYF(0), $1.str, thd->where);
	  }
4197 4198 4199 4200
	  $$= (sel->parsing_place != SELECT_LEX_NODE::IN_HAVING ||
	       sel->get_in_sum_expr() > 0) ?
	      (Item*) new Item_field(NullS,$1.str,$3.str) :
	      (Item*) new Item_ref(NullS,$1.str,$3.str);
4201
	}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4202
	| '.' ident '.' ident
4203
	{
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
4204 4205 4206 4207 4208 4209 4210 4211 4212
	  THD *thd= YYTHD;
	  LEX *lex= &thd->lex;
	  SELECT_LEX_NODE *sel= lex->current_select;
	  if (sel->no_table_names_allowed)
	  {
	    my_printf_error(ER_TABLENAME_NOT_ALLOWED_HERE, 
			    ER(ER_TABLENAME_NOT_ALLOWED_HERE),
			    MYF(0), $2.str, thd->where);
	  }
4213 4214 4215 4216
	  $$= (sel->parsing_place != SELECT_LEX_NODE::IN_HAVING ||
	       sel->get_in_sum_expr() > 0) ?
	      (Item*) new Item_field(NullS,$2.str,$4.str) :
              (Item*) new Item_ref(NullS,$2.str,$4.str);
4217
	}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4218
	| ident '.' ident '.' ident
4219
	{
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
4220 4221 4222 4223 4224 4225 4226 4227 4228
	  THD *thd= YYTHD;
	  LEX *lex= &thd->lex;
	  SELECT_LEX_NODE *sel= lex->current_select;
	  if (sel->no_table_names_allowed)
	  {
	    my_printf_error(ER_TABLENAME_NOT_ALLOWED_HERE, 
			    ER(ER_TABLENAME_NOT_ALLOWED_HERE),
			    MYF(0), $3.str, thd->where);
	  }
4229 4230 4231 4232 4233 4234 4235 4236
	  $$= (sel->parsing_place != SELECT_LEX_NODE::IN_HAVING ||
	       sel->get_in_sum_expr() > 0) ?
	      (Item*) new Item_field((YYTHD->client_capabilities &
				      CLIENT_NO_SCHEMA ? NullS : $1.str),
				     $3.str, $5.str) :
	      (Item*) new Item_ref((YYTHD->client_capabilities &
				    CLIENT_NO_SCHEMA ? NullS : $1.str),
                                   $3.str, $5.str);
4237
	};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4238 4239 4240 4241 4242


field_ident:
	ident			{ $$=$1;}
	| ident '.' ident	{ $$=$3;}	/* Skipp schema name in create*/
4243
	| '.' ident		{ $$=$2;}	/* For Delphi */;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4244 4245 4246

table_ident:
	ident			{ $$=new Table_ident($1); }
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4247
	| ident '.' ident	{ $$=new Table_ident(YYTHD, $1,$3,0);}
4248 4249
	| '.' ident		{ $$=new Table_ident($2);}
   /* For Delphi */;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4250

bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4251 4252 4253 4254 4255 4256 4257 4258 4259 4260 4261 4262 4263 4264 4265 4266 4267 4268 4269 4270 4271 4272 4273 4274 4275 4276 4277 4278 4279 4280 4281 4282 4283 4284 4285 4286
IDENT_sys:
	IDENT
	{
	  THD *thd= YYTHD;
	  if (my_charset_same(thd->charset(),system_charset_info))
	  {
	    $$=$1;
	  }
	  else
	  {
	    String ident;
	    ident.copy($1.str,$1.length,thd->charset(),system_charset_info);
	    $$.str= thd->strmake(ident.ptr(),ident.length());
	    $$.length= ident.length();
	  }
	}
	;

TEXT_STRING_sys:
	TEXT_STRING
	{
	  THD *thd= YYTHD;
	  if (my_charset_same(thd->charset(),system_charset_info))
	  {
	    $$=$1;
	  }
	  else
	  {
	    String ident;
	    ident.copy($1.str,$1.length,thd->charset(),system_charset_info);
	    $$.str= thd->strmake(ident.ptr(),ident.length());
	    $$.length= ident.length();
	  }
	}
	;

4287
TEXT_STRING_literal:
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4288 4289 4290
	TEXT_STRING
	{
	  THD *thd= YYTHD;
4291
	  if (my_charset_same(thd->charset(),thd->variables.collation_connection))
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4292 4293 4294 4295 4296 4297
	  {
	    $$=$1;
	  }
	  else
	  {
	    String ident;
4298
	    ident.copy($1.str,$1.length,thd->charset(),thd->variables.collation_connection);
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4299 4300 4301 4302 4303 4304 4305
	    $$.str= thd->strmake(ident.ptr(),ident.length());
	    $$.length= ident.length();
	  }
	}
	;


bk@work.mysql.com's avatar
bk@work.mysql.com committed
4306
ident:
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4307
	IDENT_sys	    { $$=$1; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4308 4309
	| keyword
	{
4310 4311
	  LEX *lex= Lex;
	  $$.str= lex->thd->strmake($1.str,$1.length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4312
	  $$.length=$1.length;
4313 4314
	  if (lex->next_state != MY_LEX_END)
	    lex->next_state= MY_LEX_OPERATOR_OR_IDENT;
4315 4316
	}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4317 4318

ident_or_text:
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4319 4320 4321
	ident 			{ $$=$1;}
	| TEXT_STRING_sys	{ $$=$1;}
	| LEX_HOSTNAME		{ $$=$1;};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4322 4323 4324 4325

user:
	ident_or_text
	{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4326 4327
	  THD *thd= YYTHD;
	  if (!($$=(LEX_USER*) thd->alloc(sizeof(st_lex_user))))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4328
	    YYABORT;
4329 4330 4331 4332
	  $$->user = $1;
	  $$->host.str= (char *) "%";
	  $$->host.length= 1;
	}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4333 4334
	| ident_or_text '@' ident_or_text
	  {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4335 4336
	    THD *thd= YYTHD;
	    if (!($$=(LEX_USER*) thd->alloc(sizeof(st_lex_user))))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4337 4338
	      YYABORT;
	    $$->user = $1; $$->host=$3;
4339
	  };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4340 4341 4342 4343 4344

/* Keyword that we allow for identifiers */

keyword:
	ACTION			{}
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
4345
	| ADDDATE_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4346
	| AFTER_SYM		{}
4347
	| AGAINST		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4348
	| AGGREGATE_SYM		{}
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
4349
	| ANY_SYM		{}
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4350
	| ASCII_SYM		{}
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
4351
	| AUTO_INC		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4352 4353
	| AVG_ROW_LENGTH	{}
	| AVG_SYM		{}
4354
	| BACKUP_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4355
	| BEGIN_SYM		{}
4356
	| BERKELEY_DB_SYM	{}
4357
	| BINLOG_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4358 4359
	| BIT_SYM		{}
	| BOOL_SYM		{}
4360
	| BOOLEAN_SYM		{}
4361
	| BYTE_SYM		{}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4362
	| CACHE_SYM		{}
4363
	| CHANGED		{}
4364
	| CHARSET		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4365
	| CHECKSUM_SYM		{}
4366
	| CIPHER_SYM		{}
4367
	| CLIENT_SYM		{}
4368
	| CLOSE_SYM		{}
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4369
	| COLLATION_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4370
	| COMMENT_SYM		{}
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
4371
	| COMMITTED_SYM		{}
4372
	| COMMIT_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4373
	| COMPRESSED_SYM	{}
4374
	| CONCURRENT		{}
4375
	| CUBE_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4376 4377 4378 4379 4380
	| DATA_SYM		{}
	| DATETIME		{}
	| DATE_SYM		{}
	| DAY_SYM		{}
	| DELAY_KEY_WRITE_SYM	{}
4381 4382
	| DES_KEY_FILE		{}
	| DIRECTORY_SYM		{}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4383
	| DO_SYM		{}
4384
	| DUAL_SYM		{}
4385 4386
	| DUMPFILE		{}
	| DUPLICATE_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4387 4388 4389 4390
	| DYNAMIC_SYM		{}
	| END			{}
	| ENUM			{}
	| ESCAPE_SYM		{}
4391
	| EVENTS_SYM		{}
4392
	| EXECUTE_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4393
	| EXTENDED_SYM		{}
4394
	| FAST_SYM		{}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4395 4396
	| DISABLE_SYM		{}
	| ENABLE_SYM		{}
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
4397
	| FULL			{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4398 4399 4400 4401
	| FILE_SYM		{}
	| FIRST_SYM		{}
	| FIXED_SYM		{}
	| FLUSH_SYM		{}
4402
	| GEOMETRY_SYM		{}
4403
	| GEOMETRYCOLLECTION	{}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4404
	| GRANTS		{}
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
4405
	| GLOBAL_SYM		{}
4406
	| HANDLER_SYM		{}
4407 4408
	| HEAP_SYM		{}
	| HELP_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4409 4410 4411
	| HOSTS_SYM		{}
	| HOUR_SYM		{}
	| IDENTIFIED_SYM	{}
4412
	| INDEXES		{}
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
4413
	| ISOLATION		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4414
	| ISAM_SYM		{}
4415
	| ISSUER_SYM		{}
4416
	| INNOBASE_SYM		{}
4417
	| INSERT_METHOD		{}
4418
	| RELAY_THREAD		{}
4419
	| LAST_SYM		{}
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
4420
	| LEAVES                {}
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
4421
	| LEVEL_SYM		{}
4422
	| LINESTRING		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4423
	| LOCAL_SYM		{}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4424
	| LOCKS_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4425 4426 4427 4428 4429 4430 4431 4432 4433 4434
	| LOGS_SYM		{}
	| MAX_ROWS		{}
	| MASTER_SYM		{}
	| MASTER_HOST_SYM	{}
	| MASTER_PORT_SYM	{}
	| MASTER_LOG_FILE_SYM	{}
	| MASTER_LOG_POS_SYM	{}
	| MASTER_USER_SYM	{}
	| MASTER_PASSWORD_SYM	{}
	| MASTER_CONNECT_RETRY_SYM	{}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4435 4436 4437
	| MAX_CONNECTIONS_PER_HOUR	 {}
	| MAX_QUERIES_PER_HOUR	{}
	| MAX_UPDATES_PER_HOUR	{}
4438
	| MEDIUM_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4439
	| MERGE_SYM		{}
4440
	| MEMORY_SYM		{}
4441
	| MICROSECOND_SYM	{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4442 4443 4444
	| MINUTE_SYM		{}
	| MIN_ROWS		{}
	| MODIFY_SYM		{}
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
4445
	| MODE_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4446
	| MONTH_SYM		{}
4447 4448 4449
	| MULTILINESTRING	{}
	| MULTIPOINT		{}
	| MULTIPOLYGON		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4450
	| MYISAM_SYM		{}
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4451
	| NAMES_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4452 4453
	| NATIONAL_SYM		{}
	| NCHAR_SYM		{}
4454
	| NEXT_SYM		{}
4455
	| NEW_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4456
	| NO_SYM		{}
4457
	| NONE_SYM		{}
4458
	| OFFSET_SYM		{}
4459
	| OPEN_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4460
	| PACK_KEYS_SYM		{}
4461
	| PARTIAL		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4462
	| PASSWORD		{}
4463
	| POINT_SYM		{}
4464
	| POLYGON		{}
4465
	| PREV_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4466 4467
	| PROCESS		{}
	| PROCESSLIST_SYM	{}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4468
	| QUERY_SYM		{}
4469
	| QUICK			{}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4470
	| RAID_0_SYM		{}
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
4471 4472
	| RAID_CHUNKS		{}
	| RAID_CHUNKSIZE	{}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4473
	| RAID_STRIPED_SYM	{}
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
4474
	| RAID_TYPE		{}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4475 4476
	| RELAY_LOG_FILE_SYM	{}
	| RELAY_LOG_POS_SYM	{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4477 4478
	| RELOAD		{}
	| REPAIR		{}
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
4479
	| REPEATABLE_SYM	{}
4480
	| REPLICATION		{}
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
4481
	| RESET_SYM		{}
4482
	| RESOURCES		{}
4483
	| RESTORE_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4484
	| ROLLBACK_SYM		{}
4485
	| ROLLUP_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4486 4487 4488 4489
	| ROWS_SYM		{}
	| ROW_FORMAT_SYM	{}
	| ROW_SYM		{}
	| SECOND_SYM		{}
4490
	| SERIAL_SYM		{}
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
4491 4492
	| SERIALIZABLE_SYM	{}
	| SESSION_SYM		{}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4493
	| SIGNED_SYM		{}
4494
	| SIMPLE_SYM		{}
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
4495
	| SHARE_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4496
	| SHUTDOWN		{}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4497
	| SLAVE			{}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4498
	| SOUNDS_SYM		{}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4499
	| SQL_CACHE_SYM		{}
4500
	| SQL_BUFFER_RESULT	{}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4501
	| SQL_NO_CACHE_SYM	{}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4502
	| SQL_THREAD		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4503 4504 4505 4506
	| START_SYM		{}
	| STATUS_SYM		{}
	| STOP_SYM		{}
	| STRING_SYM		{}
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
4507
	| SUBDATE_SYM		{}
4508
	| SUBJECT_SYM		{}
4509
	| SUPER_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4510 4511
	| TEMPORARY		{}
	| TEXT_SYM		{}
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
4512
	| TRANSACTION_SYM	{}
4513
	| TRUNCATE_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4514 4515 4516 4517
	| TIMESTAMP		{}
	| TIME_SYM		{}
	| TYPE_SYM		{}
	| UDF_SYM		{}
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
4518
	| UNCOMMITTED_SYM	{}
4519
	| UNICODE_SYM		{}
4520
	| USER			{}
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
4521
	| USE_FRM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4522
	| VARIABLES		{}
4523
	| VALUE_SYM		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4524
	| WORK_SYM		{}
4525
	| X509_SYM		{}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4526 4527
	| YEAR_SYM		{}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4528 4529 4530 4531 4532 4533

/* Option functions */

set:
	SET opt_option
	{
4534 4535
	  LEX *lex=Lex;
	  lex->sql_command= SQLCOM_SET_OPTION;
4536 4537
	  lex->option_type=OPT_DEFAULT;
	  lex->var_list.empty();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4538
	}
4539 4540 4541
	option_value_list
	{}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4542 4543 4544

opt_option:
	/* empty */ {}
4545
	| OPTION {};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4546 4547

option_value_list:
4548 4549 4550 4551 4552 4553 4554 4555 4556 4557 4558 4559
	option_type option_value
	| option_value_list ',' option_type option_value;

option_type:
	/* empty */	{}
	| GLOBAL_SYM	{ Lex->option_type= OPT_GLOBAL; }
	| LOCAL_SYM	{ Lex->option_type= OPT_SESSION; }
	| SESSION_SYM	{ Lex->option_type= OPT_SESSION; }
	;

opt_var_type:
	/* empty */	{ $$=OPT_SESSION; }
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4560
	| GLOBAL_SYM	{ $$=OPT_GLOBAL; }
4561 4562 4563 4564 4565 4566
	| LOCAL_SYM	{ $$=OPT_SESSION; }
	| SESSION_SYM	{ $$=OPT_SESSION; }
	;

opt_var_ident_type:
	/* empty */		{ $$=OPT_DEFAULT; }
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4567
	| GLOBAL_SYM '.'	{ $$=OPT_GLOBAL; }
4568 4569 4570
	| LOCAL_SYM '.'		{ $$=OPT_SESSION; }
	| SESSION_SYM '.'	{ $$=OPT_SESSION; }
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4571 4572

option_value:
4573
	'@' ident_or_text equal expr
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4574
	{
4575
	  Lex->var_list.push_back(new set_var_user(new Item_func_set_user_var($2,$4)));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4576
	}
4577
	| internal_variable_name equal set_expr_or_default
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4578
	  {
4579 4580
	    LEX *lex=Lex;
	    lex->var_list.push_back(new set_var(lex->option_type, $1, $3));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4581
	  }
4582
	| '@' '@' opt_var_ident_type internal_variable_name equal set_expr_or_default
4583 4584 4585 4586 4587 4588 4589 4590
	  {
	    LEX *lex=Lex;
	    lex->var_list.push_back(new set_var((enum_var_type) $3, $4, $6));
	  }
	| TRANSACTION_SYM ISOLATION LEVEL_SYM isolation_types
	  {
	    LEX *lex=Lex;
	    lex->var_list.push_back(new set_var(lex->option_type,
4591
						find_sys_var("tx_isolation"),
4592
						new Item_int((int32) $4)));
4593
	  }
4594
	| charset old_or_new_charset_name_or_default
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4595
	{
4596
	  THD *thd= YYTHD;
4597
	  LEX *lex= Lex;
4598
	  $2= $2 ? $2: global_system_variables.character_set_client;
4599
	  lex->var_list.push_back(new set_var_collation_client($2,thd->variables.character_set_database,$2));
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4600
	}
4601
	| NAMES_SYM charset_name_or_default opt_collate
4602
	{
4603
	  THD *thd= YYTHD;
4604
	  LEX *lex= Lex;
4605
	  $2= $2 ? $2 : global_system_variables.character_set_client;
4606 4607
	  $3= $3 ? $3 : $2;
	  if (!my_charset_same($2,$3))
4608
	  {
4609 4610
	    net_printf(thd,ER_COLLATION_CHARSET_MISMATCH,$3->name,$2->csname);
	    YYABORT;
4611
	  }
4612
	  lex->var_list.push_back(new set_var_collation_client($3,$3,$3));
4613
	}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4614
	| PASSWORD equal text_or_password
4615
	  {
4616
	    THD *thd=YYTHD;
4617
	    LEX_USER *user;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4618
	    if (!(user=(LEX_USER*) thd->alloc(sizeof(LEX_USER))))
4619 4620 4621 4622 4623 4624
	      YYABORT;
	    user->host.str=0;
	    user->user.str=thd->priv_user;
	    thd->lex.var_list.push_back(new set_var_password(user, $3));
	  }
	| PASSWORD FOR_SYM user equal text_or_password
4625
	  {
4626 4627
	    Lex->var_list.push_back(new set_var_password($3,$5));
	  }
4628
	;
4629

4630 4631 4632 4633 4634 4635 4636 4637
internal_variable_name:
	ident
	{
	  sys_var *tmp=find_sys_var($1.str, $1.length);
	  if (!tmp)
	    YYABORT;
	  $$=tmp;
	}
4638 4639 4640 4641 4642 4643 4644 4645 4646 4647 4648 4649 4650 4651 4652 4653 4654 4655 4656 4657 4658
	| ident '.' ident
	  {
	    sys_var *tmp=find_sys_var($3.str, $3.length);
	    if (!tmp)
	      YYABORT;
	    if (!tmp->is_struct())
	      net_printf(YYTHD, ER_VARIABLE_IS_NOT_STRUCT, $3.str);
	    tmp->base_name= $1;
	    $$=tmp;
	  }
	| DEFAULT '.' ident
	  {
	    sys_var *tmp=find_sys_var($3.str, $3.length);
	    if (!tmp)
	      YYABORT;
	    if (!tmp->is_struct())
	      net_printf(YYTHD, ER_VARIABLE_IS_NOT_STRUCT, $3.str);
	    tmp->base_name.str= (char*) "default";
	    tmp->base_name.length= 7;
	    $$=tmp;
	  }
4659
        ;
4660 4661 4662 4663 4664 4665 4666

isolation_types:
	READ_SYM UNCOMMITTED_SYM	{ $$= ISO_READ_UNCOMMITTED; }
	| READ_SYM COMMITTED_SYM	{ $$= ISO_READ_COMMITTED; }
	| REPEATABLE_SYM READ_SYM	{ $$= ISO_REPEATABLE_READ; }
	| SERIALIZABLE_SYM		{ $$= ISO_SERIALIZABLE; }
	;
4667

bk@work.mysql.com's avatar
bk@work.mysql.com committed
4668 4669 4670 4671 4672 4673 4674 4675
text_or_password:
	TEXT_STRING { $$=$1.str;}
	| PASSWORD '(' TEXT_STRING ')'
	  {
	    if (!$3.length)
	      $$=$3.str;
	    else
	    {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4676
	      char *buff=(char*) YYTHD->alloc(HASH_PASSWORD_LENGTH+1);
4677 4678
	      make_scrambled_password(buff,$3.str,use_old_passwords,
				      &YYTHD->rand);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4679 4680
	      $$=buff;
	    }
4681 4682
	  }
          ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4683

monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
4684

4685
set_expr_or_default:
4686 4687
	expr      { $$=$1; }
	| DEFAULT { $$=0; }
4688 4689
	| ON	  { $$=new Item_string("ON",  2, system_charset_info); }
	| ALL	  { $$=new Item_string("ALL", 3, system_charset_info); }
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4690
	| BINARY  { $$=new Item_string("binary", 6, system_charset_info); }
4691
	;
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
4692 4693


bk@work.mysql.com's avatar
bk@work.mysql.com committed
4694 4695 4696 4697 4698 4699 4700
/* Lock function */

lock:
	LOCK_SYM table_or_tables
	{
	  Lex->sql_command=SQLCOM_LOCK_TABLES;
	}
4701 4702 4703
	table_lock_list
	{}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4704 4705 4706

table_or_tables:
	TABLE_SYM
4707
	| TABLES;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4708 4709 4710

table_lock_list:
	table_lock
4711
	| table_lock_list ',' table_lock;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4712 4713 4714

table_lock:
	table_ident opt_table_alias lock_option
4715
	{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4716
	  if (!Select->add_table_to_list(YYTHD, $1, $2, 0, (thr_lock_type) $3))
4717 4718
	   YYABORT;
	}
4719
        ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4720 4721 4722

lock_option:
	READ_SYM	{ $$=TL_READ_NO_INSERT; }
4723
	| WRITE_SYM     { $$=YYTHD->update_lock_default; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4724
	| LOW_PRIORITY WRITE_SYM { $$=TL_WRITE_LOW_PRIORITY; }
4725 4726
	| READ_SYM LOCAL_SYM { $$= TL_READ; }
        ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4727 4728

unlock:
4729 4730
	UNLOCK_SYM table_or_tables { Lex->sql_command=SQLCOM_UNLOCK_TABLES; }
        ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4731 4732


4733
/*
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
4734
** Handler: direct access to ISAM functions
4735 4736 4737 4738 4739
*/

handler:
	HANDLER_SYM table_ident OPEN_SYM opt_table_alias
	{
4740 4741
	  LEX *lex= Lex;
	  lex->sql_command = SQLCOM_HA_OPEN;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4742
	  if (!lex->current_select->add_table_to_list(lex->thd, $2, $4, 0))
4743 4744 4745 4746
	    YYABORT;
	}
	| HANDLER_SYM table_ident CLOSE_SYM
	{
4747 4748
	  LEX *lex= Lex;
	  lex->sql_command = SQLCOM_HA_CLOSE;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4749
	  if (!lex->current_select->add_table_to_list(lex->thd, $2, 0, 0))
4750 4751
	    YYABORT;
	}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4752
	| HANDLER_SYM table_ident READ_SYM
4753
	{
monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi committed
4754 4755 4756
	  LEX *lex=Lex;
	  lex->sql_command = SQLCOM_HA_READ;
	  lex->ha_rkey_mode= HA_READ_KEY_EXACT;	/* Avoid purify warnings */
4757 4758
	  lex->current_select->select_limit= 1;
	  lex->current_select->offset_limit= 0L;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4759
	  if (!lex->current_select->add_table_to_list(lex->thd, $2, 0, 0))
4760
	    YYABORT;
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
4761
        }
4762
        handler_read_or_scan where_clause opt_limit_clause {}
4763
        ;
4764

serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
4765 4766
handler_read_or_scan:
	handler_scan_function         { Lex->backup_dir= 0; }
4767 4768
        | ident handler_rkey_function { Lex->backup_dir= $1.str; }
        ;
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
4769 4770 4771

handler_scan_function:
	FIRST_SYM  { Lex->ha_read_mode = RFIRST; }
4772 4773
	| NEXT_SYM { Lex->ha_read_mode = RNEXT;  }
        ;
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
4774 4775 4776 4777 4778 4779

handler_rkey_function:
	FIRST_SYM  { Lex->ha_read_mode = RFIRST; }
	| NEXT_SYM { Lex->ha_read_mode = RNEXT;  }
	| PREV_SYM { Lex->ha_read_mode = RPREV;  }
	| LAST_SYM { Lex->ha_read_mode = RLAST;  }
4780 4781
	| handler_rkey_mode
	{
4782 4783
	  LEX *lex=Lex;
	  lex->ha_read_mode = RKEY;
monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi committed
4784
	  lex->ha_rkey_mode=$1;
4785
	  if (!(lex->insert_list = new List_item))
4786
	    YYABORT;
4787 4788
	} '(' values ')' { }
        ;
4789 4790

handler_rkey_mode:
monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi committed
4791 4792 4793 4794
	  EQ     { $$=HA_READ_KEY_EXACT;   }
	| GE     { $$=HA_READ_KEY_OR_NEXT; }
	| LE     { $$=HA_READ_KEY_OR_PREV; }
	| GT_SYM { $$=HA_READ_AFTER_KEY;   }
4795 4796
	| LT     { $$=HA_READ_BEFORE_KEY;  }
        ;
4797

bk@work.mysql.com's avatar
bk@work.mysql.com committed
4798 4799 4800 4801 4802
/* GRANT / REVOKE */

revoke:
	REVOKE
	{
4803 4804 4805 4806 4807
	  LEX *lex=Lex;
	  lex->sql_command = SQLCOM_REVOKE;
	  lex->users_list.empty();
	  lex->columns.empty();
	  lex->grant= lex->grant_tot_col=0;
4808
	  lex->select_lex.db=0;
4809 4810
	  lex->ssl_type= SSL_TYPE_NOT_SPECIFIED;
	  lex->ssl_cipher= lex->x509_subject= lex->x509_issuer= 0;
4811
	  bzero((char*) &lex->mqh, sizeof(lex->mqh));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4812
	}
4813 4814 4815 4816 4817
	revoke_command
	{}
        ;

revoke_command:
4818 4819
	grant_privileges ON opt_table FROM user_list
	{}
4820 4821 4822 4823 4824
	|
	ALL PRIVILEGES ',' GRANT FROM user_list
	{
	  Lex->sql_command = SQLCOM_REVOKE_ALL;
	}
4825
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4826 4827 4828 4829

grant:
	GRANT
	{
4830 4831 4832
	  LEX *lex=Lex;
	  lex->users_list.empty();
	  lex->columns.empty();
4833 4834
	  lex->sql_command = SQLCOM_GRANT;
	  lex->grant= lex->grant_tot_col= 0;
4835
	  lex->select_lex.db= 0;
4836 4837
	  lex->ssl_type= SSL_TYPE_NOT_SPECIFIED;
	  lex->ssl_cipher= lex->x509_subject= lex->x509_issuer= 0;
4838
	  bzero(&(lex->mqh),sizeof(lex->mqh));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4839 4840
	}
	grant_privileges ON opt_table TO_SYM user_list
4841 4842 4843
	require_clause grant_options
	{}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4844 4845 4846

grant_privileges:
	grant_privilege_list {}
4847
	| ALL PRIVILEGES	{ Lex->grant = GLOBAL_ACLS;}
4848 4849
	| ALL			{ Lex->grant = GLOBAL_ACLS;}
        ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4850 4851 4852

grant_privilege_list:
	grant_privilege
4853
	| grant_privilege_list ',' grant_privilege;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4854 4855

grant_privilege:
4856 4857 4858 4859
	SELECT_SYM 	{ Lex->which_columns = SELECT_ACL;} opt_column_list {}
	| INSERT	{ Lex->which_columns = INSERT_ACL;} opt_column_list {}
	| UPDATE_SYM	{ Lex->which_columns = UPDATE_ACL; } opt_column_list {}
	| REFERENCES	{ Lex->which_columns = REFERENCES_ACL;} opt_column_list {}
4860 4861
	| DELETE_SYM	{ Lex->grant |= DELETE_ACL;}
	| USAGE		{}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4862 4863 4864 4865
	| INDEX		{ Lex->grant |= INDEX_ACL;}
	| ALTER		{ Lex->grant |= ALTER_ACL;}
	| CREATE	{ Lex->grant |= CREATE_ACL;}
	| DROP		{ Lex->grant |= DROP_ACL;}
4866
	| EXECUTE_SYM	{ Lex->grant |= EXECUTE_ACL;}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4867 4868 4869 4870
	| RELOAD	{ Lex->grant |= RELOAD_ACL;}
	| SHUTDOWN	{ Lex->grant |= SHUTDOWN_ACL;}
	| PROCESS	{ Lex->grant |= PROCESS_ACL;}
	| FILE_SYM	{ Lex->grant |= FILE_ACL;}
4871 4872 4873 4874 4875 4876 4877 4878
	| GRANT OPTION  { Lex->grant |= GRANT_ACL;}
	| SHOW DATABASES { Lex->grant |= SHOW_DB_ACL;}
	| SUPER_SYM	{ Lex->grant |= SUPER_ACL;}
	| CREATE TEMPORARY TABLES { Lex->grant |= CREATE_TMP_ACL;}
	| LOCK_SYM TABLES   { Lex->grant |= LOCK_TABLES_ACL; }
	| REPLICATION SLAVE  { Lex->grant |= REPL_SLAVE_ACL;}
	| REPLICATION CLIENT_SYM { Lex->grant |= REPL_CLIENT_ACL;}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4879

4880

4881 4882 4883 4884 4885 4886 4887 4888 4889 4890 4891 4892
opt_and:
	/* empty */	{}
	| AND		{}
	;

require_list:
	 require_list_element opt_and require_list
	 | require_list_element
	 ;

require_list_element:
	SUBJECT_SYM TEXT_STRING
4893 4894 4895 4896
	{
	  LEX *lex=Lex;
	  if (lex->x509_subject)
	  {
4897
	    net_printf(lex->thd,ER_DUP_ARGUMENT, "SUBJECT");
4898 4899 4900 4901 4902 4903 4904 4905 4906
	    YYABORT;
	  }
	  lex->x509_subject=$2.str;
	}
	| ISSUER_SYM TEXT_STRING
	{
	  LEX *lex=Lex;
	  if (lex->x509_issuer)
	  {
4907
	    net_printf(lex->thd,ER_DUP_ARGUMENT, "ISSUER");
4908 4909 4910 4911 4912 4913 4914 4915 4916
	    YYABORT;
	  }
	  lex->x509_issuer=$2.str;
	}
	| CIPHER_SYM TEXT_STRING
	{
	  LEX *lex=Lex;
	  if (lex->ssl_cipher)
	  {
4917
	    net_printf(lex->thd,ER_DUP_ARGUMENT, "CIPHER");
4918 4919 4920 4921 4922
	    YYABORT;
	  }
	  lex->ssl_cipher=$2.str;
	}
	;
4923

bk@work.mysql.com's avatar
bk@work.mysql.com committed
4924 4925 4926
opt_table:
	'*'
	  {
4927
	    LEX *lex= Lex;
4928
	    lex->current_select->select_lex()->db= lex->thd->db;
4929
	    if (lex->grant == GLOBAL_ACLS)
4930 4931
	      lex->grant = DB_ACLS & ~GRANT_ACL;
	    else if (lex->columns.elements)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4932
	    {
4933
	      send_error(lex->thd,ER_ILLEGAL_GRANT_FOR_TABLE);
4934
	      YYABORT;
4935
	    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4936 4937 4938
	  }
	| ident '.' '*'
	  {
4939
	    LEX *lex= Lex;
4940
	    lex->current_select->select_lex()->db = $1.str;
4941
	    if (lex->grant == GLOBAL_ACLS)
4942 4943
	      lex->grant = DB_ACLS & ~GRANT_ACL;
	    else if (lex->columns.elements)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4944
	    {
4945
	      send_error(lex->thd,ER_ILLEGAL_GRANT_FOR_TABLE);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4946 4947 4948 4949 4950
	      YYABORT;
	    }
	  }
	| '*' '.' '*'
	  {
4951
	    LEX *lex= Lex;
4952
	    lex->current_select->select_lex()->db = NULL;
4953 4954
	    if (lex->grant == GLOBAL_ACLS)
	      lex->grant= GLOBAL_ACLS & ~GRANT_ACL;
4955
	    else if (lex->columns.elements)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4956
	    {
4957
	      send_error(lex->thd,ER_ILLEGAL_GRANT_FOR_TABLE);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4958 4959 4960 4961 4962
	      YYABORT;
	    }
	  }
	| table_ident
	  {
4963
	    LEX *lex=Lex;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4964
	    if (!lex->current_select->add_table_to_list(lex->thd, $1,NULL,0))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4965
	      YYABORT;
4966
	    if (lex->grant == GLOBAL_ACLS)
4967
	      lex->grant =  TABLE_ACLS & ~GRANT_ACL;
4968 4969
	  }
          ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4970 4971 4972


user_list:
4973 4974 4975 4976 4977 4978 4979
	grant_user  { if (Lex->users_list.push_back($1)) YYABORT;}
	| user_list ',' grant_user
	  {
	    if (Lex->users_list.push_back($3))
	      YYABORT;
	  }
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4980 4981 4982 4983 4984 4985 4986 4987


grant_user:
	user IDENTIFIED_SYM BY TEXT_STRING
	{
	   $$=$1; $1->password=$4;
	   if ($4.length)
	   {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4988
	     char *buff=(char*) YYTHD->alloc(HASH_PASSWORD_LENGTH+1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4989 4990
	     if (buff)
	     {
4991 4992
	       make_scrambled_password(buff,$4.str,use_old_passwords,
				       &YYTHD->rand);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4993 4994 4995 4996 4997 4998 4999 5000
	       $1->password.str=buff;
	       $1->password.length=HASH_PASSWORD_LENGTH;
	     }
	  }
	}
	| user IDENTIFIED_SYM BY PASSWORD TEXT_STRING
	  { $$=$1; $1->password=$5 ; }
	| user
5001 5002
	  { $$=$1; $1->password.str=NullS; }
        ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5003 5004 5005


opt_column_list:
5006 5007 5008 5009 5010
	/* empty */
	{
	  LEX *lex=Lex;
	  lex->grant |= lex->which_columns;
	}
5011
	| '(' column_list ')';
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5012 5013 5014

column_list:
	column_list ',' column_list_id
5015
	| column_list_id;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5016 5017 5018 5019

column_list_id:
	ident
	{
5020
	  String *new_str = new String((const char*) $1.str,$1.length,system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5021 5022
	  List_iterator <LEX_COLUMN> iter(Lex->columns);
	  class LEX_COLUMN *point;
5023
	  LEX *lex=Lex;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5024 5025
	  while ((point=iter++))
	  {
5026 5027
	    if (!my_strcasecmp(system_charset_info,
                               point->column.ptr(), new_str->ptr()))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5028 5029
		break;
	  }
5030
	  lex->grant_tot_col|= lex->which_columns;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5031
	  if (point)
5032
	    point->rights |= lex->which_columns;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5033
	  else
5034
	    lex->columns.push_back(new LEX_COLUMN (*new_str,lex->which_columns));
5035 5036
	}
        ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5037

tonu@x153.internalnet's avatar
tonu@x153.internalnet committed
5038 5039

require_clause: /* empty */
5040
        | REQUIRE_SYM require_list
5041 5042 5043
          {
            Lex->ssl_type=SSL_TYPE_SPECIFIED;
          }
5044
        | REQUIRE_SYM SSL_SYM
5045 5046 5047
          {
            Lex->ssl_type=SSL_TYPE_ANY;
          }
5048
        | REQUIRE_SYM X509_SYM
5049 5050 5051 5052 5053 5054 5055
          {
            Lex->ssl_type=SSL_TYPE_X509;
          }
	| REQUIRE_SYM NONE_SYM
	  {
	    Lex->ssl_type=SSL_TYPE_NONE;
	  }
5056
          ;
tonu@x153.internalnet's avatar
tonu@x153.internalnet committed
5057

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
5058
grant_options:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5059
	/* empty */ {}
5060
	| WITH grant_option_list;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5061

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
5062 5063
grant_option_list:
	grant_option_list grant_option {}
5064 5065
	| grant_option {}
        ;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
5066 5067 5068

grant_option:
	GRANT OPTION { Lex->grant |= GRANT_ACL;}
5069
        | MAX_QUERIES_PER_HOUR ULONG_NUM
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
5070
        {
5071
	  Lex->mqh.questions=$2;
5072
	  Lex->mqh.bits |= 1;
5073
	}
5074
        | MAX_UPDATES_PER_HOUR ULONG_NUM
5075
        {
5076
	  Lex->mqh.updates=$2;
5077
	  Lex->mqh.bits |= 2;
5078
	}
5079
        | MAX_CONNECTIONS_PER_HOUR ULONG_NUM
5080
        {
5081
	  Lex->mqh.connections=$2;
5082
	  Lex->mqh.bits |= 4;
5083 5084
	}
        ;
5085

bk@work.mysql.com's avatar
bk@work.mysql.com committed
5086
begin:
5087 5088
	BEGIN_SYM   { Lex->sql_command = SQLCOM_BEGIN;} opt_work {}
	;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5089 5090 5091

opt_work:
	/* empty */ {}
5092 5093
	| WORK_SYM {;}
        ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5094 5095

commit:
5096
	COMMIT_SYM   { Lex->sql_command = SQLCOM_COMMIT;};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5097 5098

rollback:
5099
	ROLLBACK_SYM { Lex->sql_command = SQLCOM_ROLLBACK;};
5100 5101 5102


/*
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5103
   UNIONS : glue selects together
5104 5105 5106
*/


5107
union_clause:
5108
	/* empty */ {}
5109 5110
	| union_list
	;
5111 5112

union_list:
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5113
	UNION_SYM    union_option
5114 5115 5116 5117 5118
	{
	  LEX *lex=Lex;
	  if (lex->exchange)
	  {
	    /* Only the last SELECT can have  INTO...... */
5119
	    net_printf(lex->thd, ER_WRONG_USAGE, "UNION", "INTO");
5120
	    YYABORT;
5121
	  }
5122
	  if (lex->current_select->linkage == GLOBAL_OPTIONS_TYPE)
5123
	  {
5124
	    send_error(lex->thd, ER_SYNTAX_ERROR);
5125 5126
	    YYABORT;
	  }
5127
	  if (mysql_new_select(lex, 0))
5128
	    YYABORT;
5129
          mysql_init_select(lex);
5130
	  lex->current_select->linkage=UNION_TYPE;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5131
	}
5132
	select_init {}
5133
	;
5134 5135

union_opt:
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
5136
	union_list {}
5137 5138
	| optional_order_or_limit {}
	;
5139 5140

optional_order_or_limit:
5141
      	/* Empty */ {}
5142 5143
	|
	  {
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
5144 5145
	    THD *thd= YYTHD;
	    LEX *lex= &thd->lex;
5146
	    DBUG_ASSERT(lex->current_select->linkage != GLOBAL_OPTIONS_TYPE);
5147
	    SELECT_LEX *sel= lex->current_select->select_lex();
5148 5149 5150 5151
	    SELECT_LEX_UNIT *unit= sel->master_unit();
	    unit->global_parameters= unit;
	    unit->no_table_names_allowed= 1;
	    lex->current_select= unit;
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
5152
	    thd->where= "global ORDER clause";
5153
	  }
5154
	order_or_limit
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
5155 5156 5157 5158 5159
          {
	    THD *thd= YYTHD;
	    thd->lex.current_select->no_table_names_allowed= 0;
	    thd->where= "";
          }
5160 5161 5162
	;

order_or_limit:
5163 5164
	order_clause opt_limit_clause_init
	| limit_clause
5165
	;
5166 5167

union_option:
5168
	/* empty */ {}
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
5169
	| ALL {Select->master_unit()->union_option= 1;};
5170

5171 5172
singlerow_subselect:
	subselect_start singlerow_subselect_init
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5173 5174 5175 5176
	subselect_end
	{
	  $$= $2;
	};
5177

5178
singlerow_subselect_init:
5179
	select_init2
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5180
	{
5181
	  $$= new Item_singlerow_subselect(YYTHD,
5182 5183
					   Lex->current_select->master_unit()->
                                             first_select());
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5184
	};
5185 5186

exists_subselect:
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5187 5188 5189 5190 5191
	subselect_start exists_subselect_init
	subselect_end
	{
	  $$= $2;
	};
5192 5193

exists_subselect_init:
5194
	select_init2
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5195
	{
5196
	  $$= new Item_exists_subselect(YYTHD,
5197 5198
					Lex->current_select->master_unit()->
					  first_select());
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5199
	};
5200

bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
5201 5202 5203 5204 5205 5206 5207 5208
in_subselect:
  subselect_start in_subselect_init
  subselect_end
  {
    $$= $2;
  };

in_subselect_init:
5209
  select_init2
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
5210
  {
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
5211
    $$= Lex->current_select->master_unit()->first_select();
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
5212 5213
  };

5214
subselect_start:
5215
	'(' SELECT_SYM
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5216
	{
5217
	  LEX *lex=Lex;
5218
	  if (((int)lex->sql_command >= (int)SQLCOM_HA_OPEN &&
5219 5220 5221 5222
	       lex->sql_command <= (int)SQLCOM_HA_READ) || lex->sql_command == (int)SQLCOM_KILL)	  {	
	    send_error(lex->thd, ER_SYNTAX_ERROR);
	    YYABORT;
	  }
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5223 5224 5225
	  if (mysql_new_select(Lex, 1))
	    YYABORT;
	};
5226 5227

subselect_end:
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5228 5229 5230
	')'
	{
	  LEX *lex=Lex;
5231
	  lex->current_select = lex->current_select->return_after_parsing();
Sinisa@sinisa.nasamreza.org's avatar
Sinisa@sinisa.nasamreza.org committed
5232
	};