Why is the 'in' operator throwing an error with a string literal instead of logging false?Why can't I use switch statement on a String?Python join: why is it string.join(list) instead of list.join(string)?Multiline String Literal in C#Why does comparing strings using either '==' or 'is' sometimes produce a different result?How to initialize an array's length in javascript?How can I print literal curly-brace characters in python string and also use .format on it?Why does ++[[]][+[]]+[+[]] return the string “10”?Why is char[] preferred over String for passwords?Why does this code using random strings print “hello world”?jQuery.inArray(), how to use it right?

Multi tool use
Multi tool use

How can I prevent hyper evolved versions of regular creatures from wiping out their cousins?

Stopping power of mountain vs road bike

How to say in German "enjoying home comforts"

Why "Having chlorophyll without photosynthesis is actually very dangerous" and "like living with a bomb"?

Why do I get two different answers for this counting problem?

Why is Collection not simply treated as Collection<?>

How to take photos in burst mode, without vibration?

Famous Pre Reformation Christian Pastors (Non Catholic and Non Orthodox)

Assassin's bullet with mercury

90's TV series where a boy goes to another dimension through portal near power lines

Do I have a twin with permutated remainders?

Is "remove commented out code" correct English?

How do I write bicross product symbols in latex?

intersection of two sorted vectors in C++

I'm flying to France today and my passport expires in less than 2 months

SSH "lag" in LAN on some machines, mixed distros

Is it inappropriate for a student to attend their mentor's dissertation defense?

What reasons are there for a Capitalist to oppose a 100% inheritance tax?

What killed these X2 caps?

Is it possible to create light that imparts a greater proportion of its energy as momentum rather than heat?

Can a virus destroy the BIOS of a modern computer?

Arrow those variables!

Western buddy movie with a supernatural twist where a woman turns into an eagle at the end

Facing a paradox: Earnshaw's theorem in one dimension



Why is the 'in' operator throwing an error with a string literal instead of logging false?


Why can't I use switch statement on a String?Python join: why is it string.join(list) instead of list.join(string)?Multiline String Literal in C#Why does comparing strings using either '==' or 'is' sometimes produce a different result?How to initialize an array's length in javascript?How can I print literal curly-brace characters in python string and also use .format on it?Why does ++[[]][+[]]+[+[]] return the string “10”?Why is char[] preferred over String for passwords?Why does this code using random strings print “hello world”?jQuery.inArray(), how to use it right?






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;








7















As per MDN the in operator returns true if the property exists and accordingly the first example logs true. But when using a string literal, why is it throwing an error instead of logging false?






let let1 = new String('test');
console.log(let1.length);
console.log('length' in let1)








var let1 = 'test';
console.log(let1.length);
console.log('length' in let1);












share|improve this question
























  • I'd assume the temporary wrapper object created for the string is not enumerable ..?

    – Teemu
    4 hours ago












  • @Teemu No. There is no temporary wrapper object created at all

    – Bergi
    4 hours ago











  • @Bergi Well, that explains a lot.

    – Teemu
    4 hours ago

















7















As per MDN the in operator returns true if the property exists and accordingly the first example logs true. But when using a string literal, why is it throwing an error instead of logging false?






let let1 = new String('test');
console.log(let1.length);
console.log('length' in let1)








var let1 = 'test';
console.log(let1.length);
console.log('length' in let1);












share|improve this question
























  • I'd assume the temporary wrapper object created for the string is not enumerable ..?

    – Teemu
    4 hours ago












  • @Teemu No. There is no temporary wrapper object created at all

    – Bergi
    4 hours ago











  • @Bergi Well, that explains a lot.

    – Teemu
    4 hours ago













7












7








7








As per MDN the in operator returns true if the property exists and accordingly the first example logs true. But when using a string literal, why is it throwing an error instead of logging false?






let let1 = new String('test');
console.log(let1.length);
console.log('length' in let1)








