date:20110422

Devart news

2011-04-22 Thread Sergey Lazurenko


Hello! Could you place our news story on your site. W'll be grateful.

Best Regards,
Sergey Lazurenko


April 19, 2011

Version Five of MySQL Administration Tool from Devart Looks and Feels 
Different!





dbForge Studio for MySQL introduces the new standard of quality for MySQL 
development and administration tools.






Devart is glad to announce the release of new completely redesigned version 
of dbForge Studio for MySQL, v 5.0 - powerful and comprehensive MySQL GUI 
tool that provides a complete set of instruments for server management and 
administration. In this version Devart made a lot of improvements and added 
a whole pack of new features in almost all dbForge Studio's tools. And the 
most remarkable thing about this release is that nearly all novelties were 
suggested by users of this MySQL administration tool.


With the help of users Devart could work on the product on the new level, 
and as a result of such successful tight cooperation its standard of quality 
grew. This new standard includes taking into account actual needs of people 
using product and implementing their exact requirements except studying the 
market in general and implementing features that are theoretically demanded.


When you open the application to get acquainted with the new version, you 
will be surely stunned and pleasantly surprised by its new look. When you 
start using it, hopefully, you will be thrilled by the inner improvements 
and make the best use of them:


 a.. Dependencies List

 First of all, test the usability of Dependencies List - a unique feature 
that will allow you to see the object's references and dependants. No more 
need to spend precious minutes on looking all this up!


 b.. Full support for MySQL server 5.5

 c.. Master-Detail Browser

 You are welcome to explore and analyze master-detail data in a browser 
with rich settings, and save your data and diagrams for future use.


 d.. Enhanced Data Editor

 Foreign key lookup editor was added. Resources of client machines will be 
spared with server-side sorting and filtering. Data Editor now informs about 
its state. Capabilities to edit tables in join statements, to number 
records, copy data with header, and build graphical representation of data 
with a wizard are now available.


 e.. Improved Security Manager

 Maintaining server security is one of the most responsible tasks. We did 
our best to make it easier by redesigning Security Manager. Now you can edit 
several users at once, group them by hosts, and grant definite sets of 
privileges with the help of virtual roles.


 f.. Data Export and Import improvements

 Export data from several tables at once and save your time by exporting 
and importing data through the command line.


 g.. Object Viewer - a simple way to view object's details

 Object Viewer (formerly known as Summary Window) was totally redesigned to 
provide an easier way for analyzing objects and their structure.


 h.. Appearance improvements

 Brand new start page for quick access to the most frequently used features 
and new skins for a better look.


 i.. Other improvements

   a.. Ability to view internal SQL queries that are sent to the server 
with parameter's values added


   b.. Few UI improvements in Database Explorer were made

   c.. Options to ignore clauses during the comparison of events added to 
the Schema Comparison wizard


   d.. Highlighting of differences on comparing SQL profiling results added

   e.. More informative progress during Schema and Data comparison





Price and Availability

Consumers can give the updated dbForge Studio for MySQL a test drive by 
downloading the free Express edition or the 30-day trial Professional 
edition at the product download page. dbForge Studio license price starts at 
$49.95.


For more information about dbForge Studio for MySQL, visit the product's web 
site - www.devart.com/dbforge/mysql/studio/






About Devart

Devart is a software development company with 11 years of experience on the 
software market and over 20 thousands of devoted users.


We specialize in providing comprehensive development and management tools as 
well as native connectivity solutions for the most popular databases, 
including Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and 
SQLite.





For additional information about Devart, visit www.devart.com/company/.




# # #




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

WHERE does not work on calculated view field

2011-04-22 Thread Daniel Kraft


Hi all,

I'm by no means a (My)SQL expert and just getting started working with 
VIEWs and stored procedures, and now I'm puzzled by this behaviour:


DROP DATABASE `test`;
CREATE DATABASE `test`;
USE `test`;

