MSCEWI1080

Default value is not allowed on binary columns

Severity
Low
Description
This EWI is added when the source code has a default value for BINARY data type, which is not supported in SnowFlake SQL
Example Code 
Input Code:
create table test1345
 (
 key1 binary default 0
​
 );
Output Code:
CREATE OR REPLACE TABLE PUBLIC.test1345
(
key1 BINARY
-- ** MSC-WARNING - MSCEWI1080 - DEFAULT VALUE IS NOT ALLOWED ON BINARY COLUMNS **
--            default 0
​
);
Recommendations
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI1079

MSCEWI1081

Last modified 8mo ago