× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Shavibala Rajhans
Shavi57 reported 2013-12-17T08:41:18Z  · tariqrahiman last modified 2017-07-05T19:06:11Z

In MySQL for Datatype Binary with size (200) and DEFAULT value as 'null' wrong Create script is generated


Dev pranav.jadhao(*)
QA
Ivan Gron
ivangron
Priority Major
Complexity Unknown
Component DB - MySQL
Version 19.0
Aqua Data Studio 15.0.0-dev-51
Database Version: MySQL 5.7
 
1.Create Database
 
CREATE DATABASE `BI`
DEFAULT CHARACTER SET latin1
DEFAULT COLLATE latin1_swedish_ci
GO
 
 
2.Create Table
 
CREATE TABLE `BI`.`test` ( 
c1 binary(200) NULL DEFAULT 'null',
c2 varchar(25) NULL DEFAULT 'null' 
)
GO
 
3. Steps to reproduce the bug are as below:
 
Go to Schema Browser
Expand MySQL Server node
Expand Databases node
Expand BI database
Expand Tables node
Select test Table
Right click on it
Select Script Object to New Window as
Click on Create option
 
The wrong script is generated  (See attched screenshot:mysql_binaryScript). 
 
CREATE TABLE `BI`.`test` ( 
c1 binary(200) NULL DEFAULT 'null   [big space here is generated while scripting]    ',
c2 varchar(25) NULL DEFAULT 'null' 
)
GO
 
Due to the unwanted space when We copy that SQL and try to paste it in Text editors. The below half script is copied and pasted.
 
CREATE TABLE `BI`.`test` ( 
c1 binary(200) NULL DEFAULT 'null
2 attachments
  •  
  •  
  • No shares
  •  
All Comments (6) Change History
Sort 

Issue #11079
Closed
Fixed
Resolved 2017-05-04T13:53:47Z
 
 
Completion
No due date
Fixed Build dev-30
No time estimate

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