You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(7) |
Dec
(4) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(9) |
Feb
(4) |
Mar
(20) |
Apr
(10) |
May
(5) |
Jun
(2) |
Jul
(10) |
Aug
(4) |
Sep
(15) |
Oct
(5) |
Nov
(8) |
Dec
(2) |
| 2003 |
Jan
(11) |
Feb
(5) |
Mar
(10) |
Apr
(20) |
May
(24) |
Jun
(13) |
Jul
(6) |
Aug
(5) |
Sep
(10) |
Oct
(10) |
Nov
(9) |
Dec
(7) |
| 2004 |
Jan
(4) |
Feb
(10) |
Mar
(5) |
Apr
(18) |
May
(18) |
Jun
(14) |
Jul
(24) |
Aug
(14) |
Sep
(6) |
Oct
(18) |
Nov
(5) |
Dec
(3) |
| 2005 |
Jan
(5) |
Feb
(1) |
Mar
(5) |
Apr
(10) |
May
(10) |
Jun
(16) |
Jul
(46) |
Aug
(36) |
Sep
(16) |
Oct
(11) |
Nov
(12) |
Dec
(29) |
| 2006 |
Jan
(33) |
Feb
(45) |
Mar
(42) |
Apr
(23) |
May
(23) |
Jun
(21) |
Jul
(19) |
Aug
(23) |
Sep
(17) |
Oct
(50) |
Nov
(74) |
Dec
(44) |
| 2007 |
Jan
(35) |
Feb
(18) |
Mar
(46) |
Apr
(25) |
May
(26) |
Jun
(24) |
Jul
(33) |
Aug
(4) |
Sep
(41) |
Oct
(43) |
Nov
(23) |
Dec
(42) |
| 2008 |
Jan
(26) |
Feb
(20) |
Mar
(21) |
Apr
(18) |
May
(28) |
Jun
(32) |
Jul
(25) |
Aug
(28) |
Sep
(27) |
Oct
(34) |
Nov
(16) |
Dec
(42) |
| 2009 |
Jan
(21) |
Feb
(36) |
Mar
(40) |
Apr
(51) |
May
(27) |
Jun
(13) |
Jul
(38) |
Aug
(40) |
Sep
(5) |
Oct
(14) |
Nov
(4) |
Dec
(7) |
| 2010 |
Jan
(16) |
Feb
(10) |
Mar
(38) |
Apr
(83) |
May
(27) |
Jun
(41) |
Jul
(57) |
Aug
(24) |
Sep
(14) |
Oct
(22) |
Nov
(28) |
Dec
(42) |
| 2011 |
Jan
(52) |
Feb
(13) |
Mar
(41) |
Apr
(14) |
May
(24) |
Jun
(14) |
Jul
(16) |
Aug
(15) |
Sep
(19) |
Oct
(20) |
Nov
(35) |
Dec
(48) |
| 2012 |
Jan
(30) |
Feb
(9) |
Mar
(33) |
Apr
(15) |
May
(13) |
Jun
(13) |
Jul
(57) |
Aug
(20) |
Sep
(18) |
Oct
(29) |
Nov
(28) |
Dec
(9) |
| 2013 |
Jan
(19) |
Feb
(26) |
Mar
(44) |
Apr
(13) |
May
(38) |
Jun
(6) |
Jul
(24) |
Aug
(8) |
Sep
(7) |
Oct
(10) |
Nov
(12) |
Dec
(6) |
| 2014 |
Jan
(13) |
Feb
(6) |
Mar
(41) |
Apr
(5) |
May
(4) |
Jun
(3) |
Jul
(13) |
Aug
(9) |
Sep
(35) |
Oct
(36) |
Nov
(16) |
Dec
(4) |
| 2015 |
Jan
(6) |
Feb
(4) |
Mar
(7) |
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(2) |
Sep
(10) |
Oct
(4) |
Nov
(13) |
Dec
(3) |
| 2016 |
Jan
(6) |
Feb
(12) |
Mar
(6) |
Apr
(21) |
May
(9) |
Jun
(16) |
Jul
(13) |
Aug
(13) |
Sep
(11) |
Oct
(9) |
Nov
(20) |
Dec
(18) |
| 2017 |
Jan
(7) |
Feb
(19) |
Mar
(9) |
Apr
(12) |
May
(12) |
Jun
(35) |
Jul
(7) |
Aug
(3) |
Sep
|
Oct
(1) |
Nov
(4) |
Dec
|
| 2018 |
Jan
(4) |
Feb
(1) |
Mar
(3) |
Apr
(8) |
May
(9) |
Jun
(8) |
Jul
(6) |
Aug
(7) |
Sep
(8) |
Oct
(1) |
Nov
(6) |
Dec
|
| 2019 |
Jan
(6) |
Feb
(9) |
Mar
(3) |
Apr
(3) |
May
(4) |
Jun
|
Jul
|
Aug
(4) |
Sep
(3) |
Oct
(3) |
Nov
(3) |
Dec
(1) |
| 2020 |
Jan
(4) |
Feb
(4) |
Mar
(22) |
Apr
(1) |
May
(16) |
Jun
(12) |
Jul
(3) |
Aug
(10) |
Sep
(5) |
Oct
(1) |
Nov
(24) |
Dec
(1) |
| 2021 |
Jan
(2) |
Feb
(10) |
Mar
(9) |
Apr
(7) |
May
(8) |
Jun
(10) |
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2022 |
Jan
(3) |
Feb
(4) |
Mar
(5) |
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
(6) |
Sep
(1) |
Oct
(2) |
Nov
(2) |
Dec
|
| 2023 |
Jan
(2) |
Feb
(6) |
Mar
|
Apr
|
May
(13) |
Jun
|
Jul
|
Aug
(6) |
Sep
|
Oct
|
Nov
(1) |
Dec
(4) |
| 2024 |
Jan
(3) |
Feb
|
Mar
(5) |
Apr
(1) |
May
(5) |
Jun
(1) |
Jul
(1) |
Aug
|
Sep
|
Oct
(3) |
Nov
(3) |
Dec
|
| 2025 |
Jan
|
Feb
(5) |
Mar
(33) |
Apr
(8) |
May
(10) |
Jun
(7) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Stanimir S. <s7...@ne...> - 2025-03-02 22:27:33
|
Sun, 2 Mar 2025 17:17:37 -0500, /info/: > The whole point of my question was that I was missing the class name. > Was I not missing it, I would not have asked it. I speculate you've deleted it inadvertently. -- |
|
From: info <in...@dr...> - 2025-03-02 22:17:52
|
The whole point of my question was that I was missing the class name. Was I not missing it, I would not have asked it. On 2025-03-02 05:06 PM, Stanimir Stamenkov via Squirrel-sql-users wrote: > Sun, 2 Mar 2025 16:57:03 -0500, /info/: > >> Even in this one? >> >>> Class Name: <empty> > > You're still missing the "Class Name" – try > "org.firebirdsql.jdbc.FBDriver". > >> I only showed the subscribers the versions that I tried. That did not >> mean that I wanted to download all of them at the same time. > > All right. So you've really meant added to/replaced in the driver > definition one after another (unlike seen in the screenshot). > >> On 2025-03-02 04:53 PM, Stanimir Stamenkov via Squirrel-sql-users wrote: >>> Sun, 2 Mar 2025 16:43:03 -0500, /info/: >>> >>>> This part is important: >>>> >>>>> I downloaded *one after another* >>>> >>>> So, what am I doing differently? >>> >>> You may have downloaded the jars one after another but what you show >>> in your screenshot is you have different version jars added to the >>> driver definition _at the same time_ – try removing the 4.0.3 jars, >>> for example. You're also missing the "Class Name" for some reason. >>> You didn't say what SQuirreL and Java versions you're using. >>> >>>> On 2025-03-02 03:40 PM, Stanimir Stamenkov via Squirrel-sql-users >>>> wrote: >>>>> Sun, 2 Mar 2025 14:47:59 -0500, /info/: >>>>> >>>>>> Trying to connect to Firebird, I downloaded one after another all >>>>>> of these drivers, but none of them lists: >>>>>> >>>>>> Extra Class Path: >>>>>> /home/use0/opt/jbdc/jaybird-6.0.0.jar >>>>>> /home/use0/opt/jbdc/jaybird-native-6.0.0.jar >>>>>> /home/use0/opt/jbdc/jaybird-4.0.3.java8.jar >>>>>> /home/use0/opt/jbdc/jaybird-full-4.0.3.java8.jar >>>>>> >>>>>> Class Name: <empty> >>>>>> >>>>>> Other JDBC drivers such as MySQL, Oracle Thin, SQLite, etc have >>>>>> no problem listing the class. Why is Firebird different? >>>>> >>>>> You should not mix JARs from different driver versions. What >>>>> SQuirreL and Java versions are you using? I've tried adding just >>>>> the "jaybird-6.0.0.jar" and the driver seems to have loaded >>>>> successfully: >>>>> >>>>> https://i.imgur.com/jUU0AMB.png >>>>> >>>>> (Class Name: org.firebirdsql.jdbc.FBDriver) > |
|
From: Stanimir S. <s7...@ne...> - 2025-03-02 22:16:29
|
Sun, 2 Mar 2025 16:57:03 -0500, /info/: > Even in this one? > >> Class Name: <empty> You're still missing the "Class Name" – try "org.firebirdsql.jdbc.FBDriver". > I only showed the subscribers the versions that I tried. That did not > mean that I wanted to download all of them at the same time. All right. So you've really meant added to/replaced in the driver definition one after another (unlike seen in the screenshot). > On 2025-03-02 04:53 PM, Stanimir Stamenkov via Squirrel-sql-users wrote: >> Sun, 2 Mar 2025 16:43:03 -0500, /info/: >> >>> This part is important: >>> >>>> I downloaded *one after another* >>> >>> So, what am I doing differently? >> >> You may have downloaded the jars one after another but what you show >> in your screenshot is you have different version jars added to the >> driver definition _at the same time_ – try removing the 4.0.3 jars, >> for example. You're also missing the "Class Name" for some reason. >> You didn't say what SQuirreL and Java versions you're using. >> >>> On 2025-03-02 03:40 PM, Stanimir Stamenkov via Squirrel-sql-users wrote: >>>> Sun, 2 Mar 2025 14:47:59 -0500, /info/: >>>> >>>>> Trying to connect to Firebird, I downloaded one after another all >>>>> of these drivers, but none of them lists: >>>>> >>>>> Extra Class Path: >>>>> /home/use0/opt/jbdc/jaybird-6.0.0.jar >>>>> /home/use0/opt/jbdc/jaybird-native-6.0.0.jar >>>>> /home/use0/opt/jbdc/jaybird-4.0.3.java8.jar >>>>> /home/use0/opt/jbdc/jaybird-full-4.0.3.java8.jar >>>>> >>>>> Class Name: <empty> >>>>> >>>>> Other JDBC drivers such as MySQL, Oracle Thin, SQLite, etc have no >>>>> problem listing the class. Why is Firebird different? >>>> >>>> You should not mix JARs from different driver versions. What >>>> SQuirreL and Java versions are you using? I've tried adding just >>>> the "jaybird-6.0.0.jar" and the driver seems to have loaded >>>> successfully: >>>> >>>> https://i.imgur.com/jUU0AMB.png >>>> >>>> (Class Name: org.firebirdsql.jdbc.FBDriver) -- |
|
From: info <in...@dr...> - 2025-03-02 21:57:22
|
Even in this one? I only showed the subscribers the versions that I tried. That did not mean that I wanted to download all of them at the same time. On 2025-03-02 04:53 PM, Stanimir Stamenkov via Squirrel-sql-users wrote: > Sun, 2 Mar 2025 16:43:03 -0500, /info/: > >> This part is important: >> >>> I downloaded *one after another* >> >> So, what am I doing differently? > > You may have downloaded the jars one after another but what you show > in your screenshot is you have different version jars added to the > driver definition _at the same time_ – try removing the 4.0.3 jars, > for example. You're also missing the "Class Name" for some reason. > You didn't say what SQuirreL and Java versions you're using. > >> On 2025-03-02 03:40 PM, Stanimir Stamenkov via Squirrel-sql-users wrote: >>> Sun, 2 Mar 2025 14:47:59 -0500, /info/: >>> >>>> Trying to connect to Firebird, I downloaded one after another all >>>> of these drivers, but none of them lists: >>>> >>>> Extra Class Path: >>>> /home/use0/opt/jbdc/jaybird-6.0.0.jar >>>> /home/use0/opt/jbdc/jaybird-native-6.0.0.jar >>>> /home/use0/opt/jbdc/jaybird-4.0.3.java8.jar >>>> /home/use0/opt/jbdc/jaybird-full-4.0.3.java8.jar >>>> >>>> Class Name: <empty> >>>> >>>> Other JDBC drivers such as MySQL, Oracle Thin, SQLite, etc have no >>>> problem listing the class. Why is Firebird different? >>> >>> You should not mix JARs from different driver versions. What >>> SQuirreL and Java versions are you using? I've tried adding just >>> the "jaybird-6.0.0.jar" and the driver seems to have loaded >>> successfully: >>> >>> https://i.imgur.com/jUU0AMB.png >>> >>> (Class Name: org.firebirdsql.jdbc.FBDriver) > |
|
From: Stanimir S. <s7...@ne...> - 2025-03-02 21:54:28
|
Sun, 2 Mar 2025 16:43:03 -0500, /info/: > This part is important: > >> I downloaded *one after another* > > So, what am I doing differently? You may have downloaded the jars one after another but what you show in your screenshot is you have different version jars added to the driver definition _at the same time_ – try removing the 4.0.3 jars, for example. You're also missing the "Class Name" for some reason. You didn't say what SQuirreL and Java versions you're using. > On 2025-03-02 03:40 PM, Stanimir Stamenkov via Squirrel-sql-users wrote: >> Sun, 2 Mar 2025 14:47:59 -0500, /info/: >> >>> Trying to connect to Firebird, I downloaded one after another all of >>> these drivers, but none of them lists: >>> >>> Extra Class Path: >>> /home/use0/opt/jbdc/jaybird-6.0.0.jar >>> /home/use0/opt/jbdc/jaybird-native-6.0.0.jar >>> /home/use0/opt/jbdc/jaybird-4.0.3.java8.jar >>> /home/use0/opt/jbdc/jaybird-full-4.0.3.java8.jar >>> >>> Class Name: <empty> >>> >>> Other JDBC drivers such as MySQL, Oracle Thin, SQLite, etc have no >>> problem listing the class. Why is Firebird different? >> >> You should not mix JARs from different driver versions. What SQuirreL >> and Java versions are you using? I've tried adding just the >> "jaybird-6.0.0.jar" and the driver seems to have loaded successfully: >> >> https://i.imgur.com/jUU0AMB.png >> >> (Class Name: org.firebirdsql.jdbc.FBDriver) -- |
|
From: info <in...@dr...> - 2025-03-02 21:43:27
|
This part is important: > I downloaded *one after another * So, what am I doing differently? On 2025-03-02 03:40 PM, Stanimir Stamenkov via Squirrel-sql-users wrote: > Sun, 2 Mar 2025 14:47:59 -0500, /info/: > >> Trying to connect to Firebird, I downloaded one after another all of >> these drivers, but none of them lists: >> >> Extra Class Path: >> /home/use0/opt/jbdc/jaybird-6.0.0.jar >> /home/use0/opt/jbdc/jaybird-native-6.0.0.jar >> /home/use0/opt/jbdc/jaybird-4.0.3.java8.jar >> /home/use0/opt/jbdc/jaybird-full-4.0.3.java8.jar >> >> Class Name: <empty> >> >> Other JDBC drivers such as MySQL, Oracle Thin, SQLite, etc have no >> problem listing the class. Why is Firebird different? > > You should not mix JARs from different driver versions. What SQuirreL > and Java versions are you using? I've tried adding just the > "jaybird-6.0.0.jar" and the driver seems to have loaded successfully: > > https://i.imgur.com/jUU0AMB.png > > (Class Name: org.firebirdsql.jdbc.FBDriver) > |
|
From: Stanimir S. <s7...@ne...> - 2025-03-02 21:41:30
|
Sun, 2 Mar 2025 14:47:59 -0500, /info/: > Trying to connect to Firebird, I downloaded one after another all of > these drivers, but none of them lists: > > Extra Class Path: > /home/use0/opt/jbdc/jaybird-6.0.0.jar > /home/use0/opt/jbdc/jaybird-native-6.0.0.jar > /home/use0/opt/jbdc/jaybird-4.0.3.java8.jar > /home/use0/opt/jbdc/jaybird-full-4.0.3.java8.jar > > Class Name: <empty> > > Other JDBC drivers such as MySQL, Oracle Thin, SQLite, etc have no > problem listing the class. Why is Firebird different? You should not mix JARs from different driver versions. What SQuirreL and Java versions are you using? I've tried adding just the "jaybird-6.0.0.jar" and the driver seems to have loaded successfully: https://i.imgur.com/jUU0AMB.png (Class Name: org.firebirdsql.jdbc.FBDriver) -- Stanimir |
|
From: info <in...@dr...> - 2025-03-02 19:48:13
|
Trying to connect to Firebird, I downloaded one after another all of these drivers, but none of them lists: Other JDBC drivers such as MySQL, Oracle Thin, SQLite, etc have no problem listing the class. Why is Firebird different? Regards Al |
|
From: Gerd W. <ger...@t-...> - 2025-02-18 19:29:27
|
On 13.02.25 16:21, info wrote: > Good time of the day, everyone! > > Is it possible to use fixed-width font instead of proportional, in the > results? > Currently, long text is hard to read: > Try menu File --> Global Preferences --> tab Fonts --> Enable "Other" and choose a font. Hope this helps Gerd |
|
From: Gerd W. <ger...@t-...> - 2025-02-15 21:47:02
|
On 13.02.25 16:21, info wrote: > Good time of the day, everyone! > > Is it possible to use fixed-width font instead of proportional, in the > results? > Currently, long text is hard to read: > Try menu File --> Global Preferences --> tab Fonts --> Enable "Other" and choose a font. Hope this helps Gerd |
|
From: info <in...@dr...> - 2025-02-14 13:20:13
|
Thanks a lot! Merci! On Linux, it is Courier 10 Pitch 12 that is acceptable size. On 2025-02-14 04:07 AM, Chris Harris (INT) wrote: > > File -> Global Preferences -> Fonts tab, enable fonts for ‘Other’, > click the Other button and select a fixed-width (monospaced) font > (e.g. Courier New, 16) > |
|
From: Chris H. (INT) <Chr...@om...> - 2025-02-14 11:40:38
|
File -> Global Preferences -> Fonts tab, enable fonts for ‘Other’, click the Other button and select a fixed-width (monospaced) font (e.g. Courier New, 16) ________________________________ OM International - Unit B Clifford Court, Cooper Way - Carlisle CA3 0JG - United Kingdom Charity reg no: 1112655 - Company reg no: 5649412 (England and Wales) |
|
From: info <in...@dr...> - 2025-02-13 16:22:23
|
Good time of the day, everyone! Is it possible to use fixed-width font instead of proportional, in the results? Currently, long text is hard to read: Regards, Al |
|
From: info <in...@dr...> - 2024-11-26 19:29:02
|
Is there any chance your JRE is headless? I recently upgraded my Linux and had to install full JRE to allow any Java GUI apps to run because in the latest versions of Linux they inexplicably supply headless JRE/JDK. Surprisingly, LibreOffice still ran fine but not Squirrel or other apps. On 2024-11-25 11:39 p.m., ABNEC wrote: > Hello, > > Running squirrlesql on debian with the plasma desktop. > This fails to bring up the java swing interface and instead errors and > opens a webpage with the squirrel user interface. What causes this > error and how is it resolved so the Java GUI runs? > > export XDG_SESSION_TYPE=wayland > java -jar h2-2.3.232.jar > Error: Failed to open Wayland display, fallback to X11. > WAYLAND_DISPLAY='wayland-0' DISPLAY=':1' > > Thank you. > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: ABNEC <ab...@pe...> - 2024-11-26 14:57:30
|
squirrlesql / Error: Failed to open Wayland display, fallback to X11 / 2 == Hello, Running squirrlesql on debian with the plasma desktop. This fails to bring up the java swing interface and instead errors and opens a webpage with the squirrel user interface. What causes this error and how is it resolved so the Java GUI runs? export XDG_SESSION_TYPE=wayland java -jar h2-2.3.232.jar Error: Failed to open Wayland display, fallback to X11. WAYLAND_DISPLAY='wayland-0' DISPLAY=':1' Thank you. |
|
From: ABNEC <ab...@pe...> - 2024-11-26 06:37:48
|
Hello, Running squirrlesql on debian with the plasma desktop. This fails to bring up the java swing interface and instead errors and opens a webpage with the squirrel user interface. What causes this error and how is it resolved so the Java GUI runs? export XDG_SESSION_TYPE=wayland java -jar h2-2.3.232.jar Error: Failed to open Wayland display, fallback to X11. WAYLAND_DISPLAY='wayland-0' DISPLAY=':1' Thank you. |
|
From: Gerd W. <ger...@t-...> - 2024-10-27 17:25:41
|
Am 27.10.24 um 15:28 schrieb info: > Good morning, > > When I run 'create table' statements against an SQLite DB and then > switch from SQL tab to Objects tab, I see doubles or triples of the > table names. After refresh, the tree shrinks to single instances of each > table. > Sorry, I can't reproduce your problem. Which version of SQuirreL are you using? There was fix for your problem in version 4.5.0. Gerd |
|
From: info <in...@dr...> - 2024-10-27 14:25:17
|
Good morning, When I run 'create table' statements against an SQLite DB and then switch from SQL tab to Objects tab, I see doubles or triples of the table names. After refresh, the tree shrinks to single instances of each table. |
|
From: info <in...@dr...> - 2024-10-12 22:50:54
|
Having googled for BDB and Squirrel SQL, I've seen some mention of CH Werner JDBC driver but was not able to locate any files. Does anybody know whether it is possible to connect Squirrel to BDB or where a driver can be obtained? Regards Al |
|
From: Gerd W. <ger...@t-...> - 2024-07-20 20:19:17
|
Am 13.06.24 um 15:04 schrieb David Morsberger: > My cursor now loses focus in the SQL editor pane when I use auto complete ‘Ctrl Space’ and select an option in the window. I have to use my mouse to place the cursor after the selected value in the SQL editor. This is an extra step that makes it less efficient. I do not remember this behavior prior to v4.7.1. > > Is there anything I can do place the cursor focus right after the selected value? > > OS: Mac > SQuirreL SQL: 4.7.1 > Java: "17.0.7" 2023-04-18 LTS > Fix is committed to our GIT repositories at Sourceforge and GitHub. It will be available in future snapshots and versions. Gerd |
|
From: David M. <da...@mo...> - 2024-06-13 13:20:08
|
My cursor now loses focus in the SQL editor pane when I use auto complete ‘Ctrl Space’ and select an option in the window. I have to use my mouse to place the cursor after the selected value in the SQL editor. This is an extra step that makes it less efficient. I do not remember this behavior prior to v4.7.1. Is there anything I can do place the cursor focus right after the selected value? OS: Mac SQuirreL SQL: 4.7.1 Java: "17.0.7" 2023-04-18 LTS |
|
From: info <in...@dr...> - 2024-05-17 14:36:36
|
Now, it is perfectly *aligned*. Thanks again! On 2024-05-15 03:43 PM, Gerd Wagner wrote: > > > Am 15.05.24 um 03:44 schrieb info: >> Gerd: >> >> This kind of works, gets me at least 1/2 way there. >> >> This is its default behavior: >> >> And this is further collapsed after double-clicking on ID and Title >> columns: >> >> Multiple column is its minimum width right away. They are different >> data types though: ID INT(11) in MySQL, and Multuple is INT(1). >> >> Is it possible to arrive at the latter behavior immediately anyway? >> > > Yes there is. See the SQL result table's right mouse menu entries > "Adjust all column widths" and *"Always adjust all column widths"*. > The first of the two may be assigned a keyboard shortcut at menu File > --> Global Preferences --> tab Keyboard shortcuts. > |
|
From: Robert P. <dev...@ro...> - 2024-05-17 14:32:21
|
Hi Gerd,
I am on DB2 11.5.9 and think there is a bug in the "create table
script" generator for foreign keys when aliases are involved.
Example:
----------------------------------------
DROP TABLE IF EXISTS X.TBL1
;
DROP TABLE IF EXISTS X.TBL2
;
CREATE TABLE X.TBL1
(
OB_OID bigint PRIMARY KEY NOT NULL,
BLA bigint
)
;
CREATE TABLE X.TBL2
(
OB_OID bigint PRIMARY KEY NOT NULL,
BLUB bigint
)
;
ALTER TABLE X.TBL2
ADD CONSTRAINT CONS_TEST
FOREIGN KEY (BLUB)
REFERENCES X.TBL1(OB_OID)
;
CREATE OR REPLACE ALIAS Y.TBL1 FOR X.TBL1
;
----------------------------------------
When I do a generate on Tables TBL1 and TBL2 in Schema X (right click
-> Scripts -> Create Table Script in Sql editor) from the object tree
I get this result:
----------------------------------------
CREATE TABLE X.TBL1
(
OB_OID bigint PRIMARY KEY NOT NULL,
BLA bigint
)
;
CREATE TABLE X.TBL2
(
OB_OID bigint PRIMARY KEY NOT NULL,
BLUB bigint
)
;
ALTER TABLE X.TBL2
ADD CONSTRAINT CONS_TEST
FOREIGN KEY (BLUB)
REFERENCES X.TBL1(OB_OID)
;
ALTER TABLE X.TBL2
ADD CONSTRAINT CONS_TEST
FOREIGN KEY (BLUB)
REFERENCES Y.TBL1(OB_OID)
;
----------------------------------------
Another question:
Is it possible to build in more options for the generator?
Like
1.) DROP TABLE IF EXISTS instead of DROP TABLE
2.) push out more information, e.g. table spaces, index spaces,
compression for tables or
ALLOW REVERSE SCANS, PAGE SPLIT SYMMETRIC for indexes,...
Thanks :-)
Robert
|
|
From: Gerd W. <ger...@t-...> - 2024-05-15 19:43:21
|
Am 15.05.24 um 03:44 schrieb info: > Gerd: > > This kind of works, gets me at least 1/2 way there. > > This is its default behavior: > > And this is further collapsed after double-clicking on ID and Title columns: > > Multiple column is its minimum width right away. They are different data > types though: ID INT(11) in MySQL, and Multuple is INT(1). > > Is it possible to arrive at the latter behavior immediately anyway? > Yes there is. See the SQL result table's right mouse menu entries "Adjust all column widths" and "Always adjust all column widths". The first of the two may be assigned a keyboard shortcut at menu File --> Global Preferences --> tab Keyboard shortcuts. |
|
From: info <in...@dr...> - 2024-05-15 02:45:28
|
Gerd: This kind of works, gets me at least 1/2 way there. This is its default behavior: And this is further collapsed after double-clicking on ID and Title columns: Multiple column is its minimum width right away. They are different data types though: ID INT(11) in MySQL, and Multuple is INT(1). Is it possible to arrive at the latter behavior immediately anyway? Many thanks! On 2024-05-14 2:35 p.m., Gerd Wagner wrote: > Am 04.04.24 um 20:21 schrieb info: >> Could developers consider adding a few lines, to auto-adjust column >> width to whichever is greater: the width of the title or that of the >> longest column value, up to to a reasonable maximum? >> > > Please see menu File --> Global Preferences --> tab General --> > Section "When adjusting table column widths a maximum width may be > defined here" on the right. > |
