diff options
| author | unknown <bar@bar.mysql.r18.ru> | 2003-09-15 10:26:48 +0500 |
|---|---|---|
| committer | unknown <bar@bar.mysql.r18.ru> | 2003-09-15 10:26:48 +0500 |
| commit | bf6480ba7c726a48eab443559f14a8014c9e6ec9 (patch) | |
| tree | 4862f70d6bf1d4769bb70053bf3b37f382776f99 /mysql-test/t/overflow.test | |
| parent | 5d1b299f74e64077cba133c506371556b6fecfe5 (diff) | |
| download | mariadb-git-bf6480ba7c726a48eab443559f14a8014c9e6ec9.tar.gz | |
New syntax:
CREATE TABLE t1(a NVARCHAR(10))
This is for compatibility with MSSQL, DB2, Informix and some other DBMSs.
Note, standard SQL doesn't have "NVARCHAR" syntax.
There are only these syntaxes in SQL2003:
NATIONAL VARCHAR
NCHAR VARCHAR
NATIONAL CHARACTER VARYING
NCHAR VARYING
- Tests were added for all the above syntaxes.
sql/lex.h:
New syntax:
CREATE TABLE t1(a NVARCHAR(10))
This is for compatibility with MSSQL, DB2, Informix and some other DBMSs.
Note, standard SQL doesn't have "NVARCHAR" syntax.
There are only these syntaxes in SQL2003:
NATIONAL VARCHAR
NCHAR VARCHAR
NATIONAL CHARACTER VARYING
NCHAR VARYING
sql/sql_yacc.yy:
New syntax:
CREATE TABLE t1(a NVARCHAR(10))
This is for compatibility with MSSQL, DB2, Informix and some other DBMSs.
Note, standard SQL doesn't have "NVARCHAR" syntax.
There are only these syntaxes in SQL2003:
NATIONAL VARCHAR
NCHAR VARCHAR
NATIONAL CHARACTER VARYING
NCHAR VARYING
Diffstat (limited to 'mysql-test/t/overflow.test')
0 files changed, 0 insertions, 0 deletions