var let1 = 'test';
console.log(let1.length);
console.log('length' in let1);












share|improve this question
















As per MDN the in operator returns true if the property exists and accordingly the first example logs true. But when using a string literal, why is it throwing an error instead of logging false?






let let1 = new String('test');
console.log(let1.length);
console.log('length' in let1)








var let1 = 'test';
console.log(let1.length);
console.log('length' in let1);








let let1 = new String('test');
console.log(let1.length);
console.log('length' in let1)





let let1 = new String('test');
console.log(let1.length);
console.log('length' in let1)





var let1 = 'test';
console.log(let1.length);
console.log('length' in let1);





var let1 = 'test';
console.log(let1.length);
console.log('length' in let1);






javascript string






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 1 hour ago









Boann

37.4k1290122




37.4k1290122










asked 4 hours ago









brkbrk

29.8k32244




29.8k32244












  • I'd assume the temporary wrapper object created for the string is not enumerable ..?

    – Teemu
    4 hours ago












  • @Teemu No. There is no temporary wrapper object created at all

    – Bergi
    4 hours ago











  • @Bergi Well, that explains a lot.

    – Teemu
    4 hours ago

















  • I'd assume the temporary wrapper object created for the string is not enumerable ..?

    – Teemu
    4 hours ago












  • @Teemu No. There is no temporary wrapper object created at all

    – Bergi
    4 hours ago











  • @Bergi Well, that explains a lot.

    – Teemu
    4 hours ago
















I'd assume the temporary wrapper object created for the string is not enumerable ..?

– Teemu
4 hours ago






I'd assume the temporary wrapper object created for the string is not enumerable ..?

– Teemu
4 hours ago














@Teemu No. There is no temporary wrapper object created at all

– Bergi
4 hours ago





@Teemu No. There is no temporary wrapper object created at all

– Bergi
4 hours ago













@Bergi Well, that explains a lot.

– Teemu
4 hours ago





@Bergi Well, that explains a lot.

– Teemu
4 hours ago












5 Answers
5






active

oldest

votes


















6














In a sense it is a matter of timing. String literals do not have any properties. The reason that you can call methods and lookup properties on primitive strings is because JavaScript automatically wraps the string primitive in a String object when a method call or property lookup is attempted. JavaScript does not interpret the in operator as a method call or property lookup so it does not wrap the primitive in an object and you get an error (because a string primitive is not an object).



See Distinction between string primitives and String objects



Also, the same docs referenced in your question specifically note that using in on a string primitive will throw an error.




You must specify an object on the right side of the in operator. For
example, you can specify a string created with the String constructor,
but you cannot specify a string literal.







share|improve this answer




















  • 2





    This is the shortest and most concise correct answer shown.

    – Scott Marcus
    4 hours ago


















6














It throws an error because in is an operator for objects:




prop in object




