Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: 1.1.0
-
Fix Version/s: 1.1.0
-
Component/s: schemarouter
-
Labels:None
-
Environment:CentOS 6
Description
A literal "USE" statement sent from a client gives unexpected results when sent through schemarouter.
use DBI;
|
use Data::Dumper;
|
|
|
my $dbh = DBI->connect("DBI:mysql:host=127.0.0.1;port=$ARGV[0]", "kolbe", "kolbe");
|
|
|
foreach $i (1, 2) {
|
$dbh->do("USE shard$i");
|
print Dumper($dbh->selectrow_array("select database()"));
|
}
|
Connecting directly to the backend instances gives the expected results. shard1 only exists on the backend on port 3307. shard2 only exists on the backend on port 3308.
[skysql@max1 ~]$ perl mysqltest.pl 3307
|
$VAR1 = 'shard1';
|
DBD::mysql::db do failed: Unknown database 'shard2' at mysqltest.pl line 7.
|
$VAR1 = 'shard1';
|
[skysql@max1 ~]$ perl mysqltest.pl 3308
|
DBD::mysql::db do failed: Unknown database 'shard1' at mysqltest.pl line 7.
|
$VAR1 = undef;
|
$VAR1 = 'shard2';
|
But going through schemarouter gives unexpected and unpredictable behavior:
[skysql@max1 ~]$ perl mysqltest.pl 3310
|
$VAR1 = undef;
|
DBD::mysql::db do failed: Unknown database 'shard2' at mysqltest.pl line 7.
|
$VAR1 = 'shard2';
|
[skysql@max1 ~]$ perl mysqltest.pl 3310
|
$VAR1 = undef;
|
DBD::mysql::db do failed: Unknown database 'shard2' at mysqltest.pl line 7.
|
$VAR1 = 'shard2';
|
[skysql@max1 ~]$ perl mysqltest.pl 3310
|
DBD::mysql::db do failed: Unknown database 'shard1' at mysqltest.pl line 7.
|
$VAR1 = undef;
|
$VAR1 = 'shard2';
|
[skysql@max1 ~]$ perl mysqltest.pl 3310
|
DBD::mysql::db do failed: Unknown database 'shard1' at mysqltest.pl line 7.
|
$VAR1 = undef;
|
$VAR1 = 'shard2';
|
[skysql@max1 ~]$ perl mysqltest.pl 3310
|
DBD::mysql::db do failed: Unknown database 'shard1' at mysqltest.pl line 7.
|
$VAR1 = undef;
|
DBD::mysql::db do failed: Unknown database 'shard2' at mysqltest.pl line 7.
|
$VAR1 = 'shard2';
|