MySQL Forums
Forum List  »  Newbie

release 5.5 vs 5.7 : Invalid size for column type bit(0)
Posted by: Stephane BATAIS
Date: June 06, 2017 11:02AM

Hello

In MYSQL 5.5 I can create a table with a column and the type bit(0) and I can't create the same table in mysql 5.7 :

mysql> create temporary table `smvpdb`.`tmpT` (`A` bit(0));
ERROR 3013 (HY000): Invalid size for column 'A'.

Is this a bug in MySQL release 5.5 ?
Is there an option in MySQL release 5.7 to authorize this creation ?

The create table command is formatted by a Java program that uses the Mysql connector

Thanks in advance for your help

Options: ReplyQuote


Subject
Written By
Posted
release 5.5 vs 5.7 : Invalid size for column type bit(0)
June 06, 2017 11:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.