× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
deepti reported 2013-11-28T13:37:09Z  · tariqrahiman last modified 2017-05-13T17:49:05Z

Duplicate columns when we create tables with same name in two different database in MySQL


Dev pranav.jadhao(*)
QA
Ivan Gron
ivangron
Priority Major
Complexity Unknown
Component DB - MySQL
Version 19.0
Database Version-MySQL 5.6
Aqua Data Studio 15.0.0-dev-37 Build #: 34859 
Operating Environment Windows 8(6.2,amd64)/Cp1252/1.7.0-21-b11
 
Steps to reproduce:
1)Connect to MySQL
2)Create database with name "newdatabase"
3)Now create one more database with name "NEWDATABASE"
4)Expand database "newdatabase" right click on tables and select create table
5)Give table name "sample" and create column "col1" with varchar datatype
6)Now expand "NEWDATABASE" right click on tables and select create table
7)Give table name "sample" and create column "col1" with varchar datatype
 
When we alter or see the properties of table "sample" from "newdatabase" or "NEWDATABASE" it shows column "col1" twice
When we generate create script it shows "col1" twice
when we check in tree node there is only one column "col1"
When describe table it shows only one column "col1"
 
3 attachments

Issue #10920

Closed
Won't Fix
Resolved 2017-05-04T13:53:12Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017