Skip to content

Instantly share code, notes, and snippets.

@yoku0825
Created January 28, 2014 04:59
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yoku0825/8662501 to your computer and use it in GitHub Desktop.
Save yoku0825/8662501 to your computer and use it in GitHub Desktop.
mysql> SELECT * FROM t1;
+-----+------+
| num | val |
+-----+------+
| 1 | one |
| 2 | two |
| 3 | tree |
+-----+------+
3 rows in set (0.00 sec)
mysql> SELECT * FROM t2;
+-----+------+
| num | val |
+-----+------+
| 1 | eins |
| 2 | zwei |
| 3 | drei |
| 4 | vier |
+-----+------+
4 rows in set (0.00 sec)
mysql>
mysql> SELECT * FROM t1 RIGHT JOIN t2 USING(num);
+-----+------+------+
| num | val | val |
+-----+------+------+
| 1 | eins | one |
| 2 | zwei | two |
| 3 | drei | tree |
| 4 | vier | ( ゚ д ゚ ) |
+-----+------+------+
4 rows in set (0.00 sec)
*** client/mysql.cc.orig 2014-01-15 18:25:45.547811486 +0900
--- client/mysql.cc 2014-01-28 13:49:26.228813696 +0900
***************
*** 3752,3759 ****
if (cur[off] == NULL)
{
! buffer= "NULL";
! data_length= 4;
}
else
{
--- 3752,3759 ----
if (cur[off] == NULL)
{
! buffer= "( ゚ д ゚ )";
! data_length= 14;
}
else
{
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment