Re: Alter table add index not working
Fred Toussi via Hsqldb-user <[email protected]> Sun, 19 Mar 2023 15:05:00 +0000
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <[email protected]> |
--===============6324651862743468141== Content-Type: multipart/alternative; boundary=fd54284120e7486d9ad44e7f7edb8bbc --fd54284120e7486d9ad44e7f7edb8bbc Content-Type: text/plain This is not the correct syntax. Use this: "create index index_name on table_name(column_name)"** See the Guide: http://hsqldb.org/doc/2.0/guide/databaseobjects-chapt.html#dbc_other_object_creation On Sun, Mar 19, 2023, at 14:29, Sravya Kothuri wrote: > Hi Team, > > I am actually using embedded HSQL database in my application and we recently migrated application from oracle to MariaDB and HSQL DB is throwing "type not found or user lacks provilige " while running "alter table table_name add index index_name (column_name)" and I saw from one of your article that this syntax is also correct I am using Public schema with SA user and version HSQL2.3.4 Also I tried same command with other versions as well and I am seeing same error. > > > Thanks, > Kothuri Sravya > > _______________________________________________ > Hsqldb-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/hsqldb-user > --fd54284120e7486d9ad44e7f7edb8bbc Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE html><html><head><title></title><style type=3D"text/css">p.Mso= Normal,p.MsoNoSpacing{margin:0}</style></head><body><div style=3D"font-f= amily:Arial;">This is not the correct syntax. Use this:<br></div><div st= yle=3D"font-family:Arial;"><br></div><div style=3D"font-family:Arial;">"= create index index_name on table_name(column_name)"<b></b></div><div sty= le=3D"font-family:Arial;"><br></div><div style=3D"font-family:Arial;">Se= e the Guide: <a href=3D"http://hsqldb.org/doc/2.0/guide/databaseobjects-= chapt.html#dbc_other_object_creation">http://hsqldb.org/doc/2.0/guide/da= tabaseobjects-chapt.html#dbc_other_object_creation</a></div><div>On Sun,= Mar 19, 2023, at 14:29, Sravya Kothuri wrote:<br></div><blockquote type= =3D"cite" id=3D"qt" style=3D""><div><span style=3D"color:rgb(49, 49, 49)= ;word-spacing:1px;"><span class=3D"font" style=3D"font-family:-apple-sys= tem, "Helvetica Neue";">Hi Team,</span></span><br></div><div d= ir=3D"auto" style=3D"color:rgb(49, 49, 49);font-family:-apple-system, &q= uot;Helvetica Neue";word-spacing:1px;"><br></div><div dir=3D"auto" = style=3D"font-size:1rem;color:rgb(49, 49, 49);font-family:-apple-system,= "Helvetica Neue";word-spacing:1px;">I am actually using embed= ded HSQL database in my application and we recently migrated application= from oracle to MariaDB and HSQL DB is throwing "type not found or user = lacks provilige " while running "alter table table_name add index index_= name (column_name)" and I saw from one of your article that this syntax = is also correct I am using Public schema with SA user and version HSQL2.= 3.4 Also I tried same command with other versions as well and I am seein= g same error.<br></div><div dir=3D"auto" style=3D"font-size:1rem;color:r= gb(49, 49, 49);font-family:-apple-system, "Helvetica Neue";wor= d-spacing:1px;"><br></div><div dir=3D"auto" style=3D"color:rgb(49, 49, 4= 9);font-family:-apple-system, "Helvetica Neue";word-spacing:1p= x;"><br></div><div dir=3D"auto" style=3D"font-size:1rem;color:rgb(49, 49= , 49);font-family:-apple-system, "Helvetica Neue";word-spacing= :1px;">Thanks,<br></div><div dir=3D"auto" style=3D"font-size:1rem;color:= rgb(49, 49, 49);font-family:-apple-system, "Helvetica Neue";wo= rd-spacing:1px;">Kothuri Sravya<br></div><div><br></div><div>___________= ____________________________________<br></div><div>Hsqldb-user mailing l= ist<br></div><div><a href=3D"mailto:[email protected]">H= [email protected]</a><br></div><div><a href=3D"https://li= sts.sourceforge.net/lists/listinfo/hsqldb-user">https://lists.sourceforg= e.net/lists/listinfo/hsqldb-user</a><br></div><div><br></div></blockquot= e><div style=3D"font-family:Arial;"><br></div></body></html> --fd54284120e7486d9ad44e7f7edb8bbc-- --===============6324651862743468141== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline --===============6324651862743468141== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Hsqldb-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hsqldb-user --===============6324651862743468141==--