diff options
| author | timour@mysql.com <> | 2005-08-23 18:08:04 +0300 |
|---|---|---|
| committer | timour@mysql.com <> | 2005-08-23 18:08:04 +0300 |
| commit | e0403003933fcc5fdecac5d6f8c1bce995d4ca54 (patch) | |
| tree | 4cde988a40d008a8de1756cb6ac8fa97ea3fe6e3 /tests | |
| parent | a53d283481af8e9969ae610671a34984056280d5 (diff) | |
| download | mariadb-git-e0403003933fcc5fdecac5d6f8c1bce995d4ca54.tar.gz | |
WL#2486 - natural and using join according to SQL:2003
* Provide backwards compatibility extension to name resolution of
coalesced columns. The patch allows such columns to be qualified
with a table (and db) name, as it is in 4.1.
Based on a patch from Monty.
* Adjusted tests accordingly to test both backwards compatible name
resolution of qualified columns, and ANSI-style resolution of
non-qualified columns.
For this, each affected test has two versions - one with qualified
columns, and one without.
Diffstat (limited to 'tests')
| -rw-r--r-- | tests/mysql_client_test.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/tests/mysql_client_test.c b/tests/mysql_client_test.c index 5558028bb06..75b41ebe4d1 100644 --- a/tests/mysql_client_test.c +++ b/tests/mysql_client_test.c @@ -11801,8 +11801,8 @@ static void test_bug6046() stmt= mysql_stmt_init(mysql); - stmt_text= "SELECT a FROM t1 NATURAL JOIN t1 as X1 " - "WHERE b > ? ORDER BY a"; + stmt_text= "SELECT t1.a FROM t1 NATURAL JOIN t1 as X1 " + "WHERE t1.b > ? ORDER BY t1.a"; rc= mysql_stmt_prepare(stmt, stmt_text, strlen(stmt_text)); check_execute(stmt, rc); |