oracle / quicksql

A library for generating DDL SQL and entity-relationship-diagrams from Quick SQL code
Universal Permissive License v1.0
53 stars 11 forks source link

/insert generates unexpected 'N/A' string for a blob column & data too long for vc20 #65

Open stevemuench opened 6 months ago

stevemuench commented 6 months ago

When creating a table with a blob, and requesting the generation of sample data, Quick SQL unexpectedly provides the literal string 'N/A' as the sample data value for the blob

reports /insert 1
        created date
        description vc20
        pdf blob

This produces:

insert into reports (
id,
created,
description,
pdf
) values (
1,
sysdate-70,
'Om pikawo pe amopi woem efum ji ga sefze figi pomlot dadeziguz seak nigamu luv. Boma oziworpaz re cuznim reletwaj lojeibe lolmuj tujle tovufmu vofizo nuzi regusoj iwmum busifurih weof.',
'N/A'
);

This generated insert statement has two problems. The 'N/A' produces an error ORA-01465: invalid hex number and the sample data for the vc20 column description produces an error ORA-12899: value too large for column

A workaround for the blob issue is to use the /values null on the blob column and a workaround for the vc issue is to use a /values One Value,Another Value,Something Else,Fourth Example like this:

reports /insert 1
        created date
        description vc20 /values One Value,Another Value,Something Else,Fourth Example
        pdf blob /values null