CREATE TABLE `mytable`
  (`ID` SERIAL,
   `Type` INTEGER UNSIGNED NULL,
   PRIMARY KEY (`ID`));
INSERT INTO `mytable` (`Type`) VALUES (NULL);

CREATE TABLE `types`
  (`ID` SERIAL,
   `Name` TEXT NOT NULL,
   PRIMARY KEY (`ID`));
INSERT INTO `types` (`Name`) VALUES ('Type A'), ('Type B');

DELIMITER |
CREATE FUNCTION `EMPTY_STRING` (value TEXT)
RETURNS TEXT
DETERMINISTIC
BEGIN
  RETURN IF(value IS NULL, '', value);
END|
DELIMITER ;

CREATE VIEW `myview` AS
  SELECT a.*, EMPTY_STRING(b.`Name`) AS `TypeName`
FROM `mytable` a
  LEFT JOIN `types` b ON a.`Type` = b.`ID`;

SELECT COUNT(*) FROM `myview` WHERE `TypeName` IS NULL;
SELECT COUNT(*) FROM `myview` WHERE `TypeName` IS NOT NULL;
SELECT COUNT(*) FROM `myview` WHERE `TypeName` LIKE '%';

(I tried to simplify my problem as far as possible.)  When I run this 
against MySQL 5.0.24a, I get three times 0 as output from the SELECTs 
at the end -- shouldn't at least one of them match the single row? 
(Preferably first and third ones.)


What am I doing wrong here?  I have no clue what's going on...  Thanks a 
lot!


Yours,
Daniel

--
http://www.pro-vegan.info/
--
Done:  Arc-Bar-Cav-Kni-Ran-Rog-Sam-Tou-Val-Wiz
To go: Hea-Mon-Pri

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: WHERE does not work on calculated view field

2011-04-22 Thread Daevid Vincent



 -Original Message-
 From: Daniel Kraft [mailto:d...@domob.eu]
 Sent: Friday, April 22, 2011 12:37 PM
 To: mysql@lists.mysql.com
 Subject: WHERE does not work on calculated view field
 
 Hi all,
 
 I'm by no means a (My)SQL expert and just getting started working with
 VIEWs and stored procedures, and now I'm puzzled by this behaviour:
 
 DROP DATABASE `test`;
 CREATE DATABASE `test`;
 USE `test`;
 
 CREATE TABLE `mytable`
(`ID` SERIAL,
 `Type` INTEGER UNSIGNED NULL,
 PRIMARY KEY (`ID`));
 INSERT INTO `mytable` (`Type`) VALUES (NULL);
 
 CREATE TABLE `types`
(`ID` SERIAL,
 `Name` TEXT NOT NULL,
 PRIMARY KEY (`ID`));
 INSERT INTO `types` (`Name`) VALUES ('Type A'), ('Type B');
 
 DELIMITER |
 CREATE FUNCTION `EMPTY_STRING` (value TEXT)
 RETURNS TEXT
 DETERMINISTIC
 BEGIN
RETURN IF(value IS NULL, '', value);
 END|
 DELIMITER ;
 
 CREATE VIEW `myview` AS
SELECT a.*, EMPTY_STRING(b.`Name`) AS `TypeName`
  FROM `mytable` a
LEFT JOIN `types` b ON a.`Type` = b.`ID`;
 
 SELECT COUNT(*) FROM `myview` WHERE `TypeName` IS NULL;
 SELECT COUNT(*) FROM `myview` WHERE `TypeName` IS NOT NULL;
 SELECT COUNT(*) FROM `myview` WHERE `TypeName` LIKE '%';
 
 (I tried to simplify my problem as far as possible.)  When I run this
 against MySQL 5.0.24a, I get three times 0 as output from the SELECTs
 at the end -- shouldn't at least one of them match the single row?
 (Preferably first and third ones.)
 
 What am I doing wrong here?  I have no clue what's going on...  Thanks a
 lot!

