Re: [Squirrel-sql-users] Mariadb not handling 'create table' script correctly

[Gerd W. <ger...@t-...>]

Thanks for your quick feedback.
Gerd

Am 24.05.21 um 22:40 schrieb Roger Hill:
> Hi Gerd.
> 
> I tested it just now. It is now correct.
> 
> Many thanks
> Roger
> 
> ---
> ***************************
> Roger Hill
> ***************************
> 
> On 2021-05-24 16:25, Gerd Wagner wrote:
>> Am 20.05.21 um 11:20 schrieb Roger Hill:
>>> Hi.
>>>
>>> Using Squirrel 4.2 (same issue with 4.1).
>>>
>>> If I have a table in Mariadb that has a decimal column, say 
>>> 'dollarvalue decimal(15,2)', when I generate a 'create table' script, 
>>> Squirrel is generating the column as 'dollarvalue decimal not null', 
>>> i.e is dropping the (15,2).
>>
>> Is fixed in our Git repository and available in this snapshot
>> https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20210524_2220/ 
>>
>>
>> Gerd
>>
>>>
>>>
>>> Both DBeaver and DbVis generate the script correctly, and if i look 
>>> at the 'Columns' tab in Squirrel when the table is highlighted in the 
>>> Object list, it shows correctly.
>>>
>>>
>>> So the detailed definition is being lost somewhere in the script 
>>> generation, as far as I can see.
>>>
>>>
>>> Or is it me, doing something stupid?
>>>
>>>
>>> Cheers, thanks for a great tool.
>>>
>>> Roger