Re: Alter table add index not working
Sravya Kothuri <[email protected]> Sun, 19 Mar 2023 22:14:50 +0530
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <CAHHW1=68iG+H5FiedNE+ikSnhCt6QN3RH6KYbs3rr2DNk625DQ@mail.gmail.com> |
--===============2355004271083108550== Content-Type: multipart/alternative; boundary="0000000000000bd9a005f7438862" --0000000000000bd9a005f7438862 Content-Type: text/plain; charset="UTF-8" But we are using compatibility mode as mysql On Sun, 19 Mar 2023 at 10:13 PM, Sravya Kothuri <[email protected]> wrote: > But we are using compatibility mode as mysql. > > On Sun, 19 Mar 2023 at 8:37 PM, Fred Toussi via Hsqldb-user < > [email protected]> wrote: > >> 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 >> >> >> _______________________________________________ >> Hsqldb-user mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/hsqldb-user >> > --0000000000000bd9a005f7438862 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"auto">But we are using compatibility mode as mysql</div><div di= r=3D"auto"><br></div><div dir=3D"auto"><br></div><div><br><div class=3D"gma= il_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sun, 19 Mar 2023 at 10:1= 3 PM, Sravya Kothuri <<a href=3D"mailto:[email protected]">kot= [email protected]</a>> wrote:<br></div><blockquote class=3D"gmail= _quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:= 1ex"><div dir=3D"auto">But we are using compatibility mode as mysql.</div><= div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On= Sun, 19 Mar 2023 at 8:37 PM, Fred Toussi via Hsqldb-user <<a href=3D"ma= ilto:[email protected]" target=3D"_blank">hsqldb-user@lists= .sourceforge.net</a>> wrote:<br></div><blockquote class=3D"gmail_quote" = style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u>= </u><div><div style=3D"font-family:Arial">This is not the correct syntax. U= se this:<br></div><div style=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 style=3D"font-family:Arial"><br></div><div style=3D= "font-family:Arial">See the Guide: <a href=3D"http://hsqldb.org/doc/2.0/gui= de/databaseobjects-chapt.html#dbc_other_object_creation" target=3D"_blank">= http://hsqldb.org/doc/2.0/guide/databaseobjects-chapt.html#dbc_other_object= _creation</a></div></div><div><div>On Sun, Mar 19, 2023, at 14:29, Sravya K= othuri wrote:<br></div></div><div><blockquote type=3D"cite" id=3D"m_7000522= 134167086085m_-4114109747830170389qt"></blockquote></div><div><blockquote t= ype=3D"cite" id=3D"m_7000522134167086085m_-4114109747830170389qt"><div><spa= n style=3D"color:rgb(49,49,49);word-spacing:1px"><span style=3D"font-family= :-apple-system,"Helvetica Neue"">Hi Team,</span></span><br></div>= <div dir=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" styl= e=3D"font-size:1rem;color:rgb(49,49,49);font-family:-apple-system,"Hel= vetica Neue";word-spacing:1px">I am actually using embedded HSQL datab= ase in my application and we recently migrated application from oracle to M= ariaDB and HSQL DB is throwing "type not found or user lacks provilige= " while running "alter table table_name add index index_name (co= lumn_name)" and I saw from one of your article that this syntax is als= o 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= .<br></div><div dir=3D"auto" style=3D"font-size:1rem;color:rgb(49,49,49);fo= nt-family:-apple-system,"Helvetica Neue";word-spacing:1px"><br></= div><div dir=3D"auto" style=3D"color:rgb(49,49,49);font-family:-apple-syste= m,"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">Thanks,<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">Kothuri Sravya<br></div><div><br></= div></blockquote></div><div><blockquote type=3D"cite" id=3D"m_7000522134167= 086085m_-4114109747830170389qt"><div>______________________________________= _________<br></div><div>Hsqldb-user mailing list<br></div><div><a href=3D"m= ailto:[email protected]" target=3D"_blank">Hsqldb-user@list= s.sourceforge.net</a><br></div><div><a href=3D"https://lists.sourceforge.ne= t/lists/listinfo/hsqldb-user" target=3D"_blank">https://lists.sourceforge.n= et/lists/listinfo/hsqldb-user</a><br></div><div><br></div></blockquote><div= style=3D"font-family:Arial"><br></div></div>______________________________= _________________<br> Hsqldb-user mailing list<br> <a href=3D"mailto:[email protected]" target=3D"_blank">Hsql= [email protected]</a><br> <a href=3D"https://lists.sourceforge.net/lists/listinfo/hsqldb-user" rel=3D= "noreferrer" target=3D"_blank">https://lists.sourceforge.net/lists/listinfo= /hsqldb-user</a><br> </blockquote></div></div> </blockquote></div></div> --0000000000000bd9a005f7438862-- --===============2355004271083108550== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline --===============2355004271083108550== 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 --===============2355004271083108550==--