Try this maybe:

 SELECT COUNT(*) FROM `myview` HAVING `TypeName` IS NULL;
 SELECT COUNT(*) FROM `myview` HAVING `TypeName` IS NOT NULL;
 SELECT COUNT(*) FROM `myview` HAVING `TypeName` LIKE '%';


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: WHERE does not work on calculated view field

2011-04-22 Thread Daniel Kraft


Hi,

thanks for the fast reply!

On 04/22/11 21:39, Daevid Vincent wrote:

DROP DATABASE `test`;
CREATE DATABASE `test`;
USE `test`;

CREATE TABLE `mytable`
(`ID` SERIAL,
 `Type` INTEGER UNSIGNED NULL,
 PRIMARY KEY (`ID`));
INSERT INTO `mytable` (`Type`) VALUES (NULL);

CREATE TABLE `types`
(`ID` SERIAL,
 `Name` TEXT NOT NULL,
 PRIMARY KEY (`ID`));
INSERT INTO `types` (`Name`) VALUES ('Type A'), ('Type B');

DELIMITER |
CREATE FUNCTION `EMPTY_STRING` (value TEXT)
RETURNS TEXT
DETERMINISTIC
BEGIN
RETURN IF(value IS NULL, '', value);
END|
DELIMITER ;

CREATE VIEW `myview` AS
SELECT a.*, EMPTY_STRING(b.`Name`) AS `TypeName`
  FROM `mytable` a
LEFT JOIN `types` b ON a.`Type` = b.`ID`;

SELECT COUNT(*) FROM `myview` WHERE `TypeName` IS NULL;
SELECT COUNT(*) FROM `myview` WHERE `TypeName` IS NOT NULL;
SELECT COUNT(*) FROM `myview` WHERE `TypeName` LIKE '%';

(I tried to simplify my problem as far as possible.)  When I run this
against MySQL 5.0.24a, I get three times 0 as output from the SELECTs
at the end -- shouldn't at least one of them match the single row?
(Preferably first and third ones.)

What am I doing wrong here?  I have no clue what's going on...  Thanks a
lot!


Try this maybe:

  SELECT COUNT(*) FROM `myview` HAVING `TypeName` IS NULL;
  SELECT COUNT(*) FROM `myview` HAVING `TypeName` IS NOT NULL;
  SELECT COUNT(*) FROM `myview` HAVING `TypeName` LIKE '%';


When I try those, I get:

ERROR 1054 (42S22) at line 35: Unknown column 'TypeName' in 'having clause'