but when you declare a string as `` (` string literals) or "" '' (",' string literals) you don't create an object.



Check



typeof new String("x") ("object")



and



typeof `x` ("string").



Those are two different things in JavaScript.






share|improve this answer

























  • actually my expectation was it will log false instead of throwing error.Actually I was doing if(!(prop in someObj))

    – brk
    4 hours ago



















3














Because new creates an Object and string literal ('') is not an object. and in operator applicable only to an object instance.






console.log(typeof (new String('ddd')))
console.log(typeof ('ddd'))








share|improve this answer
































    2














    typeof('test') == string (string literal)



    typof(new String('test')) == object (string object)



    you can't use in with a string literal.




    The in operator returns true if the specified property is in the specified object or its prototype chain.







    share|improve this answer






























      1















      The in operator can only be used to check if a property is in an
      object. You can't search in strings, or in numbers, or other primitive
      types.




      The first example works and prints 'true' because length is a property of a string object.



      The second example doesn't work and gives you an error because you are trying to look for a property length in something (a string) that is not an object.






      share|improve this answer

























      • Notice, that let1.length works in the snippet.

        – Teemu
        4 hours ago











      • Right. But let1 is a string, not an object in the second example.

        – VHS
        4 hours ago











      • Umh ... the second example works as well.

        – Teemu
        4 hours ago











      • The second example wouldn't work because let1 is not an object.

        – VHS
        4 hours ago











      • Just run the second snippet, the first console.log shows 4.

        – Teemu
        4 hours ago












      Your Answer






      StackExchange.ifUsing("editor", function ()
      StackExchange.using("externalEditor", function ()
      StackExchange.using("snippets", function ()
      StackExchange.snippets.init();
      );
      );
      , "code-snippets");

      StackExchange.ready(function()
      var channelOptions =
      tags: "".split(" "),
      id: "1"
      ;
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function()
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled)
      StackExchange.using("snippets", function()
      createEditor();
      );

      else
      createEditor();

      );

      function createEditor()
      StackExchange.prepareEditor(
      heartbeatType: 'answer',
      autoActivateHeartbeat: false,
      convertImagesToLinks: true,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: 10,
      bindNavPrevention: true,
      postfix: "",
      imageUploader:
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      ,
      onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      );



      );













      draft saved

      draft discarded


















      StackExchange.ready(
      function ()
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55522988%2fwhy-is-the-in-operator-throwing-an-error-with-a-string-literal-instead-of-logg%23new-answer', 'question_page');

      );

      Post as a guest















      Required, but never shown

























      5 Answers
      5






      active

      oldest

      votes








      5 Answers
      5






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      6














      In a sense it is a matter of timing. String literals do not have any properties. The reason that you can call methods and lookup properties on primitive strings is because JavaScript automatically wraps the string primitive in a String object when a method call or property lookup is attempted. JavaScript does not interpret the in operator as a method call or property lookup so it does not wrap the primitive in an object and you get an error (because a string primitive is not an object).



      See Distinction between string primitives and String objects



      Also, the same docs referenced in your question specifically note that using in on a string primitive will throw an error.




      You must specify an object on the right side of the in operator. For
      example, you can specify a string created with the String constructor,
      but you cannot specify a string literal.







      share|improve this answer




















      • 2





        This is the shortest and most concise correct answer shown.

        – Scott Marcus
        4 hours ago















      6














      In a sense it is a matter of timing. String literals do not have any properties. The reason that you can call methods and lookup properties on primitive strings is because JavaScript automatically wraps the string primitive in a String object when a method call or property lookup is attempted. JavaScript does not interpret the in operator as a method call or property lookup so it does not wrap the primitive in an object and you get an error (because a string primitive is not an object).



      See Distinction between string primitives and String objects



      Also, the same docs referenced in your question specifically note that using in on a string primitive will throw an error.




      You must specify an object on the right side of the in operator. For
      example, you can specify a string created with the String constructor,
      but you cannot specify a string literal.







      share|improve this answer




















      • 2





        This is the shortest and most concise correct answer shown.

        – Scott Marcus
        4 hours ago













      6












      6








      6







      In a sense it is a matter of timing. String literals do not have any properties. The reason that you can call methods and lookup properties on primitive strings is because JavaScript automatically wraps the string primitive in a String object when a method call or property lookup is attempted. JavaScript does not interpret the in operator as a method call or property lookup so it does not wrap the primitive in an object and you get an error (because a string primitive is not an object).



      See Distinction between string primitives and String objects



      Also, the same docs referenced in your question specifically note that using in on a string primitive will throw an error.




      You must specify an object on the right side of the in operator. For
      example, you can specify a string created with the String constructor,
      but you cannot specify a string literal.







      share|improve this answer















      In a sense it is a matter of timing. String literals do not have any properties. The reason that you can call methods and lookup properties on primitive strings is because JavaScript automatically wraps the string primitive in a String object when a method call or property lookup is attempted. JavaScript does not interpret the in operator as a method call or property lookup so it does not wrap the primitive in an object and you get an error (because a string primitive is not an object).



      See Distinction between string primitives and String objects



      Also, the same docs referenced in your question specifically note that using in on a string primitive will throw an error.




      You must specify an object on the right side of the in operator. For
      example, you can specify a string created with the String constructor,
      but you cannot specify a string literal.








      share|improve this answer














      share|improve this answer



      share|improve this answer








      edited 4 hours ago

























      answered 4 hours ago









      benvcbenvc

      6,5681827




      6,5681827







      • 2





        This is the shortest and most concise correct answer shown.

        – Scott Marcus
        4 hours ago












      • 2





        This is the shortest and most concise correct answer shown.

        – Scott Marcus
        4 hours ago







      2




      2





      This is the shortest and most concise correct answer shown.

      – Scott Marcus
      4 hours ago





      This is the shortest and most concise correct answer shown.

      – Scott Marcus
      4 hours ago













      6














      It throws an error because in is an operator for objects:




      prop in object




      but when you declare a string as `` (` string literals) or "" '' (",' string literals) you don't create an object.



      Check



      typeof new String("x") ("object")



      and



      typeof `x` ("string").



      Those are two different things in JavaScript.






      share|improve this answer

























      • actually my expectation was it will log false instead of throwing error.Actually I was doing if(!(prop in someObj))

        – brk
        4 hours ago
















      6














      It throws an error because in is an operator for objects:




      prop in object




      but when you declare a string as `` (` string literals) or "" '' (",' string literals) you don't create an object.



      Check



      typeof new String("x") ("object")



      and



      typeof `x` ("string").



      Those are two different things in JavaScript.






      share|improve this answer

























      • actually my expectation was it will log false instead of throwing error.Actually I was doing if(!(prop in someObj))

        – brk
        4 hours ago














      6












      6








      6







      It throws an error because in is an operator for objects:




      prop in object




      but when you declare a string as `` (` string literals) or "" '' (",' string literals) you don't create an object.



      Check



      typeof new String("x") ("object")



      and



      typeof `x` ("string").



      Those are two different things in JavaScript.






      share|improve this answer















      It throws an error because in is an operator for objects:




      prop in object




      but when you declare a string as `` (` string literals) or "" '' (",' string literals) you don't create an object.



      Check



      typeof new String("x") ("object")



      and



      typeof `x` ("string").



      Those are two different things in JavaScript.







      share|improve this answer














      share|improve this answer



      share|improve this answer








      edited 1 hour ago









      Boann

      37.4k1290122




      37.4k1290122










      answered 4 hours ago









      SkillGGSkillGG

      1839




      1839












      • actually my expectation was it will log false instead of throwing error.Actually I was doing if(!(prop in someObj))

        – brk
        4 hours ago


















      • actually my expectation was it will log false instead of throwing error.Actually I was doing if(!(prop in someObj))

        – brk
        4 hours ago

















      actually my expectation was it will log false instead of throwing error.Actually I was doing if(!(prop in someObj))

      – brk
      4 hours ago






      actually my expectation was it will log false instead of throwing error.Actually I was doing if(!(prop in someObj))

      – brk
      4 hours ago












      3














      Because new creates an Object and string literal ('') is not an object. and in operator applicable only to an object instance.






      console.log(typeof (new String('ddd')))
      console.log(typeof ('ddd'))








      share|improve this answer





























        3














        Because new creates an Object and string literal ('') is not an object. and in operator applicable only to an object instance.






        console.log(typeof (new String('ddd')))
        console.log(typeof ('ddd'))








        share|improve this answer



























          3












          3








          3







          Because new creates an Object and string literal ('') is not an object. and in operator applicable only to an object instance.






          console.log(typeof (new String('ddd')))
          console.log(typeof ('ddd'))








          share|improve this answer















          Because new creates an Object and string literal ('') is not an object. and in operator applicable only to an object instance.






          console.log(typeof (new String('ddd')))
          console.log(typeof ('ddd'))








          console.log(typeof (new String('ddd')))
          console.log(typeof ('ddd'))





          console.log(typeof (new String('ddd')))
          console.log(typeof ('ddd'))






          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited 4 hours ago

























          answered 4 hours ago









          Stranger in the QStranger in the Q

          7161618




          7161618





















              2














              typeof('test') == string (string literal)



              typof(new String('test')) == object (string object)



              you can't use in with a string literal.




              The in operator returns true if the specified property is in the specified object or its prototype chain.







              share|improve this answer



























                2














                typeof('test') == string (string literal)



                typof(new String('test')) == object (string object)



                you can't use in with a string literal.




                The in operator returns true if the specified property is in the specified object or its prototype chain.







                share|improve this answer

























                  2












                  2








                  2







                  typeof('test') == string (string literal)



                  typof(new String('test')) == object (string object)



                  you can't use in with a string literal.




                  The in operator returns true if the specified property is in the specified object or its prototype chain.







                  share|improve this answer













                  typeof('test') == string (string literal)



                  typof(new String('test')) == object (string object)



                  you can't use in with a string literal.




                  The in operator returns true if the specified property is in the specified object or its prototype chain.








                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered 4 hours ago









                  FedeScFedeSc

                  877923




                  877923





















                      1















                      The in operator can only be used to check if a property is in an
                      object. You can't search in strings, or in numbers, or other primitive
                      types.




                      The first example works and prints 'true' because length is a property of a string object.



                      The second example doesn't work and gives you an error because you are trying to look for a property length in something (a string) that is not an object.






                      share|improve this answer

























                      • Notice, that let1.length works in the snippet.

                        – Teemu
                        4 hours ago











                      • Right. But let1 is a string, not an object in the second example.

                        – VHS
                        4 hours ago











                      • Umh ... the second example works as well.

                        – Teemu
                        4 hours ago











                      • The second example wouldn't work because let1 is not an object.

                        – VHS
                        4 hours ago











                      • Just run the second snippet, the first console.log shows 4.

                        – Teemu
                        4 hours ago
















                      1















                      The in operator can only be used to check if a property is in an
                      object. You can't search in strings, or in numbers, or other primitive
                      types.




                      The first example works and prints 'true' because length is a property of a string object.



                      The second example doesn't work and gives you an error because you are trying to look for a property length in something (a string) that is not an object.






                      share|improve this answer

























                      • Notice, that let1.length works in the snippet.

                        – Teemu
                        4 hours ago











                      • Right. But let1 is a string, not an object in the second example.

                        – VHS
                        4 hours ago











                      • Umh ... the second example works as well.

                        – Teemu
                        4 hours ago











                      • The second example wouldn't work because let1 is not an object.

                        – VHS
                        4 hours ago











                      • Just run the second snippet, the first console.log shows 4.

                        – Teemu
                        4 hours ago














                      1












                      1








                      1








                      The in operator can only be used to check if a property is in an
                      object. You can't search in strings, or in numbers, or other primitive
                      types.




                      The first example works and prints 'true' because length is a property of a string object.



                      The second example doesn't work and gives you an error because you are trying to look for a property length in something (a string) that is not an object.






                      share|improve this answer
















                      The in operator can only be used to check if a property is in an
                      object. You can't search in strings, or in numbers, or other primitive
                      types.




                      The first example works and prints 'true' because length is a property of a string object.



                      The second example doesn't work and gives you an error because you are trying to look for a property length in something (a string) that is not an object.







                      share|improve this answer














                      share|improve this answer



                      share|improve this answer








                      edited 4 hours ago

























                      answered 4 hours ago









                      VHSVHS

                      7,22431128




                      7,22431128












                      • Notice, that let1.length works in the snippet.

                        – Teemu
                        4 hours ago











                      • Right. But let1 is a string, not an object in the second example.

                        – VHS
                        4 hours ago











                      • Umh ... the second example works as well.

                        – Teemu
                        4 hours ago











                      • The second example wouldn't work because let1 is not an object.

                        – VHS
                        4 hours ago











                      • Just run the second snippet, the first console.log shows 4.

                        – Teemu
                        4 hours ago


















                      • Notice, that let1.length works in the snippet.

                        – Teemu
                        4 hours ago











                      • Right. But let1 is a string, not an object in the second example.

                        – VHS
                        4 hours ago











                      • Umh ... the second example works as well.

                        – Teemu
                        4 hours ago











                      • The second example wouldn't work because let1 is not an object.

                        – VHS
                        4 hours ago











                      • Just run the second snippet, the first console.log shows 4.

                        – Teemu
                        4 hours ago

















                      Notice, that let1.length works in the snippet.

                      – Teemu
                      4 hours ago





                      Notice, that let1.length works in the snippet.

                      – Teemu
                      4 hours ago













                      Right. But let1 is a string, not an object in the second example.

                      – VHS
                      4 hours ago





                      Right. But let1 is a string, not an object in the second example.

                      – VHS
                      4 hours ago













                      Umh ... the second example works as well.

                      – Teemu
                      4 hours ago





                      Umh ... the second example works as well.

                      – Teemu
                      4 hours ago













                      The second example wouldn't work because let1 is not an object.

                      – VHS
                      4 hours ago





                      The second example wouldn't work because let1 is not an object.

                      – VHS
                      4 hours ago













                      Just run the second snippet, the first console.log shows 4.

                      – Teemu
                      4 hours ago






                      Just run the second snippet, the first console.log shows 4.

                      – Teemu
                      4 hours ago


















                      draft saved

                      draft discarded
















































                      Thanks for contributing an answer to Stack Overflow!


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid


                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.

                      To learn more, see our tips on writing great answers.




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function ()
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55522988%2fwhy-is-the-in-operator-throwing-an-error-with-a-string-literal-instead-of-logg%23new-answer', 'question_page');

                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      Zp6solT3DqN
                      jDb DAnY i8 lO90tDDNm6bAtAWGQiGAZOi4wn2f079wpc1PptBNKdqBgm6rtWK5CnwxHB3Y5uOIOc5z

                      Popular posts from this blog

                      What is the result of assigning to std::vector::begin()? The Next CEO of Stack OverflowWhat are the differences between a pointer variable and a reference variable in C++?What does the explicit keyword mean?Concatenating two std::vectorsHow to find out if an item is present in a std::vector?Why is “using namespace std” considered bad practice?What is the “-->” operator in C++?What is the easiest way to initialize a std::vector with hardcoded elements?What is The Rule of Three?What are the basic rules and idioms for operator overloading?Why are std::begin and std::end “not memory safe”?

                      Creating centerline of river in QGIS? The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Finding centrelines from polygons in QGIS?Splitting line into two lines with GRASS GIS?Centroid of the equator and a pointpostgis: problems creating flow direction polyline; not all needed connections are drawnhow to make decent sense from scattered river depth measurementsQGIS Interpolation on Curved Grid (River DEMs)How to create automatic parking baysShortest path creation between two linesclipping layer using query builder in QGISFinding which side of closest polyline point lies on in QGIS?Create centerline from multi-digitized roadway lines Qgis 2.18Getting bathymetric contours confined only within river banks using QGIS?

                      SQL Server 2016 - excessive memory grant warning on poor performing query The Next CEO of Stack OverflowFix for slow SQL_INLINE_TABLE_VALUED_FUNCTIONLarge memory grant requestsPoor performing Query -Tsql execution plan - estimated number of rows =1 Paste the PlanMSSQL - Query had to wait for memory grantRow estimates always too lowBad performance using “NOT IN”Warning about memory “Excessive Grant” in the query plan - how to find out what is causing it?Optimizing table valued function SQL ServerWhen does SQL Server warn about an Excessive Memory Grant?Warning in Execution Plan