What would be the difference?  (I've never used HAVING before.)

Yours,
Daniel

--
http://www.pro-vegan.info/
--
Done:  Arc-Bar-Cav-Kni-Ran-Rog-Sam-Tou-Val-Wiz
To go: Hea-Mon-Pri

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: WHERE does not work on calculated view field

2011-04-22 Thread Carsten Pedersen


On 22.04.2011 21:37, Daniel Kraft wrote:

Hi all,

I'm by no means a (My)SQL expert and just getting started working with
VIEWs and stored procedures, and now I'm puzzled by this behaviour:

DROP DATABASE `test`;
CREATE DATABASE `test`;
USE `test`;

CREATE TABLE `mytable`
(`ID` SERIAL,
`Type` INTEGER UNSIGNED NULL,
PRIMARY KEY (`ID`));
INSERT INTO `mytable` (`Type`) VALUES (NULL);

CREATE TABLE `types`
(`ID` SERIAL,
`Name` TEXT NOT NULL,
PRIMARY KEY (`ID`));
INSERT INTO `types` (`Name`) VALUES ('Type A'), ('Type B');

DELIMITER |
CREATE FUNCTION `EMPTY_STRING` (value TEXT)
RETURNS TEXT
DETERMINISTIC
BEGIN
RETURN IF(value IS NULL, '', value);
END|
DELIMITER ;

CREATE VIEW `myview` AS
SELECT a.*, EMPTY_STRING(b.`Name`) AS `TypeName`
FROM `mytable` a
LEFT JOIN `types` b ON a.`Type` = b.`ID`;

SELECT COUNT(*) FROM `myview` WHERE `TypeName` IS NULL;
SELECT COUNT(*) FROM `myview` WHERE `TypeName` IS NOT NULL;
SELECT COUNT(*) FROM `myview` WHERE `TypeName` LIKE '%';

(I tried to simplify my problem as far as possible.) When I run this
against MySQL 5.0.24a, I get three times 0 as output from the SELECTs
at the end -- shouldn't at least one of them match the single row?
(Preferably first and third ones.)

What am I doing wrong here? I have no clue what's going on... Thanks a lot!


Hint: What's the output of SELECT * FROM `myview`?

/ Carsten

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: WHERE does not work on calculated view field

2011-04-22 Thread Daniel Kraft


Hi Carsten,

On 04/22/11 22:11, Carsten Pedersen wrote:

On 22.04.2011 21:37, Daniel Kraft wrote:

DROP DATABASE `test`;
CREATE DATABASE `test`;
USE `test`;

CREATE TABLE `mytable`
(`ID` SERIAL,
`Type` INTEGER UNSIGNED NULL,
PRIMARY KEY (`ID`));
INSERT INTO `mytable` (`Type`) VALUES (NULL);

CREATE TABLE `types`
(`ID` SERIAL,
`Name` TEXT NOT NULL,
PRIMARY KEY (`ID`));
INSERT INTO `types` (`Name`) VALUES ('Type A'), ('Type B');

DELIMITER |
CREATE FUNCTION `EMPTY_STRING` (value TEXT)
RETURNS TEXT
DETERMINISTIC
BEGIN
RETURN IF(value IS NULL, '', value);
END|
DELIMITER ;

CREATE VIEW `myview` AS
SELECT a.*, EMPTY_STRING(b.`Name`) AS `TypeName`
FROM `mytable` a
LEFT JOIN `types` b ON a.`Type` = b.`ID`;

SELECT COUNT(*) FROM `myview` WHERE `TypeName` IS NULL;
SELECT COUNT(*) FROM `myview` WHERE `TypeName` IS NOT NULL;
SELECT COUNT(*) FROM `myview` WHERE `TypeName` LIKE '%';

(I tried to simplify my problem as far as possible.) When I run this
against MySQL 5.0.24a, I get three times 0 as output from the SELECTs
at the end -- shouldn't at least one of them match the single row?
(Preferably first and third ones.)

What am I doing wrong here? I have no clue what's going on... Thanks a
lot!


Hint: What's the output of SELECT * FROM `myview`?


I get:

mysql select * from myview;
++--+--+
| ID | Type | TypeName |
++--+--+
|  1 | NULL |  |
++--+--+
1 row in set (0.00 sec)

mysql select *, `TypeName` IS NOT NULL from myview;
++--+--++
| ID | Type | TypeName | `TypeName` IS NOT NULL |
++--+--++
|  1 | NULL |  |  1 |
++--+--++
1 row in set (0.00 sec)

Should this tell me something?  To me, it looks as expected and fine.

Cheers,
Daniel

--
http://www.pro-vegan.info/
--
Done:  Arc-Bar-Cav-Kni-Ran-Rog-Sam-Tou-Val-Wiz
To go: Hea-Mon-Pri

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: WHERE does not work on calculated view field - Found word(s) list error in the Text body

2011-04-22 Thread Larry McGhaw

It does appear to be some type of bug to me.

Clearly from the select, the Typename field is not null, as shown here.

mysql SELECT *, TypeName Is NULL, TypeName IS NOT NULL FROM `myview`;
++--+--+--+--+
| ID | Type | TypeName | TypeName Is NULL | TypeName IS NOT NULL |
++--+--+--+--+
|  1 | NULL |  |0 |1 |
++--+--+--+--+
1 row in set (0.00 sec)

But when referenced in the where clause in any manner, no results are returned.

mysql SELECT *, TypeName Is NULL, TypeName IS NOT NULL FROM `myview` where TYPE
NAME IS NOT NULL;
Empty set (0.00 sec)


-Original Message-
From: Daniel Kraft [mailto:d...@domob.eu] 
Sent: Friday, April 22, 2011 1:05 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list 
error in the Text body

Hi,

thanks for the fast reply!

On 04/22/11 21:39, Daevid Vincent wrote:
 DROP DATABASE `test`;
 CREATE DATABASE `test`;
 USE `test`;

 CREATE TABLE `mytable`
 (`ID` SERIAL,
  `Type` INTEGER UNSIGNED NULL,
  PRIMARY KEY (`ID`));
 INSERT INTO `mytable` (`Type`) VALUES (NULL);

 CREATE TABLE `types`
 (`ID` SERIAL,
  `Name` TEXT NOT NULL,
  PRIMARY KEY (`ID`));
 INSERT INTO `types` (`Name`) VALUES ('Type A'), ('Type B');

 DELIMITER |
 CREATE FUNCTION `EMPTY_STRING` (value TEXT)
 RETURNS TEXT
 DETERMINISTIC
 BEGIN
 RETURN IF(value IS NULL, '', value);
 END|
 DELIMITER ;

 CREATE VIEW `myview` AS
 SELECT a.*, EMPTY_STRING(b.`Name`) AS `TypeName`
   FROM `mytable` a
 LEFT JOIN `types` b ON a.`Type` = b.`ID`;

 SELECT COUNT(*) FROM `myview` WHERE `TypeName` IS NULL;
 SELECT COUNT(*) FROM `myview` WHERE `TypeName` IS NOT NULL;
 SELECT COUNT(*) FROM `myview` WHERE `TypeName` LIKE '%';

 (I tried to simplify my problem as far as possible.)  When I run this
 against MySQL 5.0.24a, I get three times 0 as output from the SELECTs
 at the end -- shouldn't at least one of them match the single row?
 (Preferably first and third ones.)

 What am I doing wrong here?  I have no clue what's going on...  Thanks a
 lot!

 Try this maybe:

   SELECT COUNT(*) FROM `myview` HAVING `TypeName` IS NULL;
   SELECT COUNT(*) FROM `myview` HAVING `TypeName` IS NOT NULL;
   SELECT COUNT(*) FROM `myview` HAVING `TypeName` LIKE '%';

When I try those, I get:

ERROR 1054 (42S22) at line 35: Unknown column 'TypeName' in 'having clause'

What would be the difference?  (I've never used HAVING before.)

Yours,
Daniel

-- 
http://www.pro-vegan.info/
--
Done:  Arc-Bar-Cav-Kni-Ran-Rog-Sam-Tou-Val-Wiz
To go: Hea-Mon-Pri

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=lmcg...@connx.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: WHERE does not work on calculated view field - Found word(s) list error in the Text body

2011-04-22 Thread Carsten Pedersen


On 22.04.2011 22:41, Larry McGhaw wrote:

It does appear to be some type of bug to me.


I agree. I was thrown by Daniels first and third comment, which I 
guess should read second and third


I reproduced the behavior in 5.1.53-community on Windows.

/ Carsten

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Devart news

WHERE does not work on calculated view field

RE: WHERE does not work on calculated view field

Re: WHERE does not work on calculated view field

Re: WHERE does not work on calculated view field

Re: WHERE does not work on calculated view field

RE: WHERE does not work on calculated view field - Found word(s) list error in the Text body

Re: WHERE does not work on calculated view field - Found word(s) list error in the Text body

8 matches

Site Navigation

Mail list logo

Footer information